Configuring DA Server to Use the SAP HANA JDBC Driver

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

1. Download the JDBC type4 driver JAR file from the SAP® Web site for your HANA DB version.
2. Copy the ngdbc.jar file into the DA library folder:
   • On Windows – %SYBASE%\DA-15_5\server\lib\drivers\ngdbc.jar
   • On UNIX – $SYBASE/DA-15_5/server/lib/drivers/ngdbc.jar

   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.
3. Open and configure the RUN start-up script file:
   • On Windows 32-bit:

     %SYBASE%\DA-15_5\server\instance\RUN_instance_32.bat

   • On Windows 64-bit:

     %SYBASE%\DA-15_5\server\instance\RUN_instance_64.bat

   • On UNIX:

     $SYBASE/DA-15_5/server/instance/RUN_instance_64.sh

   where:

   • %SYBASE% (Windows) or $SYBASE (UNIX) is the directory in which you installed the Data Assurance Option.
   • instance is the name of your DA server.
   • RUN_instance_32.bat or RUN_instance_64.bat is the start-up script file on Windows.
   • RUN_instance_64.sh is the start-up script file on UNIX.
4. Add the location of the SAP HANA JDBC driver JAR file to the DA server CLASSPATH.
   On Windows:

   set CLASSPATH=%CLASSPATH%;%DA_LIB%\drivers\ngdbc.jar

   On UNIX:

   set CP=$CP:$DA_LIB/drivers/ngdbc.jar

5. Save the RUN start-up script file.
6. Restart the DA server for the settings to take effect.

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