• 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 Vertica Database

Use the following procedure to connect to your Vertica database.

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

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

    • If the Vertica ODBC Driver is not installed on your PC, you’ll 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 if you would like to connect to the Vertica 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 already used).

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

    • Enter your Password to complete the information about Vertica database connection.

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

  4. Select the Connection String option in the Mode drop-down list if you would like to connect to the Vertica database using special connection string.

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

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