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

Take the following steps to create a response file using the installer.

  1. Download the product installation file into a temporary directory. For example, on a 64-bit machine, the file name is PROGRESS_DATADIRECT_HDP_ODBC_WIN_64.exe.
  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 Windows command prompt, type the following command where response_file is the path and file name of the response file you want to create. You must specify an absolute path, with the path and file name enclosed in double quotation marks.

    PROGRESS_DATADIRECT_HDP_ODBC_WIN_64.exe -r response_file 

    The following example creates a response file named installer.properties in the C:\temp directory.

    PROGRESS_DATADIRECT_HDP_ODBC_WIN_64.exe -r "C:\temp\installer.properties"

  4. Continue the installation at Step 4 in Installing the ODBC driver on Windows.

See Performing the silent installation for instructions on running the response file.