Database Compare Suite™

Connecting to a Greenplum database

Use the following procedure to connect to your Greenplum database:

  1. Click on the New icon in the Project panel at the top left corner of the window.

  2. Select Greenplum in the Platform drop-down list at the top of the dialog box.

    • If the psqlODBC driver is not installed on your PC, you will need to install it. For more information, see Installing the Required Database Drivers.

    • After installing the driver, restart the DataBase Compare Suite application and get back to item # 1.

  3. Select the Standard option in the Mode drop-down list should you want to connect to the Greenplum database in the standard mode.

    • Specify the Server name in the appropriate field. You can enter it manually or select it from the drop-down list (if it has been used already).

    • Provide the remainder of connection information to the Greenplum database: Server Port, Database name and Username. You can manually enter these values or select them from drop-down lists.

    • Enter the Password to fill in the information about Greenplum database connection.

    • Press the Test button to verify that you can successfully connect to your Greenplum database.

  4. Select the ConnectionString option in the Mode drop-down list if you want to connect to the Greenplum database using the connection string.

    • Enter the Connection string manually or select it from the drop-down list (if it has already been used).

    • Find the connection string template below. Use it as an example to create a connection string that allows to connect to your Greenplum database:

      Driver={PostgreSQL Unicode(x64)};Server=greenplum_server;Port=5432;database=greenplum_db;Uid=greenplum_user;Pwd=pass;BoolsAsChar=False;Sslmode=Prefer;UseDeclareFetch=1;ByteaAsLongVarBinary=1;application_name=DB Best Database Compare Suite;
      
    • Press the Test button to verify that you can successfully connect to your Greenplum database.


Didn’t find the answer?

You can report problems, ask questions or share ideas for improvements on our email [email protected].