2018-03-05T18:47:00Z

What is your primary use case for Informatica PowerCenter?

Miriam Tover - PeerSpot reviewer
  • 0
  • 350
PeerSpot user
47

47 Answers

HK
Real User
Top 20
2024-01-22T09:03:36Z
Jan 22, 2024

I use Informatica PowerCenter as the main integration tool in our organization.

Search for a product comparison
AS
Real User
Top 10
2023-07-06T07:44:30Z
Jul 6, 2023

Our company uses Informatica PowerCenter as an ETL tool for data warehouse purposes.

Lars Borchers - PeerSpot reviewer
Real User
Top 10
2023-07-04T15:08:00Z
Jul 4, 2023

We use the product for everything that's possible in data integration. We have a data warehouse, and we load each stage. We use the product for data exchange and API services. We also use it to load data into cloud platforms and generate Customer Letters.

Muhammad -Usman - PeerSpot reviewer
Real User
Top 20
2023-04-10T11:36:33Z
Apr 10, 2023

Informatica PowerCenter is purely an ETL tool used for data integration.

Katarzyna Palikowska - PeerSpot reviewer
Real User
Top 10
2023-03-17T15:42:53Z
Mar 17, 2023

We are using the on-premises version and are working towards moving into the cloud. I design ETL workflows.

CC
Real User
2023-03-09T22:01:48Z
Mar 9, 2023

We use the solution primarily as an ETL.

Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,386 professionals have used our research since 2012.
SG
Real User
2023-03-09T22:01:32Z
Mar 9, 2023

Our company has requirements to move from legacy systems to new cloud systems. This helps migrate the data. We have complex logic and integrations on some of the systems, and Informatica makes migrations possible.

PS
Real User
Top 5Leaderboard
2022-12-05T08:32:24Z
Dec 5, 2022

The solution is basically used for anything and everything that we process, for example, from the SQL Server, from other application sources like Oracle, from Flatfiles, or loading into these kinds of sources. We use it for pretty much everything.

AE
Real User
2022-11-09T12:47:31Z
Nov 9, 2022

The product is primarily used for building the data warehouse as an ETL tool for our hospital.

PB
Real User
Top 5
2022-10-31T09:11:53Z
Oct 31, 2022

I'm using it in my company, in the sense that some of our clients use it as their tool for their day-to-day development.

YT
Real User
Top 20
2022-09-26T11:40:58Z
Sep 26, 2022

We have several uses cases for Informatica PowerCenter. We ingest data from different sources, for example, from API or other databases. We also apply data transformations in almost all cases via Informatica PowerCenter, to aggregate the data. We also check the integrity of the data and improve the data quality by applying some rules. We specify and identify all the rules and the methodology to apply the rules. We also participate in rule setting, and also check the test cycles for businesses.

Ramesh SV - PeerSpot reviewer
Real User
Top 5Leaderboard
2022-09-09T09:57:41Z
Sep 9, 2022

I am using Informatica PowerCenter as a data integration tool, and for standardization and validations.

Sunil_Shah - PeerSpot reviewer
Real User
Top 10
2022-07-10T15:41:08Z
Jul 10, 2022

We use Informatica PowerCenter primarily for its processes. We derive dashboards, functionalities and graphs with the information it provides. We create reports, generate excels, and data scientists use the information to generate reports in Tableau, Power BI or other tools.

VS
Real User
Top 5
2022-06-22T06:45:04Z
Jun 22, 2022

Informatica PowerCenter is a data extraction and data loading tool. We extract data from some sources and we load data to different source systems.

RR
Reseller
Top 5
2022-06-21T17:40:36Z
Jun 21, 2022

Informatica PowerCenter is an ETL data integration platform. It's all part of the data warehouse's extract, transform, and load process. Data is extracted from all source systems, transformed, and loaded into a data warehouse.

Ravi Kuppusamy - PeerSpot reviewer
Real User
Top 5Leaderboard
2022-05-17T11:51:37Z
May 17, 2022

We primarily use the solution for the ETL.

DC
Real User
Top 20
2022-05-11T14:38:00Z
May 11, 2022

My experience is in the semiconductor industry with our customers using the Azure supply chain. We have built-in the AIS system, IBM and Db2. We transfer data from SQL Server to MongoDB and transfer the data to Db2. Security is very important, the solution is deployed to the private cloud. We assigned five people to build the project. Informatica PowerCenter is built into the technology supply system. I use the solution to transfer the MS data system to the supply chain system.

