IT Central Station is now PeerSpot: Here's why
Information Technology Security Analyst at a tech services company with 10,001+ employees
Real User
Easy to set up and quick to deploy, good support, and unstructured data can be imported
Pros and Cons
  • "What I like the most is that we have to deal with less while writing the queries."
  • "I would like to see it be able to import data from NoSQL."

What is most valuable?

What I like the most is that we have to deal with less while writing the queries.

The unstructured data can now be imported into Informatica PowerCenter. This is an achievement for them.

What needs improvement?

I would like to see it be able to import data from NoSQL.

For how long have I used the solution?

I have been using Informatica PowerCenter for approximately three months.

What do I think about the stability of the solution?

It's a stable product.

Buyer's Guide
Informatica PowerCenter
July 2022
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: July 2022.
619,967 professionals have used our research since 2012.

What do I think about the scalability of the solution?

We are using this solution for seven to eight hours per day. We are using it frequently.

Informatica is scalable, it's perfect. There are no changes required for this solution.

How are customer service and support?

We have not had any issues with technical support. They are fine.

Which solution did I use previously and why did I switch?

I started coding in SQL, then looked up Informatica directly.

How was the initial setup?

The initial setup is not that complex.

It takes less than a day but more than an hour to deploy this solution.

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

We are satisfied with the pricing. The licensing is on a yearly basis.

What other advice do I have?

I would definitely recommend this to my friends as well as anyone who is interested in using this solution.

I would rate Informatica PowerCenter a ten out of ten.

Which deployment model are you using for this solution?

Private Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Senior Data Architect at a manufacturing company with 10,001+ employees
Real User
Top 5Leaderboard
Cloud-based, good performance, stable, and connects well with multiple sources
Pros and Cons
  • "The number of docs has been reduced drastically, which is very good."
  • "The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."

What is most valuable?

We like that it is cloud-based and the performance is good. The number of docs has been reduced drastically, which is very good.

What needs improvement?

If you were migrating or connecting with multiple sources, initially there were issues that caused network latency. In the latest version, there are fewer bugs.

The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement.

Being able to generate reports on all of the status of the monitoring tools and the job qualities would be very helpful to provide to the operational team.

For how long have I used the solution?

I have been working with Informatica PowerCenter for 12 years.

We are using version 10.4.1, which is the latest version.

What do I think about the stability of the solution?

It is very stable. It's a solution that has been in place for 20 or 22 years.

How was the initial setup?

The initial setup is straightforward. It is very easy.

When compared with Linux or Windows, it was very easy and simple to install.

It takes two days maximum to implement one nanometer.

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


What other advice do I have?

When compared with other ETL or ELP tools, Informatica PowerCenter is the best for connecting to multiple sources, which is better when you have large loads. 

I would definitely rate Informatica PowerCenter a nine out of ten.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Buyer's Guide
Informatica PowerCenter
July 2022
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: July 2022.
619,967 professionals have used our research since 2012.
SureshSwaminathan - PeerSpot reviewer
Senior Software Engineer at Depository Trust & Clearing Corporation
Real User
Top 20
Doesn't require many resources but it is lacking monitoring features

What is our primary use case?

We use it for ETL. We have multiple systems, we extract the data, and create a report from it. 

What is most valuable?

If the systems get migrated or upgraded, the amount of resources required are very minimal. We can change the connections and establish a new connection. It's very helpful.

What needs improvement?

We need another tool for monitoring. It would be easier if all the features were consolidated into one tool.

For how long have I used the solution?

I have been using PowerCenter for two years. 

What do I think about the scalability of the solution?

We don't have any problems with scalability. You can increase the nodes and it has good performance. 

We have around 25 users. 

We have two to three employees for maintenance. 

How are customer service and technical support?

I haven't had much experience with Informatica's support. We haven't had any issues that we needed their help for. 

How was the initial setup?

The initial setup was complex. It depends on the security you're working on. There are no pre-defined rules. We have to create the rules and then start working on it. 

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

It's very expensive. We have other tools that are more reasonably priced. PowerCenter is very costly. 

What other advice do I have?

I would recommend PowerCenter depending on the use case. 

I would rate it a seven out of ten. 

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
RemonHanna - PeerSpot reviewer
Data Engineer at a tech services company with 51-200 employees
Real User
Top 20
Feature rich, user-friendly, and straightforward installation

What is our primary use case?

We are using Informatica PowerCenter for data integration in a health insurance company.

What is most valuable?

The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness.

What needs improvement?

The performance of Informatica PowerCenter could improve.

For how long have I used the solution?

I have been using Informatica PowerCenter for approximately five years.

