Skip navigation

Log In

Forgot your password?
Don’t have an account? Sign Up

Sign Up

Access our rich network of apps, trials, and services.

Start the registration process by entering your email address below.

Already have an account? Log In

PowerExchange for Greenplum

Contact us for price

Posted by: Informatica Platform

The PowerExchange for Greenplum allows Informatica solutions to seamlessly integrate with Greenplum to extract, transform and load (ETL) data from a wide variety of source systems into the Greenplum Platform.

Overview

The PowerExchange for Greenplum allows Informatica solutions to seamlessly integrate with Greenplum to extract, transform and load (ETL) data from a wide variety of source systems into the Greenplum Platform. The PowerExchange leverages Greenplum’s Scatter Gather technology to eliminate bottlenecks and take full advantage of the speed of Greenplum’s MPP architecture. With this product, connecting Greenplum databases with other systems  using data integration software from Informatica is straightforward, and delivers the highest possible performance.

Key Features

Data Loading

Greenplum’s parallel bulk loading technology gpload are leveraged via the PWX adapter.

Batch loading Methods supported - Via PWX adapter or ODBC.

Real-time loading methods supported - Via PWX adapter or ODBC.

INSERTS, UPDATE and MERGE (UPSERTS) operations are supported.

Pre and Post SQL commands, including User Defined Functions (UDF’s) allow users to perform ETL operations.

Pass-through Partitioning.

Data Extraction

Bulk querying methods supported - DataDirect ODBC for Greenplum.

Record querying methods supported - DataDirect ODBC for Greenplum.

Meta-data Access

ODBC Support - DataDirect ODBC driver for Greenplum.

Other Features

Greenplum tables support partitioning, as well as distribution keys across MPP segments. Data is loaded in bulk via the PWX Adapter directly to Greenplum segments.

Parallel loading into Greenplum is standard when using the adapter, no additional configuration required.

Specifications

  • Partner Product(s) and Version(s) Supported: Greenplum Database 3.x, 4.x
  • PowerCenter Version(s) Supported: 9.0.1, 9.1.0, 9.1 and 9.5.1.

Latest Adapter Version: 9.5.1 HF2

Support

Email:support@informatica.com
Web Support: Informatica Global Customer Support
North America: 1-877-463-2435 (1-877-INFA-HELP)
Phone:Contact numbers of support centers in other countries

Seller

Informatica Corporation is the world’s number one independent provider of data integration software. Thousands of enterprises worldwide depend on Informatica data integration, data quality, and big data solutions to access, integrate, and trust their information assets residing on premise and in the Cloud.

Comments Comments (6)

Related