Testing the Connection
You can use DataDirect Test™ to verify your connection. The screen shots in this section were taken on a Windows system.
To test the connection from the driver to your data source, follow these steps:
1. Navigate to the installation directory. The default location is:
Windows systems:
Program Files\Progress\DataDirect\JDBC_51\testforjdbc
UNIX and Linux systems:
/opt/Progress/DataDirect/JDBC_51/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:
3. Click Press Here to Continue .
The main dialog appears:
4. From the menu bar, select Connection > Connect to DB .
The Select A Database dialog appears:
5. Select the appropriate database template from the Defined Databases field.
6. In the Database field, specify the correct ServerName and PortNumber for your Amazon Redshift data source.
For example:
jdbc:datadirect:redshift://Server3:5439;databaseName=Test
7. If you did not specify your user name and password in the connection URL, enter this information in the corresponding fields.
8. Click Connect .
If the connection information is entered correctly, the JDBC/Database Output window reports that a connection has been established. (If a connection is not established, the window reports an error.)
For more information about using DataDirect Test, see
Using DataDirect Test .
Windows systems: Program Files\Progress\DataDirect\JDBC_51\testforjdbc
