Installation and Upgrade Guides › Policy Server Installation Guide › Prerequisites for Running Reports Using Crystal Reports › Next Steps › Configure an Oracle ODBC Crystal Reports Data Source

Previous Topic: Configure a SQL Server ODBC Logs Data Source

Next Topic: Configure a SQL Server ODBC Crystal Reports Data Source
Configure an Oracle ODBC Crystal Reports Data Source

The Crystal Reports Data Source allows Crystal Reports to read messages from the Policy Server’s Oracle logging database.

Note: You will need an Oracle client installed on the Crystal Reports’ machine to use the Oracle client driver in this section.

To create and configure the Crystal Reports Data Source

  1. Select Programs, Administrative Tools, Data Sources (ODBC) to access the ODBC Data Source Administrator.
  2. Click the System DSN tab to move it to the front.
  3. Click Add.

    The Create New Data Source dialog box appears.

  4. Scroll down and select the CR Oracle ODBC Driver 4.10 driver and click Finish.

    The ODBC Oracle Driver Setup dialog box appears.

  5. Under the General tab, do the following:
    1. In the Data Source Name field, enter Crystal Reports Oracle Data Source.
    2. (Optional) In the Description field, enter a description of the data source.
    3. In the Server Name field, enter the Oracle service name. Do not use blank spaces in the name.

      This is the Oracle client connection string (TNS) referenced in the Oracle Easy Configuration dialog box. Your version of Oracle may cause this dialog box to appear differently.

      The service name is the name assigned to an Oracle instance specified in the tnsnames.ora file. This file contains service names and details that Oracle uses to identify and connect to Oracle instances. For example, if the tnsnames.ora file contains the following entry for an Oracle instance, enter instance1 in the Server Name field.

      instance1 =
        (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(Host = myhost)(Port =1521))
        (CONNECT_DATA = (SID = SIDofinstance1))
        )

  6. (Optional) Test the connection with the database by clicking Test Connect.
  7. Click the Advanced tab
  8. Check Procedure Returns Results and click Apply and OK.
  9. Click OK to save the selections and exit the ODBC Oracle Driver Setup.

    The configuration is complete.

  10. Edit the SiteMinder reports files to use this Crystal Reports data source.

More Information:

Modify SiteMinder Reports to Use the Crystal Reports Data Source