Business Intelligence
Now Reading
Top 56 Data Integration Platforms
7

Top 56 Data Integration Platforms

Top 56 Data Integration Platforms
4.8 (95.18%) 166 ratings

Data Integration Platforms combine data from disparate sources into meaningful and valuable information. These platforms allows you to extract data, transform it in any style and load (ETL) it to any system, supporting faster time to value and reduced IT risk. The integrated platform delivers a wide range of data quality capabilities from data profiling, standardization, matching and enrichment to active data-quality monitoring.

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.

What are the Best Top Free Data Integration Platforms: Apache Airflow, Apache Kafka, Kettle, Apache NIFI, No Frills Transformation Engine, Apache Oozie, Scriptella ETL, GeoKettle, Jaspersoft ETL, EplSite ETL, Anatella, GETL, Apache Falcon, Apache Crunch, Cascading, Apatar are some of the top Free Data Integration Platforms.

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

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.

Try Sisense Watch Demo

What are Data Integration Platforms?

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.

You may like to read: How to Select the Best ETL Software for Your Business and Top Guidelines for a Successful Business Intelligence Strategy

What are the features of Data Integration Platforms?

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

You may like to read: How to Select the Best ETL Software for Your Business and Top Guidelines for a Successful Business Intelligence Strategy

Top Data Integration Platforms

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

Top Data Integration Platforms
PAT Index™
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Clover ETL
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1

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,…

Overview
Features

•Cloud-based solution
•Integrating heterogeneous data sources:
•On-demand, real-time and scheduled execution
•Automatic and manual mapping
•Change replication:
•Web services:
•Enterprise Service Bus
•HL7
•Support for online data warehouses
•High level transformations

Price

•Starting from $250 per month

What is best?

•Integrator is a completely online solution with cloud-based servers, allowing end-users to access it from any web browsers. Integrator does not require installation of any local software, except for a web browser.
•In Integrator, all data sources are treated equally. You can easily connect databases to files and web services, and vice versa.
•Integrator supports automatic and manual per-field mapping for all data sources, regardless of the format and location.

What are the benefits?

•Etlworks Integrator is an all-in-one, any-to-any data integration service and tool for all your projects, regardless of the data location, format and volume. It provides the following key benefits:
•Connect to all your APIs and data sources, even if they are behind the firewall, semi-structured, or unstructured.  Build data integration APIs.
•Select from multiple of built-in common data integration scenarios

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.

8.6
Editor Rating
8.5
Aggregated User Rating
2 ratings
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…

Overview
Features

• Serverless.
• Integrated data catalog
• Automatic schema discovery
• Code generation
• Developer endpoints
• Flexible job scheduler

Price

Priced by regions

What is best?

•AWS Glue Data Catalog is your persistent metadata store for all your data assets
•AWS Glue crawlers connect to your source or target data store, progresses through a prioritized list of classifiers
•AWS Glue automatically generates the code to extract, transform, and load your data

What are the benefits?

• No infrastructure to buy, set up or manage.
• Easy to get started.
• Automatically provisions the environment needed to complete the job.

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.

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

AWS Glue

3

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…

Overview
Features

• Hybrid Cloud Integration
• Striim for Real-Time Integration to SQL Database
• Striim for Data Integration to Azure Storage
• Schema Evolution for Continuously Running Applications
• Striim Analytics Platforms
• In-Memory Data Grid

What is best?

• Hybrid Cloud Integration
• Striim for Real-Time Integration to SQL Database
• Striim for Data Integration to Azure Storage

What are the benefits?

• Real time data integration
• Detecting patterns and anomalies
• Creating and monitoring metrics

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.5
Aggregated User Rating
18 ratings
You have rated this

Striim

4

Talend Data Fabric

Talend Data Fabric efficiently handles all your data integration and integrity challenges — on-premises or in the cloud, from end to end. Users can collect data across systems; govern it to ensure proper use, transform it into new formats and improve quality, and share it with internal and external stakeholders.Fully integrated functionality that speeds up all your projects—batch, real-time, APIs, and big data—through one vendor and support organization. Talend Open Studio also support for highly scalable distributed ETL data load execution that can leverage a grid of commodity computers. You may like to read: Top Extract, Transform, and Load, ETL…

Overview
Features

•Get data from all your sources in any format
•Run across any environment — cloud, on-premises, or hybrid
•Perform any integration style: ETL, ELT, batch processing, or real-time
•Standardize and cleanse data easily with machine learning-augmented tools and tips
•Write once, deploy anywhere

