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
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.
Pivotal Greenplum-Informatica Connector version 1.0.5 includes the following changes:
- You can specify the
MaxErrorRowssession 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
GreenplumEnhancedLoaderConnection Details dialog.
The following issues were resolved in Pivotal Greenplum-Informatica Connector version 1.0.5:
|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
|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
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
- When performing an Update operation, the Greenplum Stream Server displays error messages such as
Please use following query to access the detailed errorand
/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.
Timeoutvalue 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.