Administration Guide › Accessing Collected Events with ODBC and JDBC › Example: Preparing to Use ODBC and JDBC Clients with Crystal Reports › Edit the Crystal Reports Configuration File

Edit the Crystal Reports Configuration File

Before you can use Crystal Reports with the CA User Activity Reporting Module JDBC client, you must first provide some configuration settings. After you configure the Crystal Reports XML configuration file, you are ready to prepare and send ANSI SQL standard queries to the CA User Activity Reporting Module event log store.

To configure Crystal Reports settings for JDBC

1. Ensure that you copy the JDBC client JAR files to the Crystal Reports server before you edit the configuration file.

   More information is available in the Implementation Guide.

2. Access the server where Crystal Reports resides.
3. Locate the file, CRConfig.xml, and open it for editing.
4. Locate the <DataDriverCommon> tag and the <Classpath> tag section under it.
5. Add the location of the JDBC JAR files for the JDBC client to the classpath.
6. Change the value in the JDBC URL tags to the following:

   jdbc:ca-elm://127.0.0.1:17002;encrypted=1;ServerDataSource=Default;CustomProperties=(querytimeout=600;queryfederated=true;queryfetchrows=1000;offsetmins=0;suppressNoncriticalErrors=false)
   

   See the section on JDBC URL considerations for more explanation of these parameters.

   Refer to the documentation supplied with Crystal Reports for additional information on setting connection parameters in that product.

7. Change the value in the JDBC Classname tags to be the following:

   com.ca.jdbc.openaccess.OpenAccessDriver
   

8. Save the file and exit.

More information:

JDBC URL Considerations