Feedback

Databases

📄️ Databases overview

Data Integration enables migrating data from legacy and cloud databases to one of the supported DWHs.

📄️ Database connectivity options

Selecting the optimal connection method

Data Integration offers multiple database River modes to meet the needs of different use cases. Each River mode has its own advantages, and the choice of a River mode depends on the nature of the source data and the requirements of the target database.

📄️ Automatic schema drift management

Schema drift refers to the gradual changes in the structure of data in a Source over time. These changes can have a significant impact on the integrity and accuracy of data replicated to a destination Target, such as a data warehouse.

📄️ Database table configuration options

The configuration options in Relational Database Management Systems (RDBMS) options enable you to manage various settings within different extraction River modes, including Standard Extraction, CDC (Change Data Capture), and System Versioning.

📄️ CDC 'Point in Time' position

Change Data Capture (CDC) is a system designed to monitor source database logs and capture modifications to the source data with precision. The CDC Point in Time Position feature enables you to understand better the operational details of the River's streaming process. This feature also provides crucial assistance for data recovery and synchronization by enabling you to locate and retrieve data from a specific point in time using the precise data stored in the CDC log position.