Price

Contact for Pricing

What is best?

•Discover and resolve data quality problems up front
•Engage data experts for more meaningful and trustworthy data
•Ensure compliance and transparency of data

What are the benefits?

•Deliver self-service access to data through a unified cloud platform
•Achieve data governance and privacy without compromising on customer experience
•Find out how to set up a data governance framework at your organization

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.4
Editor Rating
6.5
Aggregated User Rating
40 ratings
You have rated this

Talend Data Fabric

5

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…

Overview
Features

•Application specification, design, and implementation
•Business rules specification and implementation
•A single engine for all aspects of application execution
•Application orchestration
•Operational management (monitoring, scheduling, and so on)
•Software development life cycle management
•Metadata capture, analysis, and display

Price

Contact for Pricing

What is best?

•A single engine for all aspects of application execution
•Application orchestration
•Operational management (monitoring, scheduling, and so on)

What are the benefits?

•Data management, including very large data storage (hundreds of terabytes to petabytes), data discovery, analysis, quality, and masking
•Reusability of logic between batch and real-time applications
•High performance in all execution models (hundreds of thousands of messages per second in real-time)

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.

9.4
Editor Rating
6.6
Aggregated User Rating
10 ratings
You have rated this

Ab Initio

6

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.…

Overview
Features

•Built-in data source connectors
•Built in tasks and transformations
•ODBC source and destination
•Azure data source connectors and tasks
•Hadoop/HDFS connectors and tasks
•Basic data profiling tools

What is best?

•High-performance Oracle source and destination by Attunity
•SAP BW source and destination
•Data mining model training destination

What are the benefits?

•Dimension processing destination
•Partition processing destination
•Term extraction and term lookup transformations

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.

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

Microsoft SQL Server Integration Services

7

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…

Overview
Features

• A living data map
• Smart pipelines
• Performance management
• Cloud native

What is best?

• A living data map
• Smart pipelines
• Performance management

What are the benefits?

• Creates pipelines in minutes
• Design batch and streaming data with minimal coding and maximum flexibility
• Monitor and work on data quality and data flow performance

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

9.2
Editor Rating
8.3
Aggregated User Rating
11 ratings
You have rated this

StreamSets

8

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…

Overview
Features

• Data encryption
• Authentication and authorization
• Quality of service
• Kafka connect
• Freely downloadable

Price

Free

What is best?

•Easy to connect many producers to many consumers in a complex architecture
•Recover from failures and add new systems with less time and effort
•Perform data processing on real-time streams; consumers (can) become producers

What are the benefits?

• Secure multi-tenant operations
• Connect, optimize and secure your streaming data.
• Simplified development

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

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

Confluent Platform

9

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…

Overview
Features

•A high-performance parallel framework, available on premises or in the cloud
•Provides an easy and fast deployment of integration run time on your chosen cloud environment
•Extended metadata management and enterprise connectivity
•Yields tremendous gains in productivity over coding by transparently handling endpoint individuality

What is best?

•Integration of heterogeneous data, including big data at rest (Hadoop-based)
•Big data in motion (stream-based), on both distributed
•Mainframe platforms

What are the benefits?

•Application of workload and business rules
•Provides a rapid development cycle, using design automation and prebuilt patterns
•Real-time data integration and a platform that’s designed for easy use

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.

9.1
Editor Rating
7.9
Aggregated User Rating
7 ratings
You have rated this

IBM InfoSphere DataStage

10

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…

Overview
Features

• Integrate all your data sources to Amazon’s petabyte scale data warehouse.
• Import your data from any source.
• Derive real-time insights
• Friendly user interface.
• Get notified when a new field appears in your data.

What is best?

• Integrate all your data sources to Amazon’s petabyte scale data warehouse.
• Import your data from any source.
• Derive real-time insights

What are the benefits?

• Takes care of all the complexity.
• Supports dozens of the most popular data sources.
• New data sources are added on a weekly basis.

Bottom Line

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

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

Alooma

11

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…

Overview
Features

• Data Mining
• Data Visualization
• Data Warehousing
• High Volume Processing
• Standardised database and spreadsheet integration
• Powerful transformation and calculation engine
• Data quality monitoring system

Price

Contact for Pricing

What is best?

• Data Warehousing
• High Volume Processing
• Standardised database and spreadsheet integration

