We performed a comparison between Informatica PowerCenter, Oracle Data Integrator (ODI), 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 has a Data Catalog that uses the Model repository."
"It works with any multi-databases, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use."
"Once you have learned Informatica, it is very easy to use."
"Can manage a huge quantity of data and provide reliability."
"Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System."
"In the end, you have structured, proper data for use in an integrated BI solution."
"Deployment was simple and straightforward."
"The ability to scale through partitions helped us to improve the performance."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"The CAEM is very useful in its modularity and portability."
"The initial setup is easy."
"It is an ETL tool, which does the extract, transform, and load."
"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 Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance."
"Besides loading data, we do most of our transformations in ODI."
"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."
"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."
"We can connect Zapier with Zoho CRM for lead generation. I like the tool's drag and drop feature."
"The product's initial setup phase was very easy."
"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."
"The most valuable feature of Zapier is it saves me time doing repetitive tasks."
"The product's most valuable feature is automation."
"Zapier’s most valuable feature is its ability to interconnect applications or devices."
"Its interface can be modernized. It is an old product. I have been working with it for 14 years, and it still looks the same. It hasn't been modernized much. It also needs to handle more modern formats, such as JSON files. It works with the old text files and databases, but it does not always work with the newer, modern stuff. You need to make your own programs to support that kind of stuff. Support is also a kind of difficult with Informatica. They don't do direct support and rely on using their distributors around the globe for support, which means that you kind of have to go through this layer of different companies before you get help."
"The performance of Informatica PowerCenter could improve."
"It would be nice to have all tools in one place. CDC needs more effort, as it's only easy to develop if you are familiar with Linux."
"Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"Integration with Artificial Intelligence would benefit this solution."
"Its licensing can be improved. It should be features-wise and not bundle-wise. A bundle will definitely be costly. In addition, we might use one or two features. That's why the pricing model should be based on the features. The model should be flexible enough based on the features. Their support should also be more responsive to premium customers."
"The licensing is difficult."
"The solution's commercial cost is very high. Other open-source tools can do the tool's functions for free. The world is moving to the cloud, but the solution hasn't updated its drivers. I presume that its downfall will start soon. The tool is trying to cross-sell or upsell without helping customers derive benefits from the existing products. They have multiple tools and licenses. It is better to bring the smaller tools in one umbrella."
"If you have something like Cisco on top of it, you will have endless problems."
"Stability could be improved because some operators have issues."
"Technical Support could be better."
"We used a third party to do the implementation of ODI."
"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."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"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."
"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."
"Zapier could be a little faster, but that might not be possible. I would encourage Zapier to make more API endpoints for each application"
"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."
"At the moment, they allow a limited number of apps. I look forward to getting more apps for each package."
"With Zapier, improvements are required in the areas of concerns like bugs, ease of use, and documentation."
"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."
"It could support various languages along with Python."
"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."
"The solution does not work properly when we apply filters and we get errors."