Creating Models › Target Servers for Physical Models › Changing the Target Server › 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

Specifies the type of connection you want to use. 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 that you have defined.

Server

Specifies the name of the server where the database is installed.

Database

Specifies the name of the database that you want to connect to.

SQL Azure

Connection Type

Specifies the type of connection you want to use. 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

Specifies the name of the server where the database is installed.

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

Specifies the name of the database that you want to connect to.

Sybase and Sybase IQ

Server

Specifies the name of the server where the database is installed.

Database

Specifies the name of the database that you want to connect to.

Oracle

Connection String

Specifies the connection string (TNSNames entry).

Connect as SYSDBA

Specifies that you want to connect to Oracle as SYSDBA. Select the check box.

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

ODBC Data Source

Specifies the data source to which you want to connect. The drop-down list displays the data sources that are defined on your computer.

Invoke ODBC Administrator

Specifies whether you want 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 data source.

DB2/zOS

Alternate Catalog

Specifies the name of the alternate catalog that you want to use for the connection. If you leave this value empty, the application connects to the system catalog. If necessary, 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).