Connection tab

The Connection tab displays the name of the database that is associated with the DB alias and a connection string that the Optim solution uses to access it.

Example of the Connection tab on the DB Alias Editor, described in following text.

Connection String

The name or string that is used by the Optim solution to connect to the database associated with the alias. This entry varies based on the DBMS.

The following table shows examples of the type of Connection Strings you can specify for each DBMS. If you can put the Optim™ Directory in the DBMS, Yes is displayed in the Optim Directory? column. If not, No is displayed in that column.

DBMS Connect String Example Optim Directory?
DB2® Database name or alias. Yes
Oracle Connection string or host string. Yes
SQL Server Data source name (DSN) or server. Yes
Hive (for Hadoop) Name of the configured ODBC data source. No
Informix® Server name. No
Netezza® Name of the configured ODBC data source. No
PostgreSQL Name of the configured ODBC data source. No
Sybase ASE Server name. No
Teradata TDP ID for client connection to server system. No

DB Name

The DB name (1 - 64 characters) identifies the database that is associated with the alias. This parameter applies to database management systems that support multiple database instances within a single database server, such as Sybase ASE and SQL Server.



Feedback