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

Learn from top reviewers

Informatica PowerExchange Connectors: the data with quality and reliability for the enterprise

Rating: 8 out of 10
May 3, 2022
IncentivizedVetted ReviewVerified User
Informatica PowerExchange Connectors provide access to different sources of data in multiple locations, differente RDB systems and DATA WAREHOUSE environments in the mode SaaS...
Continue reading
Jaime Maña
Consultant - Professional Services
Business Developer / Advisor EDM
Freelance
Informatica PowerCenter4 years of experience

Old yet powerful ETL Tool

Rating: 8 out of 10
May 31, 2021
IncentivizedVetted ReviewVerified User
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 un...
Continue reading
Verified user
Engineer
Informatica PowerCenter7 years of experience

Amazing ETL Tool

Rating: 9 out of 10
December 1, 2020
Vetted ReviewVerified 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 ...
Continue reading
Verified user
Employee
Informatica PowerCenter4 years of experience

Informatica Power Center review

Rating: 9 out of 10
April 12, 2019
IncentivizedVetted ReviewVerified User
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/...
Continue reading
Gurcan Orhan
Manager - Other
Data Quality Management Software Development Manager
Yapı Kredi
Informatica PowerCenter1 year of experience

A powerful ETL solution which focuses on enterprise scalability, flexibility, and code re-usability

Rating: 7 out of 10
December 10, 2018
IncentivizedVetted ReviewVerified User
Informatica PowerCenter is the enterprise ETL tool used for all data integration across the organization. PowerCenter is utilized for all on premises data integration includin...
Continue reading
Jody Gitchel
Engineer - Information Technology
Senior Data Solutions Architect
Laser Spine Institute
Informatica PowerCenter5 years of experience
Log in with LinkedIn to see content from your network
Return to navigation

Pricing

View all pricing
Informatica PowerCenter

Informatica PowerCenter

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?

100 people also want pricing

Alternatives Pricing

Dataloader.io

Dataloader.io

$99
per month
What is Dataloader.io?

Dataloader.io delivers a cloud based solution to import and export information from Salesforce.

Clear Analytics

Clear Analytics

$29
Per Seat per Month
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.

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

Data Transformations

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

7.5
Avg 8.1

Data Modeling

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

8.2
Avg 7.9

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 From Top Reviewers

View all reviews
(1-5 of 21)

Informatica PowerExchange Connectors: the data with quality and reliability for the enterprise

Rating: 8 out of 10
Incentivized
May 03, 2022
JM
Jaime Maña
Business Developer / Advisor EDM
Freelance (Capital Markets, 1001-5000 employees)
Vetted Review
Verified User
Informatica PowerCenter
4 years of experience
View profile
Pros
  • Access to different RDB, API's Data (External / Internal)
  • The connectors access to data from social networks such as Twitter or LinkedIn
  • Connectors provide access to data in AS400 systems with a minimun development of interface
  • The dashboard is is completely customizable
  • for any organization
Cons
  • Define customer business rulers to put the data in the repository with easy develpoment.
  • Quickly transfer and integrate data between cloud and local RDB/SYSTEMS
  • Very simple to navigate between data before and after integration/transformation was made

Informatica Power Center review

Rating: 9 out of 10
Incentivized
April 12, 2019
GO
Gurcan Orhan
Data Quality Management Software Development Manager
Yapı Kredi (Information Technology and Services, 10,001+ employees)
Vetted Review
Verified User
Informatica PowerCenter
1 year of experience
View profile
Pros
  • Transformation speed.
  • Supports a multi-User development environment.
  • A fast learning curve.
Cons
  • It needs additional hardware.
  • Lots of windows sometimes reduce your focus.
  • It would be better to have a more compact design with the ability to aim toward specific topics.

A powerful ETL solution which focuses on enterprise scalability, flexibility, and code re-usability

Rating: 7 out of 10
Incentivized
December 10, 2018
JG
Jody Gitchel
Senior Data Solutions Architect
Laser Spine Institute (Hospital & Health Care, 501-1000 employees)
Vetted Review
Verified User
Informatica PowerCenter
5 years of experience
View profile
Pros
  • Enforces enterprise wide ETL development standards.
  • Provides code re-usability with shared connections and objects.
  • Particularly adept at integrating a wide range of disparate data sources (handles flat files particularly well).
  • Well suited for moving large amounts of data.
Cons
  • There are too many ways to perform the same or similar functions which in turn makes it challenging to trace what a workflow is doing and at which point (ex. sessions can be designed as static or re-usable and the override can occur at the session or workflow, or both which can be counter productive and confusing when troubleshooting).
  • The power in structured design is a double edged sword. Simple tasks for a POC can become cumbersome. Ex. if you want to move some data to test a process, you first have to create your sources by importing them which means an ODBC connection or similar will need to be configured, you in turn have to develop your targets and all of the essential building blocks before being able to begin actual development. While I am on sources and targets, I think of a table definition as just that and find it counter intuitive to have to design a table as both a source and target and manage them as different objects. It would be more intuitive to have a table definition and its source/target properties defined by where you drag and drop it in the mapping.
  • There are no checkpoints or data viewer type functions without designing an entire mapping and workflow. If you would like to simply run a job up to a point and check the throughput, an entire mapping needs to be completed and you would workaround this by creating a flat file target.

Old yet powerful ETL Tool

Rating: 8 out of 10
Incentivized
May 31, 2021
Verified User
Engineer in Engineering
Internet Company, 5001-10,000 employees
Vetted Review
Verified User
Informatica PowerCenter
7 years of experience
Pros
  • Informatica Powercenter is an innovative software that works with ETL-type data integration. Connectivity to almost all the database systems.
  • Great documentation and customer support.
  • It has a various solution to address data quality issues. data masking, data virtualization. It has various supporting tools or MDM, IDQ, Analyst, BigData which can be used to analyze data and correct it.
Cons
  • It doesn't have much scheduling options and the tool is not very much capable if we schedule more jobs.
  • Debugging the workflows and mappings are very hard with Informatica PowerCenter.
  • Lookup transformation on large tables consumes more Memory and CPU.

Amazing ETL Tool

Rating: 9 out of 10
December 01, 2020
Verified User
Employee in Information Technology
Banking Company, 10,001+ employees
Vetted Review
Verified User
Informatica PowerCenter
4 years of experience
Pros
  • Extracting, transforming and loading data to and from different databases.
  • Development, testing and maintenance of code is fairly simple.
  • Good performance even during processing of large amount of data.
  • Amazing ability to connect with different types of sources and targets available in the market.
Cons
  • Performance with ODBC drivers is comparatively slow which ends up in taking a lot of time.
  • Deployment is bit complex.
  • Clobs and Blobs datatypes are very difficult to handle.
Return to navigation