Manage your Greenplum data in SQL Server 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 SQL Server 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 SQL Server

SQL Server is a popular relational database management system created by Microsoft.

Connect to your Microsoft SQL Server database with our native connector and easily carry out the following actions on your data:

  • Write, update, make changes or suppress entries defined on a table and/or on the data contained in a table
  • Prepare a file to be used as parameter in an INSERT query to feed a MS SQL database.
  • Execute a SQL query stated onto a specified Microsoft SQL Server or Azure SQL database.
  • Offer a convenient way to centralize multiple or complex queries in a database and calls them easily.

Get more from your Greenplum data

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

Explore Talend's full suite of apps