Business Intelligence
Now Reading
Top 66 Extract, Transform, and Load, ETL Software
7

Top 66 Extract, Transform, and Load, ETL Software

Top 66 Extract, Transform, and Load, ETL Software
4.7 (94.9%) 149 ratings

Extract, transform, and load (ETL) refers to the process of extracting data from outside sources, transforms it to fit operational needs, loads it into the end target database, more specifically, operational data store, data mart, or data warehouse. ETL systems are commonly used to integrate data from multiple applications, typically developed and supported by different vendors or hosted on separate computer hardware. The first part of an ETL process involves extracting the data from the source systems. The transform stage applies a series of rules or functions to the extracted data from the source to derive the data for loading into the end target. The load phase loads the data into the end target, usually the data warehouse (DW) and this process vary depending on the requirements of the organization.

Top Free Extract, Transform, and Load, ETL Software : Talend Open Studio, Knowage, Jaspersoft ETL, Jedox Base Business Intelligence, Pentaho Data Integration – Kettle, No Frills Transformation Engine, Apache Airflow, Apache Kafka, Apache NIFI, RapidMiner Starter Edition, GeoKettle, Scriptella ETL, Actian Vector Analytic Database Community Edition, EplSite ETL, GETL, Apache Falcon, Apache Crunch, Apache Oozie, Apatar, Anatella, Cascading, Dataiku DSS Community are some of the top free Top Free Extract, transform, and load,ETL Software.

Top Extract, Transform, and Load, ETL Software : Etlworks, AWS Glue, Ab Initio, IBM InfoSphere DataStage, Ataccama, Noetix, Adverity DataTap, Striim, Alooma, Confluent Platform, Fivetran, Informatica Powercenter, StreamSets, Syncsort, SAS Data Management, Vero Analytics, CloverETL, Adeptia ETL suite, Oracle Data Integrator, Matillion, Elixir Data ETL, Experian Pandora, DataMigrator, OpenText Integration Center, Sagent Data Flow, SnapLogic Enterprise Integration Cloud, Lavastorm Analytics Engine, Microsoft SQL Server Integration Services, Pervasive Data Integrator, SAP Data Services, Apatar ETL, Toolsverse, RedPoint Data Management, Actian DataConnect, Oracle Warehouse Builder, IRI Voracity, Enlighten, iWay Service Manager, Back office Data Stewardship Platform, Stitch, Synaptik, DataMentors, Uniserv Data Quality Service Hub, Actian DataCloud, Mule Runtime Engine are some of the Top Free Extract, transform, and load,ETL Software.

 

Sisense

Sisense empower the most non-technical user with the ability to access data and build interactive dashboards and business intelligence reports. Sisense provides a variety of dashboard widgets to pinpoint the best visualization for your data, such as: geographical maps, gauges to measure KPIs, line charts to determine trends, scatter plots to see correlations, and pie charts for clear comparisons.Sisense enables to customize dashboard layout with drag-and-drop features to place each widget exactly where you want for optimal representation.

Sisense Demo

What are Extract, Transform, and Load, ETL Software?

ETL refers to Extraction, Transform, and Load software. Extract reads the data into a single format from multiple sources. Transform, in this step, data is linked and made consistent from various systems. Load process ensures that the transformed data is now written out to a warehouse. Since 1970s ETL has been used by business and organizations to acquire an associated view of data to enable improved business decisions.  Today, many organizations have adopted this data integration software which collects data from multiple sources as their main data integration toolbox. The system performs the data integration into three processes extracting, transforming, and loading. The three processes are interconnected and they are launched after one has successful executed. The system supports all types of data formats. For the system to perform its duties, all the three processes must run smoothly. When an organization uses the ETL software it assured of better information and excellent decision which are well analyzed and organized for the best performance and growth of the organization.

What are the features of Extract, Transform, and Load, ETL Software?

ETL software supports the integrations with operational data stores, master data management hubs, BI platforms and the cloud. Also, organizations integrates libraries of inbuilt ETL transformation with their transaction and interaction data system for it to run on Hadoop. ETL refers to the process of extracting data from multiple sources and transforming it to suit businesses and loading it into a database. There are several reasons why you need ETL software. First, it helps in data flow management. Using ETL software allows you to manage different data flows. Second, Using ETL software makes work easier to work as a team therefore, you need this software

ETL Software enhances business intelligence. The software is designed with high speed for the data retrieval and analysis. It is able to store high amount data and at the same time querying it. It enhances timely data access. Through the use of this software, users, investors, managers and other stakeholders in the organization can access the data whenever they need it. It leads to higher return on investment because it is able to generate a higher amount of revenue as a result of cost savings. ETL software generally integrate data from several systems that are developed and supported by different dealers or hosted on separate computers.

What are the features of Extract, Transform, and Load, ETL Software

What are the features of Extract, Transform, and Load, ETL Software

Top Free Extract, Transform, and Load,ETL Software

Talend Open Studio, Knowage, Jaspersoft ETL, Jedox Base Business Intelligence, Pentaho Data Integration – Kettle, No Frills Transformation Engine, Apache Airflow, Apache Kafka, Apache NIFI, RapidMiner Starter Edition, GeoKettle, Scriptella ETL, Actian Vector Analytic Database Community Edition, EplSite ETL, GETL, Apache Falcon, Apache Crunch, Apache Oozie, Apatar, Anatella, Cascading, Dataiku DSS Communityare some of the top free Top Free Extract, transform, and load,ETL Software.

Top Free Extract, transform, and load,ETL Software
PAT Index™
 
SpagoBI Business Intelligence
 
 
 
 
 
 
Jedox Base Business Intelligence
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1

Talend Open Studio

Talend Open Studio for Data Integration is a free to download GPL open source license tool which fully supports all facets of the ETL process. An intuitive process modeling tool enables business stakeholders to participate in the initial ETL design work. It provides more than 800 built-in connectors than any other ETL solution, making it easy to implement connections between diverse database types, file formats, and enterprise applications. Built-in components for ETL mapping and data transformations, including string manipulations, automatic lookup handling, an option to use ELT rather than ETL. Talend Open Studio also support for highly scalable distributed ETL…

Bottom Line

It provides more than 800 built-in connectors than any other ETL solution, making it easy to implement connections between diverse database types, file formats, and enterprise applications. Built-in components for ETL mapping and data transformations, including string manipulations, automatic lookup handling, an option to use ELT rather than ETL.

9.5
Editor Rating
5.0
Aggregated User Rating
18 ratings
You have rated this

Talend Open Studio

2

Knowage

Knowage (SpagoBI) is an Open Source Business Intelligence suite, which offers a large range of analytical functions, a functional semantic layer and a set of advanced data visualization features including geospatial analytics. The modules of SpagoBI suite are SpagoBI Server, SpagoBI Studio, SpagoBI Meta and SpagoBI SDK.SpagoBI Server is the main module of the suite, offering the core and analytical functionalities. It provides two conceptual models which are called Analytical Model and Behavioural Model, administration tools and cross-platform services. SpagoBI Studio allows the developer to design and modify analytical documents such as reports, charts, GEO and cockpits. SpagoBI Meta is…

Bottom Line

The modules of SpagoBI suite are SpagoBI Server, SpagoBI Studio, SpagoBI Meta and SpagoBI SDK.SpagoBI Server is the main module of the suite, offering the core and analytical functionalities. It provides two conceptual models which are called Analytical Model and Behavioural Model, administration tools and cross-platform services.

8.1
Editor Rating
7.3
Aggregated User Rating
8 ratings
You have rated this

Knowage

SpagoBI Business Intelligence

3

Jaspersoft ETL

Jaspersoft ETL is easy to deploy and is used to extract data from your transactional system to create a consolidated data warehouse or data mart for reporting and analysis. Jaspersoft data integration software extracts, transforms, and loads (ETL) data from different sources into a data warehouse or data mart for reporting and analysis purposes. It let to leverage and combine several disparate relational or non-relational data sources. Features include business-oriented models for early design collaboration, drag-and-drop process designer, activity monitoring dashboard tracks job execution and performance, native connectivity to ERP and CRM applications such as Salesforce.com, SAP, and SugarCRM, support…

Bottom Line

