Sheer Performance (but not for MacOS!)
April 18, 2018

Sheer Performance (but not for MacOS!)

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

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.
One of the main strengths of Informatica Enterprise Data Integration is its performance. If your business requirements include processing of huge volumes of data, then Informatica is strongly recommended over other tools. I would recommend Informatica over Talend.

On the other hand, if your business primarily works on Apple machines, Informatica Enterprise Data Integration is a resounding NO. Running Informatica on a VM or a Remote Desktop completely kills its efficiency.

Informatica PowerCenter Feature Ratings

Connect to traditional data sources
Connecto to Big Data and NoSQL
Simple transformations
Complex transformations
Data model creation
Metadata management
Business rules and workflow
Testing and debugging
Integration with data quality tools
Integration with MDM tools