After verifying that your JDBC third-party driver is compatible, you can integrate the driver with the Hybrid Data Pipeline environment. The driver should first be integrated with the Hybrid Data Pipeline connectivity service. Then, if you are using the On-Premises Connector, the driver should be integrated with the On-Premises Connector. See the following instructions for details.

Important:
  • There may not be any conflicts between the classes of various drivers. In addition, multiple drivers cannot use different versions of the same library.
  • Certain third-party JDBC drivers, such as the Microsoft JDBC Driver for SQL Server, require the json-smart and accessor-smart jar files. For these drivers, the json-smart and accessor-smart jar files must be copied to the drivers folder with the driver jar file.

Integrating the driver with the Hybrid Data Pipeline connectivity service

Take the following steps to integrate your third-party driver with the connectivity service.

  1. Run the stop service script for each node running the service. The location of the stop script is hdp_install_dir/ddcloud/stop.sh where hdp_install_dir is the installation directory of the Hybrid Data Pipeline server.
  2. Copy the jar file of your third-party JDBC driver to the drivers directory. The drivers directory may be in either of the following locations.
    • Default key location

      hdp_install_dir/ddcloud/keystore/drivers where hdp_install_dir is the installation directory of the Hybrid Data Pipeline server.

    • User-specified key location

      user_specified_location/drivers where user_specified_location is the key location specified during deployment of the Hybrid Data Pipeline server.

  3. Run the start service script for each node running the service. The location of the start script is hdp_install_dir/ddcloud/start.sh.

Result

The third-party driver has been integrated with the Hybrid Data Pipeline connectivity service.

Integrating the driver with the On-Premises Connector

Take the following steps to integrate your third-party driver with the On-Premises Connector.

  1. Stop On-Premises Connector services by selecting Progress DataDirect Hybrid Data Pipeline On-Premises Connector > Stop Services from the Windows Start Menu.
  2. Copy the jar file of your third-party JDBC driver to the opc_install_dir\OPDAS\server\drivers directory where opc_install_dir is the installation directory of the On-Premises Connector.
  3. Start On-Premises Connector services by selecting Progress DataDirect Hybrid Data Pipeline On-Premises Connector > Start Services from the Windows Start Menu.

Result

The third-party driver has been integrated with the On-Premises Connector.

What's next

After the driver has been integrated into the Hybrid Data Pipeline environment, you may proceed with creating a data source to connect to your backend data store. See the following topics for details.