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:

    C:\temp

  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. You must specify an absolute path, with the path and file name enclosed in double quotation marks.

    PROGRESS_DATADIRECT_HDP_ODBC_WIN_64.exe –i silent –f "response_file" 

    <The following example performs a silent installation by running a response file named installer.properties from the C:\temp directory:

    PROGRESS_DATADIRECT_HDP_ODBC_WIN_64.exe –i silent –f "C:\temp\installer.properties" 

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

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