Administration Guide › Accessing Collected Events with ODBC and JDBC › Example: Preparing to Use ODBC and JDBC Clients with Crystal Reports › Create an "elm" ODBC Data Source

Create an "elm" ODBC Data Source

Use this procedure to create a data source named "CA-ELM."

Note: Install the ODBC client before you can configure the data source.

To create a data source

1. Access the Windows Control Panel.
2. Open the Administrative Tools folder and start the Data Sources (ODBC) utility.
3. Click Add to display the Create New Data Source dialog.
4. Select the entry, DataDirect OpenAccess SDK 6.0 and click Finish.

   The DataDirect OpenAccess SDK ODBC Driver Setup utility displays a configuration screen.

5. Enter CA-ELM in the Data Source Name field, and provide a text description.
6. Enter the name of your CA User Activity Reporting Module server in the Service Host field. This example uses ca-elm.
7. Enter 17002 in the Service Port field.
8. Select the Encrypted SSL check box.
9. Enter the following Custom Properties:

   querytimeout=600 (seconds);queryfederated=true;queryfetchrows=1000;offsetmins=0;suppressNoncriticalErrors=false
   

10. Click Apply and then click Test Connection.

    If your connection parameters are correct, a successful connection message appears.

11. Click OK to return to the ODBC Data Source Administrator dialog and then click OK again to exit the utility.