 | 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:
- Drag-and-drop the connector for Vertica to Apatar's work panel.
- Right-click on the connector and select Configure.
- Fill in the authorization details (user name, password, host and database name).
- Click Next.
- The list of Vertica tables appears. Choose the table you would like to extract data from or write data to.
- Click Next.
- Select the mode in which the transformation should run. (Click here to read about the difference between the modes.)If you select Update mode, please also select the field(s) from the list that should be used as primary keys to define if a record already exists in the data target.
 | Make sure you map the fields selected as primary keys to input fields in an operation connecting your data source and data target. |
- 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.
