Informatica PowerCenter Reviews

Informatica PowerCenter is a data extraction and data loading tool. We extract data from some sources and we load data to different source systems.

Improved the data integrity, data flow and data managment with consummption too made easy and ustainanble and scalable.

The most valuable feature of Informatica PowerCenter is the flow designer functionally. It is the best out of any ETL tool. Additionally, the solution is reliable and trustable in dealing with large data sources anytime. When we're using billions of data transactions, it's smooth. 

Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user.

In a future release of Informatica PowerCenter, they should add more flexibility on re-usability options. Reusing any setup developed on Informatica PowerCenter, more options to make it reusable, exporting the setup, or importing the setup to any project folder or anywhere in Informatica PowerCenter so that we can use it as a plug-and-play option.

I have used Informatica PowerCenter within the last 12 months.

Informatica PowerCenter is stable. We did not have any downtime.

Informatica PowerCenter could improve its re-usage strategies. There is a scope of improvement in the re-usability of their applications. They could make it more user-friendly for re-usage so that we can create plug-and-play options for different setups.

We have more than 100 people using this solution in my organization.

I have not used the support from Informatica PowerCenter.

Oracle data integrator to Informatica because of reliability and cloud benefits.

The initial setup of Informatica PowerCenter is of a moderate level of difficulty. The full implementation took approximately one day.

When evaluating other solutions we found Informatica PowerCenter to be the most stable.

We had a major banking client, and Informatica PowerCenter is the go-to option when we are dealing with any kind of banking client. It provides the stability and very trustability factor for any kind of banking client's requirements.

This solution has provided me with all functions that I need. I recommend others to use Informatica PowerCenter if they have a decent knowledge of how data migration and data integration works. If they have good knowledge about it and if they have used any other ETL tools previously, they will find it easier to use Informatica PowerCenter. 

If it is for a beginner, I would suggest they learn something about the basics of how data migration works, and then they can start using it.

I rate Informatica PowerCenter a nine out of ten.

I am using Informatica PowerCenter as a data integration tool, and for standardization and validations.

The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness.

Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration.

I have been using Informatica PowerCenter for approximately 11 years.

The stability of Informatica PowerCenter is good.

Informatica PowerCenter application can scale very well.

We have more than 100 users using this solution which includes a mixed variety of work titles or disciplines in the company.

I have used the support from Informatica PowerCenter.

I rate the support from Informatica PowerCenter an eight out of ten.

Positive

The initial setup of Informatica PowerCenter is easy. The full deployments can take approximately seven hours.

Informatica PowerCenter is worth the money to use for its benefits.

We are using an annual license for Informatica PowerCenter.

We did evaluate other options before choosing Informatica PowerCenter. We selected Informatica PowerCenter because it fits the feature requirements of our customers. Additionally, the customization and integrations are easy compared to any other tool.

My advice to others is for them to get used to using the tool and make sure near real-time integrations are less. If they want to keep the configurations and use batch mode data they can do so.

I rate Informatica PowerCenter an eight out of ten.

My experience is in the semiconductor industry with our customers using the Azure supply chain. We have built-in the AIS system, IBM and Db2. We transfer data from SQL Server to MongoDB and transfer the data to Db2.

Security is very important, the solution is deployed to the private cloud. We assigned five people to build the project.

Informatica PowerCenter is built into the technology supply system. I use the solution to transfer the MS data system to the supply chain system.

We use Informatica PowerCenter to transfer the transitional database to and from the data warehouse. This is very efficient as it enables us to quickly find our data reports and the data, so we can build AI models.

In the future, I would like to see Informatica PowerCenter integrate a more powerful dashboard.

I have been using Informatica PowerCenter for 3 years.

In my experience Informatica is stable, however, it depends on our customer's environment.

This solution is scalable. For example, we have set two data warehouses for one of my customers, we use Informatica PowerCenter to join several PV tables separate to data warehousing. This allows us to divide, separate and exchange our data warehousing to the schema and the people in the schema.

In my last job, I used Pentaho. 

The initial setup of the solution is easier than Pentaho. Informatica was set up by me with the help of two supply chain consultants, in one day. 

