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 Integrator 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.|
ELT with Vertica
The Etlworks Integrator 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.
Please sign in to leave a comment.