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.

On each machine, take the following steps to install the driver.

  1. Copy the product installer and the response file you created to a temporary directory.
  2. Copy the four configuration and certificate files from the Hybrid Data Pipeline Server installation into the temporary directory with the installer and response files.
  3. At a command prompt, change to the directory containing the installer and supporting files.
  4. Type the following command where response_file is the path and file name of the response file created in Creating the response file using the installer or Creating a response file using a text editor.
    • Windows: PROGRESS_DATADIRECT_HDP_JDBC_WIN.exe -f  response_file -i silent
    • Non-Windows: java -jar PROGRESS_DATADIRECT_HDP_JDBC.jar -f  response_file -i silent
    Note: You can specify an absolute or relative path. If the path is not specified, the silent installation looks for the response file in the current working directory.

    Windows Example:

    This example performs a silent installation by running a response file named installer.properties in the C:\temp directory.

    PROGRESS_DATADIRECT_HDP_JDBC_WIN.exe -f C:\temp\installer.properties -i silent

    Linux Example:

    This example performs a silent installation by running a response file named installer.properties in the /install directory, which is relative to the current working directory.

    java -jar PROGRESS_DATADIRECT_HDP_JDBC.jar -f /install/installer.properties -i silent

  5. The installation proceeds without any further user intervention or notification.

Refer to the installation log file for a record of any problems that may have occurred during the installation. See JDBC driver installation log files for details.