Informatica PowerCenter Scalability
YT
Yahya Tlaghi
Developer, Architect at L'Oreal
As we work on on-premise environments and the environments are fixed, we're unable to check how scalable Informatica PowerCenter is.
View full review »When we want to scale up with more CPUs, we have to extend the license or shift to a new server with better CPUs.
View full review »AS
Ankit Sinha
Associate Manager at Accenture
In my team, around 15 people, that includes engineers and developers, use the solution.
Scalability-wise, I rate the solution around a seven out of ten.
Buyer's Guide
Informatica PowerCenter
March 2024
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.
MS
Mukul Shukla
Assistant Manager at a insurance company with 10,001+ employees
It is a scalable solution. But its licenses are costlier compared to cloud infrastructure.
View full review »The scalability is okay. I'd rate the ability to extend seven out of ten. We have had problems with large volumes of data.
This is a very popular tool and is used quite extensively. I'm not sure if we plan to expand usage in the future. It would depend on the future development of Azure Data Factory.
View full review »PB
Pavan B
Technical Manager at Agriitex
Scalability is limited since it's on-premise. PowerCenter is mostly implemented on-premises only, so it's all based on how we configure it, the number of nodes, et cetera. Few people can even deploy it in the cloud VMs, where they can scale up and scale down in the background. For Informatica, the license is based on the number of cores. You have to scale within the number of cores only.
We have more than ten people working on the solution currently.
View full review »HK
Hava Kafka
Developer and Team Lead at ZIM
I use the product in my company, which is in the business of shipping containers.
Presently, I don't see the product's scalability features since our company works with it, but any changes or improvements in our environment with the use of the existing tool that is installed have been seen. I have not experienced any changes recently in our environment with the use of the tool.
Three people from my team work with the product in my company.
My company does not plan to increase the use of the solution.
VS
Vineth Suresh
Senior Associate at PwC Acceleration Centers
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.
View full review »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.
View full review »DC
DanielChiu
Director at Lolatech
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.
View full review »It is not a very scalable solution. It is usually used in enterprise-sized organizations.
View full review »RR
reviewer1080585
Practice Head - Advanced Analytics & Cloud at a computer software company with 201-500 employees
You can definitely scale it as the data volume increases. You have many options for scaling up.
View full review »CC
reviewer2123568
Senior Oracle Database Administrator at a financial services firm with 1,001-5,000 employees
GF
Gully François
Computer system engineer at Groupe Casino
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.
View full review »The solution is scalable.
We have three or four clients we are working with in terms of Informatica.
View full review »GB
reviewer1734582
Director at a financial services firm with 10,001+ employees
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.
View full review »SG
reviewer2116809
Solution Design Expert at a pharma/biotech company with 10,001+ employees
PowerCenter is not scalable, however, the cloud is very scalable.
We have 100 developers on the solution.
View full review »The solution is scalable. Around 50 employees are using the solution every day at our company. We would like to continue using it and also evaluate using the cloud version.
View full review »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.
View full review »MA
reviewer1245828
CIO at a tech services company with 1,001-5,000 employees
We have approximately eight people who use Informatica in the organization.
View full review »Informatica can handle extremely large volumes of data very well. With features like CDC, Incremental Load, Mapping Parameters and variables, dynamic look-up, pre and post SQL, Informatica provides flexibility in handling huge volumes of data with ease. Certainly a lot depends on optimized mappings and work-flows (batching and performance tuning).
View full review »AE
Afthab Ellath
Enterprise application architect at Ministry of Health
You can easily scale the solution if you need to.
I'd rate the ability to scale 4.5 out of five.
We have around 100 or more sources using the solution.
View full review »I rate Informatica PowerCenter 7.5 out of 10 for scalability. It has limited options for connecting with real-time applications, such as IBM and cloud applications.
View full review »I believe it is a scalable solution, but I do not have all the details on scalability. For example, in AWS, there are databases like PostgreSQL, SQL and Oracle. So, it would be good if, for a specific price, Informatica PowerCenter could be available in Azure or have the ability to use Azure in the ETL tool.
About six to seven developers use Informatica PowerCenter in my company.
View full review »AT
reviewer1318821
Technology Director at a computer software company with 1,001-5,000 employees
It is easy to scale. It has the concept of a grid, but it is too costly because you also need Informatica big data edition. Informatica PowerCenter has its own software licensing called big data edition. So, whenever we want to scale to a huge volume, we need to go with big data. It has horizontal scaling, which always impacts the price. I can go for a four-node cluster grid or an eight-node cluster grid, which will have an impact on the price.
We have scaled it for one of our enterprise customers, and we had a little bit of complexity in setting it up, but we were able to achieve the desired goals with respect to the performance.
VJ
Vasubabu Jetty
Principal Consultant at Genpact - Headstrong
Informatica PowerCenter is a scalable solution. Expanding is easy, and we can execute multiple workflows based on events. I don't see any constraints, and it looks pretty good. We have approximately 50 or more people supporting or developing applications for various clients.
View full review »The scalability of Informatica PowerCenter is good.
We have approximately seven people using the solution.
View full review »CR
reviewer1342140
Business Intelligence Architect at a manufacturing company with 10,001+ employees
This solution is stable.
PS
reviewer2042916
Analytics Insights - Manager at a consultancy with 10,001+ employees
The solution is scalable. However, it depends on the server.
You can scale unless the server on which it is hosted does not have enough resources to handle the additional load.
In our organization, most developers are on the product. There are around 50 people at least using it.
View full review »FN
Franklin Nascimento
Principal Associate at Data Meaning, Inc.
I believe this solution is scalable.
View full review »RS
SeniorEtddda
Senior ETL Developer at Office of State Revenue
The solution is scalable. They have a cloud version for a small company. So nowadays start-ups or small companies are using the cloud version, while the big companies like banks and insurance companies are using the full-fledged enterprise version. We have about 100 users in our company and we plan to increase our usage of Informatica PowerCenter.
VN
reviewer1640310
Technical Lead at a financial services firm with 5,001-10,000 employees
We have approximately 40 people using this solution regularly in my organization.
The solution is not as scalable as the cloud solutions, we will be releasing it in a few years.
View full review »RP
Ricardo Pedro
Solutions & Achitecture Data Analyst Specialist at a construction company with 10,001+ employees
We performed some testing with our Asian platform and it was working fine. We are working in several countries at the same time, integrating their products, and we are hoping that it goes as smoothly as the one from Asia. This tool should allow us to scale, but we will have to wait and see.
We have between fifty and sixty people using this solution.
View full review »Not many scalability issues were experienced.
View full review »IB
IhabBekhiet
Service Delivery Manager & Data Governance Consultant at Master Works
It's easy to scale, but it has a limit. For high availability or for service on the grid, it's okay, but it has a limit. If we had the option to enable scalability based on big data architecture, like Adobe or MongoDB, it would be easier. In Enterprise Data Catalog (EDC), you can extend them by adding nodes to the cluster, but currently, to maintain scalability in both centers, you'll add a node, join the domain after that to distribute work, but fortunately, this works well. We also got a complaint, when adding a node, that the session failed without recovery.
View full review »The scalability is fair enough.
PowerCenter is suitable for large companies. The pricing could be an issue for some companies who want to implement and develop with PowerCenter.
View full review »VS
Vijaya Saduvuv
Lead Application Developer and Informatica Administrator at a healthcare company with 501-1,000 employees
Scalability, durability, everything. It is the leader in the market.
View full review »NM
reviewer1094502
Principal Consultant at a tech services company with 501-1,000 employees
Informatica PowerCenter is easy to scale.
View full review »Our data engineers are dealing with big data and large files which Informatica is capable of dealing with.
Any feature that PowerCenter doesn't provide can be found in IDQ. IDQ covers any missing options, so I think it's PowerCenter's scalability is fine.
View full review »DS
reviewer1643280
Resource Manager at a computer software company with 1,001-5,000 employees
Scalability could be improved, as it is of an intermediate level.
We have plans to increase usage.
View full review »It's scalable and can be supplemented by a Data Quality solution.
View full review »DL
reviewer1293765
Data Architecture/Management at a consultancy with 10,001+ employees
We have three different instances of this running. There is one for development, one for pre-production, and one for production. As far as having to scale linearly, we haven't had the need by putting additional nodes for high availability or load balancing. It's not something that we've necessarily needed. We have not scaled up, either. So, no vertical and no horizontal scaling. It was pretty much used out of the box.
We have two people who are using this solution and they are developers.
View full review »KG
reviewer1488372
Associate Manager at a consultancy with 501-1,000 employees
It is not scalable. Currently, we have three users of this solution.
View full review »KS
reviewer1498596
Senior Consultant at a computer software company with 1,001-5,000 employees
It has a cluster repository kind of thing where you can add multiple server nodes.
View full review »A fast SSD disk is needed for better performance to locate the temp files.
View full review »AR
AliRaza1
Senior Technical Lead at Speridian Technologies
Informatica PowerCenter is a scalable product.
View full review »SS
SureshSwaminathan
Senior Software Engineer at Depository Trust & Clearing Corporation
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.
View full review »For scalability, all you have to do is buy licenses for more cores, so it's about licensing. If you want to add more CPU cores you have to pay more licensing. All of the providers of ETL tools have different licensing models, and it's something that is typical. So, if you have to process more data then you have to pay for more licenses. That's natural.
We have about 50 users and they're developers and consultants.
View full review »I have found Informatica PowerCenter to be scalable.
View full review »SK
reviewer1491816
Senior Architect at a computer software company with 10,001+ employees
Informatica PowerCenter is highly scalable. Whether it's 4000 records, one million records, or ten million records, we did all these use cases, and it was fine.
View full review »MK
MohamedKhamis
Data Scientist at IME
The solution is very scalable but at the same time, it is very expensive. It's a scalable platform and is distributed, but on the other hand, you have to pay for many separate things. For instance, a real-time integration like a cloud connector for grabbing data from the cloud may be advantageous, but the disadvantage is that the whole package would cost a very huge amount of money for the license.
View full review »It is easy to scale the solution.
View full review »Yes, there can be scalability issues. Huge amounts of data ingestion will impact performance.
View full review »The product scales very well, beyond our needs.
View full review »DD
reviewer1407579
Associate Director at a consultancy with 1,001-5,000 employees
It's a scalable solution.
View full review »AE
AmanyEldaly
Data Engineer at a tech services company with 51-200 employees
The solution is good for scalability because it can be supplemented by a Data Quality solution ,Also, if our organization needs the scale increased, Informatica can satisfy this need, because it can deal with different types of sources and a huge amount of data. The features in partitioning and data optimization that Informatica uses make it very powerful.
TV
reviewer1448301
Information Technology Security Analyst at a tech services company with 10,001+ employees
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.
View full review »Buyer's Guide
Informatica PowerCenter
March 2024
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.