Prerequisite: Before you begin, you must create a Hybrid Data Pipeline data source. See Creating data sources with the Web UI for details.

On Windows, ODBC data sources are stored in the Windows Registry. You can configure and modify data sources through the ODBC Administrator using a driver Setup dialog box, as described in this section.

When the driver is first installed, the values of its connection options are set by default. These values appear on the driver Setup dialog box tabs when you create a new data source. You can change these default values by modifying the data source. In the following procedure, the description of each tab is followed by a table that lists the connection options for that tab and their initial default values. This table links you to a complete description of the options and their connection string attribute equivalents. The connection string attributes are used to override the default values of the data source if you want to change these values at connection time.

Take the following steps to configure an ODBC data source:

  1. Start the ODBC Administrator by selecting its icon from the Progress DataDirect Hybrid Data Pipeline for ODBC program group.
  2. Select a tab:
    • User DSN: If you are configuring an existing user data source, select the data source name and click Configure to display the driver Setup dialog box.

      If you are configuring a new user data source, click Add to display a list of installed drivers. Select the driver DataDirect HDP 4.6 and click Finish to display the driver Setup dialog box.

    • System DSN: If you are configuring an existing system data source, select the data source name and click Configure to display the driver Setup dialog box.

      If you are configuring a new system data source, click Add to display a list of installed drivers. Select the driver DataDirect HDP 4.6 and click Finish to display the driver Setup dialog box.

    • File DSN: If you are configuring an existing file data source, select the data source file and click Configure to display the driver Setup dialog box.

      If you are configuring a new file data source, click Add to display a list of installed drivers; then, select the driver DataDirect HDP 4.6. Click Advanced if you want to specify attributes; otherwise, click Next to proceed. Specify a name for the data source and click Next. Verify the data source information; then, click Finish to display the driver Setup dialog box.

  3. On the General tab, specify values for the following options:
    • Data Source Name: Type a string that identifies this data source configuration, such as HDP Oracle Connection.
    • Description: Type an optional long description of a data source name, such as My HDP Oracle Connection.
    • Hybrid Data Pipeline Source: Type the name of the Hybrid Data Pipeline data source to which you are connecting.
    • Service: Type the DNS name or IP address of the load balancer or the machine where Hybrid Data Pipeline is installed. For example: my-hdp-instance.example.com.
    • Port Number: Type the port number on which the load balancer or the Hybrid Data Pipeline service is listening.
    Note: See General Tab Options for details.
  4. Specify values for additional options as desired.

    See the following topics for details:

  5. At any point during the configuration process, you can click Test Connect to attempt to connect to the data source using the connection options specified in the driver Setup dialog box. A logon dialog box appears (see "Using a Logon Dialog Box" for details). Note that the information you enter in the logon dialog box during a test connect is not saved.
    1. Enter your Hybrid Data Pipeline user account credentials:

      User Name: Provide your Hybrid Data Pipeline user name.

      Password: Provide your Hybrid Data Pipeline password.

      Note: You can optionally store the Hybrid Data Pipeline account credentials in the ODBC data source by entering them on the Security tab.
    2. Check More Options if you did not store the credentials for the backend data store in the Hybrid Data Pipeline data source. Then, enter the required information:

      Hybrid Data Pipeline Source: Type the name of the Hybrid Data Pipeline data source to which you are connecting.

      Data Source User: Type the user name of the account of the backend data store.

      Data Source Password: Type the pasword of the account of the backend data store.

      Note: Some data stores may require an access or security token. In some cases, this may be appended to the account password.
    3. Click OK.

      A dialog box is displayed to inform you whether the connection was successful.

  6. Click OK. When you click OK, the values you have specified become the defaults when you connect to the data source. You can change these defaults by using this procedure to reconfigure your data source. You can override these defaults by connecting to the data source using a connection string with alternate values.

What to do next:

Use the example application for Windows to test SQL queries.

See Using connection strings for information on how to specify a subset of configurations using a connection string.