Use Cases

Working with databases

• Getting started with databases
• SQL actions: INSERT,UPDATE,DELETE,MERGE,IFEXIST
• Change replication with databases
• Automatically create a destination table
• Automatically create staging tables from any data source
• Expose a database object or SQL query as an API endpoint

See all 10 articles

Change replication and data synchronization

• Real-time change replication with Kafka and Debezium
• Change Replication using High Watermark
• Using a fully-qualified field name for high watermark field
• Calculating high watermark field value
• Manually setting the value of the high watermark field
• Change replication between 2 databases

See all 8 articles

Working with files

• Getting started working 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

• Getting started working with web services
• Extracting, transforming and loading data in web services
• Using copy file operations to copy the response to the file and send the payload to API
• Connecting to well-know APIs if there is no built-in connector

Working with emails

• Getting started with emails
• Sending emails and attachments
• Reading, browsing, filtering, and deleting emails and attachments

Working with social networks

• Getting started with social networks
• Working with Facebook
• Working with Twitter
• Exploring data in social networks
• Saving data returned by social network API into a file
• Automating a status update in multiple social networks

Connecting to Google services

• Google service account
• Google service account email
• Default Google service account
• Creating a new service account
• Connecting to Google services using OAuth2

Working with Google Analytics

• Getting started with Google Analytics
• Extracting data from Google Analytics and loading into any destination

Working with Google AdWords

• Getting started with Google AdWords
• Extracting data from Google AdWords and loading into any destination

Working with Google Sheets

• Getting started with Google Sheets

Loading data in Snowflake

• Getting started with Snowflake
• How to create flows to load data in Snowflake
• Snowflake flow examples
• Using wildcard filenames in Snowflake COPY INTO command

Loading data in Amazon Redshift

• Getting started with Amazon Redshift
• Loading data in Amazon Redshift
• Working with Amazon Redshift as with a relational database
• Change Replication with Amazon Redshift
• How to do MERGE with Amazon Redshift

Working with Redis

• Getting started with Redis

Working with MongoDB

• Getting started with MongoDB
• Extracting and loading data in MongoDB
• Working with documents in MongoDB

Working with message queues, such as Kafka

• Getting started with message queues

Working with HL7 messages

• Getting started with HL7
• Examples of working with HL7 messages
• Sending and receiving HL7 messages

Working with Amazon MWS API

• Getting started with Amazon MWS API
• Submitting data using the Feeds API
• Checking the status of data submitted through the Feeds API