Data Integration Solved

Integrate all your data on the cloud and on-premise with our powerful and easy to use data integration service.

Try It Free Demo

01. Benefits Lower Costs, save time

Integrator is an all-in-one data integration service for all your projects, regardless of data location, format and volume.

Connect to everything

Connected

Connect to all your APIs and data sources even if they are behind the firewall. Build data integration APIs.

Ready-to-use data integration scenarios

Easy

Select from multiple of built-in common data integration scenarios such as export, import, data replication, backup and many others.

Save money

Cost Effective

Let us host and manage a solution for you or install it on your own hardware and have a full control.

Data Integration for everyone

Simple

Manage your own data integration workflow using simple drag and drop interface or let us create it for you.

02. Our solutions Data Integration for everyone

Out-of-the-box Integrator supports numerous highly configurable data integration scenarios.

Data Export

Export data from relational databases, cloud data sources, public and private APIs to CSV, XML, JSON, PDF and Excel files, downloaded locally or saved to cloud file storage. If your database or service is behind the firewall, we can install a small, zero-maintenance integration agent which will push data to the cloud.

Data Import

Load data from files, relational databases, cloud sources, public and private APIs to other databases, cloud sources and APIs. You can map source and destination fields and create very complex transformations.

Change Replication

Set up a real-time change replication between different databases with minimum effort. Out-of-the-box Integrator supports change replication for Oracle, SQL Server, MySql, PostgreSQL, DB2, Informix and Sybase as well as any JDBC compatible database.

Backup

Create a copy of the relational database or cloud data in another database or file storage such as Amazon S3, Google Cloud Storage, FTP and SFTP. For example, you can point Integrator to the API endpoint which returns a complex nested data in JSON format and Integrator will automatically create and load data into the multiple staging tables.

Automation

Build very complex, event-driven workflow with multiple integration points and decision branches. Use a wizard-based drag and drop interface as well as JavaScript and SQL to create data integration scenarios.

Connect to API and Web Services

Read and write data from and to public and private APIs and web services. Out-of-the box Integrator supports a growing list of well-known APIs, but it is also easy to connect to practically any REST based or SOAP API as well as APIs based on industry standard EDI formats, such as HL7.

05. How it works Simple, Connected, Powerful

Choose from tens of connectors, formats and built-in scenarios to create your own data integration flows. Schedule flow and monitor as it’s running in real time or execute it on demand.

06. Customers and Partners Who trusts us


07. FAQ Would you like to know more?

Have questions? We have answers.

Who are we?

Etlworks is a creator of Etlworks Integrator, a powerful, and easy to use data integration service. We help businesses of any sizes connect various systems and APIs through the common gateway.

Etlworks is a subsidiary of the Toolsverse.com. We are the same group of people who brought you industry-leading Toolsverse ETL Framework, Data Explorer and Integration Agent. Etlworks has been founded to handle the development and marketing of the Integrator.

Why choose us?

We provide best in class data integration service, which is powerful, yet easy to use. Our customers trust us because we deliver exactly what we promise. Connect to everything with us!

We are happy to inform you that Integrator was awarded with not one, but two of the prestigeous FinancesOnline awards. We won their Great User Experience Award for 2017 and the 2017 Rising Star Award for their top business intelligence software category.

What is Integrator?

Integrator is a cloud data integration service which can also be installed on premise.

How Integrator is different from other similar services and products?

Integrator is a powerful and easy-to-use cloud data integration service which can work with data behind the corporate firewall. Users can create very complex data integration scenarios in no time, right in the browser, using intuitive drag and drop interface. Also, Integrator is a full blown Enterprise Service Bus, so users can easily build data integration APIs. Last but not least, Integrator supports unique data integration scenarios, typically requiring a specialized set of tools and costing a fortune to implement, such as: database change replication, HL7 transformations, direct data upload into the online data-warehouses such as Snowflake, and many others.

Is it possible to add new functionality to the Integrator?

Integrator has been designed to be expandable. Connectors, data integration modules, dashboards and other components are implemented as plugin modules and can be added or removed on the fly without restarting the service.

Can we install Integrator on premise?

Yes you can. Read more about our on premise options.

Installing Integrator on premise is not an option. Can it still work with the data behind the firewall?

No worries, we have got you covered. Please read below.

My database is in a corporate network, behind the firewall. How can Integrator access it from the cloud?

We install and configure a zero-maintenance background service called Integration Agent right in your network, which talks to your corporate database and to the Integrator on the cloud.

