We performed a comparison between IBM InfoSphere DataStage and Oracle Data Integrator (ODI) based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The data lineage report can be filtered for reporting. The reports are user-friendly and take less time to find what you need."
"The solution has improved the time it takes to perform tasks related to batch applications."
"It's a robust solution."
"It is quite useful and powerful."
"DataStage works better with Linux operating systems when the application services are hosted on Linux system equipment, but it's powerful on Windows too."
"We can view what we want to do. We can transform data and put them on tables."
"I am impressed with the tool's ETL tracing."
"As a data integration platform, it is easy to use. It is quite robust and useful for volumetric analysis when you have huge volumes of data. We have tested it for up to ten million rows, and it is robust enough to process ten million rows internally with its parallel processing. Its error logging mechanism is far simpler and easier to understand than other data integration tools. The newer version of InfoSphere has the data catalog and IDC lineage. They are helpful in the easy traceability of columns and tables."
"It has the ability to easily load slowly changing dimensions."
"The most valuable feature that we use is the Knowledge Modules."
"It's scalable."
"Oracle provides great documentation."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"The most valuable feature is Data movement."
"What needs improvement in IBM InfoSphere DataStage is its pricing. The pricing for the solution is higher than its competitors, so a lot of the clients my company has worked with prefer other tools over IBM InfoSphere DataStage because of the high price tag. Another area for improvement in the solution stems from a lot of new types of databases, for example, databases in the cloud and big data have become available, and IBM InfoSphere DataStage is working on various connectors for different data sources, but that still isn't up-to-date, meaning that some connectors are missing for modern data sources. The latest version of IBM InfoSphere DataStage also has a complex architecture, so my team faced frequent outages and that should be improved as well."
"In the future, I would like to see more integration with cloud technologies."
"The initial setup can be complex."
"Their web interface is good but the on-prem sites are outdated. The solution could also be improved if they could integrate the data pipeline scheduling part of their interface."
"There could be more customization options for the product."
"I really like this tool, but the administration should be on the same client application because a lot of administration features are not on the client-side, and they usually need to have administrative access. It's quite complicated to force IT teams to have separate administrative access from the developers."
"The graphical user interface (GUI) feels a lot like the interfaces from the 1980s."
"The solution should be more user-friendly."
"The performance of the user interface is in need of improvement."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"If you have something like Cisco on top of it, you will have endless problems."
"The initial setup is complex, especially if you also have to install a console."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"Reverse engineering is complicated and challenging to manage."
"Stability could be improved because some operators have issues."
IBM InfoSphere DataStage is ranked 7th in Data Integration with 37 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews. IBM InfoSphere DataStage is rated 7.8, while Oracle Data Integrator (ODI) is rated 8.2. The top reviewer of IBM InfoSphere DataStage writes "User-friendly with a lot of functions for transmission rules, but has slow performance and not suitable for a huge volume of data". On the other hand, the top reviewer of Oracle Data Integrator (ODI) writes "Straightforward to implement, scalable, and has good stability and documentation, but technical support could still be improved". IBM InfoSphere DataStage is most compared with SSIS, IBM Cloud Pak for Data, Azure Data Factory, Talend Open Studio and Oracle GoldenGate, whereas Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, SSIS, Informatica PowerCenter, Azure Data Factory and SAP Data Services. See our IBM InfoSphere DataStage vs. Oracle Data Integrator (ODI) report.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.