What are the benefits?

• Clean integrated data stack
• Increased data quality
• Full control over your data

Bottom Line

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

9.0
Editor Rating
8.3
Aggregated User Rating
7 ratings
You have rated this

Adverity DataTap

12

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…

Overview
Features

Elevating performance & efficiency - to control costs across the full IT environment, from mainframe to cloud
Assuring data availability, security and privacy to meet the world’s demand for 24x7 data access

Bottom Line

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

8.9
Editor Rating
6.0
Aggregated User Rating
4 ratings
You have rated this

Syncsort

13

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…

Overview
Features

• Complete integration
• All historical data
• Fast deployment
• Important notification always up to date
• Fully managed
• Full control
• Full security
• Personalized set up
• Raw data access
• Connect any BI tools
• Directly mapped schema
• Integration monitoring

What is best?

• Complete integration
• All historical data
• Fast deployment

What are the benefits?

• A single hub to manage all your data integrations.
• Direct Integration
• Integrate your data, centralize your company.

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.

8.9
Editor Rating
8.0
Aggregated User Rating
4 ratings
You have rated this

Fivetran

14

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…

Overview
Features

• ETL for Amazon Redshift
• ETL for BigQuery
• ETL for Snowflake

Price

• t2.medium: $1.37 p/hour or $9,950 p/annum
• m4.large: $2.74 p/hour or $19,950 p/annum
• m4.xlarge: $5.48 p/hour or $39,950 p/annum

What is best?

• ETL for Amazon Redshift
• ETL for BigQuery
• ETL for Snowflake

What are the benefits?

• Orchestrate
• Work as a team
• Cheap billing via AWS

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.

8.9
Editor Rating
7.7
Aggregated User Rating
6 ratings
You have rated this

Matillion

15

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…

Overview
Features

•Role-based tools and agile processes enabling business self-service and delivery of timely, trusted data to the business
•Users benefit from graphical and code-less tools that leverage a whole palette of pre-built transformations
•Support for grid computing, distributed processing, high availability, adaptive load balancing, dynamic partitioning, and pushdown optimization
•Analysts can collaborate with IT to rapidly prototype and validate results quickly and iteratively

What is best?

•Monitor production and reinforce coding best practices with alerts that prevent costly damage control later on
•Support for grid computing, distributed processing, high availability, adaptive load balancing, dynamic partitioning, and pushdown optimization

What are the benefits?

•Connect to cloud application sources and targets seamlessly from PowerCenter
•Provides accurate and timely data for operational efficiency, next-generation analytics and customer-centric applications

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

8.8
Editor Rating
8.7
Aggregated User Rating
4 ratings
You have rated this

Informatica Powercenter

16

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. You may like to read: Top Extract, Transform, and Load, ETL Software, How to Select the Best ETL Software for Your Business and Top Guidelines for a Successful Business Intelligence Strategy

Overview
Features

•Create reusable data transformations and job flows using a visual, hackable, debuggable and iterative approach.
•Interface with external systems via APIs, message queues, file watchers and event triggers. •Schedule, monitor and manage complex workflows.
•Optimize job performance with multiple nodes and parallelization. Source control and devops friendly. Orchestrate any number of jobs.

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.

8.7
Editor Rating
5.7
Aggregated User Rating
5 ratings
You have rated this

CloverETL

17

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…

Overview
Features

•Out-of-box integration with databases, Hadoop, ERPs, CRMs, B2B systems, flat files, XML, JSON, LDAP, JDBC, ODBC
•Knowledge module framework for extensibility
•Powerful data transformation for heterogeneous database and Big Data infrastructures
•Rich ETL for Oracle databases including Oracle Exadata, with complex dimension and cube loading support

What is best?

•Integrates with Oracle GoldenGate for real-time data warehousing
•Metadata-driven data lineage and impact analysis with Oracle Enterprise Metadata Management
•Integrates with Oracle Enterprise Data Quality for advanced profiling

What are the benefits?

•Native big data Support
•Leading Performance
•Improved Productivity

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.

8.7
Editor Rating
9.2
Aggregated User Rating
3 ratings
You have rated this

Oracle Data Integrator

18

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,…

Overview
Features

• Data migration
• Data quality management
• Data profiling
• Data discovery
• Data analysis
• Data standardization
• Data cleansing and enrichment
• Defect monitoring and resolution

Price

Contact for Pricing

What is best?

