We performed a comparison between Oracle Data Integrator (ODI), SSIS, and Zapier based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"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."
"The installation of the client ODI Studio is easy."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"One of the standout features of ODI is its ability to prepare everything on a vertical level and create reusable components, which adds to its value."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"The product's deployment phase is easy."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"We can connect with multiple data sources easily using an external connector in SSIS."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"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."
"Zapier’s most valuable feature is its ability to interconnect applications or devices."
"There are a few valuable features, like the stability that it comes with and also the number of features that it offers. I've used other services like Pabbly, but they don't offer similar numbers of applications that Zapier has or allows to integrate with – it's maximum."
"Zapier luckily has a wide range of integrations, I would say."
"We can connect Zapier with Zoho CRM for lead generation. I like the tool's drag and drop feature."
"Zapier handles everything under the sun that you would think you need in automation. It is the most mature integration platform and service on the market."
"Zapier is user friendly and makes it easy to integrate different tools. It has a drag and drop functionality which makes it easy to connect environments."
"With the previous CRM we were using – the Google Ads landing pages we had – we were collecting leads manually. That process was not efficient and took a sales team a lot of time to insert these leads manually. Currently, the process is smooth and we use Zapier to collect the leads for us."
"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."
"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 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 the ease of use. There is a steep learning curve to use the solution."
"An area for improvement in Oracle Data Integrator (ODI) is real-time integration. Currently, my company has a workaround to implement real-time integration, an area on which Oracle must focus more. Real-time integration should be easier in Oracle Data Integrator (ODI). Another area for improvement in Oracle Data Integrator (ODI) is integration with more publishers and subscribers rather than just database integrations."
"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."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."
"I would like to see better integration with Power BI."
"Generic processes should be used instead of custom code for each table."
"This solution needs full support for real-time processing."
"We'd like them to develop data exploration more."
"My biggest concern with Zapier would be their pricing strategy."
"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."
"The solution does not work properly when we apply filters and we get errors."
"With Zapier, improvements are required in the areas of concerns like bugs, ease of use, and documentation."
"After mapping them out, and they'd worked for a while, I've had Zapier fail."
"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."
"I would like to see them improve the Quickbase integration. Currently, it only allows triggering actions when records are added, but it would be more useful if we could also trigger actions when records are modified or deleted."
"Some recent changes to the solution have made it bulky and not as intuitive to use as it previously was."