PowerCenter

by Informatica

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.

What Is PowerCenter?

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

PowerCenter Details

Informatica

https://www.informatica.com

Founded 1993

PowerCenter Software - 1
PowerCenter Software - 2
PowerCenter Software - 3
PowerCenter Software - 4
PowerCenter Software - 1 - thumbnail
PowerCenter Software - 2 - thumbnail
PowerCenter Software - 3 - thumbnail
PowerCenter Software - 4 - thumbnail

Compare PowerCenter with similar products

Starting price

N/A
US$495.00/month
N/A
N/A

Free Version

Free Version No
Free Version Yes
Free Version No
Free Version No

Free Trial

Free Trial Yes
Free Trial Yes
Free Trial Yes
Free Trial No

PowerCenter deployment and support

Support

  • Email/Help Desk
  • FAQs/Forum
  • Knowledge Base
  • Phone Support
  • Chat

Deployment

  • Cloud, SaaS, Web-based

Training

  • In Person
  • Live Online
  • Documentation
  • Videos

PowerCenter Features

  • API
  • Access Controls/Permissions
  • Activity Dashboard
  • Activity Tracking
  • Ad hoc Analysis
  • Ad hoc Query
  • Ad hoc Reporting
  • Alerts / Escalation
  • Alerts/Notifications
  • Benchmarking
  • Charting
  • Collaboration Tools
  • Customisable Branding
  • Customisable Reports
  • Customisable Templates
  • Dashboard
  • Dashboard Creation
  • Data Connectors
  • Data Extraction
  • Data Import/Export
  • Data Mapping
  • Data Synchronisation
  • Data Transformation
  • Data Visualisation
  • Drag & Drop
  • Forecasting
  • Key Performance Indicators
  • Metadata Management
  • Monitoring
  • Multiple Data Sources
  • Performance Management
  • Performance Metrics
  • Predictive Analytics
  • Profitability Analysis
  • Publishing / Sharing
  • Real Time Analytics
  • Real Time Data
  • Real Time Monitoring
  • Real Time Reporting
  • Reporting & Statistics
  • Reporting/Analytics
  • Sales Trend Analysis
  • Scorecards
  • Search/Filter
  • Self Service Data Preparation
  • Strategic Planning
  • Third Party Integrations
  • Trend / Problem Indicators
  • Trend Analysis
  • Visual Analytics

View full list of Business Intelligence (BI) Tools

  • API
  • Access Controls/Permissions
  • Accounting Integration
  • Activity Dashboard
  • Activity Tracking
  • Alerts / Escalation
  • Application Management
  • Automated Scheduling
  • CRM
  • Configurable Workflow
  • Dashboard
  • Data Aggregation and Publishing
  • Data Capture and Transfer
  • Data Connectors
  • Data Extraction
  • Data Import/Export
  • Data Management
  • Data Mapping
  • Data Storage Management
  • Data Synchronisation
  • Data Visualisation
  • Data Warehouse Software
  • Database Support
  • Document Management
  • Drag & Drop
  • ERP
  • ETL Tools
  • Email Management
  • Integrations Management
  • Metadata Management
  • Mobile Access
  • Monitoring
  • Multiple Data Sources
  • Point of Sale (POS)
  • QuickBooks Integration
  • Real Time Analytics
  • Real Time Data
  • Real Time Monitoring
  • Real Time Reporting
  • Real-time Updates
  • Reporting & Statistics
  • Reporting/Analytics
  • SSL Security
  • Sales Management
  • Search/Filter
  • Social Media Integration
  • Third Party Integrations
  • User Management
  • Web Services
  • Workflow Management

View full list of System and Data Integration Software

PowerCenter Alternatives

More PowerCenter alternatives

PowerCenter Reviews for UK Users

Read all 38 reviews

Average score

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

Reviews by score

5
21
4
16
3
1

Reviews by company size (employees)

  • <50
  • 51-200
  • 201-1,000
  • >10,001
Abhisha B.
Abhisha B.
Volunteer
Higher Education, Self Employed
Used the Software for: 2+ years
  • Overall Rating
  • Ease of Use
  • Features & Functionality
  • Customer Support
  • Value for Money
  • Likelihood to Recommend
    8/10
  • Reviewer Source 
  • Reviewed on 11/10/2018

"Good ETL tool"

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.

  • Reviewer Source 
  • Reviewed on 11/10/2018
Manali V.
Software engineer
Information Technology & Services, 10,000+ Employees
Used the Software for: 1+ year
  • Overall Rating
  • Ease of Use
  • Features & Functionality
  • Customer Support
  • Value for Money
  • Likelihood to Recommend
    7/10
  • Reviewer Source 
  • Reviewed on 31/07/2019

"Good but require to inbuilt multiple function"

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

  • Reviewer Source 
  • Reviewed on 31/07/2019
Anandh S.
  • Overall Rating
  • Ease of Use
  • Features & Functionality
  • Customer Support
  • Value for Money
  • Likelihood to Recommend
    Unrated
  • Reviewer Source 
  • Reviewed on 06/10/2016

"Informatica Power Center"

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

  • Reviewer Source 
  • Reviewed on 06/10/2016
Sri ramani B.
QA MANAGER LEAD
Information Technology & Services, 10,000+ Employees
Used the Software for: 2+ years
  • Overall Rating
  • Ease of Use
  • Features & Functionality
  • Customer Support
  • Value for Money
  • Likelihood to Recommend
    10/10
  • Reviewer Source 
  • Reviewed on 05/03/2018

"Ease to use"

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.

  • Reviewer Source 
  • Reviewed on 05/03/2018
Verified Reviewer
Technology Lead
Information Technology & Services, 10,000+ Employees
Used the Software for: 2+ years
  • Overall Rating
  • Ease of Use
  • Features & Functionality
  • Customer Support
  • Value for Money
  • Likelihood to Recommend
    8/10
  • Reviewer Source 
  • Reviewed on 26/05/2019

"One of the best ETL ( Extract, Transform, Load) Tools"

Pros: 1. Able to process a huge record size. In the latest project, we used Informatica to load approx 5 Million records daily. There were no performance issues due to the data size.
2. . PowerCenter has very easy to use drag and drop interface which can be used in integration with other applications.
3. Good tool to manage legacy data and to make compatible with modern applications.
4. PowerCenter also has other additional features like the ability to profile data, visualize graphical data flow etc. Data validation can also be done very easily using the validation feature.

Cons: There is a huge licensing fee which is worth it as the product is one of the best ETL tools, but projects which smaller budget find it challenging to justify the cost.

  • Reviewer Source 
  • Reviewed on 26/05/2019