Skip to main content
TrustRadius
Informatica PowerCenter

Informatica PowerCenter

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.

Read more
Recent Reviews

TrustRadius Insights

PowerCenter is widely used across organizations for a variety of use cases. Users have found the product to be instrumental in addressing …
Continue reading

Amazing ETL Tool

9 out of 10
December 01, 2020
Informatica PowerCenter is widely used as an integration tool across many projects. This is being used in specific departments. It lets us …
Continue reading

Good ETL Platform

8 out of 10
April 06, 2017
Incentivized
Our company bought Informatica PowerCenter around 5 years ago, when we initially set up the BI team in the IT department. After that it …
Continue reading
Read all 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

View all 11 features
  • Connect to traditional data sources (18)
    9.0
    90%
  • Business rules and workflow (18)
    9.0
    90%
  • Simple transformations (18)
    8.0
    80%
  • Complex transformations (18)
    7.0
    70%
Return to navigation

Pricing

View all 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?

89 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.

Return to navigation

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
Return to navigation

Features

Data Source Connection

Ability to connect to multiple data sources

8.5
Avg 8.2

Data Transformations

Data transformations include calculations, search and replace, data normalization and data parsing

7.5
Avg 8.4

Data Modeling

A data model is a diagram or flowchart that illustrates the relationships between data

8.2
Avg 8.2

Data Governance

Data governance is the practise of implementing policies defining effective use of an organization's data assets

9
Avg 8.2
Return to navigation

Product Details

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 SystemsUnspecified
Mobile ApplicationNo

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).
Return to navigation

Comparisons

View all alternatives
Return to navigation

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!

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-20 of 20)
Companies can't remove reviews or game the system. Here's why
Jaime Maña | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Informatica PowerExchange Connectors provide access to different sources of data in multiple locations, differente RDB systems and DATA WAREHOUSE environments in the mode SaaS with high performance and security. The platform are used in a cloud-based mode, making access very simple and without major problems. Also use for transformation data and connectivity with API´s in cloud(Internal and External. The company have more than 20 offcies in the world with differente enviroments and API's locally development.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We used Informatica PowerCenter as an ETL to to feed data into Teradata Data Warehouse that houses all data marts of our company.
Mainly used to process semi-structured and unstructured data like web and mobile logs. It has been well tested against large volume of data and it stood up to the expectations.
December 01, 2020

Amazing ETL Tool

Score 9 out of 10
Vetted Review
Verified User
Informatica PowerCenter is widely used as an integration tool across many projects. This is being used in specific departments. It lets us connect to endless sources in order to pipe data out into different available repositories. Primarily it feeds our various data warehouse and data marts. Also this is being used in Salesforce implementation project to transfer data from Flat files and Relational databases to Salesforce Objects.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Informatica Powercenter is widely used as an integration tool, very commonly across projects as well as across organizations. It addresses a whole suite of data problems, starting with data integration, data quality management, master data management, data masking, data virtualization, etc. The tool is extremely popular for its ability to gather data from disparate sources and homogenize it for consumption. There are several models it can be used in: Integrate data from data sources and landing it in a staging area for consumption, in data migration projects for moving data from legacy systems to newer infrastructure.
Gurcan Orhan | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Informatica Power Center is easy to understand, gives you the opportunity to perform fast development, and also supports a multi-user development environment with a check-out/check-in mechanism. It performs transformation levels of ETL (Extract & Transform & Load) very fast.
Advanced security features also help you to perform administration more easily and with confidence.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use PowerCenter throughout the organization, under a centralized IT implementation with a decentralized (or divisional) user base. It has been our mainstay and go-to ETL tool for many years. From SAP to Oracle to SQL, it lets us connect to just about anything in order to pipe data out into different repositories. Mainly it feeds our various data warehouse and data marts, but we also use it to extract data from our old CRM system into our Salesforce transition.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Informatica PowerCenter provides a robust Extract Transform and Load (ETL) engine that is both scalable and flexible. I have implemented informatica PowerCenter for a variety of government agencies to meet a variety of different requirements. Informatica is used to integrate data, build data marts or data warehouses to support decision support systems, disseminate data or even ingest data into COTs applications. It is all about being able to move or transform your data so it is usable by your business.
Jody Gitchel | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Informatica PowerCenter is the enterprise ETL tool used for all data integration across the organization. PowerCenter is utilized for all on premises data integration including the Electronic Medical Record (EMR) system as well as disparate systems including scheduling and time management systems.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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.
April 12, 2017

Informatica Review

Brandon Fitzpatrick | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Our data integration team uses Informatica for extracting, transforming, and loading data into our data warehouse. It allows us to load data from a variety of different sources, reuse transformations, and sync work across a number of employees.
April 06, 2017

Good ETL Platform

Score 8 out of 10
Vetted Review
Verified User
Incentivized
Our company bought Informatica PowerCenter around 5 years ago, when we initially set up the BI team in the IT department. After that it became one of the core platforms in IT for data-level workflow and reporting purposea.
Score 6 out of 10
Vetted Review
Verified User
Incentivized
PowerCenter is being used to automate our ETL processes. We have implemented data pipelines to ingest and transform data from our clients. PowerCenter work flows also load data into a DBMS platform and create SAS data libraries.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Informatica enterprise data integration tools have been used in my company across different departments for enterprise data warehouses, data marts, data movements etc. It addresses or provides data for different business purposes for my company such as BI reporting and real data dashboards etc.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Powercenter is used heavily by the IT processing departments at my organization in support of the end users in various business departments. In short, it is the backend process for a majority of the company, but only a small percentage of employees use the tool itself in a day to day basis.
Sadu Kurahatti | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Our firm provides consultancy to several federal government clients. Currently we are using Informatica Powercenter for aDHS - USCIS client to perform ETL on daily basis (both initial full load and incremental load) into various data marts. It helps in moving data from one source to another, mainly to a data warehouse to help generate reports.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
PowerCenter is being used across the organization for all our ETL needs, be it generating flat files from different sources or loading data from legacy systems into data warehouse or integrating multiple systems for reporting needs.
Brian Randolph | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
PowerCenter is used in multiple applications across our company. PowerCenter mappings load the data warehouse and various data marts for our marketing and executive teams. The Informatica Cloud platform, based on the PowerCenter engine, replicates data from our Salesforce deployment for downstream consumers. PowerCenter, along with the Informatica Data Quality offering, is utilized to cleanse and land source information for our Master Data Management platform. We utilize PowerCenter and the PowerExchange connector for Salesforce to publish the best version of the truth to the source systems. The tools address the issue of timely and efficient data loads, and to be able to apply data standards and business rules across multiple disparate platforms.
Score 9 out of 10
Vetted Review
Verified User
Informatica is used to integrate to various applications like SAP, Salesforce etc. with Oracle and SQL databases. It's used by various departments across the Americas. It helps to optimize the data for various reporting tools.
Return to navigation