• Data discovery
• Data analysis
• Data standardization

What are the benefits?

• Power data-driven decisions
• Streamline migration projects
• Reduce compliance risk

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.

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

Experian Pandora

19

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…

Overview
Features

•Partner Management: accessible via the built-in web-portal for users to easily and quickly configure partner profiles
•Standards Data Dictionaries and pre-built message schemas
•Schemas: Flat Files, Fixed-length positional files, ANSI X12 EDI
•Process Designer: a web-based design tool to help IT staff collaborate with business analysts

What is best?

•Adeptia's solution facilitates the process of working with your business users by providing superior collaboration capabilities within the software.
•Adeptia Connect was built on a Services Oriented Architecture (SOA) approach, reusability is increased, greatly simplifying the processes of making enhancements and changes to flows and business rules

What are the benefits?

•Adeptia Connect allows you to centrally manage, from a single product, all the Connections, Formats, Protocols
•Adeptia's solution makes the work of setting up partner profiles and designing and automating data flows and integration touch-points simple, easy, and painless.
•Adeptia Connect supports collaboration, ease-of-use, and pre-built data flow templates for quick configuration and deployment,

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.

8.6
Editor Rating
8.4
Aggregated User Rating
4 ratings
You have rated this

Adeptia ETL suite

20

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…

Overview
Features

• Bi-directional integration
• Platform-independent, runs from Windows, Linux, Mac; 100% Java- based
• Easy customization, Java source code included
• No coding! Visual job designer and mapping enable non-developers to design and perform transformations

Price

Free

What is best?

• Connectivity to Oracle, MS SQL, MySQL, Sybase, DB2, MS Access, PostgreSQL, XML, etc
• Single interface to manage all your integration projects
• Flexible deployment options

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.

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

Apatar ETL

21

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…

Overview
Features

• Integrate any source (Web, SaaS, on-premise)
• Infinitely extensible Snap Component API
• Ability to build Snaps and re-sell on the SnapStore
• Deploy on-premise or in the cloud
• Browser-based design drag-and-drop GUI
• Enterprise ETL functionality Scheduler
• Multiple user support
• Social media integration

What is best?

• Integrate any source (Web, SaaS, on-premise)
• Infinitely extensible Snap Component API
• Ability to build Snaps and re-sell on the SnapStore

What are the benefits?

• Allows for easy tracking of feeds into your system.
• Speed of development and deployment
• Infinite connectivity

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.

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

SnapLogic Enterprise Integration Cloud

22

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…

Overview
Features

• Set and Enforce Data Policies
• Execute Data Policies
• Quality Management and Error Remediation
• Centralized Target Data Design
• Automated design, process and execution of Data Transformation and Migration activities
• Auto-generated Migration Code
• Centralized Reporting and Validation
• Charting and Dashboarding
• Project Tracking Automation to control resources, workflow and tasks
• Management Console for project visibility across landscape for all stakeholders
• Full audit of all activities
• Simple, web-based interface with full multi-language and localization
• Rapid, zero-code web form development focused on data activities

What is best?

• Set and Enforce Data Policies
• Execute Data Policies
• Quality Management and Error Remediation

What are the benefits?

• Delivers trusted data with reliable results and low risk
• Assures data accuracy from proven rules
• Improves time-to-completion of complex programs

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.

8.6
Editor Rating
7.4
Aggregated User Rating
3 ratings
You have rated this

Back office Data Stewardship Platform

23

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…

Overview
Features

•An easy-to-use, point-and-click, role-based GUI
•Drag-and-drop functionality eliminates the need for programming.
•Wizards access to source systems, creating target structures
•Import and export metadata functions, and build/execute ETL and ELT process flows.
•Customizable metadata tree views let you display, visualize and understand metadata.
•Dedicated GUI for profiling data makes it easy to repair source system
•Interactive debugging and testing of jobs during development
•Full access to logs is supported.

What is best?

•Integration with third-party vendors Subversion
•CVS provides enhanced version and source control features such as archiving, differencing and rollback.
•Enhanced SAS code import capabilities give current SAS users an easy way to import their SAS jobs and code.

What are the benefits?

•Audit history and check-in/check-out allows designers to see which jobs or tables were changed, when and by whom.
•Ability to distribute data integration tasks across any platform and to virtually connect any source or target data store.

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.

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

SAS Data Management

24

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.…

Overview
Features

Intuitive business user interfaces
Data quality dashboards
Simplified maintenance
High performance and scalability

