Integrator is an all-in-one cloud service for all your data integration projects, regardless of data location, format and volume.
Connect to all your APIs and data sources even if they are behind the firewall. Build data integration APIs.
Select from multiple of built-in common data integration scenarios such as export, import, data replication, backup and many others.
Let us host and manage a solution for you or install it on your own hardware and have a full control.
Manage your own data integration workflow using simple drag and drop interface or let us create it for you.
Out-of-the-box Integrator supports numerous highly configurable data integration scenarios.
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.
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.
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.
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.
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.
Integrator can connect to almost all relational databases, local and cloud based file storages, public and private APIs, as well as read and write data in most common data exchange formats. If the connector you are looking for is not on the list, we can build it for you in no time.
We offer Integrator as a hosted and managed service (SaaS). All plans include 2 hours quick start service, uptime monitoring and installation of patches and updates.
In addition to our subscription-based service, you can buy a license for the Integrator. We will help you install and configure it on any hardware you managed.
Have questions? We have answers.
Etlworks is the creator and provider of Etlworks Integrator, a powerful, and easy to use cloud 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.
Integrator is a cloud data integration service which can also be installed on premise.
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: database change replication, direct data upload into the online data-warehouses such as Snowflake, and many others.
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.
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.
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.
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.
Absolutely. Our Integration Agent can load data into the database or API just as well as extract it.
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.
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.
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.
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.
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. Read more about integrations and APIs.
Integrator fully supports HL7 v 2.x and 3.x. We are working on adding connectors to other formats. Please stay tuned.
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.
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.
In Integrator all passwords, access keys, and other secure credentials are encrypted by strong encryption algorithm with 512-bit key.
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.
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.
Yes you can. Please Contact us to get more information.
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 use it on your own. You can subscribe to the extended support if you need a post-go-live support.
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.
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.
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.
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.
Your company can become a partner if it belongs to one of the following groups: System Integrators, Technology Companies, Resellers and Consultants