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.

Take the following steps to install from a command line.

  1. Download the product installation file into a temporary directory.
    Non-Windows installer: 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. At a command prompt, type the installation command:

    java -jar PROGRESS_DATADIRECT_HDP_JDBC.jar -i console 

    Press ENTER.

    The installer prompts you to answer questions regarding the installation. To accept the default value, press ENTER. To return to the previous step, type back and press ENTER.

  4. The Introduction step appears. Press ENTER.
  5. You are prompted for the installation directory. Enter the full path to the installation directory, or press ENTER to accept the default directory.
  6. You are prompted to confirm the installation directory. If the installation directory is correct, type y and press ENTER.
    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.
  7. You are prompted to review the product name and installation directory. Press ENTER to continue.
  8. If the product was successfully installed, a message appears confirming the installation. Press ENTER to exit the installer.

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