Informatica PowerCenter Reviews

Filter by:Reset all filters
industry
Filter Unavailable
Company Size
Filter Unavailable
Job Level
Filter Unavailable
rating
Filter Unavailable
Vijaya Saduvuv
Real User
Lead Application Developer and Informatica Administrator at a healthcare company with 501-1,000 employees
Jun 06 2018

What is most valuable?

It works with any multi-database, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use.

How has it helped my organization?

It reduces a lot of legacy coding.

What needs improvement?

It has everything we want. We were looking for a feature but they have already it in Informatica 10. We are using Informatica 9.6.1 but they... more»

What's my experience with pricing, setup cost, and licensing?

Licensing is a one time cost. But maintenance costs depend on what you want, how long you need it. Maintenance is a kind of insurance. With... more»

What other advice do I have?

If you are a small company it depends on how much data integration you need. I cannot blindly say you should always go with Informatica because... more»
Bharathvajan Subbarao
Consultant
Technology Architect at Broadridge Financial Solutions
Jun 25 2017

What is most valuable?

We are using it to source data from Sybase database and flat files so as to load to the target Greenplum Database. The facility to do parallel... more»

How has it helped my organization?

We used Informatica PowerCenter for a re-platforming project where the earlier application was using an in-house Java-based ETL, that suffered... more»

What needs improvement?

In our implementation, for the initial conversion, we had to take on a large volume of data from the legacy Sybase system. This was taking a... more»

Which solutions did we use previously?

The legacy solution was using an in-house Java-based ETL, that had huge problems in scaling for high volume batches. As part of the... more»

What other advice do I have?

It is a good, scalable solution, provided the infrastructure is taken care of.
Find out what your peers are saying about Informatica, Microsoft, Oracle and others in Data Integration Tools.
301,499 professionals have used our research since 2012.
MattiHeimonen
Real User
DW Admin at a hospitality company with 1,001-5,000 employees
Jun 06 2017

What is most valuable?

Once you figure it out, it is a powerful and simple ETL tool. Its stability has been very satisfactory.

How has it helped my organization?

Like any other ETL tool, it collects business information for centralized reporting and analytics.

What needs improvement?

The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues... more»

What's my experience with pricing, setup cost, and licensing?

We have found the pricing very cost-effective. The licensing is CPU and data source-based. In the new version, it is... more»

Which solutions did we use previously?

Our company has always used this solution.

What other advice do I have?

Choose the right tool for the right job. For the purpose that this product was designed, I believe it is still the best... more»
Suneel Mopuri
Consultant
Integration developer at a tech services company with 10,001+ employees
Jan 24 2018

What is most valuable?

* Big Data connectivity, Data Integration solutions, and Data Quality solutions. * Easy to code and understand solutions in Informatica.

How has it helped my organization?

We are trying to implement both Finance and Operations modernization with the help of Informatica. This tool is mainly used in data ingestion, where we bring different sources into a Hadoop environment.

What other advice do I have?

Good product if you are trying implement data quality, data integration, and data management projects. We have a good relationship with the vendor. We get notifications related to new products for user validation and beta release. We have... more»
Mark Ma
User
Student at a government with 1,001-5,000 employees
Jul 08 2018

What is most valuable?

* Import from PowerCenter * Copy Text between Excel and the Developer Tool * Logical Data Object Read and Write Mapping Editing * DDL Query * Profiles

How has it helped my organization?

Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years. Informatica administrators are in the scope of daily operations.

What needs improvement?

* XML processing * Scheduler * Non-limit SQL qualifier embedded (right now 32K limitation) The Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design.
Sunil Chaubey
Consultant
User at a tech services company with 10,001+ employees
Jan 28 2018

What is most valuable?

Data Integration. The UI-based ability to create data mapping. Also, reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions.

How has it helped my organization?

Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse.

What needs improvement?

Cost! Also, BI features. While Informatica is great for data-integration, it does not have any analytics features. Thus, organizations have to always look for another product for their BI needs.

Articles

User Assessments By Topic About Informatica PowerCenter

Find out what your peers are saying about Informatica, Microsoft, Oracle and others in Data Integration Tools.
301,499 professionals have used our research since 2012.

Informatica PowerCenter Questions

Informatica PowerCenter Projects By Members

Informatica PowerCenter Consultants

What is Informatica PowerCenter?

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

Also known as
PowerCenter
Informatica PowerCenter customers

University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank

BUYER'S GUIDE
Not sure which Data Integration Tools solution is right for you?

Download our free Data Integration Tools Report and find out what your peers are saying about Informatica, Microsoft, Oracle, and more!

Sign Up with Email