Integrator is an all-in-one data integration service and etl tool for all your 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 synchronization, 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. Test and schedule flows with just a few mouse clicks. No coding, no complicated build-test-deploy process.
Out-of-the-box Integrator supports numerous highly configurable data integration scenarios.
Export data from relational databases, cloud data sources, public and private APIs and social networks. 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, social networks to other databases, cloud sources and APIs. You can map source and destination fields and create very complex transformations.
Set up a real-time data synchronization between different data sources with minimum effort. Out-of-the-box Integrator supports data synchronization for Oracle, SQL Server, MySql, PostgreSQL, DB2, Informix and Sybase as well as any JDBC compatible database and web services
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.
Connect to practically any REST and SOAP API, as well as APIs based on industry standard EDI formats, such as HL7. Build complex APIs with just a few mouse clicks.
Our software helps people see and understand their data. Whether it’s in a spreadsheet, a SQL database, a file, or a web service, you can connect and visualize any data, anywhere. Read more about Etlworks Explorer.
Explore data sources and their structure, regardless of the format or location. Use it to develop and debug data integration flows.
See data in a grid and raw (original) format. Discover dependencies by drilling down into the nested datasets, quickly filter out and sort data.
Use SQL to query data in any format, including databases, web services, structured and flat files. Leverage your natural ability to spot visual patterns quickly. Share queries with a team.
Integrator can connect to almost all relational databases, local and cloud based file storages, public and private APIs, social networks, 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.
Add ability to visualize and query any data, anywhere. Use it to debug and develop data integration flows. Subscribe only to the data visualization service or use it together with the data integration service. Explorer is free with Business and Enterprise plans
We can install and configure Integrator on any hardware you managed. Subscribe to the service and pay fixed monthly fee, or buy a license for the Integrator and own it forever.
Have questions? We have answers.
Etlworks is a creator 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. We are located in Pittsburgh, PA and registered with the Pennsylvania Department of State, tax ID # 81-2742454. Starting a data integration project? Contact us at firstname.lastname@example.org.
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.
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.
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, such as: data synchronization, HL7 transformations, 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.
Yes you can. Read more about our on premise options.
No worries, we have got you covered. Please read below.
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, Facebook, Twitter, Marketo, etc. We are constantly adding new connectors so please stay tuned.
Integrator fully supports HL7 v 2.x and 3.x. We are working on adding connectors to other formats. Please stay tuned.
In Integrator you can configure API endpoints, which will be listening to the incoming HTTP requests and, once payload is received, will trigger an execution of the data integration flows. You can also expose data sets, available from the Integrator, as REST API endpoints, build CRUD APIs and execute flows, created in Integrator, using REST API. Read more about integrations and APIs and how to build REST APIs in Integrator.
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 14 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.
Absolutely. Read more about our on premise options.
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.
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