Price

Contact for Pricing

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.

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

SAP Data Services

25

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…

Overview
Features

•Access source data in numerous formats and operating systems.
•Integrate multiple data sources into a single target or multiple data targets.
•Apply powerful data cleansing rules and transformation logic.
•Aggregate data and create roll-ups to aid decision support.
•Use specialized high-volume data loaders.

What is best?

•Schedule data updates at user-defined intervals, triggered by events, or based on conditional dependencies.

What are the benefits?

•Load a Star Schema with Slowly Changing Dimensions.
•Monitor and manage key server functions.
•View comprehensive logging and transaction statistics

Bottom Line

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

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

DataMigrator

26

Elixir Data

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…

Overview
Features

•Support for both: Traditional systems, as well as modern Big Data and NoSQL ecosystem.
•Agent based architecture keeps your data secure and on-premises. Data security is natively provided.
•Data integration platform with auto-mapper and lambda based data transformation pipeline.

What is best?

•Dozens of integrations to choose from. Works with most business tools and enterprise applications.
•Higher level development kit to extend. Develop your customized real-time data pipeline on-premises.

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.

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

Elixir Data

27

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…

Overview
Features

Provides access to virtually any business system
Uses simple to complex business logic
Supports the widest range of transformation complexity
Provides Track Changes, Impact Analysis, and Auto Documentation features
Initiates processes based on pre-determined schedules or events
Provides process monitoring, full history, and audit-trail reporting

Price

Contact for Pricing

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.

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

OpenText Integration Center

28

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,…

Overview
Features

• Rep point convergent marketing platform
• Red point interaction
• Red point interaction real time
• Red point data management
• Red point management for Hadoop

Price

Contact for Pricing

What is best?

• Red point interaction real time
• Red point data management
• Red point management for Hadoop

What are the benefits?

• Use any data from any source
• Achieve high data quality faster
• One application for data quality and integration

Bottom Line

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

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

RedPoint Data Management

29

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…

Overview
Features

• Data source connection
• Data transformations
• Data modeling
• Data governance
• Data integration
• Data warehousing

What is best?

• Data transformations
• Data modeling
• Data governance

What are the benefits?

• Enables design and deployment of enterprise data warehouses
• Enables design and deployment of data marts
• Enables design and deployment of e-business

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

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

Oracle Warehouse Builder

30

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…

Overview
Features

Multi-Pass SQL Scripting
Data Blending / Federated Queries
SQL IDE
Data Exports
Wrangle & Load Files
Metadata

Price

Contact for Pricing

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

Vero Analytics

31

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 -…

Overview
Features

Access, transform and analyze data faster
Flexible and Easy-to-Use Design Environment
Reusable sub-component support
64-bit Multi-Threaded Server Environment
Support for Web Services

Price

Contact for Pricing

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.

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

Sagent Data Flow

32

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…

Overview
Features

• Lightweight Desktop IDE
• Universal connectivity
• Flexible Deployment options
• Zero migration
• Rapid scaling
• Compliance
• Simplified architecture
• Performance tuning

What is best?

• Lightweight Desktop IDE
• Universal connectivity
• Flexible Deployment options

What are the benefits?

• Efficiently manage hundreds of connections to customer/partners.
• Rapidly onboard similar integrations in hours.
• Be proactively alerted when an integration/connection breaks.

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.

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

Actian DataConnect

33

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,…

Overview
Features

• Data profiling, discovering and monitoring
• Data matching
• Data Enrichment
• Data migration
• Web services and API integration
• Data cleansing
• Data integration
• Address validation and geocoding
• Real-time data quality

Price

Contact for Pricing

What is best?

• Data profiling, discovering and monitoring
• Data matching
• Data Enrichment

What are the benefits?

• Reduce costs
• Built a true view of customers
• Increases operational efficiency

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.

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

Enlighten

34

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…

Overview
Features

• Dashboards
• Self-service analytics
• InfoApps
• Mobile BI
• Predictive analytics
• Visual discovery
• Data integration

What is best?

• Mobile BI
• Predictive analytics
• Visual discovery

What are the benefits?

• Productivity
• Provides greater interoperability
• Provides superior ease of use

Bottom Line

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

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

iWay Service Manager

35

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…

Overview
Features

• Replication Frequency
• Data Selection
• Usage dashboard
• Email alerts
• Warehouse views
• Highly Scalable
• Designed for High Availability
• Continuous Auditing
• Complete Historical Data
• Transform Nested JSON

