Working with Data Design Features › Reverse Engineering › Database Connection Overview

Database Connection Overview

CA ERwin Data Modeler provides a gateway to your physical database using the Database Connection dialog. You use this dialog to enter connection criteria. Once the connection is established, you work directly with the physical catalog as you use CA ERwin Data Modeler modeling tools.

Review the basic requirements for establishing database connection before you attempt to connect to a database.

• Verify that the database you plan to work with is supported by CA ERwin Data Modeler. The current list of supported databases and versions appears in the CA ERwin Data Modeler Release Notes, and in the ERwin Data Modeler - Target Server dialog.
• Select the database and version in the ERwin Data Modeler - Target Server dialog. Click Target Database on the Actions menu in the physical model view to open this dialog. The database that you select in this dialog is used to display connection parameters on the <Database> Connection dialog.
• Install the appropriate client database software on the machine you want to connect from (and which is running CA ERwin Data Modeler). You must use a direct physical connection to the database, not a gateway or proxy connection.
• If your target server is SQL Server, Oracle, or Teradata, you can use Windows Authentication to connect. Before you use this connection option, check with your Database Administrator to be sure Windows Authentication is set up for your Windows account.
• Verify your User Name and Password information if you plan to use the database connection option.
• Know other details about database parameters/values needed to connect, for example, the server and database name, the connection string, the alternate catalog, and so on as is appropriate for your target server.

More information:

Execute a Query Against a Database