New features and enhancements

The May 2025 release of Data Ingestion and Replication includes the following new features that are common to multiple types of ingestion and replication tasks.

CLAIRE Copilot

CLAIRE Copilot is available to help you create application ingestion and replication tasks and database ingestion and replication tasks and to help you answer questions about Data Ingestion and Replication.

To use CLAIRE Copilot, go to the Data Integration Home page and click the CLAIRE icon to open the conversation window. The following image shows the CLAIRE Copilot conversation window:

You can select one of the sample prompts to get started, or you can enter your own prompt. For a list of examples and more information, see CLAIRE Copilot for Data Integration.

"Add Orderable Sequence" metadata column added for Kafka and file-based targets

For application ingestion and replication jobs and database ingestion and replication jobs that have an Amazon S3, Flat file, Google Cloud Storage, Kafka, Microsoft Azure Data Lake Storage Gen2, or Oracle Cloud Object Storage target and use any load type, you can add a metadata column to the target tables that records a sequence value for each change record that the job inserts into the target table. A sequence value is a combination of an epoch value and a numeric value that incremented for each change. The sequence value is always ascending, but not guaranteed to be sequential and gaps may exist. The sequence value is used to identify the order of activity in the target records.

To add the column, select the Add Orderable Sequence check box in the Advanced section of the target page in the latest task wizard.

"Add Last Replicated Time" metadata column added for Oracle targets

For application ingestion and replication jobs and database ingestion and replication jobs that have an Oracle target and use any load type, you can add a metadata column to the target tables that records the date and time in UTC format at which the last DML insert or update operation was applied. The column data type is timestamp(9). To add the column, select the Add Last Replicated Time check box in the Advanced section of the target page in either the latest task wizard or earlier task wizard. The check box is available for both Standard and Audit apply modes. You can optionally add a prefix to the name of the metadata column to easily identify it and to prevent conflicts with the names of other columns.

Note: If you add the Add Last Replicated Time column to a task with existing target tables and then redeploy the task, the target tables are re-created with the additional metadata column.

Application Ingestion and Replication

The May 2025 release of Application Ingestion and Replication includes the following new features and enhancements:

Load data to PostgreSQL targets from SAP ECC and SAP S4/HANA sources

You can configure an application ingestion and replication task of any load type to replicate data from SAP ECC or SAP S4/HANA sources to a PostgreSQL target. Use the SAP Mass Ingestion connector to extract data from the source and the PostgreSQL connector to load data to the target.

Enhance performance using the chunking options for Oracle Fusion Cloud BICC sources

You can enable data chunking in an Oracle Fusion Cloud source while extracting data in an application ingestion and replication task that uses the BICC replication approach. This feature applies to initial load tasks and the initial unload portion of combined load tasks. In the task's advanced source properties section, enable chunking and then choose either By Primary Key to specify the number of rows per chunk using a numeric primary key column or By Creation Date to segment extracts based on a set number of days using a designated creation date column.

The chunking feature is available for application ingestion and replication tasks in the latest configuration wizard. To get access to this feature for your organization, contact Informatica Global Customer Support.

Database Ingestion and Replication

The May 2025 release of Database Ingestion and Replication includes the following new features and enhancements:

Support for PostgreSQL replica databases as sources

Database ingestion and replication jobs that use any load type can read data from a PostgreSQL replica, or standby, database. A replica is a read-only copy of the primary database typically used for high availability.

To configure a replica database for database ingestion and replication tasks, you must create the replication slot on the replica. Perform the other configuration steps as normal for the primary database. If you generate a CDC script from the configuration wizard, run the script manually against the primary database, outside of the wizard.

Undeploy command available for CDC Staging Tasks

If you configured CDC Staging Tasks for database ingestion and replication jobs in the latest configuration wizard, the monitoring interfaces show the status of each task. On the My Jobs page, the Monitor > Running Jobs and All Jobs pages, and the Operational Insights > Data Ingestion and Replication > All Jobs page, the Undeploy command is now available in the Actions menu for CDC Staging Tasks. You can undeploy a CDC Staging Task that has the status of Aborted, Deployed, Failed, or Stopped.

View a list of apply jobs associated with a CDC Staging Task

When you view job details for a CDC Staging Task from My Jobs, Monitor, or Operational Insights > Data Ingestion and Replication, the new Apply Jobs tab lists all of the apply jobs that are associated with the CDC Staging Task, except any that have been undeployed. In the list, you can drill down on an apply job name to display details, including the job status and the name of the associated CDC Staging Task.