Integrations and API Management

Connect to any relational and NoSQL database, HTTP-based APIs, and hundreds of business apps. Work with industry-standard data exchange and EDI formats. Design and publish data integration APIs. Use our open APIs and webhooks to create complex automation scenarios.

Integrate with everything

Any Database, Any API, Any Format, Any File Storage

Out of the box, Etlworks supports most relational and NoSQL databases, practically any HTTP-based API, most file storage systems and industry-standard data exchange formats. Etlworks also includes hundreds of ready-to-use read/write connectors for popular business apps and online data sources. Developers can design and publish data integration APIs to enrich data consumed by other apps and trigger event-driven workflows.

Integration Documentation What you can do
Integration
Connectors for databases

Etlworks works equally well with most well-known relational and NoSQL databases.


Connectors for relational databases


Connectors for NoSQL databases

Documentation What you can do
  • ETL data FROM and TO any relational and NoSQL database
  • CDC data from the supported databases
  • Execute SQL queries and scripts
Integration
Generic HTTP connector

Using generic HTTP connector you can create a custom connector for practically any HTTP-based web service. If curl, Postman or SoapUI can do it Etlworks can do it as well, only better.


Read more

Documentation What you can do
  • ETL data FROM and TO any Web Service
  • Copy response from the HTTP request to a file
  • Send the content of the file as a payload for an HTTP endpoint
  • Call HTTP endpoint, optionally send a user-defined payload to an HTTP endpoint
Integration
Connectors for business apps

Etlworks includes hundreds of ready-to-use read/wrire connectors for most popular business apps and online data sources.


Read more

Documentation

These are just a few exampes. There are many more connectors

What you can do
  • ETL data FROM and TO any supported business app and online data source
  • Execute SQL queries and scripts
Integration
Connectors for file storage systems and data exchange formats

Etlworks supports HL7 2.x, HL7 FHIR, X12 and EDIFACT data exchange formats, as well as more common CSV, XML, JSON, Excel, Parquet, Avro and many other formats.

Read more


Etlworks also supports most commonly used file storage systems such as Amazon S3, Azure Blob, FTP and many others.

Read more

Documentation What you can do
  • Copy/Move/Rename/Delete/Archive/Split/Merge files in any of the supported file storage systems
  • ETL files FROM and TO any of the supported data exchange formats
  • Send and receive EDI and HL7 messages
Integration
Connectors for message queues

Message queues, such as Kafka, can be used to build real-time data pipelines to connect various applications. Etlworks supports most well known messages queues.


Read more


Documentation What you can do
  • ETL data FROM and TO any message queues
  • CDC data from the supported databases to message queues
Integration
Connectors for email systems

Etlworks can read emails and email attachments using the POP3 and IMAP protocols and send emails using the SMTP protocol as well as vendor-specific APIs such as Micsosoft Exchange, Office 365 and Gmail.


Read more


Documentation What you can do
  • Send and receive emails and attachements
  • ETL email messages and attachments to any destination
  • Work with email messages in Microsoft Exchnage
  • Work with email messages in Office 365
  • Work with email messages in Gmail
Integration
User-defined API

A user-defined API allows the developer to create custom HTTP endpoints, that can receive requests from third-party applications, triggering execution of the Flows in Etlworks.


Read more

Documentation What you can do
  • Build HTTP endpoint to enrich data from multiple sources and expose it to third-party apps
  • Build HTTP endpoint that can ETL the payload sent from the third-party apps
  • Build HTTP endpoint for CRUD operations
  • Build HTTP endpoint to upload files into any supported files storage system
Integrations
Built-in APIs

Whether you want to build event-driven data integration Flows or incorporate the Etlworks into your own automation workflow, you can use built-in APIs to achieve your goals.


Read more

Documentation What you can do
  • Create and manage flows, connectons, formats and schedules using API
  • Execute and monitor flows
  • Create reports
  • Monitor health of the Etlworks instance
Integration
Webhooks

Webhooks allow you to set up integrations, which subscribe to certain events in the Etlworks. When one of those events is triggered, we'll send an HTTP POST or GET request to the Webhook's configured URL.


Read more

Documentation What you can do
  • Use Webhooks to update your external system about events happening in the Etlworks
  • Send notifications about events happening in the Etlworks to Slack

Ready to Start Using Etlworks?

Try 14 Days Free
Start free trial
Get a Personalized Demo
Request Demo