CA ERwin Data Modeler Workgroup Edition › Connect to the Mart

Connect to the Mart

Use the Connection Manager to initialize and connect to the mart to access models and perform administrative functions.

To connect to the mart

1. Click Mart, Connection on the File menu.

   The Connection Manager dialog opens.

2. Complete the following information:

   Database

   Identifies the type of relational database management system (DBMS) to which you are connecting. Select from the current list of supported databases.

   Authentication

   Windows Authentication

   Specifies the use of Windows user names and passwords to secure database access.

   Database Authentication

   Specifies the use of a local user name and password for the connection.

   Parameters/Value Options

   Connection Type (Microsoft SQL Server 2005/2008 Only)

   Specifies the use of Native Connection to connect using the SQL Server Native client software or ODBC data to connect using the ODBC data source you have defined.

   Server

   Identifies the server name.

   Database

   Identifies the name of the database or mart.

   Connection String (Oracle Only)

   Specifies the connection string (TNSNames entry).

   You can select a database connection from the Recent Connections panel to populate the Database or Connection String previously used automatically.

3. Click Connect.

   The connection dialog closes. If the mart has been initialized, you are connected and remain connected until you click the Disconnect button on the Connection Manager dialog.

   Note: If the mart has not been accessed yet, you need to first initialize the mart by selecting Mart, Initialize Mart on the File menu.

More information:

Microsoft SQL Server 2005 Permissions

Enable Use of Windows Authentication

Custom Security Message at Connection

Add the Stored Procedure to Activate a Custom Message at Connection