Price

• Free $0/mo
• Starter $100 /mo
• Basic $500 /mo
• Premier $1,000/mo

What is best?

• Data Selection
• Usage dashboard
• Email alerts

What are the benefits?

• Simple, powerful ETL built for developers
• Connect to your ecosystem of data sources
• Built on Open Source

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.

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

Stitch

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…

Overview
Features

•Data-Life-Cycle Management
•Data Discovery
•Data Integration
•Data Migration
•Data Governance & Analytics

Price

Contact for Pricing

What is best?

•Data-Life-Cycle Management
•Data Discovery
•Data Integration

What are the benefits?

•Speedy performance
•Versatile features
•Valuable information

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.

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

IRI Voracity

37

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…

Overview
Features

Easy Start
No coding unless you really want to
Customizable

Price

Personal edition os free, ETL Sever is $2000

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

Toolsverse

38

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…

Overview
Features

• Flexible deployment modaties
• Open architecture
• Extensible
• Compose in real-time or batch
• Map and transform any data

What is best?

• Open architecture
• Extensible
• Compose in real-time or batch

What are the benefits?

• Single runtime deployable in the cloud or on-premises
• Enables SOA, ESB patterns, SaaS connectivity, API management and microservices
• Open architecture supports common standards and new technologies

Bottom Line

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

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

Mule Runtime Engine

39

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.…

Overview
Features

• Data analyzer
• Data cleansing
• Data protection
• Data governance
• Technology platform
• Customer data hub

Price

Contact for Pricing

What is best?

• Data protection
• Data governance
• Technology platform

What are the benefits?

• General data protection regulation
• Predictive analytics
• CRM migration

Bottom Line

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

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

Uniserv Data Quality Service Hub

40

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…

Overview
Features

• Universal connectivity
• SOAP and RESTful service
• Security & Compliance
• Dashboard views
• Hybrid agent
• Management console
• Administration

What is best?

• Universal connectivity
• SOAP and RESTful service
• Security & Compliance

What are the benefits?

• Shortens onboarding times.
• Greatly simplifies maintenance across all customers.
• Lightweight

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

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

Actian DataCloud

Top Free Data Integration Platforms

Apache Airflow, Apache Kafka, Kettle, Apache NIFI, No Frills Transformation Engine, Apache Oozie, Scriptella ETL, GeoKettle, Jaspersoft ETL, EplSite ETL, Anatella, GETL, Apache Falcon, Apache Crunch, Cascading, Apatar are some of the top free Top Data Integration Platforms.

Top Free Data Integration Platforms
PAT Index™
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1

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,…

Overview
Features

• Airflow pipelines are configuration as code (Python), allowing for dynamic pipeline generation
• Easily define your own operators, executors and extend the library so that it fits the level of abstraction.
• Airflow pipelines are lean and explicit.
•Parameterizing your scripts is built into the core of Airflow using the powerful Jinja templating engine.
•Airflow has a modular architecture and uses a message queue to orchestrate an arbitrary number of workers.

What is best?

• Airflow pipelines are configuration as code (Python), allowing for dynamic pipeline generation
• Easily define your own operators, executors and extend the library so that it fits the level of abstraction.
• Airflow pipelines are lean and explicit.

What are the benefits?

• Dynamic
• Extensible
• Elegant

Bottom Line

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

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

Apache Airflow

2

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…

Overview
Features

Publish and subscribe to streams of records, similar to a message queue or enterprise messaging system.
Store streams of records in a fault-tolerant durable way.
Process streams of records as they occur.

What is best?

Building real-time streaming data pipelines that reliably get data between systems or applications
Building real-time streaming applications that transform or react to the streams of data

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

9.4
Editor Rating
7.8
Aggregated User Rating
13 ratings
You have rated this

Apache Kafka

3

Kettle

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 the data. PDI…

Overview
Features

•With an intuitive, graphical, drag and drop design environment
•Proven, scalable, standards-based architecture

Bottom Line

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

9.3
Editor Rating
5.7
Aggregated User Rating
6 ratings
You have rated this

Kettle

4

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. You may like to read: Top Extract, Transform, and Load, ETL Software, How to Select the Best ETL Software for Your Business and Top Guidelines for a…

Overview
Features

Loss tolerant vs guaranteed delivery
Low latency vs high throughput
Dynamic prioritization
Flow can be modified at runtime
Back pressure

