We performed a comparison between Oracle Data Integrator (ODI) and Toad Data Point based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The CAEM is very useful in its modularity and portability."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"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."
"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."
"It is an ETL tool, which does the extract, transform, and load."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"The installation of the client ODI Studio is easy."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"The most valuable features of Toad Data are you could write a parameterized query and it wouldn't error out, it would give you the parameters that you could input. The auto-formatting feature is useful because it was great for keeping your queries neat and understandable. The auto comment, and uncomment toggles that you could do were convenient."
"The Connectivity and Connection Manager supports a broad number of connection types, and it is trivial for end-users to set up their own connections to sources."
"Reverse engineering is complicated and challenging to manage."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"The price needs to be lowered. It's too expensive."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"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."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"If you have something like Cisco on top of it, you will have endless problems."
"The solution lacks some functions and features."
"On the scheduling server, some scheduled reports just sit there and never execute for the first time. After manually executing the first time, they run with no issues."
"Toad Data could improve by having additional features, such as query prediction. This could help someone who's not the strongest programmer. If the software could help them write queries correctly it would be very helpful, especially for small development teams or teams that lack the input skills necessary to write and program efficiently."
Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews while Toad Data Point is ranked 38th in Data Integration with 2 reviews. Oracle Data Integrator (ODI) is rated 8.2, while Toad Data Point is rated 9.0. 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 Toad Data Point writes "Easy to learn, good connectivity to multiple data sources, and helpful supprt". Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, SSIS, Informatica PowerCenter, Azure Data Factory and Oracle GoldenGate, whereas Toad Data Point is most compared with SSIS, SAS Enterprise Guide, Alteryx, Azure Data Factory and Denodo.
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.