Jaspersoft data integration software extracts, transforms, and loads (ETL) data from different sources into a data warehouse or data mart for reporting and analysis purposes.

8.0
Editor Rating
8.3
Aggregated User Rating
2 ratings
You have rated this

Jaspersoft ETL

4

Jedox Base Business Intelligence

Jedox Base Business Intelligence : Headquartered in Freiburg, Germany, Jedox, Inc., is a leading provider of self-service BI and performance management solutions. Its product range includes software, support, implementation, and maintenance. Jedox Business Intelligence and Performance Management solutions are helping to streamline business processes and increase efficiency across the industry spectrum by manage all planning, analysis and reporting processes in your familiar Office environment with one integrated application.Jedox core is a cell-oriented, multi-dimensional in-memory OLAP server. The software has a modular structure and uses Microsoft Excel as its user interface on the one hand and a Jedox-specific spreadsheet on the…

Bottom Line

The Jedox Base Business Intelligence solution provides self-service business intelligence and analytics suite, OLAP Server, Free Excel client (Jedox Excel Add-in), No limit on database size, dimensions or number of users.

8.0
Editor Rating
7.8
Aggregated User Rating
2 ratings
You have rated this

Jedox Base Business Intelligence

Jedox Base Business Intelligence

5

Pentaho Data Integration – Kettle

Pentaho ETL

Pentaho Data Integration - Kettle delivers powerful Extraction, Transformation, and Loading (ETL) capabilities, using a groundbreaking, metadata-driven approach. Pentaho ETL is an intuitive, graphical, drag and drop design environment and a proven, scalable, standards-based architecture. Pentaho Data Integration also called Kettle is the component of Pentaho responsible for the Extract, Transform and Load (ETL) processes. Features include migrating data between applications or databases, exporting data from databases to flat files, loading data massively into databases, data cleansing and integrating applications.The Data Services and Kettle JDBC driver enable you to deliver data from multiple data sources, while enriching, cleansing, and transforming…

Bottom Line

Pentaho ETL is an intuitive, graphical, drag and drop design environment and a proven, scalable, standards-based architecture.

7.8
Editor Rating
8.6
Aggregated User Rating
2 ratings
You have rated this

Pentaho Data Integration – Kettle

6

No Frills Transformation Engine

No Frills Transformation Engine