RemonHanna - PeerSpot reviewer
Real User
Top 20
2022-04-25T09:34:01Z
Apr 25, 2022

We are using Informatica PowerCenter for data integration in a health insurance company.

GF
Real User
2022-03-15T09:26:57Z
Mar 15, 2022

I'm working for a casino, and we use this solution in our company to replicate different databases, such as from Oracle to Teradata. Most of the time, it is used for replication, but sometimes, it is also used for doing some calculations, additions, or unions for ETL. It is currently deployed on-premises, but we will be moving to a cloud solution by the end of the year. We are currently doing a proof of concept and evaluating a cloud solution from Informatica.

NM
MSP
2022-01-24T14:29:57Z
Jan 24, 2022

Informatica PowerCenter is being used for data warehouse development, using ETL and ELT, e.g. Informatica PowerCenter for ETL and Informatica Cloud Data Integration for integration between systems, e.g. with their downstream systems.

FN
Real User
2021-12-27T19:26:00Z
Dec 27, 2021

In the company I work for, we provide a lot of solutions. I've been working with a lot of clients. The last client I worked with was a big hotel company, and we used this solution for integration.

Muharrem Iseri - PeerSpot reviewer
Real User
Top 5
2021-12-14T15:56:00Z
Dec 14, 2021

Our primary use cases of PowerCenter are database regulatory reporting cases. Both sides are suitable for us to net trace metadata and it's easy to develop or hedge, after production as well. It's also easy to understand the steps or ETL. I'm working with the latest update, and it's deployed on-prem.

GB
Real User
2021-12-13T14:30:00Z
Dec 13, 2021

We are generally using it for ETL systems.

IB
Consultant
2021-10-28T19:18:00Z
Oct 28, 2021

Our primary use case is to collect data from different sources and to build it for the house or data hub, or to fill already built-in appliances like Cloudera and Teradata.

AR
Consultant
2021-10-11T12:09:41Z
Oct 11, 2021

I have worked with Informatica PowerCenter in different companies for different projects. We use Informatica PowerCenter for ETL. We need it for our data integration project.

DS
Real User
2021-08-17T13:30:49Z
Aug 17, 2021

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.

VN
Real User
2021-07-30T09:56:48Z
Jul 30, 2021

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.

KG
Real User
2021-04-29T12:26:59Z
Apr 29, 2021

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.

SB
Real User
2021-04-06T02:46:58Z
Apr 6, 2021

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

AT
Real User
2021-02-16T12:21:55Z
Feb 16, 2021

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.

SK
Real User
2021-02-08T10:22:15Z
Feb 8, 2021

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.

RM
Real User
Top 5
2021-02-01T20:44:36Z
Feb 1, 2021

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.

MA
Real User
2020-12-28T16:35:14Z
Dec 28, 2020

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

SS
Real User
2020-11-01T09:32:00Z
Nov 1, 2020

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

DL
Real User
2020-09-27T04:09:50Z
Sep 27, 2020

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

DD
Real User
2020-09-13T07:02:27Z
Sep 13, 2020

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.

RS
Real User
2020-04-04T09:49:00Z
Apr 4, 2020

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.

SC
Real User
2019-10-24T14:54:00Z
Oct 24, 2019

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

Kirill Slivchikov - PeerSpot reviewer
Real User
Top 5
2019-10-10T20:02:00Z
Oct 10, 2019

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.

RS
Real User
2019-08-01T05:43:00Z
Aug 1, 2019

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

MK
Reseller
2019-07-31T05:51:00Z
Jul 31, 2019

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

RP
Real User
2019-07-31T05:51:00Z
Jul 31, 2019

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.

it_user1119516 - PeerSpot reviewer
Real User
2019-07-29T10:11:00Z
Jul 29, 2019

We primarily use the solution for data integration.

AE
Real User
Top 10
2019-07-28T07:34:00Z
Jul 28, 2019

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

it_user1080720 - PeerSpot reviewer
Real User
2019-05-02T01:57:00Z
May 2, 2019

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.

VS
Real User
2018-05-23T10:30:00Z
May 23, 2018

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

MM
Real User
2018-03-05T18:47:00Z
Mar 5, 2018

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

Informatica PowerCenter is a data integration and data visualization tool. The solution works as an enterprise data integration platform that helps organizations access, transform, and integrate data from various systems. The product is designed to support companies in the full cycle of a project, from its initial rollout to critical deployments. Informatica PowerCenter allows developers and analysts to collaborate while accelerating the work process to deploy projects within days instead of...
Download Informatica PowerCenter ReportRead more

Related Q&As