Configuring the Data Source Definition

As part of specifying the run-time parameters, configure the data source definition.

To configure the data source definition

1. Navigate to the Administration - Server Configuration screen, Enterprises view, then Profile Configuration.

2. Copy an existing InfraDatasources named subsystem type.

3. Change the Profile and Alias properties to the Data Source name configured in Siebel Tools.

4. Update the profile parameters to correspond to the external RDBMS:

   • DSConnectString = data source connect string

     • For Microsoft SQL Server or IBM DB2, create an ODBC or equivalent connection and input the name of this in the parameter.

     • For Oracle Database, this value must specify the TNS name associated with the database and not an ODBC or other entry.

   • DSSQLStyle = database SQL type

     See the following table for a listing of the supported SQL types.

   • DSDLLName = DLL or library name corresponding to the SQL type

     See the following table for a listing of the supported connector Dynamic Link Library (DLL, Windows) or library (shared object, UNIX) names and SQL styles.

   • DSTableOwner = data source table owner

   • DSUsername = default username used for connections (Optional)

   • DSPassword = default password used for connections (Optional)

   Note: The DSUsername and the DSPassword parameters are optional. However, to avoid receiving a login prompt when accessing the external data source, specify DSUsername and DSPassword. If specified, they will override the default username and password.

The DSUsername and the DSPassword parameters are activated only when using the Database Security Adapter. For more information, see Configuring a User in LDAP or ADSI Security Adapter to Access EBCs.