Connection tab

The Connection tab includes the Connection String and database qualifier for the Optim™ Directory.

Example of the Connection tab on the Optim Directory Editor, described as follows.

Connection String

The name or string that is used by the Optim solution to connect to the database that contains the selected Optim Directory. This value varies based on the DBMS. The following table shows examples of the type of Connection Strings you can specify for each DBMS.

The following table shows examples of the type of Connection Strings you can specify for each DBMS.

DBMS Connect String Example
DB2® Database name or alias.
Oracle Connection string or host string.
SQL Server Data source name (DSN) or server.
Note: You can create DB Aliases for other supported databases, as well as these databases, but you cannot put the Optim Directory in them. For example, you can create DB Aliases to process data for the following data sources, but cannot put the Optim Directory in them: Informix®, Sybase ASE, DB2 for z/OS®, Teradata, Netezza®, PostgreSQL, and Hive (for Hadoop).

DB Name

The DB Name (1-64 characters) identifies the database. This parameter applies to database management systems that support multiple databases within a single database server, such as SQL Server.