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."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."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"It has the ability to easily load slowly changing dimensions."
"It's scalable."
"The most valuable feature that we use is the Knowledge Modules."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"The most important features are it works well and provides self-service BI."
"The performance and stability are good."
"The setup was easy. All Microsoft products are easy to set up."
"It's a competent product."
"It is easy to set up the solution."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"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."
"The product's most valuable feature is automation."
"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."
"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."
"Zapier’s most valuable feature is its ability to interconnect applications or devices."
"The most valuable feature of Zapier is it saves me time doing repetitive tasks."
"The product's initial setup phase was very easy."
"It needs easier security."
"It has been very good. Just recently, I've faced an issue, but I solved it somehow. While integrating with a file, I faced an issue where I wanted output files, and I had used the text field limited quotations, but at the end of the file, there was a line breakage for the last column. So, we just removed the text field because it was not working correctly for us."
"Stability could be improved because some operators have issues."
"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."
"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."
"The initial setup is a bit complex compared to other tools."
"We used a third party to do the implementation of ODI."
"It needs more integration tools, so you can connect to different sources."
"We have issues with SSIS connectors while extracting data from Excel sources."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"The performance of SSIS could improve when comparing it to Oracle Database."
"Options for scaling could be improved."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
"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."
"With Zapier, improvements are required in the areas of concerns like bugs, ease of use, and documentation."
"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."
"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 recent changes to the solution have made it bulky and not as intuitive to use as it previously was."
"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."
"I think that this solution should have more apps connected to it."