Vertica
Vertica is a high-performance, columnar database designed for large-scale data analytics. It offers fast query processing, advanced compression, and scalability, making it well-suited for handling big data and analytical workloads.
Using this connector requires an add-on license, included in the custom connectors package.
Prerequisites
Before connecting, ensure the following prerequisites are met:
- Verify that Vertica is accessible from the iceDQ instance.
- Gather valid user credentials and ensure the user has appropriate permissions to access the database.
- Ensure Vertica JDBC driver version 12.0 or above.
Authentication Mechanism
The following authentication mechanism is supported.
- Username and Password
Connecting to Vertica
Use one or more properties from the table below to create a valid connection. Properties marked with an asterisk (*) are required.
| Name | Description | Example Values |
|---|---|---|
| Connection Name * | Name that uniquely identifies the connection. | Sales_prod_Conn |
| Driver * | Driver used to establish the connection. By default, one driver is available. | Vertica Native JDBC |
| Custom JDBC URL | Standardized string used to define the connection details. Use this format supported by the driver: jdbc:vertica://[host]:[port]/[database] . | jdbc:vertica://165.346.67.85:5433/analytics_db |
| Host * | Server hostname of the Vertica instance. | vertica.acme.com |
| Port * | The port on which the server listens. Default: 5433. | 5433 |
| Database * | Name of the target database in Vertica. | analytics_db |
| Type * | The connection type – either System Connection or User Connection. Refer Connections for more details. | System |
| Username * | Database login username with necessary privileges. | analytics_user |
| Password * | Password associated with the specified username. | Str0ngPass@2025 |
Custom Properties
Custom properties are optional connection parameters in the Vertica driver that allow customization of settings such as timeouts and proxy configurations. A list of supported properties is available here. The availability and behavior of custom connection properties may vary depending on the Vertica JDBC driver version in use.
Supported Datatypes
The following data types are supported:
- BOOLEAN
- BIGINT
- INTEGER
- SMALLINT
- TINYINT
- FLOAT
- DOUBLE PRECISION
- DECIMAL
- CHAR
- VARCHAR
- LONG VARCHAR
- VARBINARY
- LONG VARBINARY
- DATE
- TIMESTAMP
Unsupported Datatypes
The following data types are not supported:
- ARRAY
- SET
- ROW
Data Type Coercion
The following data types are represented as specified:
| Data Type | Represented |
|---|---|
| BIGINT ; SMALLINT ; TINYINT | INTEGER |
| DOUBLE PRECISION | FLOAT |
| DECIMAL ; MONEY | NUMERIC |