• Scroll to top of this topic Scroll to Top of Page

  • Print the current topic Print Topic

  • No expanding elements on this page Show/Hide Expanders

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).

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