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."The product has an ELT approach."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"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."
"It is an ETL tool, which does the extract, transform, and load."
"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 most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"It's completely user-friendly."
"The solution is very stable."
"The most valuable feature of the solution is its amazing capabilities in regard to data handling."
"The solution offers very good data manipulation and loading."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"It has been very good. Just recently, I've faced an issue, but I solved it somehow. While integrating with a file, I faced an issue where I wanted output files, and I had used the text field limited quotations, but at the end of the file, there was a line breakage for the last column. So, we just removed the text field because it was not working correctly for us."
"The price needs to be lowered. It's too expensive."
"The initial setup is complex, especially if you also have to install a console."
"We used a third party to do the implementation of ODI."
"Reverse engineering is complicated and challenging to manage."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"So I would like to see improved integration with other software."
"The initial setup of SAS Data Integration Server was complex."
"The transform tool has limited access. They should make it more flexible."
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, 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.