Informatica PowerCenter

(31)
4.4 out of 5 stars

Power Data Integration Tool

Work for Informatica PowerCenter?

Learning about PowerCenter?

We can help you find the solution that fits you best.

Informatica PowerCenter Reviews

Request More Information
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
Ratings
Company Size
User Role
Industry
Showing 33 PowerCenter reviews
LinkedIn Connections
PowerCenter review by User in Insurance
User in Insurance
Validated Reviewer
Verified Current User
Review Source

"Solid data integration tool, recommended for enterprise-level integration needs"

What do you like best?

Excellent feature-functionality Good performance Ability to handle large data sets Sizeable talent pool Expensive licencing Poor integration with external source control, testing and release management tools Limited & clumsy handling of EDI (X12) data sets.

The software features role-based tools that support iterative business collaboration and development. Data integration is governed by metadata and the highly efficient ETL engine of the software. Other important features offered by the software include rapid prototyping, instant data profiling, graphical data flows, impact analysis, automated data validation, and efficient distributed processing.

What do you dislike?

Management features of Informatica PowerCenter do not include metadata management.

Recommendations to others considering the product

Able to access heterogeneous databases: It can work with any kind of database available in the market. In fact, it can be applied to NoSQL databases as well. SQL override allows users to write simple to complex queries inside mapping for performance tuning the load process, pre and post SQL can help control the load process to get desired outputs.Error handling techniques: Informatica provide a suite of options to handle errors. From logging error in database tables to e-mail notifications with log files, to decision/assignment tasks for data control, it can handle error at every stage of workflow. Restart options for batched work-flows.Debugging, is one other feature I found extremely useful. Before running a full load, you can run a subset of data from source-target and check for values generated from logic at every transformation.Informatica provides all the functions indexed in a proper fashion in expressions editor with syntax to allow users to build logic with ease.

What business problems are you solving with the product? What benefits have you realized?

we are very satisafied with Informatica on-Premise powercenter solution. However, we experienced issues with Informatica BDM solution. Informatica did not have enough expertise in handling some of the issues. It had to go to R&D to get fixes.

Sign in to G2 Crowd to see what your connections have to say about Informatica PowerCenter
PowerCenter review by <span>Sandeep T.</span>
Sandeep T.
Validated Reviewer
Verified Current User
Review Source

"Informatica - Power to Information!"

What do you like best?

I have used Informatica for about two years at my previous workplace. It is the best ETL Technology I have used. Some of the features that were very helpful to me

-> Access and ability to read data from multiple sources. Name the type of source and Informatica can read it.

-> The GUI is excellently simple. High on usability if I could say.

-> The expressions are many. I have used other ETL tools and I haven't found as many data manipulation expressions as in Informatica.

-> Ease of creating and using parameters.

-> Informatica PDO makes things so easier and simple to debug for errors or Data manipulations discrepancies.

What do you dislike?

There was no feature that I disliked much.

Sometimes, I would feel to write a simple statement with a aggregation and the filter is all the steps to be done in Informatica necessary. Its a simple SQL Statement.

Recommendations to others considering the product

A definite product to try for the Data Person of the company.

What business problems are you solving with the product? What benefits have you realized?

It was a full fledged project. The project was to measure the success of services. Informatica was primarily used an ETL tool to crunch the data into a database for the relevant metrics.

Some of the befits that we saw -

-> Data residing across various databases and flat files easily synched to a single application layer

-> Easier manipulation of data

-> Faster to learn and implement than SQL

-> Easier and multiple methods of transportation of packages across various environments.

What On-Premise Data Integration solution do you use?

Thanks for letting us know!
PowerCenter review by <span>Michael R.</span>
Michael R.
Validated Reviewer
Verified Current User
Review Source

"PowerCenter as an on-premise integration and management tool"

What do you like best?

PowerCenter does what it does very well. The support structure, often bemoaned in public, actually works pretty well for me.

What do you dislike?

Price. The cost associated with just implementing the core product is very large. Charging extra for management tools (in-client source control, metdata manager, etc) is untenable for my org. Management of the tool is haphazard without them; we had to "reverse-engineer" the metadata to prevent our developers from digging and digging through endless menus just to determine whether their source definitions exist already, or not.

The built-in scheduler is quite anemic and also required us to use cludgy workarounds.

Team needs to be trained up to it. That's not unique.

Recommendations to others considering the product

Get your table structures, design, architecture, and EA ownership right first.

What business problems are you solving with the product? What benefits have you realized?

Our ETL runs faster thanks in part to better software (bulking and parallelization), but it's not clear how much performance we gained just from a brand new and better table and workflow design.

We are able to run our ETL multiple times per day to provide an integrated look into the University's admissions and registration stats.

PowerCenter review by <span>Victor C.</span>
Victor C.
Validated Reviewer
Review Source

"Synonymous with ETL"

What do you like best?

> Informatica power center is probably the most powerful ETL tool I have ever used

> It is potent enough to be used as a standard enterprise ETL tool

> It supports a rich functions library and a host of different tools to prepare and cleanse the data according to your need

> You can also use informatica power center to create reusable mappings called "mapplets", these mapplets are a real convenient way of using a transformation logic again and again

What do you dislike?

> When you create a mapping in powercenter you also have to use 2 other tools to create the workflow and to run or schedule it

> Informatica can be slow at times

> Unlike other smaller competitors in the market informatica does not integrate well with the native datasets of various analytical tools like tableau, spotfire, qlikview etc

Recommendations to others considering the product

> Consider using this tool if you process large amounts of data, to be specific if you have setup a data warehouse this might be an ideal tool for you

> Powercenter can solve any data related processing starting from cleansing to transforming the data and loading it to any leading RDBMS system.

> Do not use this tool if you want to process data for quick analysis using a BI tool

What business problems are you solving with the product? What benefits have you realized?

> We use Informatica as an enterprise ETL tool

> It helps us run batch data updates in the form of data migration from SAP to teradata systems

PowerCenter review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"I have 8 Years of experience with Informatica Tool "

What do you like best?

It has lot of features to adopt the necessity of business . It is very fast and accurate. Metadata repository for the organization's ETL ecosystem.

What do you dislike?

Lack of functionality compared to other tools or things that might be improved:

Lack of a possibility to do loops within informatica workflows.

Parameter files handling. The concept of using a parameter file is ok, however it would be nice to be able to dynamically set parameters during runtime. Editing the parameter file for each run is rather painful. This would be very helpful especially for development/testing phase.

It's not possible to run a single session within a worklet. Sometimes, again especially for testing/development, it's handy to just run sessions one by one. It's ok in workflows but why it's not possible within worklets ?

Recommendations to others considering the product

It's best and fast ETL tool with Cloud computing in the market.

What business problems are you solving with the product? What benefits have you realized?

Business day to day data . Effective reporting .

PowerCenter review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"For all your data needs - Informatica"

What do you like best?

A powerful tool which can be used to integrate/access various data sources.

Supports various data sources like Relational Sources, FlatFile, XML etc.

What do you dislike?

Have to pay very huge money to buy this software.

Need to pay additional amount if i want to get any additional plugins.

Recommendations to others considering the product

Definitely recommend this product to other customers. But considering the price, I feel it bit more expansive than other software.

What business problems are you solving with the product? What benefits have you realized?

We are using Informatica to integrate various sources.

Loading data very easily. A powerful tool used to extracts tons of data.

Kate from G2 Crowd

Learning about Informatica PowerCenter?

I can help.
* We monitor all Informatica PowerCenter reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.