We performed a comparison between Oracle Data Integrator (ODI) and Toad Data Point 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 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."
"Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"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."
"The most valuable feature that we use is the Knowledge Modules."
"It's scalable."
"It has the ability to easily load slowly changing dimensions."
"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."
"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 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."
"The resource management aspect of the solution could be improved."
"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"
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"In our company, we haven't tried consuming services from IoT in our company yet, and I would like to know if the solution will support IoT services in the next release."
"If you have something like Cisco on top of it, you will have endless problems."
"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."
"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."
Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 68 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, Informatica PowerCenter, SSIS, Azure Data Factory and Oracle GoldenGate, whereas Toad Data Point is most compared with SSIS, Alteryx, SAS Enterprise Guide, Azure Data Factory and Denodo. See our Oracle Data Integrator (ODI) vs. Toad Data Point 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.