Database Ingestion and Replication runs on a Secure Agent. You must install the Secure Agent on a Linux or Windows machine prior to using Database Ingestion and Replication.
After you start the Secure Agent the first time, the Database Ingestion and Replication agent and packages are installed locally. You then can use the Data Ingestion and Replication to configure database ingestion and replication tasks and to run and monitor database ingestion and replication jobs.
The following image shows the general architecture of Database Ingestion and Replication:
From the Web-based interface in Informatica Intelligent Cloud Services, you can create and manage ingestion tasks and run and monitor ingestion jobs.
The following interactions occur:
1When you download the Secure Agent to your on-premises system, the Database Ingestion DBMI packages are also downloaded, provided that you have a license for Database Ingestion. You can then configure the DBMI agent service.
2From the Informatica Intelligent Cloud Services Web-based interface, you define database ingestion and replication tasks.
3When you deploy a data ingestion task, a corresponding executable job is created on the Secure Agent system.
4When you run a database ingestion and replication job, the ingestion and replication task metadata is pushed down to the Secure Agent. The job uses this information to process data.
- For an initial load operation, the database ingestion and replication job extracts data at a specific point-in-time from the source tables and fields. The job uses the database API of the relational source to retrieve the data.
- For an incremental load operation, the database ingestion and replication job captures changes, such as inserts, updates, and deletes, for the source tables and fields from the source database logs. Change data capture runs continuously or until the job is stopped or ends.
The data is loaded to the target using the appropriate target API.
