We performed a comparison between Oracle Data Integrator (ODI), SAS Access, and Zapier based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast."
"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."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"The scalability is great. It's one of the reasons we chose the solution."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"The installation of the client ODI Studio is easy."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"The most valuable feature is you have native access to the external databases."
"The most valuable part of SAS/ACCESS is what it is made for: connecting to remote systems that are not part of your physical SAS environment."
"The most valuable aspect of the solution is the ease of access to the data in those databases."
"The product's initial setup phase was very easy."
"We find it effortless to set up. We really don't have to do anything other than finding the application in the Zapier catalog. And as long as the application has been re-integrated into Zapier, they're able to then just provide the connection details and hook it up."
"What's most valuable in Zapier is its simplicity, seamlessness, and smooth plug-in, so you won't need to build code for every action. I'm not a developer, but I can use Zapier."
"The connection between Facebook lead forms and MailChimp integrations is the most valuable feature."
"Zapier's interface, for me, is the solution's greatest value proposition. It is designed and developed for people who don't have a clue about what they're trying to do. It has a very user-friendly interface."
"The solution is a SaaS and does not require a complex setup."
"The most valuable aspect of this solution is that it is very intuitive and has a very flat learning curve."
"The ability to connect web applications to trigger actions in another app after having enriched, formatted, delayed, grouped, and filtered is really valuable for many businesses."
"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."
"It needs easier security."
"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."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"If you have something like Cisco on top of it, you will have endless problems."
"I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product."
"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 pricing model needs to be reconsidered and adjusted."
"The solution can provide access to the newer databases that come out sooner."
"I can't really recall any missing feature or general improvement that is needed. We don't really add too many new kinds of databases and therefore our needs are already met."
"Zapier needs more YouTube or video tutorials or more training for people. That would help a lot. In particular, Zapier should have documentation for every connector. Its documentation needs to be more detailed and visual."
"System-to-system is fine, but when it comes to system-to-user, where Zapier is helping to communicate to a user, that's a one-way communication. If that user has to perform some action on that notification, the action isn't handled by Zapier. So there's no way to orchestrate that and it's very cumbersome."
"Zapier needs to improve in the same way most RPA solutions should, such as Robocorp, Make, or UiPath. They are not good at helping you find the connections that you need for the problem that you have. For example, if need something on Instagram. I'm going to have to do research for hours to be able to find the components or the app, which is going to do what I need it to do. It makes it difficult to use the system when you don't know what to use."
"It is not worth the money if you have a little bit of a technical mind...Zapier is not able to set up different modules. When automation doesn't work, it's not that easy to find why it didn't work."
"Some apps are not available yet. For instance, a connection with Joomla! would be great. In general, all the most-used apps are available, but I bumped into Joomla! with a client."
"Being able to share Zaps and organize them with teammates would allow sharing and refining scenarios and even combining steps that require different people's credentials."
"My biggest concern with Zapier would be their pricing strategy."
"After mapping them out, and they'd worked for a while, I've had Zapier fail."