What do I think about the stability of the solution?

Informatica PowerCenter is a stable solution.

What do I think about the scalability of the solution?

I have found Informatica PowerCenter to be scalable.

How are customer service and support?

I have not used the technical support from Informatica PowerCenter.

Which solution did I use previously and why did I switch?

We have used Data Quality, EDC, Axon, and Metadata Manager.

How was the initial setup?

The initial installation of Informatica PowerCenter was straightforward. The amount of time it takes for the process depends on the deployment site, and how many maps, workflows, and tables there are.

The time it took used for the deployment was approximately two hours.

What about the implementation team?

For the implementation of Informatica PowerCenter, we used one or two developers and one person from the DBA team.

Which other solutions did I evaluate?

I did not evaluate other options.

What other advice do I have?

I rate Informatica PowerCenter an eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Associate Director at a consultancy with 1,001-5,000 employees
Real User
Top 20
Good performance with easy to use interface; good documentation provided
Pros and Cons
  • "Good interface, reasonable documentation."
  • "Lacks ability to calculate cost of the product."

What is our primary use case?

Our primary use case of this solution is for building data warehouses for clients with data visualization tools. We need to pull data from other sources so we use Informatica as the ETL. The solution is generally deployed on-prem but sometimes on cloud. 

What is most valuable?

The solution provides good performance with an easy to use interface and reasonable documentation.

What needs improvement?

One of the things that I found lacking is that there should be some sort of a calculator where you can input your requirements regarding the number of data switches required, number of users, and the number of data switches in order to get a general idea of cost. It would save me time rather than having to run to the company to get the information. 

What do I think about the stability of the solution?

The solution is stabl. 

What do I think about the scalability of the solution?

It's a scalable solution. 

How are customer service and technical support?

I haven't had any issues with technical support. 

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

This is an expensive solution.

What other advice do I have?

I would rate this solution an eight out of 10. 

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Lead BI&A Consultant at a computer software company with 10,001+ employees
Real User
Top 10
Stable, easy to install, and has a good graphical user interface

What is our primary use case?

We use this solution for ETL processes.

What is most valuable?

It has a very good graphical interface.

It has the possibility to intervene in the automatic ETL. 

It has a lot of components. 

It has a Data Catalog that uses the Model repository.

What needs improvement?

The pricing could be improved.

For how long have I used the solution?

I have been providing Informatica PowerCenter since 2005.

What do I think about the stability of the solution?

Informatica PowerCenter is a very stable product.

How are customer service and technical support?

Technical support could be faster.

How was the initial setup?

The latest versions are easy to install because it's cloud-based. You needed approximately four hours to install the older versions.

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

It's quite expensive.

Our customers pay a licensing fee yearly.

What other advice do I have?

I would recommend this solution to others. It is also a question of the purpose and how big the company is. It's an investment.

I would rate Informatica PowerCenter a nine out of ten.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Team Lead Manager at a manufacturing company with 10,001+ employees
Real User
Excellent technical support and an easy setup
Pros and Cons
  • "The technical support is excellent."
  • "There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."

What needs improvement?

PowerCenter has yet to announce additional features. The face that it has not made improvements is fine, as it is very easy to integrate. We are in touch with the vendors of products other than Informatica PowerCenter. 

The reason I chose to rate the solution as a nine out of ten is because there is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce. 

For how long have I used the solution?

I've been using Informatica PowerCenter for more than 16 years.

How are customer service and technical support?

The technical support is excellent.

How was the initial setup?

The initial setup is easy.

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

The price is mostly reasonable. 

What other advice do I have?

I am satisfied with the solution. 

I rate Informatica PowerCenter as a nine out of ten. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Raghavendra Rao - PeerSpot reviewer
Solution Architect at Refinitiv
Real User
Top 5
Modern features needed and lacking migration tools

What needs improvement?

Informatica PowerCenter is outdated and would benefit from modernization. They should have a very good migration strategy from Informatica PowerCenter to AACF. Informatica PowerCenter there is no point in using it, you have to use a cloud version.

For how long have I used the solution?

I have been using Informatica PowerCenter for approximately 17 years.

How are customer service and support?

The technical support for Informatica PowerCenter is good.

I rate the support from Informatica PowerCenter a four out of five.

What other advice do I have?

I would not recommend anyone use this solution.

I rate Informatica PowerCenter a one out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Buyer's Guide
Download our free Informatica PowerCenter Report and get advice and tips from experienced pros sharing their opinions.
Updated: July 2022
Buyer's Guide
Download our free Informatica PowerCenter Report and get advice and tips from experienced pros sharing their opinions.