What is PowerCenter?

Enterprise data integration platform to help organizations access, transform, and integrate data from a variety of systems.

Who Uses PowerCenter?

Cloud-based data integration platform which helps businesses analyze, prototype, iterate, and deploy projects with automated data validation, transformation and IT collaboration.

Where can PowerCenter be deployed?

Cloud, SaaS, Web-based

About the vendor

  • Informatica
  • Founded in 1993
  • Phone Support
  • Chat

Countries available

United States

Languages

English

About the vendor

  • Informatica
  • Founded in 1993
  • Phone Support
  • Chat

Countries available

United States

Languages

English

PowerCenter videos and images

PowerCenter Software - 1
PowerCenter Software - 2
PowerCenter Software - 3
PowerCenter Software - 4
View 4 more
PowerCenter Software - 1
PowerCenter Software - 2
PowerCenter Software - 3
PowerCenter Software - 4

Compare PowerCenter pricing with similar products

PowerCenter

N/A
Free Version
Free Trial
US$129.00/month
Free Version
Free Trial
N/A
Free Version
Free Trial
N/A
Free Version
Free Trial

Features of PowerCenter

  • Collaboration Tools
  • Dashboard
  • ETL Tools
  • Metadata Management
  • Reporting/Analytics

Alternatives to PowerCenter

Mitto automates data flows from hundreds of potential sources into a single destination, fully prepped and ready for analytics.
Web, on-prem and mobile solutions to help businesses with mapping, data management, predictive modeling, geocoding and more.
Qlik Sense is a business intelligence (BI) and visual analytics platform that helps global enterprises move faster and work smarter.
Dundas BI is a flexible data analytics platform that was built to be embedded. Everything you need is in one end-to-end platform. Learn more about Dundas BI
Yellowfin is the only analytics suite that successfully combines action based dashboards with industry-leading automated analysis.
Perhaps the most comprehensive accounting software available. Everything's included and owned by you. The original 1 File 1 Format app!
OmniConnect provides secure API Connectivity as a Service between any Fintech and U.S.-based financial institution within 90 days.
B2BGateway is a Fully-Managed Business Integration, EDI & API Solutions Provider Offering Streamlined Supply Chain Automation.
Intelligent DataOps platform that offers a full portfolio of capabilities for orchestration, automation and analytics.
All-in-one BI tool for no-code data prep, analytics and visualisation, on any device. Extensible with your Python/R/JS. Look no further
BusinessOptix is a powerful suite of process mapping and mining tools on a dynamic and collaborative platform.
A low-code iPaaS for SMEs – made and hosted in Germany.
Synerise is an AI Growth Ecosystem for B2C & B2B that provides 360 Customer view and cutting-edge personalization.

Reviews of PowerCenter

Average score

Overall
4.5
Ease of Use
4.3
Customer Service
4.2
Features
4.5
Value for Money
4.1

Reviews by company size (employees)

  • <50
  • 51-200
  • 201-1,000
  • >1,001

Find reviews by score

5
56%
4
41%
3
3%
Abhisha B.
Abhisha B.
Volunteer in US
Verified LinkedIn User
Higher Education, Self Employed
Used the Software for: 2+ years
Reviewer Source

Good ETL tool

5 4 years ago

Comments: I was using Informatica PowerCenter as an ETL to to feed data into Teradata datawarehouse that houses customer information for an insurance company.

Pros:

Informatica PowerCenter is a good ETL tool for users who wish to develop a datawarehouse but do not have much programming experience. It has a nice interface where the user can simply drag and drop to create a data flow. It is very intuitive and user friendly.

Cons:

PowerCenter is a heavy software and installation is not a trivial task. It uses a lot of memory and it could crash the system if it does not have enough resources.

Manali V.
Software engineer in India
Information Technology & Services, 10,000+ Employees
Used the Software for: 1+ year
Reviewer Source

Good but require to inbuilt multiple function

4 3 years ago

Comments: It's good but yeah not too good

Pros:

1. Drag and drop services 2. Easily maintain 3. Run multiple batch jobs 4. Define methods with logistics

Cons:

1. Can't schedule in workflow 2. Job running status logs are too long 3. Doesn't have parallel off functionality 4. Can't be sync with repository automatically

Anandh S.
US
Used the Software for: Not provided
Reviewer Source

Informatica Power Center

3 6 years ago

Comments: Product Met expectations. Could have better customer support and timely resolution of user queries.

Siddharth R.
Senior ETL Developer in US
Financial Services, 1,001-5,000 Employees
Used the Software for: 2+ years
Reviewer Source

Best ETL tool

5 3 months ago

Pros:

Easy to integrate with any DB, flat file. Core concepts are very similar to sql. Very easy to understand the flow of data from source to target.

Cons:

No auto refresh functionality. Lack of a Script to automatically generate the parameter file.

Sri ramani B.
QA MANAGER LEAD in US
Information Technology & Services, 10,000+ Employees
Used the Software for: 2+ years
Reviewer Source

Ease to use

5 4 years ago

Comments: Ease to work

Pros:

It Works vwell with large structured data files 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 AT&T organization.

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.