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

The data integration leader

Rating: 8 out of 10
November 19, 2019
IncentivizedVetted ReviewVerified User
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, star...
Continue reading
Verified user
Engineer
Informatica PowerCenter10 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

PowerCenter outpowers the cloud version

Rating: 9 out of 10
March 8, 2019
IncentivizedVetted ReviewVerified User
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 to...
Continue reading
Verified user
Manager
Informatica PowerCenter2 years of experience

Informatica PowerCenter, an Enterprise ETL Tool

Rating: 10 out of 10
December 19, 2018
IncentivizedVetted ReviewVerified User
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 ...
Continue reading
Verified user
Director
Informatica PowerCenter16 years 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

Sheer Performance (but not for MacOS!)

Rating: 8 out of 10
April 18, 2018
IncentivizedVetted ReviewVerified User
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, righ...
Continue reading
Verified user
Engineer
Informatica PowerCenter1 year of experience

Licensing flexibility and skills availability in the market

Rating: 9 out of 10
March 6, 2018
IncentivizedVetted ReviewVerified User
Predominantly by the IT dept. It addresses enterprise data integration challenges, integrates with enterprise service bus for data movements
Continue reading
Verified user
Consultant
Informatica PowerCenter6 years of experience

Informatica Review

Rating: 8 out of 10
April 12, 2017
IncentivizedVetted ReviewVerified User
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 source...
Continue reading
Brandon Fitzpatrick
Employee - Information Technology
Developer
IntelliCog
Informatica PowerCenter4 years of experience

Good ETL Platform

Rating: 8 out of 10
April 6, 2017
IncentivizedVetted ReviewVerified User
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 ...
Continue reading
Verified user
Employee
Informatica PowerCenter4 years of experience

PowerCenter works well with large, structured data files

Rating: 6 out of 10
March 31, 2017
IncentivizedVetted ReviewVerified User
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 dat...
Continue reading
Verified user
Engineer
Informatica PowerCenter2 years of experience

My personal view of Informatica Enterprise Data Integration tools based on my 10+ years of user experiences.

Rating: 10 out of 10
March 9, 2017
IncentivizedVetted ReviewVerified User
Informatica enterprise data integration tools have been used in my company across different departments for enterprise data warehouses, data marts, data movements etc. It addr...
Continue reading
Luoming Hou
Engineer - Information Technology
Sr. ETL Analyst and Admin
Costco Wholesale
Informatica PowerCenter14 years of experience

Day to day user's opinion of PowerCenter

Rating: 9 out of 10
August 3, 2016
IncentivizedVetted ReviewVerified User
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 proces...
Continue reading
Verified user
Professional
Informatica PowerCenter3 years of experience
Log in with LinkedIn to see content from your network

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

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?

98 people also want pricing

Alternatives Pricing

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.

Vertify

Vertify

$7,350
per year
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.3

Data Transformations

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

7.5
Avg 8.2

Data Modeling

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

8.2
Avg 8.1

Data Governance

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

9
Avg 8.3
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

(94)

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.

Reviews

(1-21 of 21)
Companies can't remove reviews or game the system. Here's why

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
Use Cases and Deployment Scope
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.
Pros and Cons
  • 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
Likelihood to Recommend
1.- Scenaries with poor sources of data is not recomended (Very bad ROI). The solution is for medium-big enterprises with a lot of sources of data and users.
2.- Bank and finance enviroment to integrate differente data form trading, Regulatory reports, decisions makers, fraud and financial crimes because in this kind of scenary the quality of data is the base of the business.
3.- Departments of development and test of applications in enterprises because you can design enviroments, out of the production systems, to development and test the new API's or updateds made.

Old yet powerful ETL Tool

Rating: 8 out of 10
Incentivized
May 31, 2021
Verified User
Vetted Review
Verified User
Informatica PowerCenter
7 years of experience
Use Cases and Deployment Scope
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.
Pros and Cons
  • 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.
Likelihood to Recommend
Informatica Powercenter is the centerpiece of our overall enterprise data warehouse strategy. It's a critical enablement to ensure we can feed in multiple data stream and transform them into digestible data within our data warehouse. With its flexible capabilities and API availability, we were able to feed in industry standard data format as well as home grown data structure. Overall, we are very pleased with their capability and contribution to our data warehouse strategy.

Amazing ETL Tool

Rating: 9 out of 10
December 01, 2020
Verified User
Vetted Review
Verified User
Informatica PowerCenter
4 years of experience
Use Cases and Deployment Scope
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.
Pros and Cons
  • 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.
Likelihood to Recommend
This is an amazing tool to handle large data in multiple batches. Also, this is best suited if you have data in different data sources but if you are looking for a tool to use with single data source then there are multiple tools available in the market which are comparatively cheaper.

The data integration leader

