Informatica PowerCenter Software Reviews
Aug 01 2019
Assists us with integration as we migrate from on-premise to cloud, but it needs a performance analyzer
What is most valuable?The two most important components are the building and integration. On top of that, you can clean and analyze your data to make sure that you don't have any corruption. In the end, you have structured, proper data for use in an integrated… more»
What needs improvement?I would like to see the inclusion of a tool that allows you to report performance metrics. For example, it can determine whether the connectivity is correct, or how long it's taking the integration to move data from one place to another… more»
Which solution did I use previously and why did I switch?We did not have another solution in place before this. We knew that it was something that we needed to do. Since we are moving from on-premise to the cloud, we needed something to help us with the integration.
What other advice do I have?There is a lot of competition in the space, and the vendors want to get good companies where they can implement their solution. It doesn't mean that every product fits every organization. My advice for anybody researching this type of… more»
Which other solutions did I evaluate?Choosing this solution was a little bit complex for us because there are a lot of different vendors in that space. We had to do a proper evaluation and negotiation to get to the solution that we needed. Some vendors offer a certain package… more»
Aug 07 2019
Informatica PowerCenter mainly performs ETL that is able to extract transform load from a variety of data sources and it has a good GUI interface.
What is most valuable?There are two valuable features. The first is the main typical functionality that the PowerCenter gives, that is the ETL. The ETL is able to extract transform load from/to a variety of sources, like Oracle, Microsoft's SQL Server, and Big Data. The second is the capabilities of the GUI interface… more»
How has it helped my organization?Informatica PowerCenter satisfies our customers need; thus making Extract Transform Load from data base to data warehouse based on specific business rules.
What needs improvement?The licensing cost for Informatica is very high. Other all-in-one solutions offer much lower prices. Also, sometimes with data capture, the solution doesn't support some data types so you must find an alternative, Informatica Data Replication, for instance. You end up buying two very expensive… more»
What other advice do I have?Our company has many locations, in the Middle East and Africa, but we're mostly based in Cairo, and have about 100 engineers using the solution. In terms of advice, I would give to others considering using the solution, I'd say this: they should start with a datasheet of every product on… more»
Find out what your peers are saying about Informatica, Microsoft, Oracle and others in Data Integration Tools. Updated: January 2020.
391,616 professionals have used our research since 2012.
Dec 30 2019
What is most valuable?The solution is a very helpful product for data integration. The partitioning and optimization to help enhance our development is a very valuable aspect of Informatica PowerCenter. There are multiple transformations for service consumers to publish and use web services as well,In addition to the ability to implement ETL and ELT n a very easy way and finally, you have structured data for use in an… more»
What needs improvement?The multiple interfaces in Informatica PowerCenter are not great for the user experience. Because of this, I think it can cause confusion for any beginner developer. When we are dealing with multiple transformations and mapping, we cannot see the flow of our transformation until we run reports. It is not like Informatica Developer, where we can see every step of what we're doing and the flow of… more»
What other advice do I have?I'm working with a lot of Informatica products. I use Informatica PowerCenter and IDQ as well as Informatica Axon. In terms of Informatica Powercenter, we're not using the cloud. We have it running on our own servers. Overall, I find that it's a very helpful product and a powerful tool compared to other products. I would rate this solution eight out of ten.
Jul 21 2019
What is most valuable?The solution has the best user interface and it's the most user-friendly of all data integration tools.
What needs improvement?Now they are migrating to a new version, and they have something that is called Informatica Developer. Previously, they just had PowerCenter. Now, when they move everything to Informatica Developer it's not as good or stable like it was… more»
What's my experience with pricing, setup cost, and licensing?Price-wise, it's more expensive than SSIS, but it's a better tool, so it has more features. Licensing is on a yearly basis.
What other advice do I have?We have some projects on call. I work for a professional services company, so we have different clients that have different types of infrastructure. For us in our region, most of the clients have an on-premise infrastructure. Usually, we… more»
Which other solutions did I evaluate?We looked at IBM DataStage, Microsoft SSIS, and Oracle Data Integrator.
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 added the feature we were thinking about in 10.1.
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 health insurance, you don't know whether you will get sick… 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 it depends what your needs are and whether you can… more»
Which other solutions did I evaluate?When you want to convert all your company products into Microsoft, the equivalent to the Informatica product in Microsoft is SSAS. That's where the decision was made to go with the SSAS as the primary… more»
Oct 18 2019
What is most valuable?The most complex task, in this case, was to read and transform BLOB data, and Java transformation in Informatica Power Center was a great solution. The second task that was solved with Java transformation was the correct transformation of… more»
How has it helped my organization?Informatica PowerCenter moved forward the technology level of ETL-process management of the bank with visualization and standardization of ETL development instead of a huge volume of scripting used previously. Moreover, the task of… more»
What needs improvement?I hope that the next release of this solution will: * Work with HADOOP and other BigData solutions. * Have an ability to compile code to run it quicker. * Include new features for parallel job execution. * Include more instruments for LOGs… more»
Which solution did I use previously and why did I switch?As we are a consulting and data management company, the instruments we have to use during the project are chosen by our customers.
Which other solutions did I evaluate?We are also using IBM DataStage, Oracle Data Integrator, SAP Data Services. From project to project it's up to the customer.
Aug 01 2019
What is most valuable?The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand.
What needs improvement?I would like to see an improvement in the digital adoption. It would be nice if they could be cheaper, because the training is very expensive as they do everything online.
Which solution did I use previously and why did I switch?We previously used a Microsoft solution but that was not very scalable. That is why we switched to Informatica, as it is much more scalable.
What other advice do I have?I rate this solution an eight out of ten and I will recommend others to use it, even though it is a little expensive, compared to other solutions.
Aug 05 2019
What is most valuable?The stability of the solution is one of its best features. The user interface is also very good.
What needs improvement?The cost and set up of the licenses could be improved. You need a lot of different licenses, depending on your setup, and it gets expensive. For example, we're connected with Oracle, be we need licenses for that plus the core server, Terradata, etc. It gets costly. There's also a feature that exists on IBM DataStage called CDC. It's not on Informatica PowerCenter, but if they could add a feature… more»
What other advice do I have?We use the on-premises version of the solution. I'm a consultant, and I largely work with enterprises. I would recommend the product for integration. It's one of the best tools in the integration field. I would rate this solution nine out of ten.
See 4 More Informatica PowerCenter Reviews
User Assessments By Topic About Informatica PowerCenter
Informatica PowerCenter Questions
Read Archived Reviews
What is Informatica PowerCenter?
Enterprise data integration platform to help organizations access, transform, and integrate data from a variety of systems.
Also known asPowerCenter
Informatica PowerCenter customers
University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank