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."ODI is a very accessible tool, especially since the mapping functionality has been added."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"The installation of the client ODI Studio is easy."
"The CAEM is very useful in its modularity and portability."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"It has the ability to easily load slowly changing dimensions."
"It's scalable."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"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."
"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 solution lacks some functions and features."
"The initial setup is a bit complex compared to other tools."
"If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value."
"The initial setup is complex, especially if you also have to install a console."
"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 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."
"It needs easier security."
"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, 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.