Rating: 8 out of 10
Incentivized
November 19, 2019
Verified User
Vetted Review
Verified User
Informatica PowerCenter
10 years of experience
Use Cases and Deployment Scope
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.
Pros and Cons
  • Data integration - Informatica has always been a leader in the data integration space. The company has maintained its position by innovative solutions, keeping pace with technology development, providing connectors to most of the common platforms, and improving on services with time. It has the ability to integrate data from multi-cloud, hybrid, on-premise infrastructure setup. The data integration can happen in batch or in real time. The performance of Informatica data integration is among the best in class.
  • Data migration - Informatica is widely used as a data migration tool. Lots of enterprises run their software on legacy infrastructure and at some point run into limitations associated with them. The large databases they use at that time make it extremely difficult to switch to the latest infrastructure and have a list of challenges. Informatica is great at addressing these challenges. It allows developers to create rule-based workflows that can be used to migrate any amount of data from old to the new infrastructure. Since Informatica is so successful at this, there is always use cases for reference and trained resources for executing a project.
  • Application Integration - The corporate world is full of mergers and acquisitions which lead to one company's IT assets being moved/merged to another one. This requires a huge amount of work to homogenize the two systems so they can co-exist without breaking each other. Informatica is great at building pipelines to integrate many disparate applications.
  • Data warehousing - Informatica is very commonly used for building data warehouse systems to fulfill the needs of enterprises and data marts to service requirements of individual requirements. This helps organizations' ability to use data sets for driving decision making. For example, Sales teams can decide how their previous sales efforts have performed in various geographies by analyzing the data warehouse data for sales.
Likelihood to Recommend
Informatica PowerCenter, being a very mature technology leader, is well suited for large data integration projects where many different data sources exist and multiple departments need to use the data. In such cases, it is best to use a tool like power center to create a data warehouse and datamarts. These organizations usually can have in-house Informatica admins that can take care of software maintenance, contribute to performance improvement, troubleshooting, etc. They are also looking for a long term solution rather than a quick fix for data access issues. The tool may not be well suited for smaller organizations that tend to be more nimble and prefer more flexibility in building their technology landscape rather than being tied to a single tool that may define their overall data warehousing strategies. This also means that organizations do not have to maintain large software and employ dedicated people for doing that.

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
Use Cases and Deployment Scope
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.
Pros and Cons
  • Transformation speed.
  • Supports a multi-User development environment.
  • A fast learning curve.
Likelihood to Recommend
If you have many developers who will use Informatica Power Center for more than 80% of their work, multi-user development will reduce your administration effort with less chance of losing code.
When data is loaded to the Informatica Application Server, transformations perform very fast. It also supports push down ETL if your ETL mappings are simple or have average complexity.

PowerCenter outpowers the cloud version

Rating: 9 out of 10
Incentivized
March 08, 2019
Verified User
Vetted Review
Verified User
Informatica PowerCenter
2 years of experience
Use Cases and Deployment Scope
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.
Pros and Cons
  • The number of connectors, and the coverage for all the possibilities, are excellent, giving us the comfort that we won’t have to build anything custom.
  • The flow visualizations are very nice, as we often have to go in and forensically review work done by others who are no longer with the company. This helps us accurately identify source data.
  • The alert system is a great feature I think is often underutilized. We’ve been able to set up a great communication tree of notifications when a job fails, saving our DBA’s a lot of time sending out emergency communications.
Likelihood to Recommend
I think anything where you need to shuttle data in/out of one complex system and into another is a great fit for PowerCenter (on prem). The “Upsert” function of updating and inserting has saved us countless dollars in storage space and the in/out transfer of data to the cloud, so if you are pulling data out of your on-prem systems and moving it to the cloud, this is the tool for you. Coupled with a good Data Warehouse or Data Lake strategy, you can be ELT instead of ETL, as well. Makes feeding your BI Tools fast and easy.

Informatica PowerCenter, an Enterprise ETL Tool

Rating: 10 out of 10
Incentivized
December 19, 2018
Verified User
Vetted Review
Verified User
Informatica PowerCenter
16 years of experience
Use Cases and Deployment Scope
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.
Pros and Cons
  • Informatica is a proven enterprise ETL tool that scales and provides a graphical interface to code your data mappings.
  • Reading, Transforming and Loading Data to and from databases.
  • Process incoming data such as messages in real-time.
Likelihood to Recommend
Informatica PowerCenter is great for creating data marts or data warehouses in star schema.

Informatica PowerCenter doesn't provide native capabilities for data cleansing, such as USPS zip code validation. You must code this manually.

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
Use Cases and Deployment Scope
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.
Pros and Cons
  • 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.
