Working with Data Models › How to Reverse Engineer a Model from a Database or a Script › Connect to a Database and Reverse Engineer

Connect to a Database and Reverse Engineer

If you are reverse engineering from a database, you must connect to the database to complete the process. The parameters on the Database Connection dialog are displayed based on the database you select.

Follow these steps:

1. Complete the following fields on the Database Connection dialog:

   Database

   Specifies the database that you want to connect to.

   Authentication

   Specifies the type of authentication to use to connect. Select one of the following options:

   Windows Authentication

   Uses Windows user names and passwords to access the database. The user name you provide here must be the dbo of the database.

   Note: This option is available only for Oracle and SQL Server.

   Database Authentication

   Specifies the User Name and Password for the connection.

2. Complete the following fields, as appropriate for the selected database:

   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.