To add a driver with DbVisualizer:

  1. Open DbVisualizer.
  2. From the menu, select Tools>Driver Manager. The Driver Manager window opens.
  3. From the Driver Manager menu, select Driver>Create Driver.
  4. 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\oracleservicecloud.jar

    Linux

    /opt/Progress/DataDirect/JDBC/lib/60/oracleservicecloud.jar
  5. Provide values for the following fields; then, close the Driver Manager window.
    • Name: Type an alias for your driver. For example:
      Oracle Service Cloud
    • URL Format: Optionally, specify the format of the connection string for your driver. For example: 
      jdbc:datadirect:oracleservicecloud:LoginHost=mysite.custhelp.com;
    • Driver Class: From the drop-down menu, select the driver class for your driver:
      com.ddtek.jdbc.oracleservicecloud.OracleServiceCloudDriver
You can now use your driver with DbVisualizer. Proceed to "Connecting and executing SQL statements" for information on connecting and executing SQL statements.