Informatica PowerCenter Reviews

I mostly like working with the informatica designer as it is very easy to get source and targets by connecting to the server. There are variety of transformations available to clean the data and you just have to find the right one.

Sometime when I run the workflow and if there are some errors, especially those associated with date time conversion, informatica does not tell you why actually the error occurred. You have to go to the session log and google the error to find more about how to solve it.

If you are considering using a different database management system, such as moving from legacy systems or mainframe to modern RDBMS, you definitely need informatica.

Mostly I use informatica for data migration from DB2 to MSL Server. Since the new system queries the SQL Server, using informatica has helped us achieve that goal.

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.

Management features of Informatica PowerCenter do not include metadata management.

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.

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.

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

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

Have to pay very huge money to buy this software.

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

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

We are using Informatica to integrate various sources.

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

- It is one of the most powerful and user friendly ETL(Extraction, Transformation and Loading) tool.

- Very easy to use - drag and drop

- integration with other applications is easy.

- Good tool to manage legacy data and to make compatible with modern applications.

- Good team of community members and support analysts make it very helpful to debug any issues

- the licensing is very expensive But it is manageable, it's value for money.

- Every time we need to pay extra amount if we want any extra plugin for other applications to be activated. Sometimes it appears very slow in data processing

- i highly recommend this ETL tool over other tools but only if you could afford for it

- they have plugins to integrate with most of the applications out there

- to accomplish the ETL process from different sources

- availability of plugins (integrators, service providers, etc.) to connect to different applications

- to make deployments seemless

Ease of use and connectivity with different databases .It has reduced a lot of legacy coding which we need to write manually. It is very easy and simple to use to the end user.

The only thing user will face difficulty is the intial set up. It is not as easy as using it after installation. One professional is necessary to start with the set up of this product.

It depends on the size of the organization and the size of data they are trying to do integrate. For a company which is affordable of this product I can say go for it.Totally,I can give 10 out of 10 rating for this product.

We used to use this tool for data integration. It has everything that what we were looking for earlier.The scalability and stability of this product is very impressive.

One of major reason for Informatica etl tool success is its capability of enabling Integration. Informatica also leverage the same integration model. Easy training and tool availability has made easy resource availability for software industry, where else other etl tools are way behind in this aspect. Informatica comes with internal scheduler unlike many other etl tools where one need to use third party scheduler.

Transaction rework costs. Cost incurred in implementing new systems.Delays In delivery data to decision maker which has lost many customers due to poor service. It allows to use Persistent cache, which gives you performance boost by saving time in building the lookup while session run but it still takes the same time like a normal lookup for using the lookup data during session runtime.

Yes, definitely go ahead to learn more and more of informatica tool. If planning to play with data, then definitely this is the platform to begin.

The productivity of the environment. We get more done faster and more repeatably. The Data Profiling tool now has been enhanced with really nice data visualization capabilities to make it far easier and faster to understand your data and it’s relationships. Another addition is 100 free Analyst Tool seats to all editions of PowerCenter. Informatica has been driving agile data integration development based on the idea of a development team made up of a developer and a business analyst.

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.

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.

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

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.

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

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.

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

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.

> 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

> 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

> 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

> 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

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.

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 ?

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

Business day to day data . Effective reporting .

It is easy to use and probably the best ETL tool I have worked on. It is very convenient to create reusable and non reusable task depending on the user needs.

There are few bugs in the tool which can be fixed. It is slow in sometimes.

If the source data is huge then Informatica is preferable to use as it is unnecessary to purchase if your company has small data when we compare with pricing for relative ETL tools. You can get the visual pictures of metadata, data flow and throughput within no time.

We use it as ETL tool. It helps in cleansing the source data very easily and load into target table. To remove unnecessary data in source data so that process can be fastened.

Informatica PowerCenter is my go to solution for any ETL need. It is flexible, easy to understand and easy to maintain. It is easier to debug and absolutely simple to build any logic you have in mind. The security is very straight forward which avoids unnecessary confusions and saves time to concentrate on developing and testing the applications. The command line comes to rescue when you need to create a custom solution. Deployment groups and simple XML migration saves time and energy during migrations. The inbuilt version control saves lots of time when something is modified by mistake. The ETL templates for SCD saves time and avoids complexity by providing a simple method to implement complex SCDs.

Though the tools is reliable compared to other tools like ODI, frequent crashes, screen hang causes troubles. One notable issue is when you try to change the domain name in Informatica Workflow monitor-impossible to change!

Simple interface, easy to learn, use and administer.

Any ETL problem can be handled by Informatica, I work with a very big EBS implementation and developing a data warehouse was so easy with Informatica, Earlier we were considering Oracle's ODI but later realized the flexibility which was readily available in Informatica was missing in ODI.

