To help you compare the best data integration tools, IT Central Station ranked them based on hundreds of real user reviews, from our esteemed community of enterprise technology professionals. You'll find comparisons of pricing, performance, features, stability and many other criteria. Read below to find out what your peers have to say about data integration vendors such as Oracle, Informatica, Microsoft, Actian and others.
The total ranking of a product, represented by the bar length, is based on a weighted aggregate score.
The score is calculated as follows: The product with the highest count in each area gets the highest available score.
(20 points for Reviews; 16 points for Views, Comparisons, and Followers.)
Every other product gets assigned points based on its total in proportion to the #1 product in
that area. For example, if a product has 80% of the number of reviews compared to the product
with the most reviews then the product's score for reviews would be 20% (weighting factor) *
80% = 16. For Average Rating, the maximum score is 32 points awarded linearly based on our
rating scale of 1-10. If a product has fewer than ten reviews, the point contribution
for Average Rating is reduced (one-third reduction in points for products with 5-9 reviews;
two-thirds reduction for products with fewer than five reviews). Reviews that are more than 24 months old,
as well as those written by resellers, are completely excluded from the ranking algorithm.
According to IT Central Station users, data integration is all about data and governance quality. Our members want to be able to transform, organize, review, and find all sorts of data (including unstructured data, flat files, etc.) quickly and easily. Data integration tools should be customizable with efficient processing, source agnostics, real-time monitoring and debugging, and provide good documentation. Reusability and connectivity were also ranked as important factors.
Best Data Integration Tools & Solutions
Read top reviews of Data Integration Tools solutions from the IT Central Station community:
Your trust is our top concern, so companies can't alter or remove reviews.
Data Architect at a non-profit with 1,001-5,000 employees
May 30 2018
What do you think of SSIS?
Sql Server Integration Services (SSIS) 2016 Review
SSIS 2016 - the Good the Bad, and the Ugly
SSIS is a unique ETL tool for a number of reasons. Most shops already own it but may treat it as a one-off free utility rather than as an enterprise ETL tool even though it can compete with the best of ETL tools. Some of the lack of respect is due to immature beginnings in its former "DTS" days. And some of it is because it comes bundled with Sql Server and does not normally run (but can) on a separate ETL server.
It can't be good if its free right? Especially when competitors easily charge 6 figures for their tools. Don't we get what we pay for? My answer is, generally yes but this may be an exception worth noting.
SSIS has become extremely flexible, extensible...
Documentation has excellent potential as it provides the capability to generate data lineage and a complete set of rich documentation and output in multiple formats. The tool supports multiple target update methods. Support for multiple... more»
It did not pass usability, reliability, sustainability or performance tests so there was no potential benefit other than minor documentation advantages over the current automated documentation solution.
In my opinion, the tool requires a much different architectural approach to be effective. It has fundamental architectural flaws that prevent it from being a practical solution for even moderate volumes of data. The largest issue is that it... more»
The biggest feature for ODI is the fact that it uses the power of the source or target database to actually perform the ETL processing. So a typical data integration tool might have its own ETL engine, and that would be an additional server, additional costs, something else you have to maintain. ODI actually has the ability to create and generate code that runs... more»
One thing that is included, and it's going to improve, is the integration with a configuration management tool. Right now, they integrate with Subversion. And we know in the future, there's going to be more tools implemented there for configuration management and some new features there. So right now, it's kind of one of those features that, it's been released,... more»
* Able to access heterogeneous databases: It can work with any kind of database available in the market. In fact, it can be applied to NoSQL databases as well. * SQL override allows users to write simple to complex queries inside mapping for... more»
Our organization had to import data from AS400, implement a sales cost analysis and load data into Data Mart, which was further consumed by QlikView. This was done with data from five different countries in different time zones. From the... more»
There are three areas where they can make a significant improvement: * Live feeds, where if a database object changes then object definitions should automatically get refreshed as well. This would avoid re-import of objects. Auto refresh will... more»
We can focus on the data itself, MDM, metrics) instead of spending time building code to move and transform the data. During the POC myself and one WS resource were able to deliver a project in 3 days that had been in development by other... more»
Since WS supports Data Vault 2.0, I would like to see automated support for hash keys on the appropriate Data Vault tables. WS does have a table trigger that can be manually added to the WS repository that will accomplishes this but it isn’t... more»
Automation, Automation, Automation.... Automation of Data Warehouse Tasks - Traditional ETL tools are a one-size-fits-all solution. They can often be like a programming language--you can do anything you could ever imagine, but you have to... more»
We are able to build data models much faster than previously and much faster than using a traditional ETL tool. It allows us to focus on the most important aspect of a data warehouse--business requirements--instead of focusing on the... more»
As with any product, there are things that can be improved, but most are fairly minor, including things like greater flexibility in ordering job tasks. I’d also like to see increased support for NoSQL data sources.
The biggest win for my organization are the great improvements we have seen in load / refresh processing time over our legacy ETL tool. I was skeptical of the ELT architecture going into our Proof of Concept with WhereScape. I had believed... more»
I would love to see a GUI interface for defining dependencies between build processes. RED provides a spreadsheet like interface for defining the dependencies between builds. Once the dependencies are defined, RED can produce a nice... more»
I think that the product as an overall solution is good. I would only point out some minor bugs or glitches in the development interface (ODI studio), but I do not think that any of them are worthy to be reported here.
It's the best tool for data integration. It can do anything you want, but the only downside is that you need to know what you are doing. You can take 10 times longer to do the same thing if you don't know how to use the tool. You have to know... more»
For the EPM environment, the ODI is the key to transforming a good project into a great project. With ODI, we can make all the EPM tools work together as one and we can create a puzzle that will increase the performance and capability of all... more»
Right now, we have two very different GUIs - 11g and 12c. 11g is faster to develop than 12c as it takes more steps to do exactly the same as 11g, but you have a lot of things that you need to do yourself. 12c implemented some things for which... more»
Consultant at a tech consulting company with 1,001-5,000 employees
Jan 28 2018
What do you think of Oracle Data Integrator (ODI)?
The new release of Oracle Data Integrator (ODI 12c) is now available. Let´s find out what the new features of ODI12c are that this version includes.
First, is there anything fancy in the installation process?
Just one note here: to be able to use ODI Studio, the enterprise
installation needs to be selected (instead of the Standalone option)
while launching the ODI installation program.
For the configuration part, creating a new login to ODI repository
you are requested to specify a new wallet password. ODI12c provides you
with a possibility to store your credentials in a wallet that is
protected by a password. How much it helps to protect and manage your
credentials with a single password!
Goodbye Interfaces, Welcome Mappings
First of all, we do not...
It's the simplicity. It's very simple to configure, it's very simple to implement. In addition, the ability it has to capture data and transmit it with incredible speed is better than any of the product out there. It's extremely powerful.
It allows us to migrate from one system to another, from one server to another, with no downtime, no outage. We can get the data synchronized with multiple databases and then switch the connectivity across to the new servers. Whether that's taking us from on-premise to the cloud or whether that's just going from server to server, either on-premise or within the... more»
There are several very important features that we use daily. * All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration. * ODI is really powerful for BI projects with traditional... more»
There is always room for improvement, even when something is really good, but I think ODI is one of the best ETL tools in the market. However, I've always waited for the web service feature to be improved in next versions, so at last the 12C... more»
The user interface for the data integrator tool is probably the most valuable piece. I'm a relatively newcomer to the ODI. We opted to use ODI instead of Informatica. Relatively, I do not have a lot experience with a lot of VARs, but I've... more»
We use ODI to extract and transform data to load into our data warehouse from our source system, which is Oracle EBS. We have found that it's very efficient; very fast. We can easily customize and review even out-of-the-box analytics that... more»
Perhaps more learning resources related to ODI would be helpful. I'm not sure if that's what restricted the buy-in. Even though the product has been out for 4-5 years, there are still a lot of people who aren't using it or have opted to stay... more»
The Talend Studio connected to the Talend MDM (Master Data Management) is the most valuable feature. Talend Studio is used to create a job stream that connects to multiple data sources, matches, compares or creates a golden record for overall... more»
By being able to cross-match records across multiple data sources and create a logical dataflow with options to place rejected records in a separate table, we are able to cleanse and create golden records in multiple categories. Rejected... more»
It needs better installation configuration for other databases. Although the installation allows you to select another database, this doesn't mean that all connection points in the application point to the database selected. You actually need... more»
The most important aspect of the product is the ability to work with almost any data source or target. I can readily develop processes that use relational, file, XML, JMS messaging, web and big data sources or targets. I can control the style... more»
It allows a single skill set to handle virtually all of the data transport and transformation needs of a company. It moves the ETL processing to where the data resides and saves network traffic and the need for dedicated transformation... more»
There needs to better support of external version control software, currently only SVN is present, but I hear the GIT is planned in future patch. From a DevOps point of view it would be useful to add better separation between ‘code’ and... more»
* Its parallel processing capability allows you to go through extremely large data sets in no time at all, if you do your job right. * Highly customizable: Allowing you to handle multiple data latencies (scheduled batch, on-demand, and... more»
I have worked during many implementations using DataStage. All of the projects that I worked on have been successful. This is due mainly to the strict discipline around best practices, and by following a set of standards and templates... more»
High-cost of ownership: They could take a page from open source software, such as Talend. Working with some of the big data components is good, but I can see improvements are needed, such as native support for Spark and HBase.
I don't know if this is because of us or because of the tool, but sometimes I had a problem with the agent getting held up. I would come in and my jobs would be failing. Now I have implemented a script to bounce the agent nightly and this... more»
The ODI topology and designer are the most valuable features. The topology gives me total freedom in switching between technologies / ETL agents. The mapping designer gives me a good graphical overview of ETL mappings.
Overall performance needs improvement. Especially when running ODI clients on Windows desktops. ODI seems to generate a lot of network traffic. ODI Studio can be very slow. Objects (mappings, packages, tables, etc.) can take minutes to open... more»
Flexibility, ease of customization, extensive features, ease of deployment, and the ability to access to all kinds of different source system technologies. No need for extra hardware for transformation step. Easy to learn & develop. Now,... more»
It helped me to reduce a slowly changing dimensions type 2 with the same output, from 22,000 seconds to 168 seconds. Loaded 10.000+ files to a table from 1000+ different sources under 20 minutes with approximate 300GB of data per day.
* Lineage * Provenance * Flow of data through various sources * Data domain discovery to find out sensitive data. One thing we find very useful is a feature which lets us know who are the stakeholders of a particular data source, and if you... more»
Many dark data silos were identified and many hidden assets were uncovered. It helped IT in initial data integration efforts. We were creating data lake-based on MapR Converged Data Platform EIC, which helped us in initial prep.
Today at 9am PST (12pm EST) IT Central Station will be hosting consultant and ODI expert Ricardo Giampaoli for an Ask Our Consultant Anything session.
Ricardo has more than 20 years engaging in EIS, BI, EPM projects in Brazil, working for the last 5 years in global projects for a fortune 100... more»
Over 8 years experience as project manager
Over 10 years experience with database analysis and data mining
Over 8 years of PL/SQL, HTML, and Java Scripting
Over 6 years experience with Oracle, DRM, Oracle Data Integrator and other ETL tools
Over 3 years experience with using ESSBASE... more>>
EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO
Ricardo has been leading and developing EIS/EPM/BI/DSS applications for over 20 years including 10+ years of Hyperion-specific experience (the last 9 years in global projects to a fortune 100 client).
His core expertise is on design, development, and optimization of Business Intelligence... more>>
Big Data / Business Intelligence / Datawarehousing
Big Data / Business Intelligence / Data Warehousing Solution Architecture and development.
Data Warehouse best Practices, DW optimization and performance enhancement (Slowly Changing Dimensions, Change-data-capture, Materialized views, partitioning techniques, Oracle database administration),... more>>
Jérôme is a DW/BI consultant at Rittman Mead and an ODI enthusiast. Analyst, architect and developer, he built expertise with Oracle Data Integrator, Oracle Warehouse Builder and Oracle Business Intelligence Enterprise Edition. He also delivers Oracle Data Integrator trainings for Rittman... more>>
• Honored as Oracle ACE Director on Business Intelligence expertise.
• Awarded as Oracle Excellence Awards, Technologist of the Year 2011 : Enterprise Architect. (formerly known as - Oracle Magazine's Editors' Choice of Awards : Enterprise Architect of the Year 2011)
• Presented at Oracle Open... more>>
I love data. I love to categorise it, manipulate it, study it, and share it. Data Warehousing is how I satisfy this love and Business Intelligence is how I show it to others. Any type of data - music, words, pictures, numbers, ...
Specialties: Data modeling, data architecture, ETL, Cognos... more>>
I am a highly qualified Data Analyst and BI Specialist with almost 20 years of experience in IT and a thorough understanding of contemporary business models.
My major areas of interest are Enterprise Data Warehouse and Business Intelligence solutions.
I am also a big fan of Scrum. I have... more>>
IT professional graduated in computer engineering with extensive experience in the Business Intelligence (BI) area. Deep knowledge in Oracle technology and ETL processes working with Oracle Data Integrator (ODI), Enterprise Performance Management (EPM) and BI tools as a lead consultant and... more>>
As Technical Advisor, Michael spends his time developing the training program at Gluent and sharing the good word about Gluent products with the world. His expertise in data integration technologies enable him to provide a unique perspective to customers. In his spare time, Michael, an Oracle ACE... more>>
Expertise in designing & developing solutions in Greenplum which is a distributed and massively parallel processing (MPP) database engine.
Expertise in performance tuning Greenplum design for extracting best performance leveraging MPP capabilities.
Expertise in data modelling (Conceptual,... more>>
"A highly talented and experienced Business Intelligence and Data Warehousing consultant with the ability to cross the divide between technical and business consulting"
I have a great passion about data and its value to a business; this is reflected in my blog writings and conference... more>>
- Involved in designing, development and implementation of Business Intelligence (BI) and analytics systems, working with technical resources to design and model the data warehouse systems.
- Assisting in developing BI reports and analysis applications, providing optimal and cost-effective... more>>
Sr. Research Analyst - Data Management Practice Head
I am actively involved in information management, business management, and the intersection of the two. What a great field! It is constantly changing, and is rich with opportunity to contribute, to teach, and to learn.
I provide strategic consulting, mentoring, and guidance for Business... more>>