Use Cases

Working with databases

• Get started with databases
• Migrate data from one database to another
• SQL actions: INSERT, UPDATE, DELETE, MERGE, IFEXIST, CUSTOM
• Transaction management
• Open database connection when needed
• Automatically create or alter a destination table

See all 13 articles

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

See all 7 articles

Working with files

• Get started with files
• A transformation where a file is a source
• A transformation where a file is a destination
• File operations
• The destination file name in file operations

Working with web services

• Get started with web services
• Examples of the custom API connectors

Working with Snowflake

• Get started with Snowflake
• Extract, transform, and load data in Snowflake
• ELT with Snowflake
• Load files in cloud storage into Snowflake
• Directly load files in Snowflake
• Use wildcard filenames in Snowflake COPY INTO command

See all 8 articles

Working with Amazon Redshift

• Get started with Amazon Redshift
• Extract, transform, and load data in Amazon Redshift
• ELT with Amazon Redshift
• Directly load files in Redshift
• Work with Amazon Redshift as a relational database
• Data type mapping for Redshift

Working with Google BigQuery

• Get started with Google BigQuery
• Extract, transform, and load data in Google BigQuery
• ELT with Google BigQuery
• Work with Google BigQuery as a relational database

Working with Azure Synapse Analytics

• Get started with Azure Synapse Analytics
• Extract, transform, and load data in Azure Synapse Analytics
• ELT with Azure Synapse Analytics
• Work with Azure Synapse Analytics as a relational database

Working with Greenplum

• Get started with Greenplum database
• Extract, transform, and load data in Greenplum
• ELT with Greenplum
• Work with Greenplum as a relational database

Bulk load data into databases

• ETL into databases using bulk load
• Bulk load files into the database without transformation

Working with Salesforce

• Get started with Salesforce

Working with emails

• Get started with emails
• Send emails and attachments
• Send email in HTML Format
• Read, browse, filter, and delete emails and attachments

Connecting to Google services

• Connect to Google services using OAuth2
• Google service account
• Google service account email
• Default Google service account
• Create a new service account

Working with Google Analytics

• Get started with Google Analytics
• Extract data from Google Analytics and load into any destination

Working with Google AdWords

• Get started with Google AdWords
• Extract data from Google AdWords and load into any destination

Working with Google Sheets

• Get started with Google Sheets

Working with Redis

• Get started with Redis

Working with MongoDB

• Get started with MongoDB
• Extract and load data in MongoDB
• Work with documents in MongoDB

Working with message queues, such as Kafka

• Get started with message queues

Working with EDI documents

• Get started with EDI documents

Working with HL7 messages

• Get started with HL7
• Create HL7 messages
• Send and receive HL7 messages

Working with social networks

• Get started with social networks
• Work with Facebook
• Work with Twitter
• Explore data in social networks
• Save data returned by social network API into a file
• Automate a status update in multiple social networks

Working with Amazon MWS API

• Get started with Amazon MWS API
• Submit data using the Feeds API
• Check the status of data submitted through the Feeds API