Informatica, unlike other vendors like Oracle do not believe in 'reinventing the wheel' when it comes to enhancements: old features are backward compatible and new ones are intuitive to use to the familiar user. one of the best features of Informatica and a dream come true for most Informatica Developers and Designers is its ability to visually model the business process whose data it is trying to transform. This means process models developed in industry standard BPMN can be modelled to exact specification mappings in Informatica and with its robust debugger engine, it serves as the best visual tool to visualise each and every data transformation when you need to get those data sign-offs in complex data integrations. Hence code development is more agile and prototyping is faster and more robust.

Code Migration and Version Control in Informatica are pretty robust too and the process works out of the box with its excellent code labelling and version history system with minimal configuration! Add to this the excellent error handling capabilities of its workflow monitor and you have a data migration platform that works best for you and the business.

In the Product per se, the Informatica Powercentre suite needs a stronger ETL(Extract Transform Load) orchestration tool that is as intuitive as the Oracle Datawarehouse application console(DAC). Informatica allows orchestration of workflows to a certain extent but needs to come up with more level of control on table related tasks that speed up the ETL like dropping and recreating indexes. Informatica can do these activities by calling procedures in pre and post sql actions but the tasks are not very visibly monitored on its work flow monitor.Nevertheless, the session logs on the monitor do keep a record of these tasks.

Before falling into the sales pitch of ETL tools set by Oracle or IBM(Data Stage), consider this: Informatica has been the market leader for Enterprise Data Migration for the last couple of years(more than 5 years as a Leader in this sector on the Gartner Magic Quadrant). If this statistic does not impress you, consider its ability to make robust prototypes, efficient ETL Engine, strong debugging and error handling capabilities plus a version control and code migration system that simply works out of the box and you got a winner in the Data Migration tools space that will make your investment worthwhile over the years!

We are using Informatica to make complex data transformations from multiple source systems using complex business process flows that reflect the convergence of CRM(Customer Relationship Management) systems and Financial systems right from when the Customer represents an opportunity for business to the point when he holds assets from our business as a result of the Customer journey.

Easy to use even for those that are new to a new ETL tool. Ability to integrate to Cloud solutions. Easy to learn and design and troubleshot. Very reliable on a Unix environment.

It needs to incorporate more features in the Standard Edition. All Standard edition is lacking was custom built and integrated with the tool

Daily production report and key executive information through Informatica as a data integration tool.

Informatica is the main ETL tool to integrate into the EDW and therefore it is a critical tool

Informatica is a Best ETL tool,User freindly and selef descriptive.

we have different kind of transformation which helps us to Load the data in desired format.

Informatica having so many sub tools like designer,workflow designer and monitor

It is best ET tool to work on ,tool is contains all transformation to cleans and lload the data

Informatica helps us to cleanse the data which are coming from different sources like flat file,database etc.

I like the fact that Informatica is solely focused on ETL and they set the industry standard that other tools try to reach.

Not much to dislike about the product except the way some of the things are arranged and organized. This is a small price to pay for the unbeatable stability and unparalleled performance.

This is as good as it gets. The only option I would recommend is to look at the Cloud version as it offers additional functionality that the on premise version does not. Not to mention the fact that all the tools are headed to the cloud.

We are trying to solve enterprise ETL functionality and are realizing very consistent performance that we do not see with other products.

It's so easy to develop data integration mappings using Informatica Power Center. It can be used to access data from heterogeneous source file systems. So easy to maintain.

Developers are provided with very limited access.

A product that will help to save millions of development cost.

Currently we use Informatica Power Center to integrate data from TV Nielsen and various digital platforms like Hulu, FoxNOW & VOD. The cost of data integration has been reduced a lot because it is so easy to provide business solutions using this tool.

Tool is very user friendly and you have very flexible features.

each and every component or transformation is so deltailed that you can use it easily and help content is so detailed that eit will explain each and every step.

scheduling the jobs are very easy and you can rely on sceduling jobs.

informatica is a repository bases so each and every transaction is saved.

This run one job many components needs to be created like mapping session and worflow

Informatica power center is a best tool,you start loving it when you start using it

DAta transmisssion from dource system to warehouse

various tools in it, which makes workflow development easy.

If the PC configuration is not good, then it lags a lot

Used it to solve the data sparse over different databases and accumulated it in one database using different transformations. It helped in building reports on top of centralized data.

Debugger option in PowerCenter designer and ease of using IPC and easy to generate SQL statements as you no need to worry in writing huge sequel statements with IPC you can do it easily and effectively.

There are still bugs in the tool which are to be fixed like tracing problem while running multiple workflows.

I usually load the flat file data that comes everyday at particular time to database Target table and transposing the given set of data using informatica normalizer transformation. IPC is an easy and convenient tool to extract transform and load the source data into target.

It is one of the best segment of the tools that worked. It is among the best in the market and is very well regarded by all professionals who know her. The best feature of the tool is in my opinion the performance. Very good with large volumes of data.

