Case studies

44 customers solving real data integration problems.

Healthcare, manufacturing, government, retail, telematics — every industry has its own version of the same hard problem. Pick a slice that matches yours.

Large-scale deployments

Customers running Etlworks at meaningful volume — billions of records, thousands of databases, hundreds of customer environments under one tenant.

Large Scale Deployments

SermoCollect half a billion records daily from SQL Server, Marketo, Salesforce, and Smartsheet into Redshift in real time. Intertek AlchemyStream CDC data from 1,500 MySQL databases into Snowflake in real-time. OpenGovIntegrate data from CSV files, SQL Server databases, and APIs into a centralized cloud system across hundreds of customer environments. Israel Tax AuthorityMove terabytes of data from multiple SQL Server instances into a Vertica-powered warehouse using CDC. NBCUniversalLoad metadata into MongoDB and create APIs for retrieving metadata for movies and shows. Universal Music GroupCDC pipelines from MySQL to AS400. Rhenus AutomotiveIntegration with Zoho Creator and internal systems with Etlworks' hybrid architecture. Dayton FreightCDC streaming from AS400 and Apache Kafka and ETL workflows into Greenplum and Postgres. QuickFeeReal-time reporting for payment processing and transactional data, leveraging integration agents for secure environments. OnPoint WarrantyIntegrate data from S3, SFTP, APIs, cloud storage, and more into MySQL, leveraging advanced reporting APIs.

By source / destination

Where the data comes from and where it lands. Picked one or both endpoints? Start here.

Snowflake

Intertek AlchemyStream CDC data from 1,500 MySQL databases into Snowflake in real-time. GEN-IETL data from multiple SQL Server tables into Snowflake using wildcard-based workflows, parallel partition processing, and high-watermark incremental loads. Capital RxIntegrate cloud storage, APIs, Salesforce, SharePoint, Exchange, Google BigQuery, and more into Snowflake. KyeroIntegrate PostgreSQL, HubSpot, Snowflake, Google Sheets, SFTP, Amazon S3, and more. AmbyintCDC data from multiple MongoDB databases to Snowflake and connect various MQTT brokers streaming device data in real-time. SpireonReal-time CDC data integration from MongoDB and MySQL to Snowflake. TriNetLoad data from complex third-party APIs into Snowflake, with zero-maintenance pipelines. JollyesETL data from files, APIs, and relational databases into Snowflake for reporting and analytics. Tourmo.aiReal-time CDC data integration and ETL from MySQL to Snowflake. AvenueOneIntegrate real estate APIs, SaaS apps, SQL Server databases, Snowflake, and more. The Scion GroupMove hundreds of millions of records daily from SQL Server and APIs into Snowflake for operations, reporting, and automation.

Amazon Redshift

SermoCollect half a billion records daily from SQL Server, Marketo, Salesforce, and Smartsheet into Redshift in real time. XSolisConvert X12 messages to JSON and Parquet, load them into Redshift, and integrate Salesforce. TradeDoublerDiverse workloads from high-volume processing of XML and flat files to loading structured data into Amazon Redshift for analytics. PCCAOn-premise ETL workloads with files, relational databases, and Redshift.

Google BigQuery

Staples CanadaLoad data from SQL Server databases and file-based sources to Google BigQuery. AiwynExtract, transform, and load data from hundreds of sources, running thousands of flows in real-time. PrymatMove and synchronize large volumes of data between on-premise SQL Server databases and Google BigQuery using automatic partitioning. RecBiMultistep workflows for APIs, Salesforce, MySQL, email systems, and Google Cloud services.

Azure Synapse Analytics

TallinkReal-time CDC and batch ETL data from MySQL, Postgres, Oracle, APIs, and file-based sources. BioUrja GroupCloud migrations from databases and file-based sources to Azure. Community Health Plan of WashingtonETL and CDC data from SQL Server and Oracle databases to Azure Synapse. VAT ITStreams transactional data from PostgreSQL into Azure Synapse and Microsoft Fabric in real time using CDC. U.S. SilicaETL pipelines from Oracle, SQL Server, Quickbase, and APIs into an Azure data warehouse.

Relational or NoSQL database

