Skip navigation
Contact Us

Additional Information

PowerExchange for Greenplum

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.

Attributes:
Price: Contact Us
Action:


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.


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 ELT 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 partioning, 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.



Video :


How to load to Greenplum Database using PowerExchange for Greenplum



  • Latest Adapter Version: 9.5.1 HF2
  • 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.



Support Options:
Email: support@informatica.com
Web Support: Informatica Global Customer Support
Phone:

North America: 1-877-463-2435 (1-877-INFA-HELP)


Contact numbers of support centers in other countries



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 (6)