ODBC Data Sources › Using ODBC Data Sources

Using ODBC Data Sources

The installation of CA ERwin DM r8 creates two ODBC data sources on your machine. One is named ERwin_r8 and the other ERwin_r8_Current. If you want to confirm that these are present, you can invoke the Windows ODBC Data Source Administrator and go to the System DSN tab page, as shown in the following illustration:

Use the connection mechanism of your query tool to connect to one of these data sources. No user ID or password is required by CA ERwin DM.

A connection is made to a specific model loaded into the product. The ERwin_r8_Current data source connects to the current model in CA ERwin DM at the time of connection. The ERwin_r8 data source presents a dialog that allows you to select the target model for the connection. The current model is denoted with an asterisk, as shown in the following illustration of the Model Selection dialog:

If you have multiple copies of CA ERwin DM running, the ODBC driver can serve data from only one instance. By default, this is the first one started. If you want to change which instance of CA ERwin DM is handling the ODBC connection, first stop the driver on the one that is running using the Integrations page on the Options dialog, then start the driver on the second copy of CA ERwin DM from the same place:

For the ERwin Query Tool, use the Connect to ERwin ODBC toolbar item as quick way to make this connection:

To connect to CA ERwin DM using Crystal Reports 2008, follow this process:

• Ensure CA ERwin DM is running with a model loaded.
• Click Report Wizard on the startup pane. If you have not already created a report against CA ERwin DM in Crystal Reports 2008, you will not see ERwin_r8_Current under My Connections.
• Click Create a New Connection in the Available Data Sources tree.
• Expand the ODBC (RDO) entry, select ERwin_r8_Current in the popup window, and click Finish. You should now see ERwin_r8_Current in My Connections.
• Expand ERwin_r8_Current, and then expand CURRENT. You should now see a list of tables available to you and you can start creating a report using the wizard.

  

To connect to CA ERwin DM using Microsoft Office Excel 2007, follow this process:

• Ensure CA ERwin DM is running with a model loaded.
• Click the Data menu item.
• Click the From Other Data Sources tool and select the From Microsoft Query option. You are asked to choose a data source:

  

• Select the ERwin_r8_Current data source, click OK in the Login dialog, and you are connected to CA ERwin DM and ready to start constructing a query. You can either use the Wizard or click Cancel and answer 'Yes' to "Do you want to continue editing this query in Microsoft Query?" to get more direct access to SQL.