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-4 of 4)
Companies can't remove reviews or game the system. Here's why
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.
  • Data migration from multiple sources. It handles any type of source data including RDBMS, flat files, XML, mainframe etc.
  • Implementing data migration rules is very easy and efficient and reusable.
  • Development and maintenance of code is very easy. Design, development and scheduling of full load and incremental load is very easy.
  • Provides lot of features for developers to implement any kind of business rules.
  • Not worth doing simple data migration using powercenter.
  • Licensing cost.
  • Handling Blobs and clobs data types.
PowerCenter is ideal where there is a need to implement complex data migration rules and perform incremental data load. It is very efficient, easy to maintain and modify the code. It is also very efficient in connecting to data sources including XML, Flat files, spreadsheets, RDBMS, mainframe etc.
Data Source Connection (2)
70%
7.0
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
40%
4.0
Data Transformations (2)
90%
9.0
Simple transformations
100%
10.0
Complex transformations
80%
8.0
Data Modeling (5)
74%
7.4
Data model creation
40%
4.0
Metadata management
60%
6.0
Business rules and workflow
100%
10.0
Collaboration
70%
7.0
Testing and debugging
100%
10.0
Data Governance (2)
90%
9.0
Integration with data quality tools
100%
10.0
Integration with MDM tools
80%
8.0
  • It has a high ROI.
  • Overall very happy with the product.
  • Very useful in fulfilling business needs.
  1. Powercenter provides lots of features to implement mapping rules.
  2. Very easy to design, develop and maintain ETL code.
  3. Easily integrate with its other products like IDQ and MDM.
12
Information technology - consultancy
10
ETL developers with Powercenter, SQL development experience
  • Data migration
  • Full Load and incremental load
  • Data warehouse development
  • Implement complex data migration/business rules
  • Clean up data
  • Standardize data
  • Data Quality
  • Data profiling
  • Address Validation
It is a good, efficient product. Lots of developers are easily available in the market to perform the work.
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.
  • Tracking Changes in slowly changing dimensions
  • Fact & multi-dimensional loading
  • Integration of data from SAP and Salesforce is better with this ETL tool compared to other tools in the market
  • Modularity
  • Several partnerships diminishing the value of technologies
  • Unable to get list of objects from Repository (like sources & targets) that don't have any dependency
  • Scheduling: The built-in scheduling tool has many constraints such as handling Unix/VB scripts etc. Most enterprises use third party tools for this.
Scalability
Modularity
Backward Compatability.
Easy Upgrade.
Support from Vendor
  • Master data management
  • Data lineage and data archiving
  • Data discovery and profiling
  • Increased reporting strategy
Ab Initio, SSIS, Cognos
Availability of options to integrate with application oriented databases like SAP, Salesforce etc.
Product Support.
Reliability.


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.
  • Integration of data from SAP and Salesforce is better with this ETL tool compared to other tools in the market
  • Tracking Changes in slowly changing dimensions
  • Fact & multi-dimensional loading
  • Modularity
  • Scheduling: The built-in scheduling tool has many constraints such as handling Unix/VB scripts etc. Most enterprises use third party tools for this.
  • Several partnerships diminishing the value of technologies
  • Unable to get list of objects from Repository (like sources & targets) that don't have any dependency
The tool should satisfy these criteria:
  • Extraction of the data from legacy sources (usually heterogenous)
  • Data transformation (data optimized for transaction --> data optimized for analysis)
  • Synchronization and cleansing of the data
  • Loading the data into data warehouse.
  • Increased reporting strategy
  • Data discovery and profiling
  • Master data management
  • ata lineage and data archiving
  • 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
  • Flexible data integration support
  • Right-time delivery of high-quality data
  • Flexibility to rapidly create and change functionality
Robert Goodman | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
  • Informatica is a complex, full-featured data integration tool. We use Informatica primarily to extract data from our ERP systems, transform, and load it into operational and dimensional data stores.
  • We have found that upgrading from version to version can be a bit clunky and complex.
  • Watch out for their audit department. They will hunt down development environments that are in use and try to back charge you for their repositories. Ensure your development environments are properly licensed.
We are considering their PowerCenter Advanced version which will add metadata and business glossary capabilities.
  • Informatica allows us to achieve complex data integration among our systems and into our data warehouse environment. Without this tool in place, hours of manual manipulation would occur to integrate this data and extract it into the appropriate DW solution.
Our team enjoys using Informatica and feels that it is one of the best ETL tools on the market.
Return to navigation