Vertica Integration with Toad Data Point: Connection Guide

About Vertica Connection Guides

Vertica connection guides provide basic instructions for connecting a third-party partner product to Vertica. Connection guides are based on our testing with specific versions of Vertica and the partner product.

Vertica and Toad Data Point: Versions Tested

Software Version
Partner Product

Toad Data Point 6.1 (64-bit)

Desktop Platform

Microsoft Windows Server 2019 R2 Standard

Vertica Client

Vertica ODBC driver version 23.3.0

Vertica Server

Vertica Analytical Database 23.3.0

Vertica Server Platform RHEL 8.7

Toad Data Point Overview

Toad Data Point is a querying and data integration tool that connects to a wide range of data sources. It includes database diagrams and query builder features.

Installing Toad Data Point

  1. Go to the Toad Data Point download page and click Download Free Trial.
  2. We tested the Toad Data Point Traditional tool. Click Download Free Trial.
  3. Complete the required fields and click Download Trial.
  4. Open Toad Data Point installer and follow the installation prompts. For more information see the Toad Data Point Installation Guide.

Installing the Vertica Client Driver

Before you can connect to Vertica using Toad Data Point, you must install the ODBC client driver. Follow these steps:

  1. Go to the Vertica Client Drivers page.
  2. Download the version of the Vertica client package that is compatible with the architecture of your operating system and Vertica server version.
  3. Based on the client driver package you downloaded, follow the installation instructions in the Vertica documentation.

Note For more information about client and server compatibility, see Client Driver and Server Version Compatibility in the Vertica documentation.

  1. Create an ODBC DSN as described in the Creating an ODBC Data Source Name (DSN).

Connecting Toad Data Point to Vertica

With Toad Data Point running, do the following to connect to Vertica:

  1. Select File > New > Connection. The Create New Connection window appears.
  2. Select Vertica from the Group drop-down list.

  3. In the General tab, enter the following information:
    • Data source name: Select the DSN created earlier.
    • User: Enter the database user name.
    • Password: Enter the database password.
    • Database: Select the browse button to choose the default database and click Yes.
      This will populate the list of schemas in the Database drop-down list. Select the Database that you want to connect with.

  4. Click Connect. Upon a successful connection, the schemas appear in the Object Explorer.

Known Limitations

The following is a list of known limitations with data types when connecting Toad Data point to Vertica:

  • BINARY, VARBINARY, and LONG VARBINARY data types are not supported.
  • For NUMERIC data type, precision of up to 28 digits is supported.
  • For TIME, TIMETZ, TIMESTAMP, and TIMESTAMPTZ data types, milliseconds are not supported.
  • For TIMETZ data type, time zone is not supported.

For More Information