Like other tools framework for integration of large volumes of data, it has a layered architecture that is not very simple for any industry analyst begin to develop. It requires little learning time.

Deve ser considerada sempre para um projeto de integração. Líder de mercado.

I worked with integration between two databases to a system upgrade.

Ease of using tool, flexibility and durability, adaptibility gives an edge compare to other Data integration tools.

I don't have anything which I dislike about the power center tool.

Doing data integration for the client using interfacing with multiple systems.

The versatility is a big plus, you can basically work with any kind of structured data source: flat files, most of the databases.

One thing i don't like is you have to close and open the folders to see the changes reflected.

Informatica is great for ETL it makes working with data so much easier. There is everything available for everyone.

Informatica Powercenter provides the real time data integration services

Its highly intuitive and customizable that speeds up the development process

It comes with full suit of data management components including data integration, data quality, data governance etc

Seamless integration with informatica MDM and data masking tools

Its a bit costly compared to other cheaper alternatives

Its a great tool, definitely recommended

Data Integration

easy to use, reliable. lot of features. can be connected to any type of source (xml, flat file, mainframe, rdbms -Oracle etc).

Rapid development.

Integration with other products like IDQ.

error message documentation is not correct or enough to debug issues.

Highly recommend this product for ETL related work

Data migration -- Full load and incremental load with lots of transformation rules.

A new system is being developed with new data model which will be populated with three existing systems.

the user interface, diversity in its products to achieve anything related to data integration etc

too many products with overlapping features

data integration, quality & master data management

Informatica offers integration with wide range of databases and enterprise application integration with a interface helping easy to support and sustain application.

Need seamless job scheduling with dependency flexibility like control or autosys scheduling

Integrate data from wide range of source for enterprise integration and business decision support system..

Informatica Power center tool for data integration

Does not show data when it flows from different components.

High volume data llad

1.) Reliability and easy to learn

2.) It can integrate any type of data, data format from any data source

3.) Integrates well with oracle and teradata

1.) Custom built tools used to enhance functionality are not readily available

2.) It frequently crashes and the very often the screen gets stuck

Simple interface, worth a trying the 30 day free trial, easy for both user and administrator

Better performance: able to run Multiple huge scale data integration and data warehousing projects can be executed

The complete tool architecture and client tools for the developers.

Version comparison utility and debugger can be improved.

Making data available for reporting from varieties of data sources into single data warehouse that further helps in taking business decisions.

Can implement anything using Informatica PowerCenter

Easy and Flexible to use.

I do not have any to mention.

I like all the features which are included in Informatica PowerCenter.

Solving and processing all providers in Insurance area.

- GUI based Power Data Integrator

- Best in class with tight integration with industry leading databases like Oracle & Teradata

- Always leading with cutting edge features like JSON webservice support, CDC, Cloud, Data Virtualization

- No unified approach to sharing best practices via Informatica portals. Each client & system integrator has own set of best practices/standards

- Custom built tools to enhance Informatica functionality by Informatica Professional Services are not readily/easily available

- Conduct a Proof Of Concept

- Budget for Informatica Professional Services resources in your project planning

- Multiple Large scale data integration and data warehousing projects executed using Informatica PWC

Easy to use and flexible professional and lots of options and compatibility

sometimes its a bit complex with database drivers

its used to load the data ETL , it will handle large amount of data from multiple sources

Dataware house is best stl tool and we have many positions to explore

Nothing is there from my end to dislike it

Through olap system we can give data to end users to do forecast their business

Ease of use through visualization. It's as easy as gathering your requirements and then mapping it out.

Without a 3rd party tool, scheduling a series of workflows to run on a set schedule can be difficult to manage.

Take advantage of demos that are offered through vendors.

By upgrading and implementing Informatica PowerCenter, we are able to retire old ETL tools/systems. Informatica handles the big data more efficiently than the old tools, which benefits the business by saving time and resources.

Will highly recommend this product , it makes charting, reporting very easy, with various building blocks needed to generate exec reporting

The tool sometimes take some hands on learning in the initial stages to get accustomed to.

reporting, retail analytics, data science

Powerful tools, get results very quickly with full functionality

Too many features, easy to make wrong choices if you don't know what you are doing

One of the best data integration tools out there in the market today.

Discover data quickly for timely data delivery

User - friendly and easy to use and better features

They should not come up with many products rather they should concentrate on existing products to improve the quality.

Data warehouse - Warehousing data from different sources and presenting to the business

Informatica can connect to multiple databases without any issues

Needs more tools and more transformations. Also need performance tuning.

Etl requirements.

I like most product Performance and also it's flexibility.

we need to train the consultants with a long time before starting the projects

the business problems we are solving nowadays are mainly focus in extraction, load and transformation issues

Great features. Tight Metadata integration. Ease of use

Pipeline architecture. No control flow (for example loops)

Research. Google is your friend

Use it to load data warehouses for large enterprises