To connect using database selection:

  1. From the Test for JDBC Tool window menu, select Driver / Register Driver. DataDirect Test prompts for a JDBC driver name.
  2. In the Please Supply a Driver URL field, specify a driver (for example com.ddtek.jdbc.sqlserver.SQLServerDriver); then, click OK.
    If the driver was registered successfully, the Test for JDBC Tool window appears with a confirmation in the JDBC/Database Output scroll box.

    Test for JDBC Tool window

  3. From the Test for JDBC Tool window, select Connection / Connect to DB. The Select A Database window appears with a list of default connection URLs.
  4. Select one of the default driver connection URLs. In the Database field, modify the default values of the connection URL appropriately for your environment.
    Note: There are two entries for Db2: one with locationName and another with databaseName. If you are connecting to Db2 for Linux/UNIX/Windows, Db2 Hosted, or Db2 Warehouse on Cloud, select the entry containing databaseName. If you are connecting to Db2 for z/OS or Db2 for i, select the entry containing locationName.
  5. In the User Name and Password fields, type the values for the User and Password connection properties; then, click Connect. For information about JDBC connection properties, refer to your driver's connection property descriptions.
  6. If the connection was successful, the Connection window appears and shows the Connection Established message in the JDBC/Database Output scroll box.
    Important: For the Autonomous REST Connector: REST API data sources do not connect in the same manner as database servers; therefore; the Connection Established notification does not guarantee that the driver is properly configured. To confirm that the driver is correctly configured, you will need to retrieve data from an endpoint using the methods described in "Executing a simple database selection."

    API Connection window