Sheer Performance (but not for MacOS!)
April 18, 2018
Sheer Performance (but not for MacOS!)
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Informatica Enterprise Data Integration
Informatica Power Centre is primarily used by the analytics team in our organization to build our ETL workflows. Informatica lies at the heart of all our data pipelining, right from sourcing from the databases all the way through loading to visualization tools and supporting business queries. On a larger picture, it provides a very smooth platform for data movement.
- Informatica has a wide range of support for databases. Pretty much every mainstream DBMS is compatible here.
- Designing ETL mappings and workflows is a very intuitive process, and takes minimal learning time and effort even for a beginner.
- Informatica's biggest strength is its sheer performance. It is unmatched in terms of handling large volumes of data.
- Setting up Informatica and integrating with your existing services can be a hassle. While the support team is quite helpful, it can still take a considerable amount of time and effort to get Informatica up and running.
- Informatica Enterprise Data Integration unavailable for MacOS. This can be a huge problem for a business that primarily uses Apple machines.
- Using Informatica PowerCenter for ETL designing can be quite intuitive for basic to moderately complex workflows. However, for achieving advanced tasks, there is not sufficient documentation available.
- Positive - Made managing data pipelining much easier, cheaper, and faster.
- Because Informatica helps automate ETL workflows, it makes the developer's task much easier by reducing the amount of manual work required.
- Negative - No support on MacOS means that the business needs to use VMs to work on Informatica. This can be very counter-productive.
While Talend offers a much more comfortable interface to work with, Informatica's forte is performance. And on that front, Informatica Enterprise Data Integration certainly leaves Talend in the dust. For a more back-end-centric use case, Informatica is certainly the ETL tool of choice. On the other hand, if business users would be using the tool, then Talend would be the preferred tool.