TrustRadius Insights
PowerCenter is widely used across organizations for a variety of use cases. Users have found the product to be instrumental in addressing …
Overview
What is Informatica PowerCenter?
Informatica PowerCenter is a metadata driven data integration technology designed to form the foundation for data integration initiatives, including analytics and data warehousing, application migration, or consolidation and data governance.
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Popular Features
- Connect to traditional data sources (18)9.090%
- Business rules and workflow (18)9.090%
- Simple transformations (18)8.080%
- Complex transformations (18)7.070%
Pricing
N/A
Unavailable
What is Informatica PowerCenter?
Informatica PowerCenter is a metadata driven data integration technology designed to form the foundation for data integration initiatives, including analytics and data warehousing, application migration, or consolidation and data governance.
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
92 people also want pricing
Alternatives Pricing
What is Clear Analytics?
Clear Analytics is a business intelligence solution that enables non technical end users to perform analytics by leveraging existing knowledge of Excel coupled with a built in query builder. Some key features include: Dynamic Data Refresh, Data Share and In-Excel Collaboration.
What is Vertify?
VertifyData is a cloud-based integration platform with core integration capacities, including a drag-and-drop interface and real-time synchronization. It also offers over 80 prebuilt connectors and templates, plus customizable integrations for scaling businesses.
Product Demos
#Informatica #Source #Qualifier Online #Tutorial For Beginners - Part 14
YouTube
#Informatica #Client Tools #Training Session For Beginners- Part 4 || Video Course
YouTube
INFORMATICA ONLINE TRAINING Session | Free Tutorials | Materials | ETL Tool
YouTube
Features
Return to navigation
Product Details
- About
- Tech Details
- FAQs
What is Informatica PowerCenter?
Informatica PowerCenter is a metadata driven data integration technology designed to form the foundation for data integration initiatives, including analytics and data warehousing, application migration, or consolidation and data governance.
Informatica PowerCenter Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Frequently Asked Questions
Informatica PowerCenter is a metadata driven data integration technology designed to form the foundation for data integration initiatives, including analytics and data warehousing, application migration, or consolidation and data governance.
Reviewers rate Connect to traditional data sources and Data model creation and Business rules and workflow highest, with a score of 9.
The most common users of Informatica PowerCenter are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(92)
Community Insights
TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!
- Business Problems Solved
- Pros
- Cons
- Recommendations
PowerCenter is widely used across organizations for a variety of use cases. Users have found the product to be instrumental in addressing their data integration needs and solving challenges related to data quality management, master data management, data masking, and data virtualization. With PowerCenter, users can easily extract, transform, and load data from various sources such as SAP and Salesforce into their data warehouses and data marts. They appreciate how the product optimizes data for reporting tools and facilitates the generation of accurate reports.
Another common use case for PowerCenter is integrating data from disparate sources and migrating data from legacy systems to newer infrastructure. Users have found the product to be efficient in automating ETL processes and ensuring timely and efficient data loads. They also value its advanced security features, which make administration easier. Many users have praised PowerCenter's ease of use, fast development capabilities, and multi-user development environment with a check-out/check-in mechanism that supports collaborative work.
Overall, PowerCenter has become a mainstay ETL tool in organizations due to its scalability, flexibility, and robustness as an ETL engine. From loading data into data warehouses and data marts to feeding information into COTs applications or Teradata Data Warehouses, PowerCenter has proven to be an indispensable tool for enterprise-wide data integration across a range of industries including marketing, healthcare, finance, and more.
Seamless data integration capabilities: Multiple reviewers have praised Informatica PowerCenter for its seamless data integration capabilities, with users stating that it effortlessly connects to multiple sources and targets. This feature simplifies the complex process of integrating data from various systems, providing a significant advantage in terms of efficiency and productivity.
User-friendly interface: The user-friendly interface of Informatica PowerCenter has been consistently appreciated by reviewers, who find it highly intuitive and easy to navigate. Users state that the application of complicated business rule logic is straightforward, thanks to the intuitive design process for creating ETL mappings and workflows. The minimal learning time and effort required to work with PowerCenter's interface are seen as significant advantages.
Reusability and streamlined development processes: Reviewers have highlighted PowerCenter's ability to capture and share logic in mapplets, enabling reusability and streamlining development processes. This feature contributes to a seamless workflow for developers, making the development and maintenance of code in PowerCenter straightforward. Users value this functionality as it enhances efficiency and promotes consistency across projects.
Lack of Documentation: Several users have expressed frustration with the limited availability and insufficient documentation for Informatica PowerCenter. This has made it challenging for users to achieve advanced tasks and work with complex workflows, hindering their ability to fully utilize the software.
Complex Installation and Configuration: Many reviewers have encountered difficulties during the installation and configuration process of Informatica PowerCenter. The software consists of multiple components that require significant time and resources to set up effectively, causing inconvenience for users.
Limited Integration Capabilities: Some users have found it difficult to integrate code from other languages like Java, Python, or R into Informatica PowerCenter. This limitation forces users to build multiple hops in a data pipeline, resulting in additional complexity and potential inefficiencies in their workflow.
Users recommend Informatica PowerCenter for various tasks such as data migration, ETL, and data integration. They find it to be a reliable tool with strong support and powerful mapping and visualization capabilities. Additionally, users mention its ability to connect and fetch data from different source systems, as well as its capabilities for processing and transforming data. Informatica PowerCenter is highly recommended for companies dealing with large amounts of data and those in need of real-time data integration. Users also mention its plugins for integrating with other applications. While some users acknowledge that Informatica PowerCenter is more expensive than other software, they still recommend it as the best ETL tool in the market.
Attribute Ratings
Reviews
(1-19 of 19)Companies can't remove reviews or game the system. Here's why
May 03, 2022
Informatica PowerExchange Connectors: the data with quality and reliability for the enterprise
Basically the two solutions have, more or less, the same functions and features.The difference, for me, is that ThreatQuotient make more features over the security and I think is oriented to a SOC enviroments.
InformaticaExchange Connectors is oriented to the quality, integration and distribution of the data in order to ensure the reliability and access of data from different sources, as well as the integration in a single repository of enterprise data (External/internal)
InformaticaExchange Connectors is oriented to the quality, integration and distribution of the data in order to ensure the reliability and access of data from different sources, as well as the integration in a single repository of enterprise data (External/internal)
May 31, 2021
Old yet powerful ETL Tool
Informatica PowerCenter is highly flexible and scalable for different types of data and it has any inbuilt function to transform our data into the meta data structure. Some of the tool sets such as TDM, is good in some ways but need EBF more than often when running into any issue.
December 01, 2020
Amazing ETL Tool
Score 9 out of 10
Vetted Review
Verified User
This is great tool to handle large data in multiple data sources.
November 19, 2019
The data integration leader
Informatica is a mature enterprise data integration platform for ETL jobs. Informatica has a suite full of tools other than PowerCenter that can be used for various use cases. It makes sense to know what the entire suite offers rather than just power center so large organizational needs can be better tailored to fit them. It provides great abilities to connect the maximum number of data sources irrespective of being SQL or no-SQL based. Informatica is also database agnostic and can work as well with a legacy database as with the latest ones. The range of connectors it provides enable fast processing speeds which are critical with the increasing amount of data being processed every day. we selected Informatica for all these benefits and to give the client organization a base to have a great data warehouse for years and not just for the short term.
April 12, 2019
Informatica Power Center review
Informatica Power Center was already selected by my company before me. I just learned the software and started using it.
March 08, 2019
PowerCenter outpowers the cloud version
- IBM InfoSphere Data Replication, IBM InfoSphere Warehouse, webMethods OneData, Mule ESB, Talend Cloud Integration, Talend Data Integration, Talend Enterprise Service Bus, SAP Data Services, WebSphere DataPower Gateway and Informatica Cloud
PowerCenter is simply so robust and refined that most other apps cannot do as much as it can. Even Informatica’s own Cloud version is so anemic as to not even compare against it. While from that perspective it feels bloated with too much to navigate through, many of those features eventually come in handy, so you might as well go big with PowerCenter and invest in training and pay decent salaries to keep your turnover low and your productivity high.
December 19, 2018
Informatica PowerCenter, an Enterprise ETL Tool
Alternatives:
- Talend (open source, cheaper, longer development time, not intuitive UI, harder to troubleshoot, etc)
- Pentaho (cheaper, better talend)
- Oracle Integrator (similar as capabilities Informatica PowerCenter, but not as mature, similar cost)
December 10, 2018
A powerful ETL solution which focuses on enterprise scalability, flexibility, and code re-usability
SSIS is a good entry into ETL, for smaller organizations or Microsoft-centric companies. It's strengths lie in its ease-of-use, quick turnaround, and simplicity. Its weaknesses lie in scalability and re-usability (you can achieve re-usability, however segmentation is at the project level with no global scale). Pentaho is a great, low cost solution with deceptive power, however scheduling along with flexibility in other functions such as OS level script execution is a bit weaker. PowerCenter and DataStage are more comparable at an enterprise ETL level, having different management philosophies and approaches. For both, there are features in each that I wish the other either adopted or replaced, however due to its place in the market, ease of finding additional developers, and scalability, PowerCenter was chosen.
April 18, 2018
Sheer Performance (but not for MacOS!)
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.
Microsoft SSIS, Ab Initio and IBM DataStage are evaluated against Informatica. Informatica scored well on licensing, hardware infrastructure flexibility and Big Data connectivity
April 12, 2017
Informatica Review
I've really only used Informatica as an ETL developer.
April 06, 2017
Good ETL Platform
Much easier to learn and better performance
March 09, 2017
My personal view of Informatica Enterprise Data Integration tools based on my 10+ years of user experiences.
Informatica tool is easy to use and easy to maintain, it also performs well, which are the major reasons my company selected it.
August 03, 2016
Day to day user's opinion of PowerCenter
PowerCenter is very similar to DataStage, in that they both deal with the movement and manipulation of data from one source/system to another. As we use both extensively at my company, I cannot say how it compares beyond that both are well liked and widely used. I would assume that they deal with different types of data sources, but I personally have only worked with Informatica PowerCenter.
May 21, 2016
PowerCenter for ETL
- Data stage, PLSQL and Oracle Data Integrator
- Powercenter provides lots of features to implement mapping rules.
- Very easy to design, develop and maintain ETL code.
- Easily integrate with its other products like IDQ and MDM.
February 29, 2016
One stop for all ETL needs
PowerCenter can be run from different types of OSs and can integrate with multiple types of databases and applications compared to SSIS. PowerCenter performs better with any type of database due to its ability to use native drivers to read as well as load data. Due to its seam less integration with IDQ it can clean the data in a much easier and faster way than SSIS.
October 30, 2015
PowerCenter is a Industry Leading integration tool
PowerCenter is the industry leader when it comes to interfacing with multiple source and target systems. The graphical interface increases employee productivity while reducing human resource expenditures and training requirements. These other tools offer some similar capabilities, but lack the range and depth when compared with the PowerCenter platform.
April 02, 2014
Integration with Informatica
Score 9 out of 10
Vetted Review
Verified User
Ab Initio, SSIS, Cognos
March 20, 2014
Informatica - Review at a glance
Score 9 out of 10
Vetted Review
Verified User
- IBM Cognos,ab initio
Because of these key features :
- Industry-leading data integration technology
- Proven best-practice implementation methodology
- End-to-end data migration services