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 install the driver on your local drive.

  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. Double-click the installation file to start the installer.

    The Introduction window opens. Click Next to continue.

    Note: You can exit the installation program at any time by clicking Cancel, or return to the previous window by clicking Previous.
  4. Choose the type of installation to perform. Select one of the following options:
    • Standard Installation. Select this option to install the standard unbranded version of the driver. Click Next to continue with the installation. Continue at the next step.
    • OEM Installation. Select this option if you have purchased a licensed version of the product. Refer to the Progress DataDirect Hybrid Data Pipeline for ODBC Distribution Guide on the Progress PartnerLink website for information on branding and distributing the driver.
  5. In the Where Would You Like to Install? field, type the path, including the drive letter, of the product installation directory or click the Choose button to browse to and select an installation directory. Then click Next.
    • For the 32-bit driver on a 64-bit machine, the default is:

      C:\Program Files (x86)\Progress\DataDirect\Hybrid_Data_Pipeline_for_ODBC

    • For all other installations, the default is:

      C:\Program Files\Progress\DataDirect\Hybrid_Data_Pipeline_for_ODBC

  6. In the Create Default Data Source window, check the box if you want to create a default data source entry in HKEY_CURRENT_USER\Software\ODBC\ODBC.INI.
    Note: If you select Create Default Data Sources, the data source currently in your registry with the same DataDirect default name will be overwritten. To maintain your current DataDirect default data source, rename it before you continue.
  7. Click Next. The Pre-Installation Summary window appears.
  8. Review the Pre-Installation Summary window to confirm the installation setup. Click Previous to revise your choices. Click Install to proceed with the installation.
  9. Click Done to exit the installer.

What to do next:

Refer to the Progress DataDirect Hybrid Data Pipeline User's Guide for information on creating Hybrid Data Pipeline data sources.