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

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 ODBC driver installation program will be run. The files are:

  • config.properties
  • OnPremise.properties
  • ddcloud.pem
  • ddcloudTrustStore.jks

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

  1. Copy the installer and the response file you created to a temporary directory, for example:

    /tmp

  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. Execute the following command where response_file is the path and file name of the response file created in Creating a response file.

    PROGRESS_DATADIRECT_HDP_ODBC_LINUX_64.bin -i silent -f response_file  

    The following example performs a silent installation by running a response file named installer.properties that resides in your home directory:

    PROGRESS_DATADIRECT_HDP_ODBC_LINUX_64.bin -i silent -f /home/users/johndoe/installer.properties 

  5. The installation proceeds without any further user intervention unless you enter an incorrect value on the command line or in the response file, in which case an error is displayed and installation stops. You must correct the command line or silent installation response file and execute it again.

If you have any problems during installation, see ODBC driver installation log files.