Universal Music GroupCDC pipelines from MySQL to AS400. OpenGovIntegrate data from CSV files, SQL Server databases, and APIs into a centralized cloud system. VulkanFormsETL data from remote locations into a centralized SQL database using secure integration agents. LeadingREProcess XML and JSON files into MySQL, copy images from XML to S3 dynamically, and connect to OData data sources. The Cloudburst GroupLoad complex Excel spreadsheets into Oracle and develop workflows for data automation. MenosLoad data from Amazon Marketplace and Shopify into PostgreSQL in real-time. InflowIntegrate data from on-premise and cloud-based systems, including PostgreSQL, MariaDB, ClickHouse, SQL Server, and third-party APIs. OnPoint WarrantyIntegrate data from S3, SFTP, APIs, cloud storage, and more into MySQL, leveraging advanced reporting APIs. AMK CambodiaETL and CDC data from Oracle and Postgres into an Oracle data warehouse, with transformations for XML data. CerebellyETL flat files with orders and invoices in Sharepoint to PostgreSQL database for reconciliation and reporting.

API or files

Transport for NSWIntegrate data from diverse sources to AWS for centralized management and analytics. StratifyIntegrate with CRM and ERP platforms like Sage Intacct, NetSuite, QuickBooks Online, Salesforce, and more. MarketoExtract data from Marketo via APIs for large enterprise clients. XSolisConvert X12 messages to JSON and Parquet, load them into Redshift, and integrate Salesforce. Cox TransferProcesses, enriches, and loads X12 204 messages into a relational database.

SaaS platforms

Capital RxIntegrate cloud storage, APIs, Salesforce, SharePoint, Exchange, Google BigQuery, and more into Snowflake. SermoCollect half a billion records daily from SQL Server, Marketo, Salesforce, and Smartsheet into Redshift in real time. MenosLoad data from Amazon Marketplace and Shopify into PostgreSQL in real-time. StratifyIntegrate with CRM and ERP platforms like Sage Intacct, NetSuite, QuickBooks Online, Salesforce, and more. Rhenus AutomotiveIntegration with Zoho Creator and internal systems with Etlworks' hybrid architecture. AvenueOneIntegrate real estate APIs, SaaS apps, SQL Server databases, Snowflake, and more.

User-defined APIs created in Etlworks

OpenGovIntegrate data from CSV files, SQL Server databases, and APIs into a centralized cloud system. NBCUniversalLoad metadata into MongoDB and create APIs for retrieving metadata for movies and shows. Transport for NSWIntegrate data from diverse sources to AWS for centralized management and analytics. The Scion GroupMove hundreds of millions of records daily from SQL Server and APIs into Snowflake.

IBM i (AS400)

Universal Music GroupCDC pipelines from MySQL to AS400. Dayton FreightCDC streaming from AS400 and Apache Kafka and ETL workflows into Greenplum and Postgres. The Scoular CompanyCDC streaming from AS400 to SQL Server and various Azure data platforms.

By data integration technique

Sorted by the integration pattern in play — ETL, EDI, CDC, API integration, complex workflows.

ETL, ELT, reverse ETL