To implement Informatica PowerCenter you need to understand your customer's systems first and what their requirements are. It is important to understand their existing system and find the data. By understanding their logic, you can know how to extract the data and transfer the data to the data warehouse.

Informatica PowerCenter is reasonably priced. It is less expensive than Pentaho.

There is a standard version fee in Taiwan. It is a one-time yearly subscription price that is approximately $3,010 US dollars for three users.

This is my first experience with this kind of tool, I would rate Informatica PowerCenter a nine out of ten.

I'm working for a casino, and we use this solution in our company to replicate different databases, such as from Oracle to Teradata. Most of the time, it is used for replication, but sometimes, it is also used for doing some calculations, additions, or unions for ETL.

It is currently deployed on-premises, but we will be moving to a cloud solution by the end of the year. We are currently doing a proof of concept and evaluating a cloud solution from Informatica.

The support is valuable. There are also open-source ETL products, which work very well, but there is no support. When we face a production problem, being able to get support is valuable, and it brings efficiency. With an open-source solution, we can't engage anyone to resolve the problem as quickly as possible.

Its stability is high, and it is also scalable.

Some of the conversions are done inside the product. We use work tables that are created by the engine itself, but the names of the work tables are very long, and they don't have any meaning, which makes it a bit difficult to understand and follow exactly what is happening inside.

We would like to be able to communicate with our Google Cloud platform. This feature probably exists, but I'm not sure if we tested it. 

It is very stable.

It is scalable. There are no problems. It is only a financial matter. You just need to have more machines. The price changes depending on the number of CPUs that are involved. 

We have 24/7 support because it belongs to the production environment. We just have to open a case, and somebody takes up the case and provides an answer. They also call back, and there is also a knowledge base.

We had Sybase ETL, but it was not exactly for the same use. We also had some homemade solutions between Db2 and Teradata. We switched because to deal with more databases, it was easiest to use a real ETL solution.

It isn't complex. In the beginning, we have to test and try different parameters. Once that is complete, it is done for all the processes. If we have some trouble, we can call support, and most of the time, we can find people to help us in choosing the right parameters from different parameters.

The complete implementation—which includes doing the proof of concept, understanding how it works and what work has to be done, migrating all existing workflows—took over six months.

We implemented it ourselves.

I would rate it an eight out of 10. It works.

Informatica PowerCenter is purely an ETL tool used for data integration.

Informatica PowerCenter has many features compared to Talend, DataStage, and Airflow. Among all the solutions I have used, I found Informatica PowerCenter to be much more stable in terms of application. Also, one won't face issues related to bugs when using Informatica PowerCenter.

Compared to solutions offering similar functionalities, Informatica PowerCenter is not very flexible regarding customized integrations. It's not a very customizable solution.

I have been using Informatica PowerCenter for approximately nine years. So, I work for different consulting companies, and their customers use it. My job role is of a consultant and architect.

Since one does not have to face sudden issues while using the solution, I would say that it is a stable solution compared to similar solutions in the market.

It is not a very scalable solution. It is usually used in enterprise-sized organizations.

The solution is easy to deploy and manage. I also usually help my customers to implement and configure the product. The time taken for the implementation process depends upon how big of an implementation process has to be carried out. So, for a single customer, it took around three days to deploy the solution. However, three months were required for the customization part. The solution gets deployed on-premises and on the private cloud.

I rate the overall product a seven out of ten.

Informatica PowerCenter is an ETL data integration platform.

It's all part of the data warehouse's extract, transform, and load process. Data is extracted from all source systems, transformed, and loaded into a data warehouse.

It is very robust, scalable, and simple to use.

It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective.

I believe that people are shifting to more agile, flexible platforms not only in this era but also in the last two or three years. This is happening not only on data management platforms but also on analytics platforms. Platforms for visualizing data dashboards. We used to have very rigid tools like Cognos and MicroStrategy, but Tableau and Power BI have recently taken over. The same can be said for data management. 

Informatica, in my opinion, is very rigid and not very flexible, whereas platforms like Alteryx or Matillion are very flexible and agile.

I have over 15 years of experience working with Informatica tools, and we have worked with Informatica PowerCenter in the last 12 months.

