Configuring DA Server to Use the Oracle JDBC Driver

Configure the DA server to use the ojdbc.jar Oracle JDBC driver JAR file, before performing a heterogeneous comparison.

  1. Obtain the JDBC driver JAR file from your Oracle installation directory.
    For example, in Oracle 10.2.0, the JAR file is in:
    • On Windows – %ORACLE%\product\10.2.0\server\jdbc\lib\ojdbc14.jar
    • On UNIX – $ORACLE/product/10.2.0/server/jdbc/lib/ojdbc14.jar
  2. Copy the ojdbc14.jar file into the DA library folder:
    • On Windows – %SYBASE%\DA-15_5\server\lib\
    • On UNIX – $SYBASE/DA-15_5/server/lib/
    where %SYBASE% (Windows) or $SYBASE (UNIX) is the directory in which you installed the Data Assurance Option, and lib is the library folder of your DA server instance.
    Note: You need not copy the driver file, if the JAR file is available to the DA server on the same file system.
  3. Restart the DA server for the settings to take effect.

    Follow the same steps to configure a DA agent to use the Oracle JDBC driver JAR file.

Parent topic: Heterogeneous Comparison Configuration
Related tasks
Data Comparison Scenario 1: SAP Adaptive Server to SAP IQ and Oracle Databases
Related reference
create connection