Database Ingestion and Replication can be used to solve multiple business problems.
You can use Database Ingestion and Replication in the following scenarios:
•Offline reporting. Move user reporting activity from a mission-critical production database system to a separate reporting system to avoid degrading database performance.
•Data warehousing. Help build out data warehouses by transferring data from multiple databases, including on-premises databases, to the data warehouse system. After an initial batch load of data to the data warehouse, Database Ingestion and Replication can propagate data changes continuously from a source database to keep the data in the data warehouse up to date.
•Real-time fraud detection. Run real-time fraud detection analytics against a replica database that Database Ingestion and Replication keeps up to date by providing change data continuously. Fraud detection processes can then run against the latest data without degrading the source system.
•Coordination with big data applications. Keep data lakes synchronized with on-premises sources in a database management system (DBMS) or provide data to Data Integration for at scale processing.
•Migration to cloud-based systems. Migrate data from on-premises database systems to cloud-based systems.