Informatica PowerCenter is stable. On a scale from 1 to 10, I would rate it a ten.

I haven't had any problems with jobs or projects failing or anything like that.

You can definitely scale it as the data volume increases. You have many options for scaling up.

The technical support is great.

They are responsive and simple to contact.

While I have not implemented it, I am familiar with Informatica PIM.

We have also used Informatica Cloud in the last 12 months.

The installation and configuration are both well-documented and straightforward.

I am not sure about the most recent price, but I think it should be $100,000 or more.

It's obviously the best.

I would rate Informatica PowerCenter a ten out of ten.

We are generally using it for ETL systems. 

We have different sources of files coming, sometimes from the mainframe, and Informatica is very useful for accepting different sources, such as spreadsheets and databases, and doing the transformation. Libraries are also helpful. I also managed to go into the database and create my own transformations for mapping automatically.

The greatest feature is that it is very easy to have someone come in and jump right in. It is one of the nicest tools in terms of getting a person acquainted quickly.

What I didn't like about it is that the platform itself is not great at distributed processing. When you need high parallel processing, it has some inherent issues. We had to use Java transformation, and it did not go very well. I have heard that it is going to the cloud, but we haven't tried that. We have Informatica in-house, and we thought it would go with ADF. Microsoft is leaning on us to do that because we're working with Azure. So, I don't know much about cloud features.

The pricing model is a little bit difficult for development tools versus running the system in production. So, it has some shortcomings, but in general, it is not bad.

We worked with PowerCenter for a long time, and we have a site license for it.

We haven't had major problems. The issues that we had were more around libraries linking to other places. It was not so flexible there. For example, we used a Java transformation that needed a separate set of libraries, but they collided if a library was used by Informatica. So, we had to stay a version earlier. Although it seemed a little bit rigid on what it can provide in terms of the ability to go into the database and create your own stuff, I wrote a makefile that actually went into the database, and based on the parameters that people put in the makefile, created transformation for them.

I wasn't impressed with its ability to process in parallel. Some of it is inherited in the tool, and there is nothing you can do about it. For example, if you have aggregation, then everything stops, which is okay and I understand that, but for the other things also, I didn't see it scalable. I have heard that it is better in new releases.

I work with Azure Data Factory and Informatica PowerCenter, and we are now considering taking either of them. We did work with PowerCenter for a long time, and we have a site license for it. With ADF, we're just starting.

We have a site license, but we do pay by the division.

I would rate it an eight out of 10.

Informatica PowerCenter is a data integration tool. We use it as an extract, load, transform tool and we can transfer data from production to test or to any other environment.

We have several use cases. For example,  we use it to create data warehouse applications, which are used for analytics and to help generate business value.

Another use case is to modify a test environment such that it is compliant with GDPR regulations. We can use it to transfer production data to a test environment for the purpose of facilitating our testing. Another use case is that if we are working on a data warehouse application, it can be used to extract data from different sources to load into the target environment.

The most valuable features are that it is quick and easy to use. Anybody can master it in a short time.

The interface is very clean and clear.

This tool integrates with distributed systems.

I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases. As it is now, writing custom transformations is not user-friendly.

I have been working with Informatica PowerCenter for approximately two years.

This is a stable product.

Informatica PowerCenter is scalable.

We have one person in the company in charge of administration. 

I am part of a seven-person team that uses it, although there are a lot of other applications in the company that make use of PowerCenter. The number of users overall is huge.

We plan to increase our usage in the future.

Our admin team is from Informatica, and if we have any problems then we contact them. For example, the tool that I work on directly interacts with PowerCenter, where PowerCenter works as a backend for my application. If I have connectivity issues or need special access to PowerCenter, I contact the admin team and they help me to sort out the issues.

Prior to PowerCenter, I used an open-source tool called Talend. It was not very good.

The installation is not complex. It is easy to do because you just need one database, such as Oracle, set up as the backend, and some executable files.

I was not involved in the deployment. Another team in our company was responsible for it.

The licensing fees are paid on a yearly basis.

In summary, this is a good tool and I definitely recommend it. It integrates with distributed systems and if the use cases involve data ETL then this is the best tool to use.

I would rate this solution an eight out of ten.