This guide will help you learn how to extract/load data from/to Vertica Analytic Database, a high-performance, grid-based column-oriented database management system used for analytics and business intelligence.

Configuration

To gain access to Vertica Analytic Database, please do the following:

1. Drag-and-drop the connector for Vertica to Apatar's work panel.
   
   
   
   
2. Right-click on the connector and select Configure.
3. Fill in the authorization details (user name, password, host and database name).
   
   
   
   
4. Click Next.
5. The list of Vertica tables appears. Choose the table you would like to extract data from or write data to.
6. Click Next. If all the previous actions were performed correctly, you will see the names of the data fields.
7. Click Finish.

If necessary, you can preview the data entries. To do so, right-click on the connector and choose "Preview Results".

Now you can integrate your Vertica Analytic Database with other data sources.