We just raised a $30M Series A: Read our story
2018-03-05T18:47:00Z

What is your primary use case for Informatica PowerCenter?

128

How do you or your organization use this solution?

Please share with us so that your peers can learn from your experiences.

Thank you!

ITCS user
Guest
2222 Answers

author avatar
Top 20Real User

We use the solution for businesses that wish to analyze their raw data. The solution allows us to do data cleansing and to transform the raw data into useful, insightful information.

2021-08-17T13:30:49Z
author avatar
Top 20Real User

We are using Informatica PowerCenter for our data warehouse to generate reports from heterogeneous data sources from XML, JSON, or CSV databases. We then do some transformations to generate XML ISO standards to send to regulators in Europe and UK.

2021-07-30T09:56:48Z
author avatar
Top 5LeaderboardReal User

We are using Informatica PowerCenter to process the data of the files in the landing zone. These files contain a huge amount of data, and Informatica PowerCenter is the source for us to push the data to Azure Synapse. We are using its latest version.

2021-04-29T12:26:59Z
author avatar
Top 10Real User

We are a solution provider and this is one of the products that we implement for our clients.

2021-04-06T02:46:58Z
author avatar
Top 20Real User

We receive the data files from insurance carriers. We load the data, do some processing, and then make the data available to their internal systems. We apply some business transformations and data validations and share the data in the healthcare domain and EDI B2B exchange. Its version varies based on the customer, but when it comes to the cloud, we have the latest version. We have been using Informatica Intelligent Cloud Services (IICS) for two years. We have used IICS for two purposes. One is for data integration, and the other one is for application integration.

2021-02-16T12:21:55Z
author avatar
Top 5LeaderboardReal User

We use Informatica PowerCenter to extract the data from legacy products and load it into new applications. We're using it for this purpose only. Apart from that, we use the Data Quality tool for data quality issues. We use this solution to extract and load.

2021-02-08T10:22:15Z
author avatar
Top 10Real User

This solution is really the backbone of what we do. Informatica PowerCenter is one of the most used platforms for data governance in the banking and insurance industry. It's quite expensive so it's not used much outside the industry, but it's very reliable and strong in everything connected to data management and data governance strategy. For our industry, that is crucial. We are customers of Informatica and I'm the head of big data and solution architecture.

2021-02-01T20:44:36Z
author avatar
Top 20Real User

One of my use cases is integrating personnel data from multiple systems.

2020-12-28T16:35:14Z
author avatar
Top 10Real User

We use it for ETL. We have multiple systems, we extract the data, and create a report from it.

2020-11-01T09:32:00Z
author avatar
Top 20Real User

This product is primarily used with an Oracle product called OBI EE, Oracle Business Intelligence. It is used for integration and data visualization.

2020-09-27T04:09:50Z
author avatar
Top 20Real User

Our primary use case of this solution is for building data warehouses for clients with data visualization tools. We need to pull data from other sources so we use Informatica as the ETL. The solution is generally deployed on-prem but sometimes on cloud.

2020-09-13T07:02:27Z
author avatar
Top 20Real User

Integration between different applications, such as Hospital Information Systems built on AS400 and in-house legacy. It is old data structure file based as opposed to relational. Therefore, it was very difficult to connect and integrate with other new applications. We used Informatica to read from our Hospital Information System and transform the data into a relational model in order to speed up reporting and do cleansing of the data. We also used Informatica to integrate SQL Server based applications with our Oracle applications.

2020-04-04T09:49:00Z
author avatar
Top 20Real User

We use this solution for ETL of a US Law Enforcement agency's data sources to a data warehouse.

2019-10-24T14:54:00Z
author avatar
Top 10Real User

Our primary use case for this solution is at a Russian bank. The goal was to integrate DWH with a banking core system that used Pervasive SQL 2000 DB. The bank as our client in the field of Data Warehousing asked us to extract data from their core banking system and build a Data Mart for preparation of regulatory reports.

2019-10-10T20:02:00Z
author avatar
Real User

Our primary use case for Informatica PowerCenter is for insurance and enterprise data warehouse creation.

2019-08-01T05:43:00Z
author avatar
Reseller

ETL ; Extract Transform Load from data base to data warehouse based on specific business rules.

2019-07-31T05:51:00Z
author avatar
Real User

We are implementing our master data management integration solution. The idea is to have the data cleaned, and have a catalog set up so that we have a library we can consult to see what type of data is being used. At the same time, have a tool to provide a three hundred and sixty-degree view of our customer data. We will also have a unique repository and a data link that we're setting up in Azure. We will be moving all of our storage to the cloud so that we have a single repository, and this data will be accessible by our tools such as Tableau, for integration with our reporting. Currently, we are in a hybrid-cloud environment, but our intention is to be cloud-based using Azure.

2019-07-31T05:51:00Z
author avatar
Real User

We primarily use the solution for data integration.

2019-07-29T10:11:00Z
author avatar
Top 5LeaderboardReal User

Our primary uses of the solution are for data integration and to build a warehouse model.

2019-07-28T07:34:00Z
author avatar
Real User

Our primary use case is to process semi-structured and structured files using business rules to create CSV files for data warehouse loading and reporting.

2019-05-02T01:57:00Z
author avatar
Real User

We use it for data integration. It's a great tool.

2018-05-23T10:30:00Z
author avatar
Real User

Our primary use is to implement our data warehouse, including moving data between FTP, flat file and relational databases, and Domain/Integrated Service designs.

2018-03-05T18:47:00Z
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: October 2021.
540,984 professionals have used our research since 2012.