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 create a response file using the installer.

  1. Download the product installation file to 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. At a command prompt, type the following command where response_file is the path and file name of the response file you want to create. Specify an absolute path. If the path is not specified, the specified file is created in the current working directory.

    java -jar PROGRESS_DATADIRECT_HDP_JDBC.jar -r response_file 

    This example for Windows systems creates a response file named installer.properties in the C:\temp directory:

    java -jar PROGRESS_DATADIRECT_HDP_JDBC.jar -r C:\temp\installer.properties 

    This example for Linux systems creates a response file named installer.properties in the /install directory:

    java -jar PROGRESS_DATADIRECT_HDP_JDBC.jar -r ./install/installer.properties 

  4. The Introduction window appears. Click Next.
  5. In the Where Would You Like to Install? field, type the path, including the drive letter on Windows machines, of the product installation directory or click Choose (...) to browse to and select an installation directory.

    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.
  6. Click Done to exit the installer. The response file is created in the directory you specified in Step 3.
    See Performing the silent installation for instructions on running the response file.