Connect to a data source using the JDBC or ODBC drivers

Create an installation directory and download the driver installer

Take the following steps to create an installation directory and download the OPC installer.

1. Create a driver installation directory. For example:

   c:\temp\hdp-odbc-installer\

2. Go to the DataDirect Connectors Download page, complete the download form, and click DOWNLOAD.
3. Click the tab for the driver you are downloading.
4. Download the installer file for the version of the driver you are downloading.
5. Copy the installer file to the installation directory.

Obtain the Hybrid Data Pipeline configuration and certificate files

Take the following steps to obtain the configuration and certificate files generated during the installation of the Hybrid Data Pipeline server.

Note:

• The configuration and certificate files generated during the installation of the Hybrid Data Pipeline server are located in the redist folder of the installation directory. For example:

  /home/ec2-user/Progress/DataDirect/Hybrid_Data_Pipeline/Hybrid_Server/redist/

• These are the Hybrid Data Pipeline server files you must obtain:
  • config.properties
  • OnPremise.properties
  • ddcloud.pem
  • ddcloudTrustStore.jks

Copy the configuration and certificate files from the installation directory on your EC2 instance to the installer directory.

In the following example, an SCP client was used to copy the files from the EC2 instance to a Windows machine.

scp -i C:\hdp-aws\hdp-on-aws.pem ec2-user@ec2-12-34-56-78.compute-1.a
mazonaws.com:/home/ec2-user/Progress/DataDirect/Hybrid_Data_Pipeline/Hybrid_Serv
er/redist/config.properties c:\temp\hdp-odbc-installer\

scp -i C:\hdp-aws\hdp-on-aws.pem ec2-user@ec2-12-34-56-78.compute-1.a
mazonaws.com:/home/ec2-user/Progress/DataDirect/Hybrid_Data_Pipeline/Hybrid_Serv
er/redist/ddcloud.pem c:\temp\hdp-odbc-installer\

scp -i C:\hdp-aws\hdp-on-aws.pem ec2-user@ec2-12-34-56-78.compute-1.a
mazonaws.com:/home/ec2-user/Progress/DataDirect/Hybrid_Data_Pipeline/Hybrid_Serv
er/redist/ddcloudTrustStore.jks c:\temp\hdp-odbc-installer\

scp -i C:\hdp-aws\hdp-on-aws.pem ec2-user@ec2-12-34-56-78.compute-1.a
mazonaws.com:/home/ec2-user/Progress/DataDirect/Hybrid_Data_Pipeline/Hybrid_Serv
er/redist/OnPremise.properties c:\temp\hdp-odbc-installer\

Result: You have all the files that you need to run the OPC installer. For example:

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

Next steps:

• Install and configure the driver. For details, refer to:
  • Installing the Hybrid Data Pipeline Driver for ODBC
  • Installing the Hybrid Data Pipeline Driver for JDBC
• For information about creating data sources, see Open Hybrid Data Pipeline and create a data source.