We performed a comparison between Oracle Data Integrator (ODI) and SAS Data Integration Server based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The scalability is great. It's one of the reasons we chose the solution."
"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."
"Besides loading data, we do most of our transformations in ODI."
"All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner."
"It's scalable."
"Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast."
"The most valuable feature that we use is the Knowledge Modules."
"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."
"The solution offers very good data manipulation and loading."
"The most valuable feature of the solution is its amazing capabilities in regard to data handling."
"The solution is very stable."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"It needs easier security."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"The tool should improve its pricing. It prevents the application of Oracle ODI on small and medium projects in countries like Croatia, Germany, or the US. While there are no technological obstacles to using it, the high price makes it unfeasible for projects with smaller budgets."
"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."
"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 67 reviews while SAS Data Integration Server is ranked 34th 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, SSIS, Informatica PowerCenter, 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 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.