To use the driver to access data with DbVisualizer:

  1. Open DbVisualizer.
  2. From the menu, select Database>New Connection. When prompted to use the Connection Wizard, click OK.
  3. Provide the following information when prompted; then, click Next to proceed:
    • Connection alias: Type the name to be used when referring to this connection.
    • Driver: Select the alias that you provided for your driver from the drop-down menu.
  4. Provide values for the following fields; then, click Finish.
    • Database URL: Copy and paste your connection URL into this field. The following examples show how to connect using either user ID/password or Kerberos authentication.

      User ID/password authentication

      jdbc:datadirect:greenplum://server1:5432;
AuthenticationMethod=userIdPassword;User=test;
Password=secret;
      Note: See Configuring the driver for user ID/password authentication for details.

      Kerberos authentication

      jdbc:datadirect:greenplum://server1:5432;
DatabaseName=greenplumDB;AuthenticationMethod=kerberos;
ServicePrincipalName=postgres/myserver.example.com@EXAMPLE.COM;
      Note: See Configuring the driver for Kerberos authentication for details.
  5. To execute SQL statements, select SQL Commander>New SQL Commander. A SQL Commander tab opens.
  6. Select values for the following fields:
    • Database Connection: Select connection alias you provided for the connection from the drop-down menu.
    • Schema: Select the schema you want to execute queries against from the drop-down menu.
  7. In the SQL Commander tab, enter SQL commands you want to execute; then select SQL Commander>Execute. For example:

    To select all of the rows from the BLOGS table: 

    SELECT * BLOGS
    To select the details of a specified company: 
    SELECT * FROM COMPANY WHERE COMPANYID = <company_id>
    Note: If you are fetching large sets of data, you may want to limit the results using the Max Rows and Max Chars fields.
You have successfully accessed your data with DbVisualizer.