skip to main content
Quick Start: Accessing REST data sources using basic authentication : Connecting to a DataSource : Connecting using data sources : Testing a data source connection
  

Try DataDirect Drivers Now
Testing a data source connection
You can use DataDirect Test to establish and test a data source connection. The screen shots in this section were taken on a Windows system.
Important: Receiving a Connection Established notification from the DataDirect Test tool is only partial confirmation that the driver is properly configured. Since REST services lack traditional database structures, you will need to retrieve data from an endpoint using the following steps to confirm that you have successfully connected to your data.
Take the following steps to establish a connection.
1. Navigate to the installation directory. The default location is:
*Windows systems: Program Files\Progress\DataDirect\JDBC_60\testforjdbc
*UNIX and Linux systems: /opt/Progress/DataDirect/JDBC_60/testforjdbc 
For UNIX/Linux, if you do not have access to /opt, your home directory will be used in its place.
2. From the testforjdbc folder, run the platform-specific tool:
*testforjdbc.bat (on Windows systems)
*testforjdbc.sh (on UNIX and 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 via Data Source.
The Select A Database dialog appears:
The Select a Database dialog box
5. Select a datasource template from the Defined Datasources field.
6. Provide the following information:
a. In the Initial Context Factory, specify the location of the initial context provider for your application.
b. In the Context Provider URL, specify the location of the context provider for your application.
c. In the Datasource field, specify the name of your datasource.
7. If you are using user ID/password authentication, enter your user ID and password in the corresponding fields.
8. Click Connect. The JDBC/Database Output window reports that a connection has been established.
Note: The Connection Established notification does not confirm that the Resftful driver is properly configured. You will need to retrieve data from an endpoint using the following steps to confirm that you have successfully connected to your data.
Connection window
9. From the Connection window menu, select Connection / Create Statement. The Connection window indicates that the creation of the statement was successful.
10. Select Statement / Execute Stmt Query. DataDirect Test displays a dialog box that prompts for a SQL statement.
Execute SQL Query window
11. Type a Select statement and click Submit. Then, click Close.
12. Select Results / Show All Results. The data from your result set displays in the JDBC/Database Output scroll box.
Connection window with table data
If your data displays in the JDBC/Database Output box, you have successfully configured the driver.