Greenplum is an open-source massively parallel data platform for analytics, machine learning, and AI. The Etlworks Integrator includes several pre-built Flows optimized for Greenplum.
What can you do with Greenplum in Etlworks Integrator
|
Load data in Greenplum Set the Flow type and source-to-destination transformations parameters. |
Setup Change Replication using high watermark As in any other Flow type, it is possible to configure a change replication using a high watermark. |
|
Setup change replication using change data capture (CDC) Once the CDC is configured for the source database, you can create a CDC pipeline where the source is one of these databases and the destination is Greenplum. |
Load multiple tables by a wildcard name You can load multiple database objects (tables and views) by a wildcard name (without creating individual source-to-destination transformations). |
Related resources
|
Extract, transform, and load data in Greenplum Using Greenplum-optimized Flows, you can extract data from any supported sources and load it directly into Greenplum. |
ELT with Greenplum The Etlworks Integrator supports executing complex ELT scripts directly in the Greenplum database which greatly improves the performance and reliability of the data ingestion. |
Work with Greenplum as a relational database You can use any |
Connect to Greenplum database
Here's how you can connect to the Greenplum database:
Step 1. Open the Connections window and click +.
Step 2. Type greenplum into the search field.
Step 3. Select Greenplum Connection and continue by defining the Connection parameters.
Read more about configuring Greenplum Connection.
Comments
0 comments
Please sign in to leave a comment.