Sahil asked 2 years ago
Title : How Do You Connect Siebel Tools and the Mobile Web Client (MWC) to an Encrypted Local Database?

Question :

How Do You Connect Siebel Tools and the Mobile Web Client (MWC) to an Encrypted Local Database?

1 Answers
Umesh SharmaUmesh Sharma Staff answered 2 years ago

Hello Sahil,

In Siebel version 8.0 and higher, when extracting a local database with the default settings, the local database is now encrypted. This is the standard behavior and differs from the earlier versions when you needed to make changes in order to encrypt the local database.

One result is that if you download the local database using Siebel Tools, you will not automatically be able to connect to it using the Siebel Mobile Web Client (MWC).

The following demonstrates how in Siebel 8.0 and higher you can use the Siebel Mobile Web Client (MWC) to connect to a Local Database extracted by Siebel Tools.

Steps

1. Run Generate New Database (GenNewDB).

2. Run Database Extract (DBExtract).

3. Start Siebel Tools and Connect to Local using your USER_ID and PASSWORD.  Due to the fact the local database does not exist on the PC, you will be prompted to download the Local Database.

4. Once the local database had downloaded, please ensure you can connect correctly using Siebel Tools.

5. Copy the file ${Tools}\local\dicdata.dat to ${Client}\local\dicdata.dat
Without this step, you cannot connect to the local database from the Siebel Mobile Web Client.

6.  Locate and copy the following parameters’ lines exactly as they are from [Local] section of Tools CFG   (used to Initialize database) to Siebel Mobile Web Client’s CFG file:

DSDockEncryptDB = …
DSHashUserPwd    = …
DSHashAlgorithm   = …

7. In the Mobile Web Client CFG file [Local] section, edit the ConnectString parameter to point to where the local database is located.

8. Copy the file ${Tools}\bin\mwc_storage.cfg to ${Client}\bin\mwc_storage.cfg

9. Change the ODBC DataSource for the Client by performing the following steps:-

a. Navigate to Control Panel  > Administrative Tools > Data Source (ODBC)

b. Select the System DSN tab

c. In the list, find the DSN Source called “SSD Local DB default instance”.  Double-click on it or click once and then click the Configure button.

d. Click the Database tab

e. Copy the Server Name (such as: C__SIA_TOOLS_Local_sse_data_dbf).  Click Cancel to close this window and return to the list of System Data Sources.

f. Locate the System Data Source for the client called “SEAW Local DB default instance”. Double-click on it or click once and then click the Configure button.

g. Click the Database tab

h. Paste the data just copied into the Server Name.  Click OK to save the changes.

NOTE: It is possible to extract a local database without encryption but you need to specify the parameters below:- Encrypt client Db password = False
Client Database encryption method = none If you create a non-encrypted local database, you will still need to copy the file ‘mwc_storage.cfg’ file from the ${Tools}\bin directory to the ${Client}\bin directory and update the local ODBC section in the client CFG file (assumes extraction took place using Tools)

Further information on these parameters can be found in the Siebel Remote and Replication Manager Administration Guide version 8.0 > Extracting Databases for Mobile Web Clients > Database Extraction for a Mobile Web Client and Siebel Remote and Replication Manager Administration Guide version 8.0 > Extracting Databases for Mobile Web Clients > Database Extraction for a Mobile Web Client > Parameters of the Database Extract Component.

Hope this answers your query.

Cubastion is among a very small number of specialized Siebel CRM Oracle Gold Partners in SME.