SiebelSupport

-Learning the sharing way :)

Wednesday, September 5, 2012

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


By on 5:18 PM


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).
This FAQ 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)
SBL-SEC-10018, SBL-DAT-00522, SBL-SEC-10001 and SBL-DAT-00565, SBL-DAT-00522, Incorrect, "missing encryption key"

SiebelSupport - Learning the sharing way :)

When you know a thing, to hold that you know it, and when you do not know a thing, to allow that you do not know it - this is knowledge.

0 comments:

Post a Comment

Labels

ADSI authentication ADSISecAdpt apiinstaller.jar Applet User Properties Barcode fonts in PDF Best Practices BI Publisher BI Publisher 11g BI Publisher Desktop BI Publisher Desktop 10.1.3.2 BI Publisher template error BIP Performance tuning BUG 19469254 Create iPad Reports CRM on Demand R19 Deployment Guide - IP2014 Desktop Integration Siebel Agent (DISA) EAI Object Manager EnableURLCredentials ENTERPRISE NAME IS TRUNCATED DURING MIGRATION INSTALL IN LINUX PLAT Escripting External Business Components (EBCs) Generate Trigger Get a 20% Discount on Oracle Training How To Incorrect missing encryption key Incremental Repository Merge (IRM) Install Barcode fonts in BIP Server Integration Object IP2014 IP2014 Patch Set 1 IP2014 Patchset 2 IP2015 IP2015 Patchset 1 (15.1) IsRecordSensitive JDeveloper jqmtoolbarrenderer.js LDAP LDAPSecAdpt log level of SWSE Menu in Siebel Open UI new theme in Siebel 8.1.1.11 Open UI NFS OBIEE Integration on Siebel 7.8.2 Oracle Database XE Oracle Fusion Middleware Oracle Integration Cloud Services (ICS) Oracle WebLogic Server Override Custom Theme In Open UI Without Deleting The User Preferences Files Of All Users Performance Tuning Quiz Release Notes Responsive Web Design REST SAI REST SAP BusinessObjects Data Quality SavePreferences SBL-DAT-00222 SBL-DAT-00522 SBL-DBC-00107 SBL-SEC-10001 and SBL-DAT-00565 SBL-SEC-10018 Siebel - Oracle Real-time Scheduler Integration SIEBEL 8.1.1.14 ENVIRONMENT VARIABLE INSTALL ISSUE Siebel 8.1.1.8 Fix Pack Siebel 8.1.1.9 / 8.2.2.2 Siebel Administration Siebel Analytics Siebel BI Publisher Reports Siebel Composer Siebel Composer Developer Preview Siebel CRM 15.0 Siebel CRM 8.1.1.10/8.2.2.3 Siebel CRM Innovation Pack 2015 Siebel Delta Files (SDF) Siebel Email Marketing Siebel Filesystem Siebel Innovation Pack 2016 Siebel License Keys Siebel Open UI Siebel Open UI Manifest Siebel Release 15.1 Siebel Reports Siebel RESTful Services Siebel Server Cloning SPF Symbolic URL Synergy Open UI Theme Synergy Theme Open UI - Siebel CRM Innovation Pack 2015 Videos What is Workflow Policy OR

Tags