Likelihood to Recommend
PowerCenter is well equipped to handle large amounts of data movement in an organization with many disparate sources and a structured development team. It excels in enforcing enterprise development standards through things like metadata manager and the monitoring capabilities (as well as being able to design monitoring rules for everything from naming standards to design practices). It is especially well suited at handling flat-file data in addition to its many connectors and native support for just about any ANSI standard database. For large development teams or the desire to remain flexible at an enterprise scale, Powercenter is a top-tier solution.

For small projects or even smaller development teams with mostly a single data source, expect frustration with being able to quickly test a solution as the design flow is very structured. It is also designed in a way that segregation of duties at a very high level can also cause small development teams to be counter-productive. Each step in the design process is a separate application, and although stitched together, is not without its problems. In order to design a simple mapping for example, you would first need a connection established to the source (example, ODBC) and keep in mind that it will automatically name the container according to how you named your connection. You would then open the designer tool, import a connection as a source, optionally check it in, create a target, optionally check it in as well, and design a transformation mapping. In order to test or run it, you will need to open a separate application (Workflow Manager) and create a workflow from your mapping, then create a session for that workflow and a workflow for those one or more sessions at which point you can test it. After running it, in order to observe, you then need to open a separate application (Monitor) to see what it is doing and how well. For a developer coming from something like SSIS, this can be daunting and cumbersome for building a simple POC and trying to test it (although from the inverse, building an enterprise scalable ETL solution from SSIS is its own challenge).

Sheer Performance (but not for MacOS!)

Rating: 8 out of 10
Incentivized
April 18, 2018
Verified User
Vetted Review
Verified User
Informatica PowerCenter
1 year of experience
Use Cases and Deployment Scope
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.
Pros and Cons
  • 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.
Likelihood to Recommend
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.

Licensing flexibility and skills availability in the market

Rating: 9 out of 10
Incentivized
March 06, 2018
Verified User
Vetted Review
Verified User
Informatica PowerCenter
6 years of experience
Use Cases and Deployment Scope
Predominantly by the IT dept. It addresses enterprise data integration challenges, integrates with enterprise service bus for data movements
Pros and Cons
  • Multi platform connectivity, including Hadoop and Cloud providers
  • Deployment and Licensing flexibility
  • Pricing
  • Skills availability in the market
Likelihood to Recommend
Well suited when there are more diverse source platforms, and there's a need for integrating data movements across enterprise bus

Informatica Review

Rating: 8 out of 10
Incentivized
April 12, 2017
Use Cases and Deployment Scope
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.
Pros and Cons
  • Shared objects allow transformations, sources, and targets to be reused.
  • Mapplets allow for blocks of transformations to be reused.
  • Field by field transformations.
  • Union and join a variety of data sources.
Likelihood to Recommend
Great for ETL especially when sourcing from various sources. Also handy when field by field or row by row transformations are needed. It may be less suited where quick bulk changes can be done.

Good ETL Platform

Rating: 8 out of 10
Incentivized
April 06, 2017
Verified User
Vetted Review
Verified User
Informatica PowerCenter
4 years of experience
Use Cases and Deployment Scope
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.
Pros and Cons
  • It is quite flexible to handle different type of data formats like DB objects or Tables
  • Good performance when processing lots of data in batch
  • Easy to learn and use
Likelihood to Recommend
DB level or flat file for reporting or analysis

PowerCenter works well with large, structured data files

Rating: 6 out of 10
Incentivized
March 31, 2017
Verified User
Vetted Review
Verified User
Informatica PowerCenter
2 years of experience
Use Cases and Deployment Scope
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.
Pros and Cons
  • PowerCenter processes input files, performs specified transformations, and maps the input data format to the output data format very quickly. The PowerCenter backend implementation seems to be optimized to process and map structured input records to structured output records and load the records into a database. One of the strengths of PowerCenter is performance of processing petabytes of structured input data files.
  • PowerCenter does not require a software development experience or education. After providing initial hands-on training, the data consultants (who are statisticians, subject matter experts) in our organization were able to implement data ingest and data transformation tasks fairly easily.
  • PowerCenter supports multiple DBMS technologies (for example, Oracle, Netezza). This flexibility allows it to be used by multiple departments within our organization.
Likelihood to Recommend

PowerCenter is well suited for processing of large amounts of data that is structured and pre-defined. It is well-suited for large organizations that have the resources to install, configure and support PowerCenter. It is well suited for large organizations that have a large number of data consultants/analysts that do not have a software development/programming background.

PowerCenter is not a good fit for smaller, agile organizations that work with unstructured data and changing/dynamic data.

My personal view of Informatica Enterprise Data Integration tools based on my 10+ years of user experiences.

Rating: 10 out of 10
Incentivized
March 09, 2017
LH
Luoming Hou
Sr. ETL Analyst and Admin
Costco Wholesale (Wholesale, 10,001+ employees)
Vetted Review
Verified User
Informatica PowerCenter
14 years of experience
View profile
Use Cases and Deployment Scope
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.
Pros and Cons
  • Informatica Power Center tools are very effective on extracting, transforming and loading bulk data such as hundreds of millions of database rows or raw data flat files, XML files etc., out of or into all kinds of platforms such as databases (Oracle, DB2, SQL server, MySQL, any database that you can name it), OS (UNIX, Linux, Windows), web services, and real time such as IBM MQ.
  • A single toolset to be used for all kinds of platforms, for bulk data loads, for real-time loads, or web services.
Likelihood to Recommend
Informatica Enterprise data integration tools are well suited in extracting/loading/transforming large amounts of data as batch loads. It can also be easily integrated with Hadoop on big data applications. But its real-time integration with MQ or Tibco may be a little overlapped with them for the functionalities.

Day to day user's opinion of PowerCenter

Rating: 9 out of 10
Incentivized
August 03, 2016
Verified User
Vetted Review
Verified User
Informatica PowerCenter
3 years of experience
Use Cases and Deployment Scope
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.
Pros and Cons
  • The tool is excellent at pulling data from source systems, modifying it to fit a target system, and then pushing the data accordingly.
  • It handles conversion of datatypes very well
  • PowerCenter is very adapt at applying data filters and 'business rules' to source data before pushing the results to the end user.
Likelihood to Recommend
PowerCenter is the top of the line tool for migrating data from one source to another. It excels at filtering and modifying data before deploying it into a target environment, usually for end user use.

However, if you are looking for a tool to simply look at data from one source, there are other products out there. This is really designed for aggregating data and filtering/manipulating it into useful information.

PowerCenter for ETL

Rating: 8 out of 10
Incentivized
May 21, 2016
SK
Sadu Kurahatti
Sr Consultant
Sevatec, Inc. (Information Technology and Services, 201-500 employees)
Vetted Review
Verified User
Informatica PowerCenter
13 years of experience
View profile
Use Cases and Deployment Scope
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.
Pros and Cons
  • 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.
Likelihood to Recommend
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.

One stop for all ETL needs

Rating: 8 out of 10
Incentivized
February 29, 2016
Verified User
Vetted Review
Verified User
Informatica PowerCenter
8 years of experience
Use Cases and Deployment Scope
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.
Pros and Cons
  • Ability to work with different types of sources and targets.
  • Version control of the code.
  • Ability to integrate with LDAP for security.
  • Ease of use.
Likelihood to Recommend
In scenarios where we have to integrate data from heterogeneous sources into targets PowerCenter is the best tool as it can extract as well as load data by using native drivers of each of the different databases with a performance that is not matched by any of its competitors. By bringing power exchange, data quality, metadata management and data discovery under one instance, Informatica has simplified PowerCenter integration with above mentioned tools as well as maintenance of the instance.

PowerCenter is a Industry Leading integration tool

Rating: 8 out of 10
Incentivized
October 30, 2015
BR
Brian Randolph
Data Integration Data Quality Specialist
CARFAX (Information Services, 501-1000 employees)
Vetted Review
Verified User
Informatica PowerCenter
12 years of experience
View profile
Use Cases and Deployment Scope
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.
Pros and Cons
  • PowerCenter connects to multiple sources and targets with ease, and at the same time.
  • PowerCenter allows the application of complicated business rule logic with ease through a user friendly interface.
  • PowerCenter logic can be captured and shared in mapplets, enabling reusability.
Likelihood to Recommend
PowerCenter is by far the industry leader when it comes to extract, transform and load applications. The ability to access a multitude of data sources and targets makes the product versatile. And the graphic user interface makes it easy to learn and use the tool with limited knowledge. Even business users can understand the mappings and logic applied.

Integration with Informatica

Rating: 9 out of 10
April 02, 2014
hM
hai Mani
Senior informatica developer
L'Oréal (Cosmetics, 10,001+ employees)
Vetted Review
Verified User
Informatica PowerCenter
9 years of experience
Use Cases and Deployment Scope
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.
Pros and Cons
  • 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
Likelihood to Recommend
Scalability
Modularity
Backward Compatability.
Easy Upgrade.
Support from Vendor

Informatica - Review at a glance

Rating: 9 out of 10
March 20, 2014
Verified User
Vetted Review
Verified User
Informatica PowerCenter
8 years of experience
Use Cases and Deployment Scope
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.
Pros and Cons
  • 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
Likelihood to Recommend
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.

A Powerful ETL Tool in Informatica PowerCenter

Rating: 8 out of 10
October 09, 2013
RG
Robert Goodman
Director, Business Intelligence & Analytics
Georgetown University (Higher Education, 5001-10,000 employees)
Vetted Review
Verified User
Informatica PowerCenter
11 years of experience
Pros and Cons
  • 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.
Likelihood to Recommend
We are considering their PowerCenter Advanced version which will add metadata and business glossary capabilities.
Return to navigation