Use Cases

Working with databases

• Getting started with databases
• Migrating data from one database to another
• SQL actions: INSERT,UPDATE,DELETE,MERGE,IFEXIST
• Transaction management
• Automatically create a destination table
• ELT with databases

See all 12 articles

Change replication and data synchronization

• Comparing data replication techniques
• Change Data Capture (CDC)
• Real-time change replication with Kafka and Debezium
• Change Replication using High Watermark (HWM)
• Using a fully-qualified field name for high watermark field
• Calculating high watermark field value

See all 13 articles

Working with files

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

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

• Getting started with Snowflake
• Extract, transform and load data in Snowflake
• ELT with Snowflake
• Directly load files in Snowflake
• Using wildcard filenames in Snowflake COPY INTO command
• Working with Snowflake as a relational database

See all 7 articles

Working with Amazon Redshift

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

Working with Salesforce

• Getting started with Salesforce

Working with Marketo

• Getting started with Marketo

Working with HubSpot

• Getting started with HubSpot

Working with emails

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

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

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 EDI documents

• Getting started with EDI documents

Working with HL7 messages

• Getting started with HL7
• Creating HL7 messages
• Sending and receiving HL7 messages

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

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