Target Servers and the Physical Model › Database Connection Parameters

Database Connection Parameters

The connection parameters in the Database Connection dialog vary depending on the target server you select. The variable connection parameters in CA ERwin Data Modeler are:

SQL Server:

Connection Type

Select Use Native Connection to connect using the API provided by the SQL Server Native client software. Select Use ODBC Data to connect using the ODBC data source you have defined.

Server

Enter the server name.

Database

Enter the name of the database.

SQL Azure:

Connection Type

Select Use Native Connection to connect using the API provided by the SQL Server Native client software. Select Use ODBC Data to connect using the ODBC data source you have defined.

Server

Enter the server name.

Note: You may need to append the SQL Azure server name to the login in the connection string using the <login>@<server> notation. If you do, separate the login and the SQL Azure server name with the at (@) symbol. For more information, see Connecting to SQL Azure.

Database

Enter the name of the database.

Sybase and Sybase IQ:

Server

Enter the server name.

Database

Enter the name of the database.

Oracle:

Connection String

Enter the connection string (TNSNames entry).

Connect as SYSDBA

Select the check box to connect to Oracle as SYSDBA.

ODBC/Generic, DB2 LUW, Informix, DB2 for i, MySQL, Progress, SAS, and Teradata:

ODBC Data Source

Enter the data source, or leave the default selection unchanged. When you click the ODBC Data Source box, a drop-down list displays the data sources defined on your machine.

Invoke ODBC Administrator

Select the check box to start the ODBC Administrator software and display the Select Data Source dialog. You can then select a previously defined data source, or create a new one.

DB2/zOS:

Alternate Catalog

Enter the name of the alternate catalog you want to use for the connection. If you leave this value empty, the connection is made to the system catalog. If appropriate, you may consider connecting to the alternate catalog for faster reverse engineering.

The Parameters/Value Options in CA ERwin Data Modeler Workgroup Edition are:

SQL Server and Sybase:

Server

Enter the server name.

Database

Enter the name of the database.

Oracle:

Connection String

Enter the connection string (TNSNames entry).