Rhenus AutomotiveIntegration with Zoho Creator and internal systems. OpenGovCSV, SQL Server, and APIs into a centralized cloud system. OnPoint WarrantyS3, SFTP, APIs, and cloud storage into MySQL. QuickFeeReal-time payment processing and transactional reporting via integration agents. Community Health Plan of WashingtonETL and CDC from SQL Server and Oracle to Azure Synapse. Capital RxCloud storage, APIs, Salesforce, SharePoint, BigQuery into Snowflake. SermoHalf a billion records daily from SQL Server, Marketo, Salesforce, and Smartsheet to Redshift. U.S. SilicaOracle, SQL Server, Quickbase, and APIs into an Azure data warehouse. KyeroPostgreSQL, HubSpot, Snowflake, Google Sheets, SFTP, S3. TallinkReal-time CDC and batch ETL from MySQL, Postgres, Oracle, APIs, and files. Dayton FreightCDC streaming from AS400 and Apache Kafka into Greenplum and Postgres. Staples CanadaSQL Server and file-based sources to Google BigQuery. InflowOn-premise and cloud systems including PostgreSQL, MariaDB, ClickHouse, SQL Server. AiwynHundreds of sources, thousands of flows in real-time. VulkanFormsRemote locations into a centralized SQL database via integration agents. RecBiMultistep workflows for APIs, Salesforce, MySQL, email systems, Google Cloud. BioUrja GroupCloud migrations from databases and file-based sources to Azure. AMK CambodiaETL and CDC from Oracle and Postgres into an Oracle data warehouse. LeadingREXML and JSON to MySQL, image copying from XML to S3, OData. GEN-IMultiple SQL Server tables into Snowflake with parallel partitioning. CerebellyFlat files with orders and invoices in Sharepoint to PostgreSQL. PrymatLarge-scale SQL Server to Google BigQuery with automatic partitioning. JollyesFiles, APIs, and relational databases into Snowflake. AvenueOneReal estate APIs, SaaS apps, SQL Server, Snowflake. TradeDoublerHigh-volume XML and flat files into Amazon Redshift for analytics. PCCAOn-premise ETL with files, relational databases, and Redshift.

EDI processing

XSolisConvert X12 messages to JSON and Parquet, load into Redshift, integrate Salesforce. Cox TransferProcess, enrich, and load X12 204 messages into a relational database.

Change Data Capture (CDC)

Intertek AlchemyStream CDC data from 1,500 MySQL databases into Snowflake in real-time. Universal Music GroupCDC pipelines from MySQL to AS400. AmbyintCDC from MongoDB to Snowflake plus MQTT brokers streaming device data. The Scoular CompanyCDC streaming from AS400 to SQL Server and Azure data platforms. SpireonReal-time CDC from MongoDB and MySQL to Snowflake. TallinkReal-time CDC and batch ETL from MySQL, Postgres, Oracle, APIs, files. Dayton FreightCDC streaming from AS400 and Apache Kafka into Greenplum and Postgres. AMK CambodiaETL and CDC from Oracle and Postgres into an Oracle data warehouse. VAT ITPostgreSQL into Azure Synapse and Microsoft Fabric in real time using CDC. Israel Tax AuthorityTerabytes from multiple SQL Server instances into Vertica using CDC. Tourmo.aiReal-time CDC and ETL from MySQL to Snowflake. The Scion GroupHundreds of millions of records daily from SQL Server and APIs into Snowflake. Community Health Plan of WashingtonETL and CDC from SQL Server and Oracle to Azure Synapse.

Complex Excel processing

The Cloudburst GroupLoad complex Excel spreadsheets into Oracle and develop workflows for data automation.

API integration & user-defined APIs

NBCUniversalLoad metadata into MongoDB and create APIs for retrieving movie and show metadata. Transport for NSWIntegrate diverse sources into AWS for centralized management and analytics. TriNetLoad data from complex third-party APIs into Snowflake. StratifyCRM and ERP platforms — Sage Intacct, NetSuite, QuickBooks Online, Salesforce. MarketoExtract data from Marketo via APIs for large enterprise clients. LeadingREXML and JSON files to MySQL, image copying, OData. AvenueOneReal estate APIs, SaaS apps, SQL Server, Snowflake. The Scion GroupHundreds of millions of records daily from SQL Server and APIs into Snowflake.

Complex workflows & transformations

AMK CambodiaETL and CDC from Oracle and Postgres with XML transformations. NBCUniversalMongoDB metadata loading and API creation. OpenGovCentralized cloud system with remote agents and reusable templates. OnPoint WarrantyS3, SFTP, APIs, cloud storage into MySQL with advanced reporting APIs. QuickFeeReal-time payment processing and transactional reporting. LeadingREXML and JSON files to MySQL, image copying from XML to S3, OData.

Behind-firewall data with remote agents

OpenGovRemote agents and reusable templates across hundreds of customer environments. QuickFeeIntegration agents for secure environments. InflowOn-premise and cloud-based systems via remote integration agents. VulkanFormsRemote locations into a centralized SQL database via integration agents.

By industry

Customers grouped by vertical — pick the closest match to your business and see how that industry is using the platform.

