In the company I work for, we provide a lot of solutions. I've been working with a lot of clients. The last client I worked with was a big hotel company, and we used this solution for integration.

It's a very powerful tool you can use to load data, get data, do the drawing between the tables, and put it into the packet in a very fast way.

So for this client, we are using the MDM (Master Data Management), and the PowerCenter will be very helpful in building data and merging all the data between the different systems they have. They have a lot of systems that contain the same information and we want to put that into a single place. This is the most valuable feature of this solution which has been of great help to us.

To be honest, we didn't find big issues with this tool. All the issues we found, we were able to fix. We don't have any issues with the tool so far.

I would like to see this solution change the way it creates workflows. In Alteryx, for example, it's easier to build the workflow because of the way it was built, while PowerCenter was built in a more complex way to be able to process a large number of roles. The way PowerCenter creates the workflows is much more complex than the others, but nothing big. It's just that it's the old way. It would be good to recreate the entire interface to make it easier for users to build workflows. This is what I'd like to see in the next release.

I've been using it for 10 years.

The solution is stable. No complaints.

I believe this solution is scalable.

That's a tricky question because it's always complex. For the business logic, it's complex. They had a lot of systems and we had to do the integration between the source. I've been working with this solution for a lot of years, so to me it's straightforward. So that's a tricky question. I would say that for professionals, it's straightforward.

I evaluated Alteryx.

It's Informatica PowerCenter I work with a lot of times, but I also have knowledge on Informatica Data Quality. Now on my last project, I'll be working with MDM, but I'm not an expert on MDM, as I've mostly been working with PowerCenter.

I've been working with this solution since 2010 on a lot of projects which I don't have on top of my head right now. I live in Brazil and I've been working for the government for healthcare where I used this solution. I also worked with PowerCenter for an insurance company. I used this solution during integration where we also created a web API. This is a feature in Informatica that can deploy and make APIs available for third parties or vendors so they can do acquisitions, restore API, and get data. These are what we created in PowerCenter as well.

All the projects were deployed on-premise. I never work on the cloud, but I would love to. Deployment took six months for this project.

We have 30 to 50 people using this solution. If the project goes well, if there are more resources to implement this solution, and more features to improve the analytics of the company, then we will plan to increase usage of this solution.

I'm a PowerCenter guy, so I'm rating this solution a ten.

Data Integration: Integrates heterogeneous source platforms data into the unified data warehouse.

Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse.

Data Integration. The UI-based ability to create data mapping. Also, reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions.

Cost! 

Also, BI features. While Informatica is great for data-integration, it does not have any analytics features. Thus, organizations have to always look for another product for their BI needs.

Our primary use case is to collect data from different sources and to build it for the house or data hub, or to fill already built-in appliances like Cloudera and Teradata. 

It has helped us meet our monetization needs. 

Real time is amazing. If you have AI use cases, you can predict if it's a threat or if it's a positive or negative transaction. You can use real time with PowerExchange to write data directly to Kafka, to consume, write, or parse data using an AI algorithm to detect if the data is positive or negative and to define what use cases you want. 

It would be nice to move from Windows tools (like Developer, Designer, or Manager) and have everything in one place like DATAQ developer, which is eclipse-based and user-friendly. 

CDC needs more improvement. It's stable and has good features, but it's only easy to develop if you are familiar with Linux. 

Sometimes a new monitor will not be accurate in logging or you'll open a log and get a misleading error message. The connection parameter is sometimes inaccurate, or the parameter will not load. Proactive Monitoring doesn't work very well with all of the Informatica processes. The latest version came out five years ago and there has been no enhancement since then. It doesn't make sense for a product to be ranked number one but have no enhancements. The product hangs and you can lose control for several hours. It works, but it hangs. 

I have been using PowerCenter and PowerExchange for around 7 to 8 years. 

