Informatica ETL & Data Integration
On this page we show a rough outline of our recently updated, independent ETL & Data Integration study of the software vendor Informatica and its product range (such as Informatica PowerCenter, Informatica Intelligent Cloud Services and Powerexchange). Informatica ETL & Data Integration scores better in our comprehensive research than Microsoft but slightly worse than SAS. Informatica is the strongest in data connectivity and comes out the least strong in the category master data management. Within the context of ETL & Data Integration, we have researched the pros and cons of Informatica Data Integration, and listed them by theme (data integration, ETL, data replication and Data quality). We also display the distinguishing features of the most popular products like Informatica PowerCenter, Informatica Intelligent Cloud Services and Powerexchange et cetera.
- Fully independent investigation
- Informatica compared based on more than 250 criteria
- Can be found in more than 100 countries
Independent information about Informatica PowerCenter, Informatica Intelligent Cloud Services and Powerexchange
How does Informatica ETL & Data Integration perform on certain components?
Figure 1: Scorecard of the Data Integration provider Informatica. You can get a maximum score of 100 percent. Reference: the ETL & Data Integration Guide 2023. Do you need more clarification about the research justification? Check out our buyers guide for ETL & Data Integration.
In our study we also inspected the various software products of Informatica software. We evaluated Informatica ETL & Data Integration on no less than 290 criteria. The figure to the right gives good insight into the strengths and weaknesses of Informatica Data Integration. Please note that Passionned Group is 100% independent of the software vendors in our research. We do not sell software licenses, we do not make deals or have done business with the supplier. Among other things, we help and advise organizations in selecting the right ETL & Data Integration platform.
The Informatica analysis was conducted by tapping into a lot of public big data and from there it was scrutinized in detail. More than 2,470 documents were analyzed for this vendor. In this analysis process both algorithms and the critical eye of a senior Data Integration expert played a decisive role in validating the results.
In our 100% vendor-neutral ETL & Data Integration Guide we have researched all the ins and outs of Informatica ETL & Data Integration for you. You will get access to many (short) courses, tutorials, tech talks, lectures, demos, and so on and always have the latest ETL & Data Integration news at your fingertips. In addition, this guide helps you in reinforcing your expertise in ETL & Data Integration. Download now.
Informatica and their complete ETL & Data Integration product portfolio
The vendor Informatica has (a minimum of) 21 products in the field of ETL & Data Integration. Starting with the most popular product of Informatica ETL & Data Integration we list the most important products below:
What is Informatica Data Integration?
In this paragraph, we describe Informatica Data Integration, including some of its features and any related products. This product group consists of Informatica PowerCenter, Informatica Intelligent Cloud Services, Powerexchange, Informatica Big Data, Informatica Data Quality, Informatica Master Data Management, Informatica Cloud Data Integration, Informatica Data Replication, Informatica Cloud Data Replication, Informatica Cloud Data Profiling, Informatica Mass Ingestion and Informatica Data Quality Platform. This product / group of products can be best characterized by the following features:
- data integration > cloud data integration
- data integration > data integration hub
- data management
- data integration > data integration job
- data quality management > data quality
- data infrastructure > API
- data integration > ETL
- data management > data sources
- data management > big data management > data lakes
Are you now curious about all the functionalities (100+) of Informatica Data Integration? Download the ETL & Data Integration Guide™ 2023 here.
Are you considering hiring a knowledgeable Informatica Data Integration specialist?
Are you looking for an interim Informatica Data Integration consultant who can help you get started and can help you to implement an Informatica Data Integration application? Or do you want to develop an application for one of the related products like Informatica Cloud Data Integration, Informatica Intelligent Cloud Services, Powercenter, IICS, Informatica Data Quality, Informatica PowerCenter and Powerexchange? You can do so using our interim services. Indeed, hiring Informatica Data Integration developers is not always necessary and sometimes even inconvenient. Drop a message here and we’ll get back to you quickly.
What is Informatica PowerCenter?
This product is also known as: Powercenter
In this section, we give you insight in the key behaviors of Informatica PowerCenter, including some of its features and any related products. This product group consists of Powercenter Big Data, Powercenter Data Virtualization, Powercenter Data Integration, Informatica PowerCenter Data Profiling and Informatica PowerCenter Data Quality. The product Informatica PowerCenter can be best defined by the following properties:
- data integration
- data management
- data integration > data warehouse
- data connectivity > AWS
- data infrastructure > API
- data infrastructure > rest API
- data management > CDC
- data connectivity > hadoop
- data infrastructure > cloud platforms
- metadata management > metadata
Do you want to know everything about all elements (100+) of Informatica PowerCenter? Then order the ETL & Data Integration Guide™ 2023 here.
What is Powercenter Big Data?
We do not display here all the features but, in this paragraph, we provide a description of Powercenter Big Data, including some of its features and any related products. This product / group of products can be defined by the following functionalities:
- data management > big data management > big data
- data connectivity > hadoop
- data management
- data integration
- data management > big data management
- metadata management > data catalog
- metadata management > enterprise data catalog
- data quality management > data profiling
- metadata management > metadata
- data management > data sources
Are you curious about all the functions (100+) of Powercenter Big Data? Download the ETL & Data Integration Guide™ 2023 here.
What is Powercenter Data Virtualization?
In this paragraph, we provide a description of Powercenter Data Virtualization, including some of its features and any related products. This product / group of products can be defined by the following characteristics:
- metadata management > business glossary
- data infrastructure > data virtualization
- data management > real time
- data integration
- metadata management > metadata
- data connectivity > PDF
- data infrastructure
- data management
- data integration > ETL
- data connectivity > XML
Are you curious about all features (100+) of Powercenter Data Virtualization? Open the ETL & Data Integration Guide™ 2023 here.
What is Powercenter Data Integration?
In this paragraph, we provide a description of Powercenter Data Integration, including some of its features and any related products. This product / group of products can be best characterized by the following properties:
- data integration > data integration hub
- data integration > ETL > target table
- data infrastructure > API
- metadata management > data catalog
- data integration > data warehouse
- data integration > ETL > bulk processing > bulk loading
- data management
- data infrastructure > operating system > windows
- data connectivity > ABAP
Do you want to know everything about all properties (100+) of Powercenter Data Integration? Then download our ETL & Data Integration Guide™ 2023 here.
What is Informatica PowerCenter Data Profiling?
This product is also known as: Powercenter Data Profiling
In this paragraph, we provide a description of Informatica PowerCenter Data Profiling, including some of its features and any related products. This product / group of products can be best defined by the following features:
- data quality management > data quality
- data governance
- data quality management > data profiling
Are you curious about all the functions (100+) of Informatica PowerCenter Data Profiling? Open the ETL & Data Integration Guide™ 2023 here.
What is Informatica PowerCenter Data Quality?
This product is also known as: Powercenter Data Quality
In this paragraph, we describe Informatica PowerCenter Data Quality, including some of its features and any related products. This product can be defined by the following properties:
- data quality management > data quality
- master data management
- data connectivity > XML
- data quality management > data quality rules
- master data management > master data
- data management
- data integration
- data quality management > data cleansing
- data governance
- metadata management > data lineage
Are you curious about all the functionalities (100+) of Informatica PowerCenter Data Quality? Download the ETL & Data Integration Guide™ 2023 here.
What is Informatica Intelligent Cloud Services?
This product is also known as: IICS
In this section, we provide a description of Informatica Intelligent Cloud Services, including some of its features and any related products. This product / group of products can be best characterized by the following properties:
- data integration
- data management
- data infrastructure > API
- data integration > cloud data integration
- data connectivity > salesforce
- data infrastructure > rest API
- data integration > data warehouse > snowflake
- data integration > data integration hub
- data quality management > data quality
- data infrastructure > security
Are you curious about all the functions (100+) of Informatica Intelligent Cloud Services? Then order the ETL & Data Integration Guide™ 2023 here.
What is Powerexchange?
In this paragraph, we provide a description of Powerexchange, including some of its features and any related products. The product Powerexchange can be best characterized by the following functionalities:
- data management > CDC
- data management > data sources
- data infrastructure > operating system > linux
- data connectivity > ODBC
- data infrastructure > operating system > windows
- data integration > data warehouse > snowflake
- data infrastructure > security
- data infrastructure > operating system > UNIX
- data connectivity > salesforce
- data integration > ETL > SQL
Are you curious about all the functions (100+) of Powerexchange? Then download our ETL & Data Integration Guide™ 2023 here.
What is Informatica Big Data?
In this paragraph, we provide a description of Informatica Big Data, including some of its features and any related products. This product group consists of Informatica Big Data Management, Informatica Big Data Parser and Informatica Big Data Integration. Informatica Big Data can be characterized by the following features:
- data management > big data management > big data
- data management > big data management
- data quality management > data quality
- master data management
- data integration
- data infrastructure > security
- data management > big data management > data lakes
- data management > big data management > big data streaming
- data governance
Do you want to know the intricacies of all features (100+) of Informatica Big Data? Download the ETL & Data Integration Guide™ 2023 here.
What is Informatica Big Data Management?
In this paragraph, we provide a description of Informatica Big Data Management, including some of its features and any related products. This product can be characterized by the following characteristics:
- data management > big data management > big data
- data management > big data management
- data integration
- data connectivity > hadoop
- data management > big data management > data lakes
- master data management
- data quality management > data quality
- metadata management > data catalog
- metadata management > enterprise data catalog
Are you now curious about all the functionalities (100+) of Informatica Big Data Management? Then download our ETL & Data Integration Guide™ 2023 here.
What is Informatica Big Data Parser?
In this paragraph, we describe the key elements of Informatica Big Data Parser, including some of its features and any related products. This product can be characterized by the following features:
- data management > big data management > big data
- data connectivity > hadoop
- data management > big data management
- data management > data pipelines
- data connectivity > AWS
Are you curious about all properties (100+) of Informatica Big Data Parser? Then download our ETL & Data Integration Guide™ 2023 here.
What is Informatica Big Data Integration?
We do not display here all the features but, in this paragraph, we provide a description of Informatica Big Data Integration, including some of its features and any related products. This product can be characterized by the following features:
- data management > big data management > big data
- data integration
- data management > data pipelines
- data management > big data management > big data integration
- data infrastructure > open source
- data integration > data integration platform
- data integration > cloud data integration
- metadata management > data catalog
Do you want to know everything about all the functionalities (100+) of Informatica Big Data Integration? Then download our ETL & Data Integration Guide™ 2023 here.
What is Informatica Data Quality?
In this paragraph, we describe Informatica Data Quality, including some of its features and any related products. This product / group of products can be defined by the following features:
- data quality management > data quality
- data integration
- data connectivity > AWS
- data management
- data infrastructure > SDK
- data infrastructure > security
- metadata management > data catalog
- data integration > data warehouse
- data quality management > data profiling
- data quality management
Do you want to know the intricacies of all the functionalities (100+) of Informatica Data Quality? Then download our ETL & Data Integration Guide™ 2023 here.
What is Informatica Master Data Management?
This product is also known as: Informatica MDM
In this section, we portrait Informatica Master Data Management, including some of its features and any related products. The Informatica Master Data Management can be characterized by the following features:
- master data management > master data
- data management
- data governance
- data management > data sources
- master data management > MDG
- data infrastructure > security
- metadata management > metadata
- data management > data migration
- data integration
Do you want to know the intricacies of all the functionalities (100+) of Informatica Master Data Management? In that case order the ETL & Data Integration Guide™ 2023 here.
What is Informatica Cloud Data Integration?
Under this heading, we give you insight in the key behaviors of Informatica Cloud Data Integration, including some of its features and any related products. The Informatica Cloud Data Integration can be best defined by the following characteristics:
- data integration > cloud data integration
- data management
- data integration > ETL > ELT
- data infrastructure > API
- data connectivity > SOQL
- data integration > data warehouse
- data connectivity > AWS
- data quality management > data quality
Are you curious about all the functionalities (100+) of Informatica Cloud Data Integration? Download directly our ETL & Data Integration Guide™ 2023 here.
What is Informatica Data Replication?
We do not display here all the features but, in this paragraph, we describe the key elements of Informatica Data Replication, including some of its features and any related products. The product Informatica Data Replication can be best characterized by the following functionalities:
- data replication
- data integration
- data connectivity > ODBC
- data connectivity > sybase
- data integration > ETL > SQL
- data replication > data replication tasks
- data integration > ETL
- data connectivity > JAR
- data replication > data replication task
- data connectivity > salesforce
Do you want to know everything about all elements (100+) of Informatica Data Replication? Then order the ETL & Data Integration Guide™ 2023 here.
What is Informatica Cloud Data Replication?
We do not display here all the features but, in this paragraph, we give you insight in the key behaviors of Informatica Cloud Data Replication, including some of its features and any related products. This product / group of products can be characterized by the following functionalities:
- data replication
- data connectivity > salesforce
- data management
- data replication > data replication tasks
- data integration > cloud data integration
- data management > big data management
- data integration > ETL > SQL
- data integration > data warehouse > snowflake
- data infrastructure > API
Do you want to know everything about all characteristics (100+) of Informatica Cloud Data Replication? Download the ETL & Data Integration Guide™ 2023 here.
What is Informatica Cloud Data Profiling?
We do not display here all the features but, in this paragraph, we provide a description of Informatica Cloud Data Profiling, including some of its features and any related products. The Informatica Cloud Data Profiling can be defined by the following characteristics:
- data quality management > data profiling
- data quality management > data quality
- data management > data sources
- data infrastructure > operating system > windows
- data infrastructure > operating system > linux
- data connectivity > AWS
- data integration
- data connectivity > salesforce
- data integration > data warehouse > snowflake
- data infrastructure > security
Are you now curious about all features (100+) of Informatica Cloud Data Profiling? In that case order the ETL & Data Integration Guide™ 2023 here.
What is Informatica Mass Ingestion?
In this paragraph, we report the (main) characteristics of Informatica Mass Ingestion, including some of its features and any related products. This product can be characterized by the following characteristics:
- data integration > data ingestion
- data management > big data management > data lakes
- data management > real time
- data integration > data warehouse
- data integration > ETL > incremental ETL
- data integration > data warehouse > snowflake
- data integration
- data connectivity > CSV
- data management > big data management > big data
- data connectivity > FTPS
Do you want to know everything about all properties (100+) of Informatica Mass Ingestion? In that case order the ETL & Data Integration Guide™ 2023 here.
What is Informatica Data Quality Platform?
Under this heading, we report the (main) characteristics of Informatica Data Quality Platform, including some of its features and any related products. The Informatica Data Quality Platform can be defined by the following characteristics:
- data quality management > data quality
- data integration > ETL
- data quality management
- data integration
- data management > real-time
- metadata management > data catalog
- data management
- data infrastructure > operating system > windows
- data connectivity > PDF
- data quality management > business rules
Are you now curious about all elements (100+) of Informatica Data Quality Platform? Then download our ETL & Data Integration Guide™ 2023 here.
Three recent innovations of Informatica Data Integration-tools and the version history
Recently, we see a stable evolution with respect to ETL & Data Integration functionality and support for operating systems and connectivity. The latest novelties are in the areas of self-service integration > self-service data quality, data infrastructure > microservice > microservices architecture and data infrastructure > enterprise service bus.
We investigated Informatica’s latest updates of its complete ETL & Data Integration proposition. Below we give an overview of the various releases of the various ETL & Data Integration products of Informatica:
- Informatica Big Data Management: 10.2.1
- Informatica Data Integration: 2023 10.1 9.6.1 9.1.0
- Informatica Data Quality: 2023
- Informatica Data Replication: 9.1.1
- Informatica Intelligent Cloud Services: October 2021
- Informatica PowerCenter: 10.5.2 10.5.1 10.5 10.4.1 10.4.0 10.2 hf2 9.6.1
- Powerexchange: 10.5 10.4.1 10.4.0 10.2 10.1 10 9.1
Behind each product we show the version numbers, the most recent updates are listed first.
Can you easily determine the licensing costs of Informatica PowerCenter, Informatica Intelligent Cloud Services and Powerexchange?
In many cases, it can be difficult to determine the licensing costs of Informatica ETL & Data Integration because it depends on the country, the number of users (or the number of CPUs in the case of server software), the connectors to data sources, and at what point in the year you request a quote. If you request a quote just before the end of the fiscal period of Informatica, you can probably get a decent reduction in the license cost. As part of a cloud-first strategy, it makes sense running the software in the cloud. You then only pay for what you actually use in resources. The purchase cost of Informatica PowerCenter, Informatica Intelligent Cloud Services and Powerexchange may not be the most important costs, but maintenance and support do put a strain on your budget each year.
What makes Informatica ETL & Data Integration distinctive
In our study, we see that Informatica in the field of ETL & Data Integration software has a number of specific features and thus differentiates itself from the competition. This makes Informatica Data Integration more or less unique: enterprise data catalog, data integration hub, data quality rules, data transformation and ABAP.
The advantages and disadvantages of Informatica Data Integration
Figure 47: Tag cloud of the pluses and minuses of Informatica ETL & Data Integration
In the following paragraphs, we name all the pros and cons of Informatica ETL & Data Integration, Informatica PowerCenter, Informatica Intelligent Cloud Services and Powerexchange, et cetera. They are not fixed: Informatica wants to gain a better position in the market, and works continuously on improving current functions and adding features that meet specific customer needs.
We value your opinion
Write a review about Informatica ETL & Data Integration here. Your experiences can then be taken into account in an even more informed review of the results of Informatica Data Integration.
1. Informatica Data Connectivity
Informatica has an excellent performance in our study on the subject ‘Data Connectivity’ (for this section Informatica comes out as the absolute market leader in our research) with a score of 100%, compared to other vendors. We looked at the following criteria, among others: hadoop, salesforce, apache, AWS, teradata, amazon redshift and SOAP. In total, we examined 49 criteria within this section. Would you like to go into more depth with the subject ‘Data Connectivity’? Then download here our ETL & Data Integration Guide 2023.
2. Informatica Metadata Management
Informatica has an excellent rating in our 100% vendor-independent ETL & Data Integration survey on the section ‘Metadata Management’ (for this section Informatica comes out as the absolute market leader in our research) with a score of 100%, compared to other vendors. We considered the following factors: metadata, data catalog, data lineage, enterprise data catalog, business glossary, metadata repository and impact analysis. In doing so, we investigated the following products: Informatica PowerCenter. In total, we examined 7 features within this discipline. Would you like to learn more about the subject ‘Metadata Management’? Then download here our ETL & Data Integration Guide 2023. Or learn more about the following topics:
3. Informatica Data Infrastructure
Informatica has an excellent score in our objective ETL & Data Integration survey on the subject ‘Data Infrastructure’, given that they score 97% on this, compared to other vendors. We considered the following factors: security, operating system and interoperability. In doing so, we analyzed the following products: Powercenter Data Virtualization. In total, we examined 87 criteria in this category. Would you like to go into more depth with the subject ‘Data Infrastructure’? Then download here our ETL & Data Integration Guide.
4. Informatica Data Replication
The vendor Informatica has an excellent score in our 100% vendor-independent ETL & Data Integration survey of the theme ‘Data Replication’, given that they score 97% on this, relative to other vendors. We considered the following factors: data synchronization, database replication, sql replication, transactional replication, data replication framework, replication model and data replication tasks. In doing so, we looked at the following two products: Informatica Data Replication and Informatica Cloud Data Replication. In total, we examined 32 features within this discipline. Are you excited about the subject ‘Data Replication’? Then download here our ETL & Data Integration Study 2023.
5. Informatica Data Management
The vendor Informatica has an excellent score in our independent ETL & Data Integration survey of the theme ‘Data Management’, given that they score 94% on this, compared to other vendors. We looked at the following criteria, among others: data sources, OLAP, real time, data migration, data pipelines, source table and streaming data. In doing so, we analyzed the following five products: Informatica Intelligent Cloud Services, Powercenter Data Integration, Informatica Cloud Data Integration, Informatica PowerCenter and Powercenter Data Virtualization. In total, we examined 71 criteria within this section. Would you like to learn more about the subject ‘Data Management’? Then download here our ETL & Data Integration Guide.
6. Informatica Self-service Integration
The company has an excellent rating in our independent ETL & Data Integration survey on the subject ‘Self-service Integration’ with a score of 90%, relative to other vendors. We looked at the following criteria, among others: self-service data preparation, self-service data integration and self-service data warehouse. In total, we examined 8 criteria in this category. Would you like to become more proficient in the subject ‘Self-service Integration’? Then download here our ETL & Data Integration Guide 2023.
7. Informatica Data Integration
Informatica has an excellent rating in our study on the subject ‘Data Integration’ with a score of 90%, compared to other vendors. We considered the following factors: ETL, data warehouse and data flow. In doing so, we looked at the following five products: Powerexchange, Informatica Intelligent Cloud Services, Powercenter Data Integration, Informatica Cloud Data Integration and Informatica PowerCenter. In total, we examined 169 aspects in this category. Would you like to go into more depth with the subject ‘Data Integration’? Then download here our ETL & Data Integration Guide.
8. Informatica Data Quality Management
Informatica has an excellent performance in our 100% vendor-independent ETL & Data Integration survey of the theme ‘Data Quality Management’, given that they score 86% on this, compared to other vendors. We looked at the following criteria, among others: data quality and data quality rules. In doing so, we studied the following two products: Informatica Data Quality and Informatica Data Quality Platform. In total, we examined 28 features within this discipline. Are you excited about the subject ‘Data Quality Management’? Then download here our ETL & Data Integration Study 2023. Or learn more about the following topics:
9. Informatica Data Governance
Informatica has a good rating in our independent ETL & Data Integration survey on the subject ‘Data Governance’ with a score of 62%, relative to other vendors. The following criteria were used: data privacy and data anonymization. In doing so, we analyzed the following four products: Informatica Data Quality, Informatica Big Data, Informatica Big Data Management and Informatica Master Data Management. In total, we examined 11 criteria within this section. Would you like to learn more about the subject ‘Data Governance’? Then download here our ETL & Data Integration Study 2023.
10. Informatica Master Data Management
The company has a moderate performance in our study on the section ‘Master Data Management’. The score amounts to 38%, relative to other vendors. We considered the following factors: master data quality and employee master data. In doing so, we investigated the following five products: Powerexchange, Informatica Data Replication, Informatica Big Data, Informatica Big Data Management and Informatica PowerCenter Data Quality. In total, we examined 16 criteria in this category. Would you like to go into more depth with the subject ‘Master Data Management’? Then download here our ETL & Data Integration Guide 2023. Or learn more about the following topics:
The footprint of Informatica ETL & Data Integration in different sectors
In our study, we also looked at which industries a supplier operates in. These are the industries where Informatica has the largest footprint: banking, education, financial services, health care, insurance, pharmaceuticals, retail and telecom.
Informatica software is most used by…
The ETL & Data Integration software from Informatica is most often mentioned in combination with the following functions: business analysts, data stewards and mapping designer.
Training and courses Informatica ETL & Data Integration
We provide various classes in the area of ETL & Data Integration but can also provide specific Informatica training, for example as incompany. Then think about the following software: Informatica PowerCenter, Informatica Intelligent Cloud Services and Powerexchange. Of course we frame the training with the ideas of the intelligent, data-driven organization.
Final assessment: Informatica Data Integration scores eminent
Informatica has a extensive product portfolio with which it scores eminent in our ETL & Data Integration survey. Informatica ETL & Data Integration innovates (approximately) at an average rate of more than 15 features per year, is active (for now) in many different sectors, and has developed best in data connectivity.
About Passionned Group
Passionned Group specializes in 100% independent ETL & Data Integration consulting and the implementation of ETL & Data Integration solutions. Our dedicated and passionate consultants help large and small governments and businesses to advance as a smart, data-driven business.
A selection of our customers
