Pivotal Greenplum-Informatica Connector 1.0.5 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.

Pivotal Greenplum-Informatica Connector 1.0.5 is a maintenance release of the Greenplum Database connector for Informatica. This release includes new features and bug fixes.

Released: July 3, 2019

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.5 5.10.x and above, 6.x 10.x

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

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

Changed Features

Pivotal Greenplum-Informatica Connector version 1.0.5 includes the following changes:

  • You can specify the MaxErrorRows session property to identify the maximum number of errors the Connector should encounter before it considers the task failed.
  • The Connector documentation includes a new procedure to disable verbose logging.
  • You can now specify the Greenplum Database Schema in the GreenplumEnhancedLoader Connection Details dialog.

Resolved Issues

The following issues were resolved in Pivotal Greenplum-Informatica Connector version 1.0.5:

Bug Id Summary
164397005 The Greenplum-Informatica Connector did not always detect and propagate an error returned by the Greenplum Stream Server (GPSS) to Informatica. The Connector now detects GPSS errors and propagates an exception to Informatica.
164487748 In some cases, the Greenplum-Informatica Connector did not close the connection to the Greenplum Stream Server when the Informatica job failed. The Connector now closes the GPSS connection in these failure cases.
164487772 The Greenplum-Informatica Connector prints the PreSQL and PostSQL commands in Informatica Workflow Monitor only when the load operation to Greenplum succeeds and the commands succeed.
165050683 In some cases, the Greenplum-Informatica Connector returned a Success status in Informatica Workflow Monitor even when a task failed. This problem has been resolved. The Connector now exposes a MaxErrorRows property, and returns a failure when a task reaches this configured value.
165874896 In certain situations, the Greenplum-Informatica Connector returned an out of memory error while writing to a Greenplum Database table when it encountered a numeric type with no precision value. This problem has been resolved. The Connector now supports a maximum combined precision and scale value of 1000.

Known Issues and Limitations

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

  • The Informatica server component sometimes crashes if you enable the OS profile feature. Workaround: Temporarily assign write permission to the OS Profile user on the directories $INFA_HOME/server/bin/workspace/.metadata and $INFA_HOME/server/cci/plugins/osgi.
  • When performing an Update operation, the Greenplum Stream Server 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 Timeout value is fixed at “0”, which means that the Connector will wait indefinitely for a response from the Greenplum Stream Server.
  • The Informatica Data Integration Service and Developer Tool do not support unregistering plug-ins, such as the Pivotal Greenplum-Informatica Connector plug-in. Informatica PowerCenter supports unregistering and removing plug-ins.