Manage your Greenplum data in MySQL with Talend

Greenplum uses massively parallel processing (MPP) architecture and a database based on PostgreSQL to deliver analytics on large datasets. Greenplum uses MPP to distribute the big data workload to data warehouses and maximize a system’s resources in parallel. The Greenplum Database software can be deployed on on-premises hardware or cloud servers, and parent company Dell EMC also sells it as part of a hardware bundle. Manage Greenplum data in MySQL with Talend's suite of data integration tools.

Connecting to Greenplum

To connect to a Greenplum database, use the tGreenplumConnection component. Choose a property type (built-in or repository) and additional details such as the host, port, database, schema, and username and password.

Learn more about connecting to Greenplum

More about integrating Greenplum data

Talend has detailed documentation on how to ETL your Greenplum data for a better view of the business.

Connecting to MySQL

MySQL is an open source relational database management system based on Structured Query Language.

Connect to MySQL with our native connector in a simple four-step process: Drag and drop the MySQL component from the Talend Palette onto the design workspace and set up your credentials.

Configuring a connection to a MySQL database >

Type in your login details and a few fields about your MySQL data, and you’ll be able to a lot of things with Talend:

  • Write, update, make changes, or suppress entries in a database.
  • Execute the stated SQL query on a specified MySQL database.
  • Check MySQL database rows against specific data quality patterns (regular expression) or Data Quality rules (business rule).
  • Call a MySQL database stored procedure.
  • Write a file with columns based on the defined delimiter and the MySQL or Aurora standards.
  • Obtain the primary key value of the record that was last inserted in a MySQL table by a user.

Get more from your Greenplum data

Deliver data your organization can trust... Get started today.

Explore Talend's full suite of apps