"No frills transformation" (NFT) is intended to be a lightweight transformation engine, having an extensible interface which makes it simple to extend with Source Readers, extend with Target Writers and extend with additional Operators (if you can't do with the Custom Operators) Out of the box, NFT will read from CSV files in any encoding Salesforce SOQL queries, SQLite Databases, MySql Databases, Oracle Databases, SQL Server Databases and from SAP RFCs if they have a TABLE as output value and write to CSV files in any encoding (including with or without UTF-8 BOMs), Salesforce Objects (including Upserts and using External…

Bottom Line

Out of the box, NFT will read from CSV files in any encoding Salesforce SOQL queries, SQLite Databases, MySql Databases, Oracle Databases, SQL Server Databases and from SAP RFCs if they have a TABLE as output value and write to CSV files in any encoding (including with or without UTF-8 BOMs), Salesforce Objects (including Upserts and using External IDs), Oracle Databases and Rudimentary XML files.

7.8
Editor Rating
8.5
Aggregated User Rating
2 ratings
You have rated this

No Frills Transformation Engine

7

Apache Airflow

Apache Airflow

Apache Airflow is an open-source tool for authoring, scheduling and monitoring workflows. In other words, it performs computational workflows that are complex and also data processing pipelines. Airflow is ideal for your business if you are involved in executing very long scripts are even keeping a calendar of big data processing batch jobs. Apache airflow has an airflow scheduler that executes your tasks on an array of workers while following the specified dependencies. It has a rich command line utility that makes performing complex surgeries on DAGs (Directed Acyclic Graph- a collection of all the tasks you want to run,…

Bottom Line

Apache Airflow is an open-source tool that works by programmatically authoring, scheduling and monitoring workflows.

7.5
Editor Rating
7.8
Aggregated User Rating
2 ratings
You have rated this

Apache Airflow

8

Apache Kafka

Apache Kafka

Apache Kafka is an open-source message broker project to provide a unified, high-throughput, low-latency platform for handling real-time data feeds. Kafka is a distributed, partitioned, replicated commit log service. It provides the functionality of a messaging system, but with a unique design. Kafka has a modern cluster-centric design that offers strong durability and fault-tolerance guarantees Kafka is designed to allow a single cluster to serve as the central data backbone for a large organization. It can be elastically and transparently expanded without downtime. Data streams are partitioned and spread over a cluster of machines to allow data streams larger than…

Bottom Line

It provides the functionality of a messaging system, but with a unique design. Kafka has a modern cluster-centric design that offers strong durability and fault-tolerance guarantees

7.6
Editor Rating
7.5
Aggregated User Rating
5 ratings
You have rated this

Apache Kafka

9

Apache NIFI

Apache NIFI

Apache NIFI supports powerful and scalable directed graphs of data routing, transformation, and system mediation logic. Some of the high-level capabilities of Apache NiFi include Web-based user interface, Seamless experience between design, control, feedback, and monitoring, data Provenance, SSL, SSH, HTTPS, encrypted content, etc, pluggable role-based authentication/authorization.Apache nifi is highly configurable with loss tolerant vs guaranteed delivery, low latency vs high throughput, dynamic prioritization, flow can be modified at runtime, back pressure.

Bottom Line

Some of the high-level capabilities of Apache NiFi include Web-based user interface, Seamless experience between design, control, feedback, and monitoring, data Provenance, SSL, SSH, HTTPS, encrypted content,

7.6
Editor Rating
7.4
Aggregated User Rating
5 ratings
You have rated this

Apache NIFI

10

RapidMiner Starter Edition

RapidMiner Studio provides a wealth of functionality to speed & optimize data exploration, blending & cleansing tasks – reducing the time spent importing and wrangling your data. RapidMiner provides an integrated environment for data preparation, machine learning, deep learning, text mining, and predictive analytics. It is used for business and commercial applications as well as for research, education, training, rapid prototyping, and application development and supports all steps of the machine learning process including data preparation, results visualization, model validation and optimization. Hundreds of machine learning, text analytics, predictive modeling algorithims, automation, and process control features help you build better…

Bottom Line

RapidMiner Studio ( Data Rows- 10,000) , RapidMiner Server (2 GB RAM) and RapidMiner Radoop (Limited to Single User) are available in starter edition with limitations.

7.5
Editor Rating
8.2
Aggregated User Rating
3 ratings
You have rated this

RapidMiner Starter Edition

11

GeoKettle

GeoKettle

GeoKettle is a powerful, metadata-driven Spatial ETL tool dedicated to the integration of different spatial data sources for building and updating geospatial data warehouses. GeoKettle enables the Extraction of data from data sources, the Transformation of data in order to correct errors, make some data cleansing, change the data structure, make them compliant to defined standards, and the Loading of transformed data into a target DataBase Management System (DBMS) in OLTP or OLAP/SOLAP mode, GIS file or Geospatial Web Service. GeoKettle is a spatially-enabled version of the generic ETL tool Kettle (Pentaho Data Integration). GeoKettle also benefits from Geospatial capabilities…

Bottom Line

GeoKettle enables the Extraction of data from data sources, the Transformation of data in order to correct errors, make some data cleansing, change the data structure, make them compliant to defined standards, and the Loading of transformed data into a target DataBase Management System (DBMS) in OLTP or OLAP/SOLAP mode, GIS file or Geospatial Web Service.

7.6
Editor Rating
8.3
Aggregated User Rating
3 ratings
You have rated this

GeoKettle

12

Scriptella ETL

Scriptella ETL

Scriptella is an open source ETL (Extract-Transform-Load) and script execution tool written in Java. Its primary focus is simplicity hence users don't have to study yet another complex XML-based language - use SQL (or other scripting language suitable for the data source) to perform required transformations.Its main areas of application are executing scripts written in SQL, JavaScript, JEXL, and Velocity, database migration and Interoperability with LDAP, JDBC, XML and other datasources and cross-database ETL operations, import/export from/to CSV, text and XML and other formats.The solution features simple XML syntax for scripts and all users need is to add dynamics to…

Bottom Line

The solution features simple XML syntax for scripts and all users need is to add dynamics to their existing SQL scripts by creating a thin wrapper XML file.Moreover, it allows users to work with multiple data sources in a single ETL file while offering support for many useful JDBC features like batching, prepared statements and parameters in SQL including references to files (BLOBs) and JDBC escaping.

7.5
Editor Rating
8.2
Aggregated User Rating
3 ratings
You have rated this

Scriptella ETL

13

Actian Vector Analytic Database Community Edition

Actian Vector is a developer-friendly high-performance analytics engine that has been proven to outperform other popular analytics platforms even on commodity hardware. Requires minimal setup, provides automatic tuning to reduce database administration effort and enables highly-responsive end-user BI reporting. Industry-standard ANSI SQL:2003 support plus integration with an extensive set of data formats makes this platform one of the easiest to adopt. Actian Vector provides security, management, full ACID compliance, support for real time updates and performance that will please even the most discerning CIO. Actian Vector is typically used as a standalone Analytical Data Mart, or as an Analytical Data…

Bottom Line

Actian Vector Express includes the following capabilities: Analytics Workbench - quickly build visual workflows to prepare, transform, and analyze data, Analytics Database - run complex queries against billions of records in seconds and Management Console - easily monitor and manage your analytics database

7.5
Editor Rating
8.5
Aggregated User Rating
1 rating
You have rated this

Actian Vector Analytic Database Community Edition

14

EplSite ETL

EplSite ETL

EplSite ETL is a tool to do easy the data migrations, doing extraction, transformation, validation and load in a very fast way. It was built by people involved in data migrations so, it contains the necessary to do the migration(Extract Transformation, validation and load) and do it well. Features include Easy to use, Low resources consumption, just the necessary tools to do the job, Web interface and it is possible to run transformations using cron jobs on Linux or task manager on Windows.

Bottom Line

Features include Easy to use, Low resources consumption, just the necessary tools to do the job, Web interface and it is possible to run transformations using cron jobs on Linux or task manager on Windows.

7.5
Editor Rating
8.4
Aggregated User Rating
1 rating
You have rated this

EplSite ETL

15

GETL

GETL

GETL is a set of libraries of pre-built classes and objects that can be used to solve problems unpacking, transform and load data into programs written in Groovy, or Java, as well as from any software that supports the work with Java classes.GETL based package in Groovy, which automates the work of loading and transforming data. GETL taken into account when developing ideas and following requirements: The simpler the class hierarchy, the easier solution.The data structures tend to change over time, or not be known in advance, working with them must be maintained. All routine work ETL should be automated…

Bottom Line

GETL taken into account when developing ideas and following requirements: The simpler the class hierarchy, the easier solution.

7.5
Editor Rating
8.4
Aggregated User Rating
1 rating
You have rated this

GETL

16

Apache Falcon

Apache Falcon

Falcon is a feed processing and feed management system aimed at making it easier for end consumers to onboard their feed processing and feed management on Hadoop clusters. The platform gives users the ability to establish the accurately relationship between various data and processing elements on a Hadoop environment. The solution allows for Feed management services such as feed retention, replications across clusters, archival and more. The platform makes it easy for users to onboard new workflows/pipelines, with support for late data handling, retry policies. It provides for integration with metastore/catalog such as Hive/HCatalog. It provides notification to end customer…

Bottom Line

The platform gives users the ability to establish the accurately relationship between various data and processing elements on a Hadoop environment. The solution allows for Feed management services such as feed retention, replications across clusters, archival and more.

7.5
Editor Rating
8.5
Aggregated User Rating
1 rating
You have rated this

Apache Falcon

17

Apache Crunch

Apache Crunch

The Apache Crunch Java library provides a framework for writing, testing, and running MapReduce pipelines. It runs on top of the Hadoop MapReduce and Apache Spark, and its goal is to make pipelines that are composed of many user-defined functions simple to write, easy to test, and efficient to run.Crunch supports different output options via the WriteMode menu, which can be passed along with a Target to the write method on either PCollection or Pipeline. Listed below are the some of the supported WriteModes:Many of the most common aggregation patterns in Crunch are provided as methods on the PCollection interface,…

Bottom Line

Apache Crunch library is a simple Java API for tasks like joining and data aggregation that are tedious to implement on plain MapReduce. The APIs are especially useful when processing data that does not fit naturally into relational model, such as time series, serialized object formats like protocol buffers or Avro records, and HBase rows and columns.

7.5
Editor Rating
5.0
Aggregated User Rating
1 rating
You have rated this

Apache Crunch

18

Apache Oozie

Apache Oozie

Oozie is a workflow scheduler system that is designed to manage Apache Hadoop jobs. Oozie Workflow jobs are Directed Acyclical Graphs (DAGs) of actions. Oozie Coordinator jobs are recurrent Oozie Workflow jobs triggered by time (frequency) and data availability. The platform is integrated with the rest of the Hadoop stack supporting several types of Hadoop jobs out of the box (such as Java map-reduce, Streaming map-reduce, Pig, Hive, Sqoop and Distcp) as well as system specific jobs (such as Java programs and shell scripts).The system is a scalable, reliable, and extensible hence it ensures that developers make the most out…

Bottom Line

Oozie is integrated with the rest of the Hadoop stack supporting several types of Hadoop jobs out of the box (such as Java map-reduce, Streaming map-reduce, Pig, Hive, Sqoop and Distcp) as well as system specific jobs (such as Java programs and shell scripts).

7.5
Editor Rating
8.7
Aggregated User Rating
2 ratings
You have rated this

Apache Oozie

19

Apatar

Apatar

Apatar is an innovative and powerful suite of software tools designed to provide extraordinary productivity benefits to those organizations that need to move data in and out of different sources. Applications include data warehousing, data migration, synchronization and application integration.Apatar can be used anywhere users have data in diverse databases or applications that need to be captured in a new application, data warehouse, or presented with a single front end. Additionally, Apatar is user-friendly, and for even a non-technical user it would take just a couple of hours to get trained.Training to perform complex transformations may take up to three…

Bottom Line

Apatar generates XML metadata files that store all the information captured by the Apatar designer and mapping graphical user interfaces. The Apatar engine manages, executes, and controls the total project execution plan described in XML metadata files. In addition, for each executed job, Apatar generates a detailed report/log.

7.5
Editor Rating
8.5
Aggregated User Rating
1 rating
You have rated this

Apatar

20

Anatella

Anatella

Business-Insight distributes a free version of Anatella to promote their main suite of software tool: The “TIMi suite” which includes Anatella, TIMi and Stardust.Anatella was developed with some unique set of functionalities that allow users to dramatically reduce the time required to develop new data transformations. Developing new scripts with Anatella is usually a lot shorter (from ½ to 1/10 of the time) than to develop the equivalent transformations using any competitor tool.The Anatella integrated-development-environment (IDE) is based on a unique hybrid technology. Using, creating and debugging new data-manipulation-scripts is extremely simple & intuitive. Users can develop new data transformations…

Bottom Line

Anatella, the ata transformation operators are "meta-data free", which means that it is not necessary to define “meta-data” to use 99% of the various transformations available in Anatella.

7.5
Editor Rating
8.6
Aggregated User Rating
2 ratings
You have rated this

Anatella

21

Cascading

Cascading

Cascading is a proven application development platform for building Big Data applications on Apache Hadoop. Whether solving simple or complex data problems, Cascading balances an optimal level of abstraction with the necessary degrees of freedom through a computation engine, systems integration framework, data processing and scheduling capabilities.Uniquely, the platform offers Hadoop development teams portability. As new, more interesting, compute fabrics are developed, teams will need the ability to move existing applications without incurring the cost to rewrite them. With Cascading, it is simply a matter of changing a few lines of code and a Cascading application is ported to another…

Bottom Line

Cascading offers Hadoop development teams portability. As new, more interesting, compute fabrics are developed, teams will need the ability to move existing applications without incurring the cost to rewrite them.

7.5
Editor Rating
9.0
Aggregated User Rating
2 ratings
You have rated this

Cascading

22

Dataiku DSS Community

Dataiku

Dataiku DSS is the collaborative data science software platform for teams of data scientists, data analysts, and engineers to explore, prototype, build, and deliver their own data products more efficiently. Dataiku develops the unique advanced analytics software solution that enables companies to build and deliver their own data products more efficiently. Dataiku DSS is a collaborative and team-based user interface for data scientists and beginner analysts, to a unified framework for both development and deployment of data projects, and to immediate access to all the features and tools required to design data products from scratch. The visual interface of Dataiku…

Bottom Line

The visual interface of Dataiku DSS empowers people with a less technical background to learn the data mining process, and build projects from raw data to predictive application, without having to write a single line of code.

7.5
Editor Rating
5.6
Aggregated User Rating
1 rating
You have rated this

Dataiku DSS Community

Top Extract, Transform, and Load,ETL Software

Etlworks, AWS Glue, Ab Initio, IBM InfoSphere DataStage, Ataccama, Noetix, Adverity DataTap, Striim, Alooma, Confluent Platform, Fivetran, Informatica Powercenter, StreamSets, Syncsort, SAS Data Management, Vero Analytics, CloverETL, Adeptia ETL suite, Oracle Data Integrator, Matillion, Elixir Data ETL, Experian Pandora, DataMigrator, OpenText Integration Center, Sagent Data Flow, SnapLogic Enterprise Integration Cloud, Lavastorm Analytics Engine, Microsoft SQL Server Integration Services, Pervasive Data Integrator, SAP Data Services, Apatar ETL, Toolsverse, RedPoint Data Management, Actian DataConnect, Oracle Warehouse Builder, IRI Voracity, Enlighten, iWay Service Manager, Back office Data Stewardship Platform, Stitch, Synaptik, DataMentors, Uniserv Data Quality Service Hub, Actian DataCloud, Mule Runtime Engine are some of the Top Free Extract, transform, and load,ETL Software.

Top Extract, Transform, and Load, ETL Software
PAT Index™
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Clover ETL
 
 
 
 
 
 
 
 
 
Lavastorm Analytics Engine
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1

Etlworks

Etlworks
Etlworks

Etlworks, a SaaS start-up helping businesses of any sizes connect various systems and APIs through the common gateway, has introduced Etlworks Integrator, a contemporary data integration platform that supports numerous highly configurable data integration scenarios. Etlworks Integrator is the most powerful, yet cost effective, cloud data integration tool in the market. This system integrates all data on the cloud and on premise easily and helps implement features requested by the customers in no time. Etlworks provides data integration solutions for everyone, such as data export or import, data synchronization, cloud data backup, HL7 transformations, automation, building or connecting to APIs,…

Bottom Line

Etlworks Integrator is a powerful and easy-to-use cloud data integration service that can work with structured, semi-structured data and unstructured data of any type and size. Users can create and execute very complex data integration scenarios in no time, right in the browser, using intuitive drag and drop interface.

7.6
Editor Rating
8.9
Aggregated User Rating
1 rating
You have rated this

Etlworks

2

AWS Glue

AWS Glue is a cost-effective and fully managed ETL (extract, transform and load) service that is simple and flexible. With this ETL service it’s easier for your customers to prepare and load their data which is for analytics. With just a few clicks you can create and run an ETL job in the AWS Management Console. How this is done is that you just point AWS Glue to the data that you have already stored on AWS. The next thing that happens is that the AWS Glue will discover your data and stores the associated metadata in the AWS Glue…

Bottom Line

AWS Glue is a cost-effective and fully managed ETL (extract, transform and load) service that is simple and flexible for your customers to prepare and load their data for analytics.

7.5
Editor Rating
8.9
Aggregated User Rating
3 ratings
You have rated this

AWS Glue

3

Ab Initio

Ab Initio specializes in high-volume data processing applications and enterprise application integration. The Ab Initio products are provided on a user friendly homogeneous and heterogeneous platform for parallel data processing applications. These applications perform functions relating to fourth generation data analysis, batch processing, complex events, quantitative and qualitative data processing, data manipulation graphical user interface (GUI)-based parallel processing software which is commonly used to extract, transform, and load (ETL) data. Ab Initio has a single architecture for processing files, database tables, message queues, web services, and metadata. This same architecture enables virtually any technical or business rule to be graphically…

Bottom Line

Ab Initio has a single architecture for processing files, database tables, message queues, web services, and metadata. This same architecture enables virtually any technical or business rule to be graphically defined, shared, and executed.

7.5
Editor Rating
8.5
Aggregated User Rating
2 ratings
You have rated this

Ab Initio

4

IBM InfoSphere DataStage

IBM InfoSphere DataStage provides a powerful, scalable ETL platform that supports the collection, integration and transformation of large volumes of data, with data structures ranging from simple to complex. It Support for big data and Hadoop and enables you to directly access big data on a distributed file system, and helps clients more efficiently leverage new data sources by providing JSON support and a new JDBC connector. IBM InfoSphere DataStage integrates data across multiple systems using a high performance parallel framework, and it supports extended metadata management and enterprise connectivity. The scalable platform provides more flexible integration of all types…

Bottom Line

IBM InfoSphere DataStage Support for big data and Hadoop and enables you to directly access big data on a distributed file system, and helps clients more efficiently leverage new data sources by providing JSON support and a new JDBC connector.

7.6
Editor Rating
8.3
Aggregated User Rating
4 ratings
You have rated this

IBM InfoSphere DataStage

5

Ataccama

Master Data Center (MDC) is part of the complete Ataccama family of products, providing functionality together with ease of use, broad compatibility, and the ability to customize the solution to meet users specific business needs.MDC is a platform optimized for demanding transactional environments that makes consistent, accurate, and up-to-date data instantly available across a wide range of internal systems and enterprise applications.MDC is fast, reliable, and designed to integrate with user’s existing infrastructure. Its advanced architecture and high-performance engine are designed for demanding real-time and near-real-time environments, where large number of records must be handled. It can instantly provide the…

Bottom Line

Master Data Center (MDC) is a high-performance platform—optimized for demanding transactional environments—that makes consistent, accurate, and up-to-date data instantly available across a broad range of enterprise applications and internal systems.

7.5
Editor Rating
8.4
Aggregated User Rating
3 ratings
You have rated this

Ataccama

6

Noetix

Noetix Analytics is a packaged data management solution that greatly simplifies and accelerates the process of implementing an enterprise data warehouse, giving organizations a comprehensive view of corporate information. The data can be used to support strategic performance reporting while also supporting the ability to drill down to transaction details and perform ad hoc analysis. Noetix Analytics includes advanced integration with industry-leading business intelligence and reporting tools from Oracle, IBM, SAP, Microsoft, and Qlik to maximize the value of existing investments. Noetix Analytics includes a packaged ETL to extract, transform and load data from Oracle E-Business Suite and salesforce.com applications, and an…

Bottom Line

Noetix Analytics includes a packaged ETL to extract, transform and load data from Oracle E-Business Suite and salesforce.com applications, and an open interface to integrate data from third-party and custom applications to provide an enterprise-wide view of data and performance.

7.5
Editor Rating
8.2
Aggregated User Rating
4 ratings
You have rated this

Noetix

7

Adverity DataTap

Adverity DataTap is a next generation cloud-based ETL platform. DataTap combines different data streams before normalizing the data to allow users to explore new correlations and discover new insights into their marketing performance. With the platform, users can integrate server data, email data, e-commerce data, retail data, social data, databases, and spreadsheets to make quicker decisions based on real data to optimize return on advertising expenditure. Adverity DataTap allows its users to connect all sources provisioned by the API without having to use a single line of code and it maintains and updates data connector library, meaning there’s no groundwork…

Bottom Line

Adverity DataTap allow marketers to connect and manage all their data sources in one single platform in the cloud or on-premise

7.6
Editor Rating
8.8
Aggregated User Rating
3 ratings
You have rated this

Adverity DataTap

8

Striim

Striim is an end-to-end, real-time data integration and intelligence and streaming platform. It ingest data in real-time from a wide variety of sources and it data more valuable while it's streaming before loading it to common data targets. Striim enables smart decisions by analyzing all of your data in-flight for relevancy. It is driven by customer requirements and demand. it focuses on facilitating real-time, hybrid Cloud integration, and simplifying the management of applications running on streaming data. The latest striim version include several hybrid cloud integrations with Microsoft® data solutions running on Azure®. Before data lands on SQL database striim…

Bottom Line

Striim is a real-time data integration and streaming analytics software platform that enables smart decisions by analyzing all of your data in-flight, while it is still relevant

9.5
Editor Rating
7.9
Aggregated User Rating
6 ratings
You have rated this

Striim

9

Alooma

Alooma is a data integration platform that enables your data teams to have visibility and control. It brings all your data sources together into Redshift, BigQuery, Redshift among others. Alooma works by bringing together data from different data silos to your data warehouse. It does all this in real-time. Alooma is able to stream your data from various sources, transform and enrich that data and then finally store it in your own Amazon Redshift cluster. With Alooma you have access to real-time insights. It has the advantage of taking care of any complexity so that you don’t have to. Alooma…

Bottom Line

Alooma is a data integration platform that brings all your data sources together from different data silos to your data warehouse.

7.5
Editor Rating
8.3
Aggregated User Rating
2 ratings
You have rated this

Alooma

10

Confluent Platform

Confluent Platform which is built on the Apache Kafka, works to provide a central stream data pipeline to solve the challenges that come with data integration. It’s open source and free. It’s good for enabling streaming of data for your organizations data flow. It’s mainly created to help your organization cope with the large-scale data ingestion and requirements for processing of your business networking service. It’s excellent for turning your organization’s data into low-latency streams that are readily available. In addition, the platform acts as a buffer between your systems that are capable of producing or even consuming your data…

Bottom Line

Confluent is a free open source platform that is built on the Apache Kafka and works to provide a central stream data pipeline to solve the challenges that come with data integration

7.5
Editor Rating
8.6
Aggregated User Rating
1 rating
You have rated this

Confluent Platform

11

Fivetran

Fivetran is an intergrated system for cloud services, databases and business intelligence. It extracts all your data from cloud to your warehouse, analyze the queries and leads it to tons of different cloud and BI tools. Fivetran as a cloud middleware, integrates data from all your Saas service and databases to a single hub directly through completely secure connections. It uses sophisticated caching layer to move data from point A to point B without storing copy of your data on its application server. It centralizes your company performance indicators (KPIs) helping business focus on its top metrics. Fivetran integrates all…

Bottom Line

Fivetran is an integrated software for cloud services, databases, and business intelligence (BI) tools, it allows for direct integration and centralization of business data to a single hub.

7.5
Editor Rating
8.0
Aggregated User Rating
3 ratings
You have rated this

Fivetran

12

Informatica Powercenter

PowerCenter jumpstarts and accelerates data integration projects to deliver data to the business up-to five times faster. Role-based tools lets analysts and developers rapidly prototype, iterate, analyze, validate, and deploy projects in days instead of months. PowerCenter scales to support growing data volumes from more data types, sources, projects, and users. It delivers performance and reliability while providing visibility to the business via data lineage and impact analysis. A common business vocabulary keeps business and IT in sync. Real-Time Engine provides real time and “right-time” integration. PowerCenter automatically tests and monitors critical data integration processes through a repeatable, scalable, auditable…

Bottom Line

PowerCenter scales to support growing data volumes from more data types, sources, projects, and users. It delivers performance and reliability while providing visibility to the business via data lineage and impact analysis. A common business vocabulary keeps business and IT in sync

7.5
Editor Rating
8.5
Aggregated User Rating
2 ratings
You have rated this

Informatica Powercenter

13

StreamSets

Stream sets is an open source software for building any-to-any batch and any streaming data flows. It is deployed on edge, on cluster or in could to move data from big data sources to numerous destinations through smart pipelines. Its Data Performance Manager (DPM) acts as a single source of operational management for all data movement providing a leading data map of the flow and data. Stream sets requires minimal coding and maximum flexiblty for design ciding and streaming of data. Monitors and act on dataflow performance and data quality. Steam sets provide real time data statistics and metrics for…

Bottom Line

StreamSets is data operations platform is built on an open source core to streams dataflows easily plus a DPM which aggregates hundreds of dataflows into topologies managed centrally with live visibility and control over performance

7.5
Editor Rating
7.9
Aggregated User Rating
2 ratings
You have rated this

StreamSets

14

Syncsort

Syncsort provides enterprise software that allows organizations to collect, integrate, sort and distribute more data in less time, with fewer resources and lower costs. Syncsort software provides specialized solutions spanning “Big Iron to Big Data,” including next gen analytical platforms such as Hadoop, cloud, and Splunk. Syncsort offers fast, secure, enterprise grade products to help the world’s leading organizations unleash the power of Big Data. With Syncsort, you can design your data applications once and deploy anywhere: from Windows, Unix & Linux to Hadoop; on premises or in the Cloud. Syncsort DMX-h was designed from the ground up for Hadoop…

Bottom Line

Syncsort offers fast, secure, enterprise grade products to help the world’s leading organizations unleash the power of Big Data.

7.5
Editor Rating
8.8
Aggregated User Rating
2 ratings
You have rated this

Syncsort

15

SAS Data Management

SAS Data Management enables your business users to update data, tweak processes and analyze results themselves, freeing you up for other projects. Plus, a built-in business glossary as well as SAS and third-party metadata management and lineage visualization capabilities keep everyone on the same page. SAS Data Management manage processes with an intuitive, role-based GUI that offers drag-and-drop functionality, source system access and a customizable metadata tree.Provides integrated process designer. Build and edit data management processes with a visual, end-to-end event designer. Connect in real time or batch to more data sources on more platforms than most other solutions. Provides…

Bottom Line

SAS Data Management manage processes with an intuitive, role-based GUI that offers drag-and-drop functionality, source system access and a customizable metadata tree.Provides integrated process designer. Build and edit data management processes with a visual, end-to-end event designer. Connect in real time or batch to more data sources on more platforms than most other solutions.

7.5
Editor Rating
8.2
Aggregated User Rating
1 rating
You have rated this

SAS Data Management

16

Vero Analytics

Vero is an SQL IDE that can Write SQL. It goes beyond providing basic keyword hinting to generating complete queries, automatically resolving complex join trees and providing Alias Aware code completions. Vero generates Multi-Pass SQL Scripts that Data Engineers and Analysts write manually. This makes automatic join resolution, in database blending and federated queries easier. Vero also allows its users to run queries across separate databases as if they are collocated. Users can drag and drop to generate a data blending query scaffold and then proceed to hack the query. Vero's high performance data blending tech takes care of moving…

7.5
Editor Rating
8.1
Aggregated User Rating
3 ratings
You have rated this

Vero Analytics

17

CloverETL

CloverETL is a rapid, end-to-end data integration solution. Businesses choose CloverETL for its usability and intuitive controls, along with its lightweight footprint, flexibility, and processing speed. CloverETL is a Java based data integration framework which can be used to transform/map/manipulate data in various formats such as CSV,FIXLEN,XML,XBASE,COBOL,LOTUS. CloverETL can be used standalone or embedded(as a library) and connects to RDBMS/JMS/SOAP/LDAP/S3/HTTP/FTP/ZIP/TAR.

Bottom Line

CloverETL is a Java based data integration framework which can be used to transform/map/manipulate data in various formats such as CSV,FIXLEN,XML,XBASE,COBOL,LOTUS.

7.5
Editor Rating
5.1
Aggregated User Rating
3 ratings
You have rated this

CloverETL

Clover ETL

18

Adeptia ETL suite

Adeptia Integration Suite is a leading Data Integration and Extract Transform and Load (ETL) software for aggregating, synchronizing and migrating data across systems and databases.Adeptia offers “self-service ETL” capability because it enables business users and data scientists to themselves create simple data integration connections. Adeptia Integration Suite is a comprehensive ETL solution that provides a powerful data conversion capability. This is graphical, wizard-driven, easy to use software that supports any-to-any conversion. Adeptia Integration Suite is an enterprise-class data integration software that is centrally administered and managed to ensure smooth performance and uptime. Detailed logs are maintained and audit trails are…

Bottom Line

Adeptia Integration Suite is a comprehensive ETL solution that provides a powerful data conversion capability. This is graphical, wizard-driven, easy to use software that supports any-to-any conversion.

7.5
Editor Rating
8.4
Aggregated User Rating
3 ratings
You have rated this

Adeptia ETL suite

19

Oracle Data Integrator

Delivers Extract Load and Transform (E-LT) technology that improves performance and reduces data integration costs—even across heterogeneous systems. Provides High-performance bulk data movement and data transformation, E-LT architecture for improved performance and lower TCO, Heterogeneous platform support for enterprise data integration, Knowledge modules for optimized developer productivity and extensibility and Service-oriented data integration and management for SOA environments. An easy to use user interface combined with a rich extensibility framework helps Oracle Data Integrator Enterprise Edition improve productivity, reduce development costs and lower total cost of ownership among data centric architectures. Oracle Data Integrator Enterprise Edition is fully integrated with…

Bottom Line

Provides High-performance bulk data movement and data transformation, E-LT architecture for improved performance and lower TCO, Heterogeneous platform support for enterprise data integration, Knowledge modules for optimized developer productivity and extensibility and Service-oriented data integration and management for SOA environments.

7.5
Editor Rating
8.7
Aggregated User Rating
1 rating
You have rated this

Oracle Data Integrator

20

Matillion

Matilion is a modern powerful Exact Transformation Load (ETL)and Exact Load Transform (ELT) tool specific for amazon Redshift. It makes loading and transforming data on redshift fast, easy and affordable. Sets and delivers results faster than other ETL technologies. It is easy to load data from dozens of sources including S3 and RDS, multiple databases and ATIs systems like google analytics even on social media like Facebook. Matillion makes orchestration and automation of data load, transformation and integration with other systems an AWS services. It transforms data speedily in a graphical job development environment. Matilion reduces ETL development and maintenance…

Bottom Line

A modern, powerful ETL/ELT tool built specifically for Amazon Redshift that is fundamentally changing data integration and enabling customers to innovate at the speed of business.

7.5
Editor Rating
7.5
Aggregated User Rating
2 ratings
You have rated this

Matillion

21

Elixir Data ETL

Elixir Data ETL is designed to provide on-demand, self-serviced data manipulation for business users as well as for enterprise level data processing needs. Its visual-modeling paradigm drastically reduces the time required to design, test and implement data extraction, aggregation and transformation - a critical process for any application processing, enterprise reporting and performance measurement, data mart or data warehousing initiatives. Elixir Data ETL allows business users to quickly obtain the critical information for their business decisions and operational needs, freeing up the IT group to focus on enterprise level IT issues - the way it should have always been. Provides…

Bottom Line

Elixir Data ETL allows business users to quickly obtain the critical information for their business decisions and operational needs, freeing up the IT group to focus on enterprise level IT issues - the way it should have always been.

7.5
Editor Rating
8.6
Aggregated User Rating
1 rating
You have rated this

Elixir Data ETL

22

Experian Pandora

Experian Pandora is a data management platform that provides greater proactive data insight. It allows your users to completely understand their data through robust profiling functionality; improve their information through cleansing, standardization and enrichment capabilities; and then control data over time through proactive monitoring and reporting. It allows your business users to get more from their data, faster. Using Experian Pandora, you can execute complex data processing tasks that would otherwise take many hours or even days to execute and execute in a matter of seconds. Experian Pandora gives you immediate visibility into what’s really happening with your organizations data,…

Bottom Line

Experian Pandora is a data management platform that provides immediate visibility into what’s really happening with your organizations data, which will in turn present valuable insights.

7.5
Editor Rating
8.6
Aggregated User Rating
1 rating
You have rated this

Experian Pandora

23

DataMigrator

DataMigrator is a powerful and comprehensive automated tool designed to dramatically simplify extract, transformation, and load (ETL) processes, including the creation, maintenance, and expansion of data warehouses, data marts, and operational data stores. DataMigrator enables fast, flexible, end-to-end ETL process creation involving heterogeneous data structures across disparate computing platforms.DataMigrator provides greater reach and range than any other ETL offering by employing iWay Software’s award-winning data adapters. DataMigrator can create tables in any major relational database, as well as create fixed or delimited flat files and XML documents as described by an XML-schema definition. Web Console provides efficient management of ETL…

Bottom Line

DataMigrator enables fast, flexible, end-to-end ETL process creation involving heterogeneous data structures across disparate computing platforms.

7.5
Editor Rating
8.5
Aggregated User Rating
1 rating
You have rated this

DataMigrator

24

OpenText Integration Center

The OpenText Integration Center helps organizations fuse traditional data management and enterprise content management approaches into a single comprehensive information management strategy. This kind of fusion allows organizations to realize the true value of their people, processes, and information. By supporting a complete view of the relevant information across the enterprise, the Integration Center helps organizations ensure that all critical business decisions are based on current and complete information, regardless of its location or format, for the purposes of business intelligence, governance, and process optimization. Serving as the hub of the information system, the OpenText Integration Center gives organizations the…

Bottom Line

OpenText Integration Center is a data and content integration platform that gives organizations the ability to quickly adapt to new and changing business processes with powerful and flexible capabilities that transforms information from where it is to where it needs to be.

7.5
Editor Rating
8.7
Aggregated User Rating
2 ratings
You have rated this

OpenText Integration Center

25

Sagent Data Flow

Sagent Data Flow from Pitney Bowes Software is a powerful and flexible integration engine that collates data from disparate sources and provides a comprehensive set of data transformation tools to enhance its business value. Moreover, the solution allows users to address the two most daunting parts of achieving sound reports which are: accessing data from various sources and; manipulating it to create meaningful reports.It allows for the analyzing of information and creating meaningful reports to aid better understanding of business. One of Pitney Bowes' Location Intelligence solutions, Sagent Data Flow provides customer profiling, data warehousing, ETL and business intelligence -…

Bottom Line

Sagent Data Flow allows for analyzing information and creating meaningful reports to aid understanding of your business. One of Pitney Bowes' Location Intelligence solutions, Sagent Data Flow provides customer profiling, data warehousing, ETL and business intelligence - leveraging real data to make smarter decisions.

7.5
Editor Rating
8.1
Aggregated User Rating
1 rating
You have rated this

Sagent Data Flow

26

SnapLogic Enterprise Integration Cloud

SnapLogic is a web-based solution that is open-source. It offers an innovative data flow solution for your organization that allows you to connect with popular SaaS applications like Salesforce, Newsuite including SugarCRM, with limitless connectors that are available through SnapStore. SnapLogic also has a scalable architecture which handles your organizations data flow from any number of sources to any number of destinations. This is beneficial to your business in that you will be able to acquire, keep and grow your customers. This SnapLogic architecture scales and works just like web servers do. SnapLogic also offers versatility for your organization. For…

Bottom Line

SnapLogic is a web-based solution that is open-source that offers an innovative data flow solution for your organization that allows you to connect with popular SaaS applications like Salesforce, Newsuite including SugarCRM, with limitless connectors that are available through SnapStore.

7.5
Editor Rating
8.4
Aggregated User Rating
2 ratings
You have rated this

SnapLogic Enterprise Integration Cloud

27

Lavastorm Analytics Engine

Lavastorm is a visual data discovery solution that allows to rapidly integrate diverse data, easily discover elusive insights, and continuously detect anomalies, outliers, or patterns. Lavastorm Analytics Engine provides self-service capability for business users and rapid development capabilities for IT users in the areas of integration, analytics, and business control. Features include acquire, transform, combine, and enrich data from virtually any source, including Big Data sources without intensive modeling, pre-planning, or scripting. The solution discover data issues, such as completeness, inconsistent formats, accuracy, automate the evaluation and cleansing process. Lavastorm Analytics Engine use the visual analytic environment and its configurable…

Bottom Line

Lavastorm Analytics Engine provides self-service capability for business users and rapid development capabilities for IT users in the areas of integration, analytics, and business control.

7.5
Editor Rating
7.3
Aggregated User Rating
2 ratings
You have rated this

Lavastorm Analytics Engine

Lavastorm Analytics Engine

28

Microsoft SQL Server Integration Services

Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. Integration Services is used to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data. The packages can work alone or in concert with other packages to address complex business needs. Integration Services can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations.…

Bottom Line

Integration Services is used to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data.

7.6
Editor Rating
8.2
Aggregated User Rating
3 ratings
You have rated this

Microsoft SQL Server Integration Services

29

Pervasive Data Integrator

Pervasive’s Data Integrator platform is a robust enterprise data integration software solution that enables you to quickly build powerful and frictionless connections between any kind of data source and application. Data Integrator supports countless integration scenarios in real time, from data exchange and data migrations to Master Data Management and data warehousing. Reusable components give you the flexibility to design once and deploy on-premise or in the Cloud. Unlike other data integration tools, Pervasive Data Integrator has the same full-featured web UI used for both on-premise and cloud versions. Data Integrator is used by hundreds of organizations for data integration,…

Bottom Line

Data Integrator supports countless integration scenarios in real time, from data exchange and data migrations to Master Data Management and data warehousing.

7.5
Editor Rating
8.6
Aggregated User Rating
1 rating
You have rated this

Pervasive Data Integrator

30

SAP Data Services

SAP Data Services allow users to unlock meaning from all of their organization’s data irrespective of whether it is structured or not. This data management software provides best-in-class functionality for data integration, quality, cleansing, and more. It enables organizations to transform their data into a trusted, ever-ready resource for business insight – and use it to streamline processes and maximize efficiency.SAP Data Services enable users to quickly discover, cleanse, and integrate data – and make it available for real-time analysis. The platform enables businesses to boost productivity and cut costs using an all-in-one solution for data quality and data integration.…

Bottom Line

This data management software provides best-in-class functionality for data integration, quality, cleansing, and more. Transform your data into a trusted, ever-ready resource for business insight – and use it to streamline processes and maximize efficiency.

7.5
Editor Rating
8.5
Aggregated User Rating
1 rating
You have rated this

SAP Data Services

31

Apatar ETL

Apatar brings innovative and powerful data integration to end-users, partners and developers. Apatar offers features such as flexible deployment options, mapping, visual job designer and bi-directional integration. Apatar allows connectivity to Oracle, MS SQL, MySQL, Sybase, DB2, MS Access, PostgreSQL, XML, InstantDB, Paradox, BorlandJDataStore, Csv, MS Excel, Qed, HSQL, Compiere ERP, SalesForce.Com, SugarCRM, Goldmine and any JDBC data sources. Apatar offers easy customization since Java source code is included so no coding is required. Apatar supports cross systems such as source system, FTP logic, application to application, queue to queue and flat files. Apatar can be used anywhere, even in…

Bottom Line

Apatar is a powerful and innovative software which uses applications such as synchronization, data migration, data warehousing and application integration to ensure the quality of data being integrated.

7.5
Editor Rating
8.5
Aggregated User Rating
1 rating
You have rated this

Apatar ETL

32

Toolsverse

Toolsverse LLC is a privately-held software company based in Pittsburgh, PA, USA. The firm specializes in custom data integration solutions. It has three main products, and they are: platform independent tools for ETL; data integration and; database development. The Data Explorer allows users to create complex data integration and ETL scenarios using drag&drop visual designer and scripting languages such as JavaScript. The best-in-class universal database development IDE is integrated right into Data Explorer. It works equally well with SQL and NoSQL data sources, as well as popular file formats and APIs. ETL Framework is a compact, modular, high performance and…

7.5
Editor Rating
8.5
Aggregated User Rating
1 rating
You have rated this

Toolsverse

33

RedPoint Data Management

Redpoint global is a data management expert. Redpoint makes data management easy by integrating and transforming data to make it useful for businesses. Its main goal is to empower data driven organizations by unlocking the full value of their data to drive customer engagement, profitable and sustainable growth. Redpoint empowers customer success by optimizing customer engagement. Its customer engagement capabilities are customer engagement hub, customer interaction platform, customer data platform and convergent marketing platform. Redpoint provides a connected, open ecosystem therefore getting started is simple and fast. Redpoint offers support in all stages of data management to your business: Pre-implementation planning, deployment,…

Bottom Line

Redpoint provides high quality data by increasing productivity through automating resources, using one application to integrate and centralize control of data.

7.5
Editor Rating
8.7
Aggregated User Rating
2 ratings
You have rated this

RedPoint Data Management

34

Actian DataConnect

Actian data connect is an integration solution that allows you to be able to easily design, deploy, manage integrations on premise or in the cloud, or even in environments that are hybrid with no limits whatsoever on volumes or data types. Actian data connect emphasizes on reuse and adaptability. It’s mainly designed to assist you to integrate diverse data cost-effectively and also applications from various endpoints. Actian data connect is useful to you in that it helps your organization to visually create integration maps, schemas, artifacts, rules and job schedules in a matter of minutes. All this without coding or…

Bottom Line

Actian data connect is an integration solution that allows you to be able to easily design, deploy, manage integrations on premise or in the cloud, or even in environments that are hybrid with no limits whatsoever on volumes or data types.

7.5
Editor Rating
8.6
Aggregated User Rating
1 rating
You have rated this

Actian DataConnect

35

Oracle Warehouse Builder

Oracle warehouse builder is a data integration solution that is data warehouse-centered. It’s a tool that caters to all aspects of your data integration. It takes advantage of the oracle database to transform your data into information that is of high-quality. It provides you with data quality, data auditing, fully integrated relational and also dimensional modelling, and also a full lifecycle management of data and metadata. Oracle warehouse builder is a data integration from Oracle that allows you to create data warehouses, migrate data from legacy systems, consolidate data from disparate data sources, clean and transform data to provide quality…

Bottom Line

Oracle warehouse builder is a data integration from Oracle that allows you to create data warehouses, migrate data from legacy systems, consolidate data from disparate data sources, clean and transform data to provide quality information and manage corporate metadata

7.5
Editor Rating
8.2
Aggregated User Rating
1 rating
You have rated this

Oracle Warehouse Builder

36

IRI Voracity

IRI Voracity is the only end-to-end software platform for fast, affordable, and ergonomic data life-cycle management; it combines data discovery, integration, migration, governance, and analytics in a single pane of glass. Voracity bends the multi-tool cost, complexity, and risk curves away from mega-vendor ETL packages, disjointed Apache projects, and specialized software since it includes data: profiling and classification, integration and federation, cleansing and enrichment, unification and validation, masking and encryption, reporting and preparation, subsetting and testing. IRI Voracity total data management is powered by CoSort or Hadoop and front-ended in Eclipse, and it delivers the outcomes that businesses need, the…

Bottom Line

IRI Voracity is an end-to-end software platform for fast, affordable, and ergonomic data life-cycle management; it combines data discovery, integration, migration, governance, and analytics in a single pane of glass.

7.6
Editor Rating
8.7
Aggregated User Rating
1 rating
You have rated this

IRI Voracity

37

Enlighten

Enlighten is an automated data management product suite. Its users can accurately and efficiently determine the true picture of their organization's data and understand it in detail. This gives its clients accurate and efficient data from the beginning and ability to maintain it over time.Enlighten has an end-to-end data quality suite that offers customizable and comprehensive solutions for organizations regardless of their size. Enlighten has data analyzer that provides profiling assessment, monitoring and evaluation tools. It offers data solutions by industry and by business need. There is the option to choose any deployment method to meet your data security, data privacy,…

Bottom Line

Enlighten uses powerful data quality tools with a data quality suite that offers customizable and comprehensive data solutions for any size of business.

7.5
Editor Rating
6.6
Aggregated User Rating
2 ratings
You have rated this

Enlighten

38

iWay Service Manager

iWay service manager enables your organization to create, compose and also manage services and micro services. iWay service also helps your organization to reuse existing application and infrastructure investments so as to create web services that are powerful. It lays the foundation for integration that is real-time, web-oriented architecture and also event-driven architecture. It provides more interoperability and superior ease of use. iWay service manager provides complete unhindered visibility by including end-to-end business activity monitoring (BAM) of all the key business activities that pass through it. Due to this, your users can immediately identify and correct inefficiencies. iWay service manager…

Bottom Line

iWay service manager enables your organization to create, compose and also manage services and micro services.

7.5
Editor Rating
8.1
Aggregated User Rating
1 rating
You have rated this

iWay Service Manager

39

Back office Data Stewardship Platform

Back office Data Stewardship Platform orchestrates manages, designs and builds lifecycle for your data. It optimizes data quality migration and governance initiatives using the back-office stewardship platform, which provides information governance orchestration across data migration, archival, quality analytics, master data management and business process governance. DSP creates an environment of collaboration by connecting your IT business users in a “decide once and reuse everywhere” environment. You will benefit over and over again from prior efforts and improve governance of your data ecosystem regardless of your downstream ecosystem in use. Helps run your business by reducing complexity costs. It will increase…

Bottom Line

Data Stewardship Platform is a data management software that helps manage, design and build lifecycle for data with an environment of collaboration, connecting your IT and business users.

7.5
Editor Rating
8.5
Aggregated User Rating
1 rating
You have rated this

Back office Data Stewardship Platform

40

Stitch

Stitch is a software that enables business to house data in the warehouse in minutes. Stitch has no API maintenance, scripting, cron jobs or JSON wrangling. It has a REST API that allows for replication of data from any source, the REST API recognizes schema based on the data you send. Stitch technology allows you to spend more time on surfing for valuable insights and less time on managing data. It has flexible UI that allows for configuration of data pipeline. Stitch integrations are powered by singer and open source ETL standards. You can create your own integrations with standard…

Bottom Line

Stitch is a software that helps businesses consolidate data from a variety of databases, SaaS apps, and services into a single data warehouse.

7.5
Editor Rating
8.5
Aggregated User Rating
1 rating
You have rated this

Stitch

41

Synaptik

Synaptik helps businesses transform via an adaptive, intuitive and accessible platform using a modern mix of light-weight frameworks, scalable cloud services, and efficient data management and research tools. The plug-n-play Machine Learning platform to create and manage customized libraries and data processes. Automate the management of structured and unstructured data, customize dashboards and reports, choose from a library of statistical models and AI plugins to help users understand data in new ways, and adapt software to suit. Synaptik’s fully-managed infrastructure makes big-data in the cloud is fast, auto-scalable, secure and on-demand. With auto-ingestion data-transfer agents and web-based interfaces similar to…

Bottom Line

The Synaptik platform makes it easier for business environments to connect with alternative data shared models, statistical tools and Machine Learning specialists for deep mining and predictions.

7.6
Editor Rating
8.1
Aggregated User Rating
1 rating
You have rated this

Synaptik

42

DataMentors

Data mentors is a powerhouse in data solutions, real-time technologies and powerful analytics. As a leading market provider in data quality and integration, business intelligence and data as a service, Data mentors blends its deep experience in 1st party data identification with the Relevate family of data solutions. This offers clients the right data connections, at the right time, and following right channels. Data mentors works with financial services, retail, healthcare, utilities and B2B industries. Data solutions offered include: relevate auto that provides the most accurate data in the automotive industry. Relevate telematch gives a comprehensive resource of directory assistance,…

Bottom Line

DataMentors offers data as a service using data solutions, real-time technologies and powerful analytics for right connection, at the right time through right channels.

7.5
Editor Rating
8.4
Aggregated User Rating
1 rating
You have rated this

DataMentors

43

Uniserv Data Quality Service Hub

Uniserv Data Quality Service Hub provides a combination of powerful tools, experienced consultants and proven methods to offer data management solutions. Its main projects are data quality initiatives, data warehousing, data migration and data master management. Uniserve optimizes client data for the best possible quality levels with best performance; it is centred on data quality. The ultimate goal is to maintain data quality at the highest level through its life cycle.The data quality service hub offers four unique data management products which are: data analyzer, data cleansing, data protection and data governance. These incorporate seamlessly to your business data to meet demand.…

Bottom Line

Uniserv Data technology management customizes business data by merging data products seamlessly into its IT structure to fulfill client demands.

7.5
Editor Rating
8.3
Aggregated User Rating
1 rating
You have rated this

Uniserv Data Quality Service Hub

44

Actian DataCloud

Actian data cloud is an integration platform that is cloud-based and hybrid. It’s a very secure platform. It works by integrating both on-premise and cloud data applications. With Actian data cloud, your organization will get sophisticated and also fully customizable data integration capabilities that are able to scale and perform in the most demanding environments. In addition, they are also able to accommodate changing endpoints that expand quickly. You can depend on Actian data cloud to remove any friction from data integration while at the same time providing universal connectivity, scalability and also enterprise security. With Action data cloud, you…

Bottom Line

Actian data cloud is an integration platform that is cloud-based and hybrid that works by integrating both on-premise and cloud data applications making sure that your organization will get sophisticated and also fully customizable data integration capabilities that are able to scale and perform in the most demanding environments

7.5
Editor Rating
8.5
Aggregated User Rating
1 rating
You have rated this

Actian DataCloud

45

Mule Runtime Engine

Mule Runtime Engine is a universal building block for connectivity. It connects world’s applications, data and devices by combining data and application integrations across legacy systems, Saas applications and APIs. The engine provides integration both on premise and in the clouds. It supports millions of transactions in the largest clouds. It enables splunk to orchestrate across multiple cloud and on premise in a matter of weeks versus months. Mule runtime technology uses hybrid technology for maximum flexibility. It manages and sources connectivity in one powerful yet light weight package. It is light enough to run in a developer’s laptop in…

Bottom Line

Mule runtime engine connects applications, data and devices by providing integrations across systems, with a hybrid deployment technology for maximum flexibility

7.5
Editor Rating
8.6
Aggregated User Rating
1 rating
You have rated this

Mule Runtime Engine

7 Reviews
  • July 23, 2015 at 6:38 am

    ADDITIONAL INFORMATION
    Hi Imanuel,

    I was not pleased with the complexity of the “big” ETL tools, and wanted something really lightweight, scriptable and flexible. I rolled my own, and ended up with something that might be interesting to other people facing the same challenges as I do. NoFrillsTransformation was conceived primarily as a way of simplifying data loading and extracting to Salesforce (by leveraging the Data Loader). Meanwhile, it has gained other functionality aswell, like connecting to various database sources (currently SQLite, MySql, Oracle and SQL Server).

    Its strength lies in the way it handles the configuration; it’s pure XML, no GUI at all, but it’s fairly simple to model and get what you want. It’s open source, open to contributions, and I’d be happy if somebody gave it a go.

    Some pointers into the documentation:
    https://github.com/Haufe-Lexware/haufe.no-frills-transformation/wiki/Getting-Started
    https://github.com/Haufe-Lexware/haufe.no-frills-transformation/wiki/Config-File-Documentation

    Chances are this is just enough for many ETL/migration processes.

    Best regards,
    Martin

    • November 16, 2016 at 4:26 pm

      ADDITIONAL INFORMATION
      Hi Martin,

      Does your ETL engine accept Web Services as a source (reader) and destination (writer)? I would be interested in using the engine for my project.

      Thank you,
      Leonid

  • David
    October 27, 2015 at 2:51 pm

    ADDITIONAL INFORMATION
    CloverETL is not free. the ‘Designer’ basic package costs $5,000 and up plus 20% annual maintenance fee.

  • Alan B
    May 25, 2016 at 4:31 am

    ADDITIONAL INFORMATION
    CloverETL isn’t free.

  • January 16, 2017 at 5:14 am

    ADDITIONAL INFORMATION
    Thanks for this complete article.
    ETLs are the most powerful tools in terms of data integration. Unfortunately, most of them require good technical coding skills, so I for instance, someone like me with a business profile will need to hire a developer to handle such a tool. A friend of mine who worked on high profile data migration projects decided to create Myddleware, a user-friendly, easy-to-handle ETL tool for business users, which I am very happy about. It’s free and open source.

    Website : http://www.myddleware.com/index.php/en/
    For contributions : https://github.com/Myddleware

    I would be very much interested in hearing about other open source tools designed for non technical business profiles though.
    Thank you,

    Barbara

  • July 6, 2017 at 4:36 am

    ADDITIONAL INFORMATION
    Don’t see Centerprise on this list. We’ve heard some really good things about the platform from our partners. Has anybody used it? I haven’t gotten around to giving the free trial a spin myself, but I am intrigued.

  • July 9, 2018 at 6:08 am

    ADDITIONAL INFORMATION
    Skyvia also pretends to be added to the list of free ETL tools
    The service is free up to the definite amount of processed records

What's your reaction?
Love It
19%
Very Good
56%
INTERESTED
7%
COOL
7%
NOT BAD
6%
WHAT !
2%
HATE IT
4%
About The Author
imanuel