Etlworks handles batch, real-time, files, APIs, cloud, on-prem, legacy, and streaming integration. Below are the core use-case categories, each with a get-started guide and customer stories.
File to database
Ingest structured or semi-structured files (CSV, Excel, XML) from SFTP, SMB, or cloud storage into SQL databases or cloud warehouses.
Customer stories: LeadingRE optimized partner data integration and image processing; OnPoint Warranty scaled data integration with advanced pipelines and reporting.
Relational database to anything (or anything to relational database)
Move data into or out of SQL Server, PostgreSQL, Oracle, MySQL, and other relational databases — for analytics, application sync, or cross-system integration.
Customer stories: GEN-I enhanced data integration; Community Health Plan of Washington streamlined data integration; VulkanForms centralized data integration.
API to database / API to API
Integrate REST or SOAP APIs with internal systems — persist to a database or chain to another API.
Customer stories: RecBi simplified multi-step data integration workflows; QuickFee powers real-time payment processing and reporting.
Load data into a cloud data warehouse (ETL/ELT)
Load data from operational databases, files, and APIs into modern cloud warehouses using ETL or ELT patterns.
- Snowflake
- Google BigQuery
- Amazon Redshift
- Azure Synapse Analytics and Microsoft Fabric Warehouse
- Vertica
- Greenplum
Customer stories: Intertek Alchemy streams real-time CDC from 1,500+ MySQL databases to Snowflake; Sermo streamlined data integration to Amazon Redshift; Staples Canada loaded data into Google BigQuery; Tallink streams real-time data into Synapse Analytics.
Change Data Capture (CDC)
Stream real-time changes from databases using log-based CDC; replicate into cloud systems.
Customer stories: Universal Music Group enables transactional data sync from MySQL to AS400; Spireon powers real-time data integration; AMK Cambodia simplifies XML data integration.
Real-time streaming
Process events from message queues and MQTT topics in real time.
Customer stories: Ambyint leverages Etlworks for real-time data streaming; Dayton Freight accelerates data integration across diverse platforms.
Event-driven flows and custom APIs
Trigger flows from API calls, webhooks, or other real-time inputs — or expose flows as REST endpoints.
Customer stories: NBCUniversal simplified metadata integration; Transport for NSW created a REST API for Tableau.
Hybrid integration (Integration Agent)
Access on-prem data securely from a cloud-hosted Etlworks instance using the Integration Agent.
Customer stories: OpenGov streamlined data integration across hundreds of customers; Inflow secured data integration across on-premise and cloud systems.
EDI / HL7 to database or API
Transform X12 EDI or HL7 messages into structured datasets for downstream use in APIs or databases.
Get started with EDI documents
Customer story: XSolis processes large X12 messages at scale and simplifies Salesforce integration.
Integration with SaaS platforms
Integrate Etlworks with SaaS platforms to deliver behind-the-scenes integration capabilities to end customers.
Customer stories: Rhenus Automotive streamlined rapid application integration; Stratify powers CRM and ERP integration; Menos simplifies real-time e-commerce data integration.
Explore more
Full catalog of documented use cases: Integration Use Cases. Browse all customer stories: etlworks.com/case-studies/.