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.

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 |
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.