What is best?

Build your own processors and more
Enables rapid development and effective testing

What are the benefits?

SSL, SSH, HTTPS, encrypted content, etc...
Multi-tenant authorization and internal authorization/policy management

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,

9.1
Editor Rating
7.2
Aggregated User Rating
7 ratings
You have rated this

Apache NIFI

5

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…

Overview
Features

•CSV files in any encoding
•Salesforce SOQL queries
•SQLite Databases
•MySql Databases
•Oracle Databases
•SQL Server Databases

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.

9.1
Editor Rating
8.1
Aggregated User Rating
2 ratings
You have rated this

No Frills Transformation Engine

6

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…

Overview
Features

•Scalable
•Reliable
•Extensible
•Integrated

Price

Contact for Pricing

What is best?

•Scalable
•Reliable
•Extensible

What are the benefits?

•Workflow scheduler system to manage Apache Hadoop jobs
•Workflow jobs are Directed Acyclical Graphs (DAGs) of actions
•Supporting several types of Hadoop jobs out of the box

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).

9.0
Editor Rating
8.7
Aggregated User Rating
4 ratings
You have rated this

Apache Oozie

7

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…

Overview
Features

Simple
Free
Easy to run
Easy to use

Price

Contact for Pricing

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.

8.8
Editor Rating
8.8
Aggregated User Rating
6 ratings
You have rated this

Scriptella ETL

8

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…

Overview
Features

• Spatial OLAP
• OLAP
• RDMBS
• Web services
• Geo files
• Files

Price

• Free download
• Open source

Website
What is best?

• Spatial OLAP
• OLAP
• RDMBS

What are the benefits?

• Powerful
• Metadata driven spatial ETL tool
• Data cleansing

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.

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

GeoKettle

9

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.8
Editor Rating
8.2
Aggregated User Rating
5 ratings
You have rated this

Jaspersoft ETL

10

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. You may like to read: Top Extract, Transform, and Load, ETL Software, How to Select the Best…

Overview
Features

•Easy to use.
•Low resources consumption.
•Just the necessary tools to do the job.
•Web interface.
•It is possible to run transformations using cron jobs

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.

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

EplSite ETL

11

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…

Overview
Features

Easily extensible
Extremely versatile:
Precise Data integration
Data Migration
Data Consolidation
Data Federation (ETL for Business Intelligence and Data Warehousing)
Data Synchronization
Master Data Management
Data quality (in CRM, in data warehouse, etc.)
Data cleaning

Price

Contact for Pricing

Website
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.

8.6
Editor Rating
8.9
Aggregated User Rating
5 ratings
You have rated this

Anatella

12

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…

Overview
Features

•Support for working with CSV, JSON, XML and Excel files
•Support for working with JDBC sources (tables, sql queries, DDL, sequence)
•Support for copying the data flow between sources

What is best?

•Intelligent processing of data (mapping and cast) in flows
•Support for working with temporal data
•Support for data transformation (aggregation and sorting)

What are the benefits?

•Support work with log files
•Statistics gathering speed execution of processes
•Manage files on file systems and FTP

Bottom Line

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

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

GETL

13

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…

Overview
Features

Easy to use
Multi-faceted
Integrated
Streamlines processes

Price

Contact for Pricing

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.

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

Apache Falcon

14

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,…

Overview
Features

Multi-faceted
Easy to use
Integrated
Supports various WriteModes

Price

Contact for Pricing

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.

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

Apache Crunch

15

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…

Overview
Features

Java API
Data Processing API
Data Integration API
Scheduler API
Query Process Planner

Price

Contact for Pricing

Website
What is best?

Taps and Schemes
Portable
Test-Driven

What are the benefits?

Quickly build robust, reliable, data-oriented applications in Java
Eliminate platform lock-in
Develop testable and reusable integrations, data processing code and algorithms

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.

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

Cascading

16

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…

Overview
Features

Unicode-compliant
User-friendly
Allows easy building of add-on connectors for any data integration applications
Shareable among multiple clients

Price

Contact for Pricing

Website
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.

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

Apatar

You may like to read: How to Select the Best ETL Software for Your Business and Top Guidelines for a Successful Business Intelligence Strategy

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
18%
Very Good
55%
INTERESTED
9%
COOL
7%
NOT BAD
5%
WHAT !
2%
HATE IT
4%
About The Author
imanuel