In order to use the SAP ADS data source, please install the SAP ADS JDBC driver as follows:

  1. Stop the CData Virtuality Server.
  2. Place the SAP ADS JDBC driver in the %dvserver%/modules/system/layers/base/com/sap/ads/main/ folder.

  3. Check the module.xml file and change the driver JAR file name if applicable.

  4. Open the %dvserver%/standalone/configuration/dvserver-standalone.xml file, find the <drivers> section, and enter the following code:

    <driver name="sapads" module="com.sap.ads">
    <driver-class>com.extendedsystems.jdbc.advantage.ADSDriver</driver-class>
    </driver>

  5. Open the %dvserver%/modules/system/layers/base/com/datavirtuality/dv/translator/sap/ads/main/module.xml file, find the <dependencies> section, and enter the following code:

    <module name="com.sap.ads" />

  6. Start the CData Virtuality Server.