Overview
Vertica is an analytical database and query engine that leverages the power of cloud-based technologies but can be deployed on-premises as well. The Etlworks includes several pre-built Flows optimized for Vertica.
Flows optimized for Vertica
| Flow type | When to use |
|
When you need to extract data from any source, transform it and load it into Vertica. |
| Bulk load files into Vertica | When you need to bulk-load files that already exist in local or cloud storage without applying any transformations. The flow automatically generates the COPY command and MERGEs data into the destination. |
| Stream CDC events into Vertica | When you need to stream updates from the database which supports Change Data Capture (CDC) into Vertica in real-time. |
| Stream messages from a queue into Vertica | When you need to stream messages from the message queue which supports streaming into Vertica in real time. |
Related resources
|
ELT with Vertica The Etlworks supports executing complex ELT scripts directly in Vertica, which greatly improves the performance and reliability of the data ingestion. |
Reverse ETL with Vertica You can use any
|
|
Setup incremental replication using High Watermark (HWM) Using HWM replication, you can load only new and updated records into Vertica. |
Load multiple tables by a wildcard name You can ETL data from multiple database objects (tables and views) into Vertica by a wildcard name without creating individual source-to-destination transformations. |
Connect to Vertica
Step 1. Open the Connections window and click +.
Step 2. Type verticainto the search field.
Step 3. Select Vertica Connection and continue by defining the Connection parameters.
Read more about configuring Vertica Connection.
Comments
0 comments
Please sign in to leave a comment.