Progress DataDirect for JDBC for Greenplum User's Guide Release 6.0.0

Adding a driver

Save PDF

Table of Contents

Adding a driver

Save PDF

Last Updated: July 20, 2023
1 minute read

DataDirect Connectors
JDBC
Documentation

To add a driver with DbVisualizer:

Open DbVisualizer.
From the menu, select Tools>Driver Manager. The Driver Manager window opens.
From the Driver Manager menu, select Driver>Create Driver.
Click the button to navigate to the location of the driver jar file; then, click OK. The following are the default locations for the driver:
Windows
```
C:\Program Files\Progress\DataDirect\JDBC\lib\60\greenplum.jar
```
Linux
```
/opt/Progress/DataDirect/JDBC/lib/60/greenplum.jar
```
Provide values for the following fields; then, close the Driver Manager window.
- Name: Type an alias for your driver. For example:
```
Greenplum
```
- URL Format: Optionally, specify the format of the connection string for your driver. For example:
```
jdbc:datadirect:greenplum:
```
- Driver Class: From the drop down menu, select the driver class for your driver. For example:
```
com.ddtek.jdbcx.greenplum.GreenplumDataSource
```

You can now use your driver with DbVisualizer. Proceed to "Connecting and executing SQL statements" for information on connecting and executing SQL statements.