The May 2025 release of Data Ingestion and Replication includes the following changed behavior.
Using GV$TRANSACTION instead of V$TRANSACTION for Oracle sources
Database Ingestion and Replication now uses the GV$TRANSACTION global view instead of the V$TRANSACTION view by default to check for open transactions for CDC processing. Configure your Oracle privileges to grant SELECT to PUBLIC on GV$TRANSACTION. Using GV$TRANSACTION ensures that results for all nodes in a RAC cluster are returned.
GV$TRANSACTION is the default view for new jobs created from the current release. For existing jobs that use V$TRANSACTION and are on hold, the view is not changed when the job is resumed.
Default value for Row Flush Threshold field for CDC Staging tasks increased to 50000 rows
For database ingestion and replication tasks that are part of a CDC staging group, the default value of the Row Flush Threshold field in the New Staging Group dialog box was increased from 20000 rows to 50000 rows.
DataDirect ODBC Driver for PostgreSQL Version 8.x
The Progress DataDirect ODBC Driver for PostgreSQL version 7.x has reached End of Support. In the May 2025 IDMC release, Data Ingestion and Replication delivers both versions 7.x and 8.x of the DataDirect ODBC for PostgreSQL on Linux. Data Ingestion and Replication uses the 8.x driver by default for reading PostgreSQL source data unless you’re using SSL encryption with a Java keystore (jks) of certificate files. In this case, Data Ingestion and Replication transparently uses the older 7.x driver because version 8.x doesn’t support jks keystores. In the future, the version 7.x driver will be dropped. To prepare for eventual version 8.x. use, Informatica recommends that you migrate your jks keystore to the .p12 format, which version 8.x accommodates.