Integration Use Cases
Step-by-step guides for integrating specific systems like databases, APIs, cloud platforms, and more. Organized by source and destination types.
Working with Connected Apps
Working with APIs
Working with databases
- Get started with databases
- ETL with relational databases
- Create pipeline to CDC data into relational database
- SQL actions: INSERT, UPDATE, DELETE, MERGE, IFEXIST, CUSTOM
- Transaction management
- Open database connection when needed
Working with files
Change replication and data synchronization
- Compare data replication techniques
- Change Data Capture (CDC) from transaction log
- Change Replication using High Watermark (HWM)
- Change Data Tracking (CT)
- Real-time change replication with Kafka and Debezium
- Change replication using full refresh
Bulk load data into databases
Working with Snowflake
- Get started with Snowflake
- Extract, transform, and load data in Snowflake
- Bulk load files into Snowflake
- Create pipeline to CDC data into Snowflake
- Load files in Snowflake using user-defined COPY INTO command
- ELT with Snowflake
Working with Amazon Redshift
- Get started with Amazon Redshift
- Extract, transform, and load data in Amazon Redshift
- Bulk load files in S3 into Redshift
- Create pipeline to CDC data into Amazon Redshift
- Load files in Redshift using user-defined COPY command
- ELT with Amazon Redshift
Working with Google BigQuery
Working with Azure Synapse Analytics and Microsoft Fabric Warehouse
- Get started with Azure Synapse Analytics and Microsoft Fabric Warehouse
- Extract, transform, and load data in Azure Synapse Analytics and Microsoft Fabric Warehouse
- Bulk load files in Azure Storage into Synapse Analytics and Microsoft Fabric Warehouse
- Create pipeline to CDC data into Azure Synapse Analytics and Microsoft Fabric Warehouse
- ELT with Azure Synapse Analytics and Microsoft Fabric Warehouse
- Reverse ETL with Azure Synapse Analytics and Microsoft Fabric Warehouse