ConnectionString

The connection string to connect to the database.

TIP: Any instances of the character '@', except those immediately before a DSN or TNS name, must be escaped with a backslash. For example, you must escape this character if it appears in your password.

TIP: You can encrypt the value of this parameter before entering it into the configuration file. Encrypt the entire parameter value, not just the password. For information about how to encrypt parameter values, refer to the IDOL Getting Started Guide.

Type: String (can be encrypted)
Default:  
Required: No
Configuration Section: Database Repository
Example:

To connect to an ODBC database:

ConnectionString=DSN=Groups
ConnectionString=USER/PASSWORD@DSN
ConnectionString=DSN=value;UID=user;PWD=password

To connect to an Oracle database, use the following format:

ConnectionString=USER/PASSWORD@TNS_ALIAS

or alternatively the full descriptor:

ConnectionString=user/password@(DESCRIPTION = (FAILOVER = ON)(CONNECT_TIMEOUT = 5)(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1522))(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1522)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = servicename)))

See Also: