Integration Use Cases
Step-by-step guides for integrating specific systems like databases, APIs, cloud platforms, and more.
Change Data Capture (CDC)
- Change Data Capture (CDC) from transaction log
- Database-Specific CDC Cases
- Tips and Tricks for CDC Flows
- CDC Configuration and Monitoring
- Snapshot Management
- Stream CDC Events into Files (CSV, JSON)
Working with Connected Apps
Building custom APIs
Working with APIs
- Working with APIs
- Test and explore API endpoints
- Using Pre-Configured API Connectors
- Test a payload before sending it to web service
- Cannot Connect to a Web Service
- How to debug HTTP requests
Working with databases
- Get started with databases
- ETL with relational databases
- SQL actions: INSERT, UPDATE, DELETE, MERGE, IFEXIST, CUSTOM
- Advanced SQL with CUSTOM Action
- Transaction management
- Use global variables with database connections
Working with files
Change replication and data synchronization
Bulk load data into databases
Working with Snowflake
- Get started with Snowflake
- Extract, transform, and load data in Snowflake
- Bulk load files into Snowflake
- Load files in Snowflake using user-defined COPY INTO command
- ELT with Snowflake
- Reverse ETL 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
- Load files in Redshift using user-defined COPY command
- ELT with Amazon Redshift
- Reverse ETL 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
- ELT with Azure Synapse Analytics and Microsoft Fabric Warehouse
- Reverse ETL with Azure Synapse Analytics and Microsoft Fabric Warehouse