Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools.
279,075 professionals have used our research since 2012.
Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools.
279,075 professionals have used our research since 2012.
Chart Key
Average Rating
Average rating based on reviews
Views
Number of total page views
Comparisons
Number of times compared to another product
Reviews
Total number of reviews on IT Central Station
Followers
Number of followers on IT Central Station
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.

What is Data Integration Tools?

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.
Microsoft
Real User
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 Summary 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...
WhereScape
Real User
Data Architect at a non-profit with 1,001-5,000 employees
Dec 29 2017

What is most valuable?

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»

How has it helped my organization?

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.

What needs improvement?

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»
Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools.
279,075 professionals have used our research since 2012.
Consultant
Technical Advisor at Gluent Inc
Oct 31 2016

What is most valuable?

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»

What needs improvement?

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»
Real User
Data Warehousing and Business Intelligence Lead at Bank of America
Oct 06 2016

What is most valuable?

* 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»

How has it helped my organization?

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»

What needs improvement?

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»
WhereScape
Real User
BI Architect at a healthcare company with 5,001-10,000 employees
Jul 07 2017

What is most valuable?

Automated creation of documentation, quick time to market, ease of use, code standardization and support for Data Vault 2.0.

How has it helped my organization?

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»

What needs improvement?

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»
WhereScape
Real User
Business Intelligence Architect at a university with 1,001-5,000 employees
Jun 13 2017

What is most valuable?

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»

How has it helped my organization?

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»

What needs improvement?

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.
WhereScape
Real User
Manager Data Warehousing at a university with 1,001-5,000 employees
Feb 06 2017

What is most valuable?

* Metadata-based architecture * Ability to prototype solutions quickly * Automated documentation * Great performance

How has it helped my organization?

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»

What needs improvement?

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»
Consultant
Oracle Business Intelligence Consultant at a tech consulting company with 51-200 employees
Aug 24 2017

What is most valuable?

It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors.

How has it helped my organization?

My organization develops solutions using all the Oracle EPM products, and ODI has helped us to integrate all the different technologies.

What needs improvement?

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.
Consultant
EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at a consultancy with 1,001-5,000 employees
Jun 04 2018

What is most valuable?

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»

How has it helped my organization?

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»

What needs improvement?

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
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...
Real User
Database Architect at Chandler Systems
Jun 06 2018

What is most valuable?

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.

How has it helped my organization?

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»
Consultant
Big Data / Business Intelligence / Datawarehousing at a tech services company with 51-200 employees
May 09 2018

What is most valuable?

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»

How has it helped my organization?

All projects where I have implemented ODI solution highly benefited of high data volume integration.

What needs improvement?

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»
Real User
Director - Special Projects at Sandals Resorts International
Dec 12 2016

What is most valuable?

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»

How has it helped my organization?

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»

What needs improvement?

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»
Real User
(2IC) Senior System Analyst at a insurance company with 1,001-5,000 employees
Apr 11 2018

What is most valuable?

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»

How has it helped my organization?

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»

What needs improvement?

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»
Consultant
Principal and Owner at Sandwich Analytics
Sep 28 2016

What is most valuable?

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»

How has it helped my organization?

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»

What needs improvement?

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»
User
Partner
May 27 2018

What is most valuable?

* 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»

How has it helped my organization?

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»

What needs improvement?

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.
Real User
Database Administrator at Tarrant County College
Dec 08 2016

What is most valuable?

The most valuable feature is being able to schedule the jobs, especially when they're multi-step.

How has it helped my organization?

I don't know why we have different database environments, but we do. The business wants the data to be collected in one place, so they can do reporting and so on.

What needs improvement?

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»
Real User
Architect (Datawarehouse / BI) at a financial services firm with 1,001-5,000 employees
Oct 02 2016

What is most valuable?

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.

How has it helped my organization?

The speed in which we create/generate our ETL mappings has increased by at least a factor of four as compared to Oracle Warehouse Builder.

What needs improvement?

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»
Consultant
Enterprise DWH Architect - Oracle ACE Director at Ekol Logistics Corp.
Mar 24 2017

What is most valuable?

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»

How has it helped my organization?

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.

What needs improvement?

They need to work on the multiuser development environment and include the ability to comply with different kinds of SDLCs.
Real User
Interior Designer at a construction company
Nov 26 2017

What is most valuable?

* 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»

How has it helped my organization?

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.

What needs improvement?

Speed. The solution is bit slow.
Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools.
279,075 professionals have used our research since 2012.

Data Integration Tools Articles

EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at a consultancy with 1,001-5,000 employees
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»
reviewer145365Hi Ricardo, It would of great help if you can give some tips on loading... more»
Ricardo GiampaoliHi Moses how are you? I usually try to avoid XML as much as I can since XML... more»
2,868
Lead Consultant
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>>
3,631
TOP 5POPULAR
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>>
1,325
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>>
Reviewed Oracle Data Integrator (ODI): All our systems can be widely integrated by ODI,...
894
Consultant - Oracle ACE
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>>
Reviewed Oracle Data Integrator (ODI): With the Knowledge Modules, we're able to create our...
1,616
Enterprise DWH Architect - Oracle ACE Director
• 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>>
2,524
Principal Consultant
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>>
Reviewed IBM InfoSphere Information Server: It provided us with data connections and...
1,988
TOP 20POPULAR
Business Intelligence Consultant
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>>
Reviewed Oracle Data Integrator (ODI): It allows us to create scripts and share them across...
299
Sr. Consultant - Software Development
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>>
Reviewed Oracle Data Integrator (ODI): If it doesn't connect out-of-the-box to a specific...
1,654

4
TOP 20POPULAR
Technical Advisor
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>>
Reviewed Oracle Data Integrator (ODI): ODI is a flexible tool that can adapt to fit your...
664
Technology Architect
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>>
1,229
Principal and Owner
"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>>
Reviewed Oracle Data Integrator (ODI): I can readily develop processes that use relational,...
249
- 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>>
Reviewed Oracle Data Integrator (ODI): The features that we have applied to our project...
159

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

Sign Up with Email