2018-03-05T18:47:00Z

What is your primary use case for Informatica PowerCenter?


How do you or your organization use this solution?

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

Thank you!

Guest
1111 Answers

author avatar
Top 10Real 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
Real 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 5Real 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
Top 20Real 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
Top 20Reseller

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 primarily use the solution for data integration.

2019-07-29T10:11:00Z
author avatar
Top 10Real User

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

2019-07-28T07:34:00Z
author avatar
Consultant

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
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 2020.
442,283 professionals have used our research since 2012.