Healthcare

Community Health Plan of WashingtonETL and CDC data from SQL Server and Oracle databases to Azure Synapse. Capital RxCloud storage, APIs, Salesforce, SharePoint, Exchange, BigQuery, and more into Snowflake. XSolisConvert X12 messages to JSON and Parquet, load into Redshift, integrate Salesforce. SermoHalf a billion records daily from SQL Server, Marketo, Salesforce, and Smartsheet to Redshift.

Education

Intertek AlchemyStream CDC data from 1,500 MySQL databases into Snowflake in real-time.

Manufacturing

U.S. SilicaETL pipelines from Oracle, SQL Server, Quickbase, and APIs into an Azure data warehouse. VulkanFormsETL data from remote locations into a centralized SQL database via integration agents. PCCAOn-premise ETL workloads with files, relational databases, and Redshift.

Agriculture

The Scoular CompanyCDC streaming from AS400 to SQL Server and various Azure data platforms.

Real Estate

KyeroPostgreSQL, HubSpot, Snowflake, Google Sheets, SFTP, S3. LeadingREXML and JSON files to MySQL, image copying from XML to S3, OData. AvenueOneReal estate APIs, SaaS apps, SQL Server, Snowflake. The Scion GroupHundreds of millions of records daily from SQL Server and APIs into Snowflake.

Government Agencies and Contractors

OpenGovCentralized cloud system with remote agents and reusable templates. Israel Tax AuthorityTerabytes from multiple SQL Server instances into Vertica using CDC. The Cloudburst GroupLoad complex Excel spreadsheets into Oracle. Transport for NSWIntegrate data from diverse sources to AWS.

Energy

BioUrja GroupCloud migrations from databases and file-based sources to Azure. GEN-IMultiple SQL Server tables into Snowflake with parallel partitioning and high-watermark loads.

E-commerce and Retail

JollyesFiles, APIs, and relational databases into Snowflake. MenosAmazon Marketplace and Shopify into PostgreSQL in real-time. Staples CanadaSQL Server and file-based sources to Google BigQuery. CerebellyFlat files with orders and invoices in Sharepoint to PostgreSQL. PrymatLarge-scale SQL Server to Google BigQuery with automatic partitioning.

Media and Entertainment

NBCUniversalLoad metadata into MongoDB and create APIs for movie and show metadata. Universal Music GroupCDC pipelines from MySQL to AS400.

IoT and Telematics

AmbyintCDC from MongoDB to Snowflake plus MQTT brokers streaming device data. SpireonReal-time CDC from MongoDB and MySQL to Snowflake. Tourmo.aiReal-time CDC and ETL from MySQL to Snowflake.

Logistics and Transportation

Rhenus AutomotiveIntegration with Zoho Creator and internal systems. TallinkReal-time CDC and batch ETL from MySQL, Postgres, Oracle, APIs, files. Dayton FreightCDC streaming from AS400 and Apache Kafka into Greenplum and Postgres. Cox TransferProcess, enrich, and load X12 204 messages into a relational database.

Financial Services

QuickFeeReal-time payment processing and transactional reporting via integration agents. AMK CambodiaETL and CDC from Oracle and Postgres with XML transformations. VAT ITPostgreSQL to Azure Synapse and Microsoft Fabric using CDC. Israel Tax AuthorityTerabytes from multiple SQL Server instances into Vertica using CDC.

Professional Services and Technology

OnPoint WarrantyS3, SFTP, APIs, cloud storage into MySQL with advanced reporting APIs. TriNetLoad data from complex third-party APIs into Snowflake. StratifyCRM and ERP platforms — Sage Intacct, NetSuite, QuickBooks Online, Salesforce. MarketoExtract data from Marketo via APIs for large enterprise clients. AiwynHundreds of sources, thousands of flows in real-time. RecBiMultistep workflows for APIs, Salesforce, MySQL, email systems, Google Cloud. InflowOn-premise and cloud systems via remote integration agents. TradeDoublerHigh-volume XML and flat files into Amazon Redshift for analytics.

Build the next case study.

14-day free trial, no credit card. The 44 above started exactly here.

Start free trial → Talk to us