We performed a comparison between Informatica PowerExchange, Oracle Data Integrator (ODI), and SnapLogic based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The data transformation is the solution's most valuable feature."
"The agentless RCDC enablement through PowerExchange is a great idea and has worked very well so far."
"The most valuable feature is connectivity to data sources."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"The product’s flexibility is valuable."
"The scalability is excellent."
"It is a scalable and versatile solution."
"The main benefit of PowerExchange is its native real-time capabilities. Competing tools are counting on third-party packages or Oracle to offer real-time capabilities. However, Informatica has a native ability to scan the data on the file system level and capture the changes almost instantly when I push it to the consumers. The solution has a powerful built-in replication engine."
"The scalability is great. It's one of the reasons we chose the solution."
"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."
"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."
"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."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"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."
"The most valuable feature that we use is the Knowledge Modules."
"SnapLogic is an IPA tool that leverages a low code environment to connect to multiple sources, extract data, and store it in Azure data lake."
"The initial setup is very straightforward."
"The product is easy to use and has many connectivity options."
"The connection with SOAP is the best feature."
"An important tool for building prototypes and MVPs than can seamlessly turn into production jobs"
"SnapLogice is a low-code development tool."
"The feature I found most valuable in SnapLogic is low-code development. Low-code development has been very useful for simple processes, which is required for business users such as extracting details from a file or getting things reported by calling your web service. Calling your web service also becomes easier with SnapLogic because of the snaps available, so if you have the documentation, you can call an API. You don't have to write all those clients to call an API, so that is another feature I found very easy in SnapLogic. Configuring and managing all the file systems also become very handy with the solution."
"The solution could improve its API management."
"Should diversify more, maybe with a reporting and visualization utility,"
"They should make it quick and easy for use of citizen data integration or for people or integrators developing at the customer side. They could be development teams within the business team. For them, the product owners can consider making it a little bit more seamless and a little bit more democratized."
"The connectivity with T24 core banking could be improved."
"Real-time has not been enhanced that much over the past few years. There has not been as many features added like they did before."
"I would like the stability to improve."
"The solution could be made more user-friendly. The configurations are also quite difficult."
"The major shortcoming of PowerExchange is high availability and failover. None of the versions we've used to date have had the out-of-the-box ability to enable failover and high-availability requirements. This is a significant challenge and risk."
"The solution needs better integration with other tools."
"Stability could be improved because some operators have issues."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"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."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"The price needs to be lowered. It's too expensive."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"Technical Support could be better."
"They should expand in terms of features for SaaS-based market requirements in different sectors."
"SnapLogic should have some inbuilt protocol mechanism in order to speed up."
"What could be improved in SnapLogic is that it was not capable in terms of processing a large number of datasets, but at that point, SnapLogic was evolving. It didn't give a lot of Snaps. I heard recently there are a lot of Snaps getting added and the solution was being enhanced, particularly to connect different data sources. When I was working with SnapLogic six months to one year back, I faced the issue of it not being capable of handling a huge volume of datasets or didn't have much of Snaps, and that was the drawback. If there is any large number of data sets, that's based on or depends on your configuration. If it is a huge volume of data, other traditional ETL tools such as Informatica and Talend can process millions and billions of records, while in SnapLogic, the Snaplex fails or it returns an error in terms of processing that huge volume of data. Informatica, Talend, or any other ETL tool can run for hours in terms of jobs, while SnapLogic jobs fail when the threshold is reached. SnapLogic isn't able to withstand processing, but I don't know if that's still an issue at present, because the solution is getting enhanced and it's been more than six months to one year since I last worked with SnapLogic. There are now a lot of Snaps getting added to the solution, and if it can overcome the limitations I mentioned, SnapLogic could be the go-to tool because currently, it's not being used as much in organizations. It's being used comparatively less compared to other retail tools."
"The support is the most important improvement they could make."
"There is room for improvement with APM management and how task execution looks."
"Ultra Pipelines provides real-time ingestion but it needs some adjustment."
"We'd like zero downtime in the future."
"One area for improvement in SnapLogic is the transparency in the flow of data. It needs to have more transparency. Right now, users only have a preview option at the end of any job flow, so at the end of any Snap Pack, there is a data preview option that lets you review the data and see how it's moving. What would make the solution better is more debugging and more access to change data from the preview panel or more functionality in terms of the preview option."