Skip to main content

Vertica Vertica

The column-oriented Vertica Analytics Platform is designed to manage large, fast-growing volumes of data and with fast query performance for data warehouses and other query-intensive applications.

Creating a Vertica connection​

Select one of the following methods to create a GCP connection:

Using an account​

To create the connection you need:

  • Access to your Vertica cluster
  • Define which account and database you wish to connect with

Creating your connection​

  1. In the Blink platform, navigate to the Connections page > Add connection. A New Connection dialog box opens displaying icons of external service providers available.
  2. Select the Vertica icon. A dialog box with name of the connection and connection methods appears.
  3. (Optional) Edit the name of the connection. At a later stage you cannot edit the name.
  4. Select Password as the method to make the connection.
  5. Fill in the parameters:
    • Username of the user to use for authentication.
    • Password of the user to use for authentication.
    • The Hostname of the Vertica server, without a protocol. Can be an IP or a domain name, but must be accessible to your runner.
    • The Port number of the server to connect to.
    • Name of the Database you wish you operate on.
  6. (Optional) Click Test Connection to test it.
  7. Click Create connection. The new connection appears on the Connections page.

Using a data source name​

If you want to use a different type of authentication, you can use a custom DSN (Data Source Name) for Blink.

View the Go Vertica Documentation on how to format the connection string.

Creating your connection​

  1. In the Blink platform, navigate to the Connections page > Add connection. A New Connection dialog box opens displaying icons of external service providers available.
  2. Select the Vertica icon. A dialog box with name of the connection and connection methods appears.
  3. (Optional) Edit the name of the connection. At a later stage you cannot edit the name.
  4. Select DSN as the method to make the connection.
  5. Fill in the parameters:
    • The full DSN string to use for connection.
  6. (Optional) Click Test Connection to test it.
  7. Click Create connection. The new connection appears on the Connections page.