You connect to the target DBMS when you use a feature such as Forward or Reverse Engineering or Complete Compare that requires a DBMS connection. You can also connect to a database when you click Database Connection on the Actions menu.
Use the Connection Manager with CA ERwin Data Modeler Workgroup Edition to connect to the mart to access models and perform administrative functions.
To connect to the database or mart
The <Database> Connection or Connection Manager dialog opens.
Specifies the database to which you will connect.
Specifies the type of authentication to use to connect. Select one of the following options:
Windows Authentication
Uses Windows user names and passwords to secure database access when you are currently logged on to your machine as the user who is the dbo of the database.
Note: This option is available only for Oracle and SQL Server.
Database Authentication
Lets you enter a User Name and Password for the connection.
Lets you specify the parameters and variables to use for your target server.
Note: Since the parameters and variables vary depending on your target server, see the Database Connection Parameters for database-specific information.
You connect to the selected target DBMS or mart and the connection dialog closes. You remain connected until you click the Disconnect button on the Connection dialog.
Note: If you use ODBC to connect to your target DBMS, you must set up the ODBC driver to point to the database to which you want to connect.
|
Copyright © 2013 CA.
All rights reserved.
|
|