We performed a comparison between Actian Pervasive Data Integrator [EOL], 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."There were no concerns with the stability. This product is very good from a stability perspective."
"The solution's initial setup is straightforward, especially compared to Mule, which our team has worked with before and found to be a bit more complex in terms of setup."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"The CAEM is very useful in its modularity and portability."
"It has the ability to easily load slowly changing dimensions."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"Oracle provides great documentation."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"It's completely user-friendly."
"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 solution is very stable."
"I am not sure if there are various connectors available in the recent version of Pervasive DI to support the wide range of sources available (e.g., big data, cloud, EME)."
"If you have something like Cisco on top of it, you will have endless problems."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue."
"It needs easier security."
"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."
"The price needs to be lowered. It's too expensive."
"Stability could be improved because some operators have issues."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"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."
Earn 20 points