We performed a comparison between Informatica PowerCenter, Informatica PowerExchange, 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 support is valuable. There are also open-source ETL products, which work very well, but there is no support. When we face a production problem, being able to get support is valuable, and it brings efficiency. With an open-source solution, we can't engage anyone to resolve the problem as quickly as possible."
"UI-based ability to create data mapping."
"It has helped us monetize."
"I like the completeness of the way I can build ETL workflows."
"It's a complete package, which is why we use this solution."
"The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness."
"Technical support, and their approach is good. They have a support portal and support tickets. If you open a ticket it has multiple levels of severity from level one to very high or critical."
"The performance and design of Informatica have been very valuable. I find the performance faster than, say, Oracle Data Integrator or DataStage."
"The user interface and user experience are perfectly all right."
"This product is easy to install and it can be done in a few hours."
"The data transformation is the solution's most valuable feature."
"The scalability is excellent."
"The agentless RCDC enablement through PowerExchange is a great idea and has worked very well so far."
"Overall, it's a good tool. It's currently number one on the market. It pretty much has all the necessary capabilities to pull the incremental data from the source system, technically speaking."
"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."
"Provides a significant amount of control over the landscape and overall implementation."
"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 connection with SOAP is the best feature."
"It is a scalable solution."
"They are very good at building out new aspects according to customer requirements."
"By using snaps instead of functions in code, you can see the building blocks of the integration visually. This helps a lot."
"What I found most valuable in SnapLogic is the ETL feature, particularly the Transform Snap Pack, for example, any kind of reading or writing on Transform Snaps. Other than that, all the third-party connectivity tools such as the SAP Snap Pack, Salesforce Snap Pack, Workday Snap Pack, even the ServiceNow Snap Pack, I find all those are pretty useful in SnapLogic."
"The product is easy to use and has many connectivity options."
"The solution is easy to implement and easy to use. It's basically just drag and drop."
"I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"Its scalability can be improved. It is not scalable."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"The solution must improve the integration with new services."
"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."
"The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues with the Workflow Monitor application."
"Some of the conversions are done inside the product. We use work tables that are created by the engine itself, but the names of the work tables are very long, and they don't have any meaning, which makes it a bit difficult to understand and follow exactly what is happening inside."
"Integration with the largest number of databases and other systems would be important."
"V10.2 is very stable, but we are still struggling to make V10.5 stable. We found services that were down, and PowerExchange stopped working."
"Technical support can be improved with respect to delays in ticket response time."
"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."
"The product is not suitable for application integration."
"The solution needs better integration with other tools."
"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."
"I would like the stability to improve."
"SnapLogic should have some inbuilt protocol mechanism in order to speed up."
"One of the areas for improvement in SnapLogic is that the connectors for some of the applications should be more available in terms of testing in the dev environment. Another area for improvement is that the logging should be standardized, for example, the integration with an ELK stack should be required out-of-the-box, so you can ship the log and have it in the ELK stack. There should be integration with ELK stack for the log shipping."
"Connecting to data behind enterprise firewalls has been tricky."
"I don't think the support has better knowledge about technologies and tool support. There were lots of times when we had an issue, and it took me quite a long time to explain the problem. I feel like some of the support staff don't know their product well."
"We'd like zero downtime in the future."
"They should expand in terms of features for SaaS-based market requirements in different sectors."
"SnapLogic doesn't provide any on-premises software, so users have only cloud-based software to use."
"We'd like there to be more ways for users to get more comfortable and have more experience with the solution to make it easier to use."