We performed a comparison between Oracle Data Integrator (ODI) and SAS Data Integration Server 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."It has the ability to easily load slowly changing dimensions."
"The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."
"What I found most valuable in Oracle Data Integrator (ODI) is that it integrates well with almost all technologies currently being used in my company."
"It uses the power of the database system efficiently."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"The initial setup is easy."
"The tool improved our data integration workflow primarily due to its compatibility with Oracle. Its integration makes it very convenient for analytics. Its most valuable feature is robust extended capability. The solution's debugging capabilities are good."
"Oracle provides great documentation."
"The most valuable feature of the solution is its amazing capabilities in regard to data handling."
"The solution is very stable."
"The solution offers very good data manipulation and loading."
"ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use."
"The initial setup is a bit complex compared to other tools."
"Oracle support services are not up to the mark."
"Oracle Data Integrator (ODI) is already good as a solution. Still, it needs some editing of its preview package, or if the package is upgraded, that will make Oracle Data Integrator (ODI) even better."
"We used a third party to do the implementation of ODI."
"If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value."
"The interface of ODI could be improved. For example, navigating and finding functions can be difficult. For example, you have to know which step you need to go to look at where your job status is. The logical step is a bit complex compared to other tools. It's much easier to get a graphical view, but with ODI, it's graphical, plus you have to know all the other pieces that fit around it. You have to think about the logical and physical aspects."
"Reverse engineering is complicated and challenging to manage."
"The transform tool has limited access. They should make it more flexible."
"So I would like to see improved integration with other software."
"The initial setup of SAS Data Integration Server was complex."
Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 68 reviews while SAS Data Integration Server is ranked 32nd in Data Integration with 3 reviews. Oracle Data Integrator (ODI) is rated 8.2, while SAS Data Integration Server is rated 7.4. 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". On the other hand, the top reviewer of SAS Data Integration Server writes "A stable and scalable tool with data handling capabilities and an amazing technical support". Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, Informatica PowerCenter, SSIS, Azure Data Factory and Oracle GoldenGate, whereas SAS Data Integration Server is most compared with Palantir Foundry, SSIS, Azure Data Factory, AWS Glue and AWS Database Migration Service. See our Oracle Data Integrator (ODI) vs. SAS Data Integration Server 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.