Skip to content

🧮 Data Driven Integration ​

Data-Driven patterns focus on the movement and transformation of data itself, often in batch or incremental modes. These are ideal for analytical and reporting use cases.

🧠 Key Characteristics ​

  • Data is the trigger for integration
  • Batch or incremental processing
  • Optimized for large volumes
  • ETL/ELT, CDC, file-based ingestion

🧮 Differential Data Synchronization ​

Regular data synchronization using change data capture (CDC). Optimized for large volumes.

Example
Daily synchronization of sales data from Salesforce to our Data Warehouse to feed Power BI dashboards.

📦 Full Data Synchronization ​

Full table or file loads at scheduled intervals. Used for low-volume sources or when CDC is not available.

Example
Weekly loading of Excel forecast files sent by subsidiaries into the Azure Data Lake.

✅ When to Use ​

  • Data is updated periodically
  • Historical or analytical processing is needed
  • Source systems do not support real-time APIs