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
- Access the Windows Control Panel.
- Open the Administrative Tools folder and start the Data Sources (ODBC) utility.
- Click Add to display the Create New Data Source dialog.
- Select the entry, DataDirect OpenAccess SDK 6.0 and click Finish.
The DataDirect OpenAccess SDK ODBC Driver Setup utility displays a configuration screen.
- Enter CA-ELM in the Data Source Name field, and provide a text description.
- Enter the name of your CA User Activity Reporting Module server in the Service Host field. This example uses ca-elm.
- Enter 17002 in the Service Port field.
- Select the Encrypted SSL check box.
- Enter the following Custom Properties:
querytimeout=600 (seconds);queryfederated=true;queryfetchrows=1000;offsetmins=0;suppressNoncriticalErrors=false
- Click Apply and then click Test Connection.
If your connection parameters are correct, a successful connection message appears.
- Click OK to return to the ODBC Data Source Administrator dialog and then click OK again to exit the utility.
Copyright © 2013 CA.
All rights reserved.
|
|