It's stable and we rarely have any issues. During the setup, when developers tried to connect, there were some issues, but it ran smoothly once it was configured and fixed. Sometimes, there is conflict between servers (like Analytics, Data Quality, or PowerCenter) and we have problems with loading libraries.

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. 

For technical support, there are levels. The first level of support is called TechAccess and it's between Informatica and other vendors. TechAccess takes time and their response is often delayed. After that, we escalate and go to the Informatica level of support. Once we reach them, they proceed to explain the solution. 

We've tried SSIS and DataStage, but we prefer PowerCenter for stability and monitoring. 

The set-up was simple and I did it myself. If you try it one time, it'll be easy the next time. The one product that does need improvement in installation is Enterprise Data Catalog, EDC. It's very difficult and all my colleagues hate communicating with and installing EDC.

I implemented it myself and with my team. We have expertise, so there was no need to engage Informatica Professional Services. 

The pricing is a little expensive, but in the same range as IBM and other competitors. There is not a big difference in pricing between its main competition. The pricing is mostly the same between other vendors. 

PowerCenter is good for large enterprises and good for ETL purposes, but not for ELT. If you need to go with ELT, Informatica has another package called Data Streaming that's more stable and recommended for a larger environment. 

I would rate Informatica an eight out of ten. 

We are using Informatica PowerCenter for our data warehouse to generate reports from heterogeneous data sources from XML, JSON, or CSV databases. We then do some transformations to generate XML ISO standards to send to regulators in Europe and UK.

We have found the PowerCenter and B2B data transformation most valuable. Additionally, they have many native connectors, high performance, and a lot of support documentation.

The solution can improve by providing more connectivity by having native ODBC or JDBC connections available. It will be easier and more people could start using it.

I have been using this solution for approximately 10 years.

The solution is stable.

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.

The technical support has been responsive and we were in contact with them quickly. We were very satisfied.

The initial setup was easy. The full implementation took approximately two weeks.

Our internal technical team did the implementation and handles the maintenance of the solution. The maintenance team makes sure Informatica services are started and are up and running.

The solution is in the middle price range compared to other solutions. There are additional costs if you want other features. For example, more connectors or the use of other solutions, such as Snowflake.

I would recommend this solution to others.

I rate Informatica PowerCenter a nine out of ten.

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

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.

I have been working with Informatica PowerCenter for 12 years.

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

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

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.

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.

Our primary use is to implement our data warehouse, including moving data between FTP, flat file and relational databases, and Domain/Integrated Service designs.

Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years. Informatica administrators are in the scope of daily operations.

• Import from PowerCenter
• Copy Text between Excel and the Developer Tool
• Logical Data Object Read and Write Mapping Editing
• DDL Query
• Profiles

• XML processing
• Scheduler
• Non-limit SQL qualifier embedded (right now 32K limitation)

The Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design.

With this product, we managed to implement all of our ETL, including those with many sources, and complex transformations.

With this product we can centralize all our ETL needs in one technology. One unique team with the right expertise is responsible for developing, implementing, and tuning it. We eliminated the variety of different solutions and different technologies. This means that the knowledge and skills are not spread-out.

One area for improvement is with huge ETLs, where the product has to extract large amounts of information. That's because some sources wait for others inside the map to finish, and only afterwards do they continue extracting data from other sources in the database.

I've used it for six years.

No issues encountered.

No, but after some errors, the cache directory, where we keep the temp files, fills up, and you have to drop them in manually or have a process to delete unused files periodically.

A fast SSD disk is needed for better performance to locate the temp files.

3/10.

3/10.

We previously used Oracle Warehouse Builder. We switched because Warehouse Builder generated PL/SQL code and the transformation resided inside the database. With PWC, the transformation is on a different server.

The initial setup was complex. There were many performance problems and some migrations took a long time to be implemented. After many meetings with different experts both problems were solved.

We used a vendor team, who were 4/10.

We also looked at ODI (Oracle data integration).

Be persistent in trying to implement all kinds of transformations with Power Center, you will be happy with the final result.