Pivotal Greenplum-Informatica Connector 1.0.1 (Experimental) Release Notes

The Pivotal Greenplum-Informatica Connector supports high speed data transfer from an Informatica PowerCenter cluster to a Pivotal Greenplum Database cluster for batch and streaming ETL operations.

This an experimental release of Pivotal Greenplum-Informatica Connector that includes a new architecture, new features, and other improvements as compared to the previous Informatica connector.

Warning: Experimental features are not recommended or supported for production deployments. These features may change in or be removed from future versions of the product based on further testing and feedback. Moreover, any features that may be visible in the open source code but that are not described in the product documentation should be considered experimental and unsupported for production use.

Supported Platforms

The following table identifies the supported component versions for Pivotal Greenplum-Informatica Connector:

Greenplum-Informatica Connector Version Pivotal Greenplum Version PowerCenter Version
1.0.1 (Experimental) 5.6.x 10.x

Refer to the Pivotal Greenplum Database documentation for detailed information on Pivotal Greenplum Database.

See the Informatica PowerCenter documentation for information about the PowerCenter platform and tools.

New and Changed Features

This release of the Pivotal Greenplum-Informatica Connector introduces the following new features and changes:

  • Merge Support

    The 1.0.1 version of the Pivotal Greenplum-Informatica Connector now supports the Merge operation in addition to Insert and Update.

  • Informatica PowerExchange Client Support

    The 1.0.1 version of the Pivotal Greenplum-Informatica Connector supports Informatica PowerExchange Client in addition to the Informatica Developer Tool.

Known Issues and Limitations

Known issues and limitations related to the this experimental release of the Pivotal Greenplum-Informatica Connector include:

  • When performing an Update operation, GPSS displays error messages such as Please use following query to access the detailed error and /api.Gpss/Close SuccessCount:4 ErrorCount:6 <nil>. You can ignore these messages, as they only indicate that the update number is not equal to number of lines loaded.
  • The PreSQL, PostSQL, TruncateTable, and Timeout configuration properties are not yet supported. See Configuring Greenplum Target Session Properties.
  • The Timeout value is fixed at “0”, which means that the connector will wait indefinitely for a response from GPSS.
  • The Informatica Developer Tools limits the precision value of Greenplum Database loader target columns to 65,536.
  • Server components for the connector have only been tested with the Linux version of Informatica Data Integration Service.
  • Informatica does not support removing the registration for a plugin, so there is currently no mechanism for removing a Pivotal Greenplum-Informatica Connector installation from Informatica.