SnapLogic vs Informatica - which one is better?
February 21, 2019

SnapLogic vs Informatica - which one is better?

Anonymous | TrustRadius Reviewer
Score 5 out of 10
Vetted Review
Verified User

Overall Satisfaction with SnapLogic

Snaplogic is being used within the BI team as well as other teams to integrate data from different applications.

Pros

  • Easy to complete data integration for a non-tach-savvy person.
  • Cheaper than other established data integration products such as Informatica, Talend etc...
  • Not much maintenance headache as this is both a platform as a service, as well as software as a service.

Cons

  • Complex re-usable components are difficult to implement. Although nested pipelines exist, you have to pass all the parameters and configure them each time. If there is complex business logic during data transformation, SnapLogic forces you to use a lot of scripts. This way anyone can lose the readability and maintainability of the code of any ETL tool.
  • Parallel processing of data (multi-thread) is not easy to implement.
  • Not well integrated with the AWS environment. For instance, it does not support KMS encryption. With newer tools coming up in the AWS /AZURE environments, SnapLogic is not able to quickly come up with integration tools to compensate.
  • SnapLogic cannot solve business problems and you still need a technical person to solve the complex integration issues.
  • Our business bought SnapLogic thinking this could replace our current ETL tools such as Informatica. But SnapLogic falls short in a lot of features when compared to Informatica. Later our business decided not to replace Informatica.
  • SnapLogic promised to solve big data integration problems, but we did not find a suitable solution that can solve our problems of data integration using SnapLogic (for instance, it could not parse parquet nested file).
SnapLogic does better API integration than Informatica Power Center. Informatica has better re-usable component integration and version control than Snaplogic. Metadata lineage for Informatica is better than SnapLogic. I do not think that SnapLogic is better than SSIS.
Our finance team is doing integration with the billing systems, and some of our non-tech-savvy team is doing the SnapLogic integration. I will recommend using SnapLogic. However, if there is a BI team doing data warehouse, I would not recommend using SnapLogic as the sole data integration tool.

SnapLogic Feature Ratings

Pre-built connectors
8
Connector modification
5
Support for real-time and batch integration
4
Data quality services
1
Data security features
3
Monitoring console
9

Comments

More Reviews of SnapLogic