Before modifying an application with the URL to connect, you can use DataDirect Test™ to verify the URL. The screen shots in this section were taken on a Windows system.

To test the connection from the driver to a data store, follow these steps:

  1. Navigate to the driver installation directory. For example, to point to the file for an installation on /opt/jdbc, you navigate to:
    /opt/jdbc/Hybrid_for_JDBC
  2. From the testforjdbc folder, run the platform-specific tool:
    testforjdbc.sh (on Linux systems)

    The Test for JDBC Tool window appears:


    Test for JDBC Tool landing page

  3. Click Press Here to Continue.
    The main dialog appears:

    Test for JDBC Tool window

  4. From the menu bar, select Connection > Connect to DB.

    The Select A Database dialog appears:


    Select a Database dialog box

  5. Select the Database field to edit the URL.
  6. At the end of the URL, replace myDataSource with the name of the Data Source defined in the Hybrid Data Pipeline dashboard.
  7. If you did not store credentials for the data store in the Data Source, add these parameters to the end of the JDBC URL:
    • datastoreUserId=<user_name> 
    • datastorePassword=<password> (optionally, if the account requires a security token, append it to the password) 

    For example, with a user name of me@mycompany.com, a password of myPassword, and a security token of zzzzzzzzzzzzzzz, append the following to the URL: datastoreUserId=me@mycompany.com; datastorePassword=myPasswordzzzzzzzzzzzzzzz

  8. For User Name, type your Hybrid Data Pipeline account user name.
  9. For Password, type your Hybrid Data Pipeline account password.
  10. Click Connect.

    The dialog reports whether the connection was successful.

Now that you have verified the connection URL, you can use that in your JDBC application, as described in Connecting from an Application to Hybrid Data Pipeline.