How does the Integration Agent communicate with a databases and APIs in a corporate network?

Integration Agent works behind the corporate firewall, so it communicates with databases and APIs directly. It uses JDBC to talk to the databases and HTTP to get and push data to REST and SOAP APIs.

How does the Integration Agent, working behind the corporate firewall, communicate with Integrator on a cloud?

Integration Agent can push data to the secure cloud file storage such as Amazon S3, which is accessible by Integrator, or it can push data directly to the Integrator REST API.

Is it possible to load data into my corporate database or API using the Integration Agent?

Absolutely. Our Integration Agent can load data into the database or API just as well as extract it.

So, why do I need a cloud-based Integrator if I have the Integration Agent working behind my corporate firewall?

Integration Agent is limited to simple change replication, extract and load scenarios. Integrator and Integration Agent work together to support very complex data integration flows with transformations, mapping and logic.

Can Integrator connect to to my database/application/service/etc?

Almost certainly - it can. Please see the list of the available connectors. If connector you are looking for is not on a list - we or our partners can develop it practically in no time.

Can Integrator connect to web services?

Integrator supports REST and SOAP based web services through an HTTP connector. You specify the endpoint, type of the payload and format (JSON, XML, etc.), as well as any authentication parameters and Integrator will handle the rest. Integrator will automatically connect to the endpoint, push the payload and parse the response. There is no difference between working with the web services compare to working with the files downloaded locally.

Can Integrator connect to the well know APIs?

Integrator includes a growing list of connectors to the well knows APIs, such as Google Analytics, Marketo, etc. We are constantly adding new connectors so please stay tuned.

Does Integrator have it's own REST API so we can integrate our system with it?

In Integrator you can configure API endpoints, which will be listening to the incoming HTTP POST requests and, once payload is received, will trigger an execution of the data integration flows. You can also execute flows, created in Integrator, using REST API. Read more about integrations and APIs.

Does integrator support any of the standard EDI formats such as HL7?

Integrator fully supports HL7 v 2.x and 3.x. We are working on adding connectors to other formats. Please stay tuned.

Can we trust our data to you?

We don’t have access to your data at all unless you opt-in to store it on our servers. If needed, we can install Integrator on any hardware managed by you, including cloud providers such as Amazon and Microsoft.

How do you protect data?

We take security very seriously. We only use SSL connections, all our API endpoints are protected by short-lived JWT tokens and we encrypt all passwords, security keys and tokens.

How do you encrypt credentials?

In Integrator all passwords, access keys, and other secure credentials are encrypted by strong encryption algorithm with 512-bit key.

Where I can read more about your security policies?

Security Policies.

Can I try service before buying it?

Yes you can. Just sign-up to the service and use it free of charge for 20 days. You can choose a specific subscription plan once your trial period expires.

How do I choose a subscription plan?

You can choose between the three most common packages. Subscription plans are based on how much data will be moved every day; how many scheduled packages are required and how often scheduled flows must be executed.

Is it possible to install Integrator on premise?

Absolutely. Read more about our on premise options.

What is a difference between subscribing to the service or buying Integrator as a product?

When you subscribe to the service we manage everything, from hardware to software and you pay us fixed monthly fee. When you buy a license for the Integrator as a product you pay us one-time upfront fee, we help you install and configure Integrator and you own it forever. You can subscribe to the extended support and we will help you create data integration flows.

Is support included in the subscription?

Standard support is included. We provide monitored service 24/7 and you will receive free automatic upgrades as long as you are subscribed to the service. As a part of the subscription plan, you will have access to all available connectors.

What is a quick start service?

When you subscribe to our service we will help you configure your first connectors and flows. We will also do a quick product walk-though and will demonstrate most important for you features of the Integrator. The 2 hours quick start service provided free of charge.

Can you help us develop data integration flows?

Absolutely. You can subscribe to the extended support and we will help you develop and maintain your data integration flows. You can also outsource custom development to us, where we can develop new connectors, data integration flows and plugins for the Integrator based on your requirements.

Do you offer a partner program?

Yes we do! Partnering with Etlworks will give your business a head start and will allow you to uncover new opportunities and find new possibilities for growth. We are offering distinct financial incentives and a great support to our partners. Interested in becoming a partner? Contact us today.

Who can become a partner?

Your company can become a partner if it belongs to one of the following groups: System Integrators, Technology Companies, Resellers and Consultants