⚠️ The DataGalaxy Vertica connector will be removed from the list of supported connectors end of June 2026. It won't be available in your platform anymore.
If you're already using the Vertica connector plugin of the Desktop connector, you can continue using it at your own risk. But it will not be updated anymore (including regarding vulnerabilities) and the support team won't be able to help you if you encounter issues.
If you want a secure solution for gathering metadata from Vertica, use the advanced JDBC mode of the Desktop connector with the Vertica JDBC driver.
This article describes how Vertica connector works.
This connector is available in the following modes:
| Desktop mode ✅ | SaaS Online mode ❌ |
Connector scope
The connector allows you to import the following metadata from Vertica into a Database source.
The extracted objects and their correspondences are detailed in the following table:
Vertica Object | DataGalaxy Object |
| Schema | Model (container) |
| Table | Table (structure) |
| View | View (structure) |
| Column | Column |
| Primary Key | Primary Key |
| Foreign Key | Foreign Key |
Step 1 : Installation
- Download DataGalaxy connector from the portal (see here)
- Extract the connector archive in the directory of your choice
- Download the Vertica plug-in from the portal and copy it into the /lib directory of the connector
Step 2 : Run Vertica connector
- After starting the connector, access to Dictionary connectors:
- If it has been correctly installed, the Vertica plug-in appears in the list
- The following information is requested:
| Parameter | Mandatory | Description |
| Server | Yes | The name or IP address of the Vertica server |
| Port | Yes | |
| Database | Yes | Name of the Vertica database |
| User | Yes | |
| Password | Yes | |
| Advanced Mode | No | Option to customize the JDBC URL used during the connection |
Technical information
The Vertica connector uses the JDBC driver provided by the editor in version 10.1.1: https://www.vertica.com/download/vertica/client-drivers/
Releases
| Date | Plugin Version | DataGalaxy release | Desktop Connector version (minimum) | Description |
| 06/08/2024 | 2.0.0 | v3.65.0 | 5.0.5 | Migrated from java 11 to java 17 + CVE fixes |