Configuring and testing an ODBC data source on Windows
On Windows systems, you can configure and modify data sources through the ODBC Data Source Administrator, which is available from the Hybrid Data Pipeline Driver forODBC program group. You specify default connection values in the driver’s setup dialog box. The ODBC Data Source Administrator stores the values as user or system data sources in the Windows Registry, or as file data sources in a specified location. See "Creating a Data Source definition in the User's Guide.
The following steps describe how to configure and test a connection to a Hybrid Data Pipeline connectivity service Data Source as a user data source. You must create a Hybrid Data PipelineData Source with the dashboard before using these procedures.
1. From the Progress Hybrid Data Pipeline Driver for ODBC program group in your start menu, start the ODBC Data Source Administrator.
2. On the User DSN tab, click Add to add a new data source.
You can add a file or system data source using similar procedures.
3. Scroll down the list of drivers and select Progress DataDirect Hybrid Data Pipeline.
4. Click Finish.
The Progress DataDirect Hybrid Data Pipeline ODBC Driver window displays with focus on the General tab.
5. For Data Source Name, enter a unique name for this data source, such as myHybridDSN.
6. Optionally enter a description in the Description field.
7. For Hybrid Data Pipeline Source, enter the name of the Hybrid Data PipelineData Source you created in the Hybrid Data Pipeline dashboard, such as MyForceDS.
8. For Service, type the DNS name of the machine where the Hybrid Data Pipeline service is installed.
9. For Port, type the port number that the Hybrid Data Pipeline service is listening to.
10. Click Test Connection and a dialog box will prompt your for credentials.
11. Enter the user name and password for your Hybrid Data Pipeline user account.
Note: You can optionally store the Hybrid Data Pipeline account credentials in the ODBC Data Source by entering them on the Security tab.
12. If you did not store the cloud data store credentials in the cloud Data Source, select the More Options check box and enter the user name and password for the cloud data store. If the account requires a security token, append it to the password.
13. Click OK.
A dialog box is displayed to inform you whether the connection was successful.
14. Configure your ODBC-compliant application to use this data source.
