# Etlworks Etlworks is an enterprise-grade data integration platform with a real AI agent built in. It handles CDC, ETL, ELT, reverse ETL, APIs, files, EDI, message queues, IoT, and event-driven workflows across cloud, on-premise, and hybrid environments. The platform supports 270+ connectors to databases, SaaS apps, file systems, message queues, and APIs. It runs at petabyte scale with high availability and supports SOC 2, HIPAA, GDPR, a data processing addendum, SSO via SAML and OpenID Connect, role-based access control with six roles, MFA, and multi-tenancy. The AI agent has tools across the entire platform — flows, code, CLI, metadata, monitoring. It can build pipelines from natural language descriptions, infer schemas, generate transformations, apply best-practice templates, debug failures, and watch production flows. The agent works alongside data engineers and solutions architects rather than replacing them. It is reachable in the product, through the REST API, through the built-in CLI, and through an MCP server that exposes the same tools to external clients such as Cursor and Claude Desktop. ## What the platform does - **Change data capture** — log-based CDC for SQL Server, MySQL, Oracle, PostgreSQL, Db2, MongoDB, and IBM i, with no Kafka or Debezium installation required: https://etlworks.com/real-time-cdc.html - **Every data movement pattern** — ETL, ELT with warehouse pushdown, reverse ETL, EDI, APIs, files, queues, and IoT: https://etlworks.com/solutions.html - **dbt** — dbt Core runs as a native flow type against your existing warehouse connection, with Git-pinned projects, artifacts and lineage in execution history, and a separate flow for triggering dbt Platform jobs: https://etlworks.com/dbt-integration.html - **Schema drift** — tables created, columns added, primary keys and indexes generated, wildcard processing, custom metadata rules, and AI-assisted mapping: https://etlworks.com/schema-drift.html - **Data quality** — script-based validation per field and per record, SQL-like filtering, full SQL over non-SQL sources, deduplication, enrichment, pivots and reshaping, set operations, and pre/post verification with SQL or dbt: https://etlworks.com/data-quality.html - **Streaming and message queues** — Kafka, Azure Event Hubs, Google Pub/Sub, Amazon Kinesis, SQS, RabbitMQ, and ActiveMQ, read or written or streamed continuously, with CDC events published straight to a topic: https://etlworks.com/message-queues.html - **IoT and MQTT** — MQTT 3 and 5, wildcard topics, quality of service, certificate authentication, Base64 and Sparkplug B payloads, and broker-to-broker forwarding: https://etlworks.com/iot-mqtt.html - **Files** — 21 formats, every one both a source and a destination: CSV, fixed length text, Excel, Key=Value, CLOB, byte array, JSON, XML, Avro, Parquet, JSON dataset, XML dataset, X12, EDIFACT, NCPDP, VDA, HL7 2.x, HL7 FHIR, PDF, HTML, and QVD. Wildcard matching, nested mapping, and file operations that run without a transformation: https://etlworks.com/file-processing.html - **Visibility and traceability** — execution history, automatic per-run findings with severities, an executions heatmap, self-opening resource incidents, and a filterable audit trail available over the API: https://etlworks.com/observability.html - **Security and compliance** — SOC 2, HIPAA, GDPR, DPA, tag-based artifact access, and an eight-layer permission model: https://etlworks.com/security.html - **Developer surfaces** — REST API, built-in CLI with SQL, scripting in SQL, JavaScript and Python, and an MCP server: https://etlworks.com/dev/ - **OpenAPI specs** — platform REST API: https://etlworks.com/dev/api/etlworks-api.openapi.yaml ; AI Agent API: https://etlworks.com/dev/ai/etlworks-ai-agent-api.openapi.yaml ## Deployment and pricing Cloud, hybrid, and on-premise. Pricing starts at $300/month for first projects, $600/month for production teams, and $1,000+/month for mission-critical workloads with real-time CDC, dedicated infrastructure, SSO, and on-premise options. All plans include unlimited users, connections, and flows. Free 14-day trial, no credit card required: https://etlworks.com/pricing.html ## Customers Etlworks is used by data teams at NBCUniversal, Universal Music Group, Staples Canada, OpenGov, Raiffeisen Bank International, Rhenus Automotive, Sermo, Aiwyn, SpecialtyCare, Ambyint, QuickFee, Dayton Freight, U.S. Silica, and GEN-I. Case studies: https://etlworks.com/case-studies/ A 9-slide company overview (product, customers, deployment options, security, pricing, roadmap) is available as a PDF: https://etlworks.com/downloads/etlworks-introduction.pdf ## Comparisons Etlworks maintains side-by-side comparisons against 44 data integration platforms, including Fivetran, Airbyte, Informatica, Talend, Matillion, MuleSoft, Boomi, SnapLogic, Workato, Zapier, n8n, Make, Airflow, Dagster, dbt, Debezium, AWS Glue, AWS DMS, Azure Data Factory, Microsoft Fabric Data Factory, Google Cloud, Databricks LakeFlow, Snowflake Openflow, Oracle GoldenGate, Oracle Data Integrator, IBM DataStage, IBM StreamSets, SAP, Qlik, Estuary, Striim, and SSIS: https://etlworks.com/etl-tools-comparison.html Each comparison covers pricing, integration scope, transformations, dbt, orchestration, CDC and streaming, lineage and audit, developer experience, compliance, and generative AI, and states where the other tool is the better choice. Compared to traditional integration platforms, Etlworks differentiates by having a real built-in agent that operates across every part of the platform rather than a chatbot grafted onto an existing UI, by fixed per-tier pricing instead of per-row or per-seat metering, and by covering ingestion, transformation, and orchestration in one product. ## Why Etlworks A letter from the founder: some customers have left Etlworks over price or corporate politics, but in ten years none left because the product didn't deliver. It covers hands-on engineering support, real complexity, the AI agent, same-day fixes on the cloud and for self-hosted installs, and why vibe-coded integrations are hard to keep running: https://etlworks.com/why-etlworks.html ## Roadmap What Etlworks is building next, with no dates: a registry, health model and approval-gated control actions for the AI agents a customer already runs; schema drift ALTER and DROP; official Kubernetes support; and end-to-end lineage with a data catalog: https://etlworks.com/roadmap.html ## Blog The Etlworks blog is at https://etlworks.com/blog/ (RSS: https://etlworks.com/blog/feed.xml). It covers AI and data integration, best practices, lessons from real production deployments, product releases, and platform engineering notes, written by the Etlworks team.