Applications using JDBC to access the Progress DataDirect Hybrid Data Pipeline connectivity service require access to a properly configured Hybrid Data Pipeline Driver for JDBC.

During installation of the Hybrid Data Pipeline server, four configuration and certificate files are generated. For a non-Docker, non-load balancer deployment, these files are written to the Hybrid Data Pipeline installation directory <install_dir>/redist. For load balancer and Docker deployments, these files are written to the redist directory of the shared file location. These files must be copied to the directory from which the JDBC driver installation program will be run. The files are:

  • config.properties
  • OnPremise.properties
  • ddcloud.pem
  • ddcloudTrustStore.jks
Note: The Java installer can be run on any platform, including Windows; however, if you run the Java installer on Windows, turn off User Account Controls or select a non-system directory as the installation directory. The Windows installer allows you to install the Hybrid Data Pipeline Driver for JDBC in the Program Files system directory without turning off User Account Controls.

Take the following steps to install the driver.

  1. Download the product installation file into a temporary directory.
    • Windows: PROGRESS_DATADIRECT_HDP_JDBC_WIN.exe
    • Non-Windows: PROGRESS_DATADIRECT_HDP_JDBC.jar
  2. Copy the four configuration and certificate files from the Hybrid Data Pipeline Server installation into the temporary directory with the installer file.
  3. Run the installer.
    • Windows: Right-click PROGRESS_DATADIRECT_HDP_JDBC_WIN.exe and select Run as administrator.
    • Non-Windows: Double-click PROGRESS_DATADIRECT_HDP_JDBC.jar

    The Introduction window appears.

  4. Click Next.

    The Installation Type window appears.

  5. Choose Standard Installation for the type of installation to perform.
  6. In the Where Would You Like to Install? field, click Choose... to browse to and select an installation directory or type the path, including the drive letter on Windows machines, of the appropriate directory.
  7. Click Next to continue.
    Note: If you specify a directory that contains a previous installation of the driver, a warning message appears allowing you to overwrite your existing installation or specify a different installation directory.
  8. A window appears allowing you to confirm your installation options. Click Previous to revise your choices, or click Install to continue with the installation.
  9. Click Done to exit the installer.

Refer to the Progress DataDirect Hybrid Data Pipeline User's Guide for information on creating Hybrid Data Pipeline data sources.