Table 36. Data Source Parameters
|
|
AutoStopDB |
True or False. Applies to Sample or Local data sources only. If it is True, then the SQL Anywhere database engine exits when the user logs out. If it is False (the default), then the database engine continues to run after the user logs out of the Siebel Business Applications. For more information about the local database, see Siebel Remote and Replication Manager Administration Guide. |
CaseInsensitive |
True or False. If it is True, then the client is notified to work with the database in case-insensitive mode. See also the description of the InsensitivityFactor parameter for data sources. NOTE: Queries against fields of type DTYPE_ID are always case-sensitive, even if the CaseInsensitive parameter is set to True. For more information, see Siebel Applications Administration Guide.
|
ConnectString |
Database-dependent string that defines how to connect to the database (also referred to as the connection string). For SQL Anywhere (for local database or Sample Database), the -q option hides the SQL Anywhere icon. The -c option indicates the initial cache size, and -ch indicates the limit of the cache size. The -m option indicates to the SQL Anywhere database engine to truncate the transaction log after each checkpoint. The ConnectString parameter is also used to specify the Siebel Gateway Name Server computer in the GatewayDataSrc section. In the Siebel Mobile Web Client's configuration file, you must specify the Siebel Gateway Name Server's hostname, preferably in a fully qualified form like node.domain.xxx . Failure to specify this parameter correctly results in the server administration screens being inaccessible. For more information about using connection strings for different server databases, see the Siebel Installation Guide for the operating system you are using. |
ContactLogin |
True or False. If it is True, then it indicates that the corresponding data source uses contact login, rather than employee login. Because a contact user is generally not associated one-to-one with a database account, you must use a security adapter to support contact users. If it is False, then the data source is using employee login, rather than contact login. |
DisableExecuteRetry |
True or False. When set to True, this parameter prevents the client from resending a query to the database layer if an error occurs such as a network error or session kill. |
DLL |
Name of the DLL file to use for the database connector code. The names differ depending upon whether you are using Oracle Database, Microsoft SQL Server, IBM DB2, and so on. |
Docked |
Determines which database connection the application login screen for a Mobile Web Client defaults to. For example, if Docked is True in the [ServerDataSrc] section of the configuration file and Docked is False in the [Local] section of the configuration file, then the application login screen defaults to the server database rather than the local database. The values used in this example are the default values. |
DockConnString |
Name of the docking server (Siebel Remote Server). It is the computer name of the Siebel Server against which the Mobile Web Client synchronizes. |
DockRecvTxnsPerCommit |
Number of transactions received by the Mobile Web Client before a commit is issued to the database. The default value for this parameter is 10. Change the setting to:
- A higher value if you have a fast network connection, such as a LAN. Increasing the value can provide better performance when synchronizing the Mobile Web Client with the server.
- A lower value if you have a lower-bandwidth network connection, such as a modem.
|
DockTxnsPerCommit |
Number of transactions processed before a commit is issued to the database. |
EnterpriseServer |
Name of the Siebel Enterprise Server. |
FileSystem |
Specifies how the Mobile or Siebel Developer Web Client (for administrative purposes) accesses the Siebel File System. The value of this parameter cannot exceed 253 characters. Generally, FileSystem and other parameters identified in this table are set during the Siebel client installation. Mobile Web Client. The following scenario for setting the FileSystem parameter applies to the Siebel Mobile Web Client. Install the Siebel File System locally on a Mobile Web Client, so that it is accessible when the client is not connected to the network and can be synchronized using Siebel Remote: Set the following parameter, where FS_location is a UNC location or a drive-letter path to the location on the client computer where the local Siebel File System was installed: FileSystem = FS_location
Developer Web Client. The following scenarios for setting the FileSystem parameter apply to the Siebel Developer Web Client when used for administrative purposes. Make sure that users on the Siebel Developer Web Client have physical access privileges for the Siebel File System directories:
If your networked Siebel File System resides on a UNIX server, then you require a cross-platform NFS file system mounting tool to connect from Siebel Developer Web Clients running on Windows computers. |
GatewayAddress |
Host name or IP address of the Siebel Gateway Name Server. |
Hidden |
True or False. Determines if the data source shows up in the login screen's picklist of data sources. |
InsensitivityFactor |
Set to a positive integer value (default is 2). Applies only when the CaseInsensitive parameter is True for the data source. The value controls the number of characters in each string that are treated as case-insensitive in a query. Not all database vendors support case-insensitivity efficiently, so this feature provides an approximate solution. See also the description of the CaseInsensitive parameter for data sources. The following is an example SQL WHERE clause generated when searching for an opportunity named New, when InsensitivityFactor is set to 2. WHERE ((S_OPTY.NAME LIKE 'ne%' OR S_OPTY.NAME LIKE 'Ne%'OR S_OPTY.NAME LIKE 'nE%'OR S_OPTY.NAME LIKE 'NE%') AND UPPER(S_OPTY.NAME)=UPPER('New'))
This example shows that all of the permutations of the first two letters of the string New are checked. With a higher factor, the number of permutations grows exponentially, and performance suffers. NOTE: Do not set this parameter to a value higher than 13.
|
InsUpdAllCols |
True or False. Ordinarily, when the Siebel application generates INSERT or UPDATE statements to send to the database, the actual statement contains only the columns where data is present or has changed. When there are situations where you generate many statements on a particular table, the differences in the values being updated might prevent you from using an array interface supported by the DBMS. When this feature is set to True, all of the columns are present in all INSERT and UPDATE statements. Where two statements are issued against the same table in the same business component as part of a batch operation, this setting automatically enables the statements to use any existing array feature of the DBMS. |
IntegratedSecurity |
True or False. When True, the Siebel client is prevented from prompting the user for a user name and password when the user logs in. Facilities provided in your existing data server infrastructure determine whether the user is allowed to log into the database. This parameter is set for your server data source. However, it is supported for Oracle Database and Microsoft SQL Server databases only. The default value is False. For additional information, refer to your third-party documentation. For Oracle Database, refer to the OPS$ and REMOTE_OS_AUTHENT features. For Microsoft SQL Server, refer to Integrated Security. |
MaxCachedCursors |
Specifies the maximum number of SQL cursors that can be cached in memory for a database connection. The default is 16. Caching SQL cursors can improve response time and CPU usage because an SQL cursor does not have to be prepared each time it is executed. If memory usage is not a concern, then you might consider increasing the value of this parameter. |
MaxCachedDataSets |
Specifies the maximum number of data sets that can be cached in memory for a database connection. The default is 16. A data set is the set of records that has been retrieved by the execution of a business component. Data-set caching applies only to those business components for which the Cache Data property has been set in Oracle's Siebel Tools. Caching data sets for frequently visited business components can improve response time and CPU usage. If memory usage is not a concern, then you might consider increasing the value of this parameter. |
MaxConnections |
Number of connections that can be made to the data source database server. |
MaxCursorSize |
Sets the total number of rows that can be returned in a result set. MaxCursorSize is intended for use only with IBM DB2 for OS/390 and z/OS, and must be set as described in Implementing Siebel Business Applications on DB2 for z/OS. If you are using another database, then do not set this parameter to any value other than the default value (-1), or database behavior is adversely affected. MaxCursorSize and PrefetchSize are used together, and they must be set to the same value. See also the description for the PrefetchSize parameter. |
NonSQL |
True or False. Setting that indicates that the data source does not use an SQL DBMS to retrieve its data. Use this parameter only in conjunction with a specialized business component that your company builds internally. Never use this parameter arbitrarily. |
PrefetchSize |
Sets the number of rows that the Siebel application reads initially as part of a query execution. PrefetchSize is intended for use only with IBM DB2 for OS/390 and z/OS, and must be set as described in Implementing Siebel Business Applications on DB2 for z/OS. If you are using another database, then do not set this parameter to any value other than the default value (-1), or database behavior is adversely affected. MaxCursorSize and PrefetchSize are used together, and they must be set to the same value. See also the description for the MaxCursorSize parameter. |
PrimaryEnterprise |
The name of the Enterprise Server that you want to administer from the client computer. Set this parameter to view or change information in the server administration views. |
ReverseFillThreshold |
When the current query contains many rows, it might be very inefficient for the user to click End try to display and read them all sequentially. For this reason, the customer might configure a threshold value to invert the current sort, re-execute the query, and fill the data buffers from the end. These internal operations are hidden from the user. |
SortCollation |
Allows the user to specify sorting order on the local database or Sample Database. The SortCollation parameter is not a default part of the configuration file, so it must be added manually in order to take effect. If this parameter is not present, then sorting in Siebel Business Applications when using SQL Anywhere uses the binary sort order, as identified in the information that follows. Customers using languages other than English (particularly those using accented characters) might prefer to use an appropriate setting from among those listed. NOTE: Setting this parameter to a value other than binary affects the sort performance.
After this parameter is changed, the Siebel application must be restarted in order for the change to take effect. The valid values of the SortCollation parameter, supported by the SQL Anywhere database, consist of the following values:
- ISO 14651 Unicode multilingual (Default):
default
- ISO 14651 Unicode multilingual ordering standard:
14651 (produces same results as default sort collation)
|
SortCollation (continued) |
- Big5 (Traditional Chinese) binary order:
big5bin
- Binary sort:
binary (produces UTF-8 binary order)
- CP 850 Western European: no accent:
altnoacc
- CP 850 Western European: lower case first:
altdict
- CP 850 Western European: no case, preference:
altnocsp
- CP 850 Scandinavian dictionary:
scandict
- CP 850 Scandinavian: no case, preference:
scannocp
- CP874 (TIS 620) Royal Thai dictionary order:
thaidict
- CP932 (Japanese on Windows) Shift-JIS binary order:
sjisbin
- CP932 (Japanese on Windows) Shift-JIS with Microsoft extensions binary order:
cp932bin
- GB2312 (Simplified Chinese) binary order:
gb2312bin
- GB 2312 (Simplified Chinese) Pinyin phonetic order:
gbpinyin
- EUC JIS (Japanese on UNIX) binary order:
eucjisbin
- EUC KSC (Korean) binary order:
euckscbin
- ISO 8859-1 ('Latin-1') English, French, German dictionary order:
dict
- ISO 8859-1 ('Latin-1') English, French, German no case:
nocase
- ISO 8859-1 ('Latin-1') English, French, German no case, preference:
nocasep
- ISO 8859-1 ('Latin-1') English, French, German no accent:
noaccent
|
SortCollation (continued) |
- ISO 8859-1 ('Latin-1') Spanish dictionary:
espdict
- ISO 8859-1 ('Latin-1') Spanish no case:
espnocs
- ISO 8859-1 ('Latin-1') Spanish no accent:
espnoac
- ISO 8859-2 Hungarian dictionary:
hundict
- ISO 8859-2 Hungarian no accents:
hunnoac
- ISO 8859-2 Hungarian no case:
hunnocs
- ISO 8859-5 Cyrillic dictionary:
cyrdict
- ISO 8859-5 Cyrillic no case:
cyrnocs (not supported for Sybase)
- ISO 8859-5 Russian dictionary:
rusdict
- ISO 8859-5 Russian no case:
rusnocs (not supported for Sybase)
- ISO 8859-7 Greek dictionary:
elldict
- ISO 8859-9 Turkish dictionary:
turdict
- ISO 8859-9 Turkish no accents:
turnoac (not supported for Sybase)
- ISO 8859-9 Turkish no case:
turnocs (not supported for Sybase)
- Unicode UTF-8 binary sort:
utf8bin (produces same results as binary sort collation)
NOTE: In these collation options, no accents indicates that the accented and nonaccented characters are treated equivalently by the sort. No case indicates that the sort ignores case. Preference indicates that uppercase records appear before lowercase records where the letter is the same but the case differs.
|
SqlStyle |
Indicates what kind of SQL to send to the database that you are using. When generating SQL to send to a DBMS, the application constructs the SQL statement to suit the particular DBMS. The value of this parameter is automatically set by the Siebel client installer or by initial server configuration, according to database information that you specified. The local database or Sample Database, based on SQL Anywhere, use Watcom. Server databases such as Oracle Database, IBM DB2, or Microsoft SQL Server use the style applicable to the particular DBMS. |
TableOwner |
In a database, tables are identified by both their owner and their name. When queries that reference tables are issued, the table owner must be included in those references (for example, SIEBEL.S_EVT_ACT, where SIEBEL is the table owner). Siebel Server infrastructure and system management components, such as SRBroker and SRProc, read the value of this parameter. For Application Object Manager server components, you specify the table owner by setting a value for the Datasource Table Owner (alias DSTableOwner) named subsystem parameter. |
UpperCaseLogin |
The default is False. If it is set to True, then the user ID, when a user logs in, is converted to uppercase before it is sent to the database for authentication. This value is applicable only if the database is used for authentication. The value of the parameter is ignored when SecurityAdapter is set to a nonempty value. Use this parameter if you want to enforce a policy of having all of the database accounts in uppercase on a case-sensitive database, but you do not want users to worry about case when they type in their user names. NOTE: The value of UpperCaseLogin does not affect the password.
|
UseDictionaryinTransactionLogging |
To avoid the diccache.dat creation while using the Developer Web Client connected to the database server, add this parameter to the [ServerDataSrc] section in the configuration file. UseDictionaryInTransactionLogging = False NOTE: This parameter is not supported if you plan to use Siebel Remote and synchronize between client and server. If you plan to perform only testing and administration tasks connected against the database server, then you will not be affected. For Siebel Remote testing, use the Siebel Web Client and the Siebel Mobile Web Client.
|