I have used Dataflow, Azure Data Factory, SSIS from Microsoft, and Oracle Data Integrator, but not intensely. Compared to Dataflow and Data Factory, ways for developing source-to-target mappings are more in PowerCenter. Data Factory is bound by the ways defined by Microsoft. PowerCenter provides more flexibility to do it.

View full review »

I have previously used Datastage, an IBM product, the support for which was not proper. Informatica had the provision for moving to the cloud.

View full review »

I previously used SSIS. I used that at another organization and switched jobs. This company uses Informatica.

View full review »

I have used other solutions in the past. For example, I've used SSIS, Talend, and SnapLogic.

It's a use-case question, which solution would make the most sense. We cannot say straight away which will fit in, or which is the best product. However, both PowerCenter and SnapLogic are very good compared to SSIS and Talend.

View full review »

My company uses several tools for integration purposes.

There is a very strong side of usage in our company when it comes to Informatica PowerCenter. Informatica PowerCenter is good for B2B, while there are other tools my company uses to manage in-house integrations. In our organization, we use several types of integration tools, and it all depends on the targets of the users.

View full review »

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

View full review »

In my last job, I used Pentaho. 

View full review »

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

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

View full review »

I did not use a different solution. This is my first experience working with a data center. I did use the ETL from Microsoft that came with the SQL server. 

View full review »

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.

View full review »

Snowflake is something that is surfacing. Every customer is now started asking about Snowflake. They're thinking of it being a viable option. When it comes to data warehousing, it's the kind of a solution that you want to deal with huge among this data processing. 

Most startups and probably smaller companies thinking of building a custom open-source pipeline. It could be Pulsar-based, or Kafka-based. And that is what they're looking at. In enterprises, they don't want to go with a hundred percent, the open-source solutions. They like Informatica or probably Talend or probably some of the ETL tools that are available.

View full review »

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.

View full review »

I have previously used several other tools. However, PowerCenter is very stable. 

View full review »

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

View full review »

I also have experience with solutions from IBM, SAS, and other vendors.

View full review »

We were using a conventional RPG programming tool to do analysis, but every time you add more tables for data analysis, profiling, quality, manipulation, it was turning into pages and pages of code. A user friendly GUI interface like Informatica solution, provided the right kind of solution and was easy to migrate from programming to Informatica.

View full review »

We did not previously use another solution. 

View full review »

We were using the cloud version of PowerCenter with one of our clients, but they have since moved to MuleSoft.

View full review »

Different products are suitable for different use cases. One unified product cannot address multiple use cases. For example, Informatica may not be suitable for real-time integration, but it may be helpful for batch integration. Similarly, MuleSoft caters to low latency, but it doesn't get into high latency, which means it is not suitable for larger data processing systems. That's why we need to have a combination of technologies. For example, I may say that I have a resource or a person who has a primary skill and a secondary skill. Primary skill is specialized, and then secondary skill is complementary to that. Similarly, every product has a primary thing and a secondary thing. For Informatica, it is the batch processing, not the real-time data processing. It only processes the structured data, but it does not process unstructured data. For unstructured data, you need to go for a different product. For the cloud version, they have introduced IICS specifically for catering to the application integration requirements.

View full review »

I have experience with SSIS, and I compared the features. They are different, especially on the navigation front and the user interface. The SQL server integration service is always handy in Azure. Most of the time, you'll be using Microsoft products, so their interface is very user-friendly. But in Informatica, it'll be completely different, especially on the mapping side. When you map from the first to the next target, you have to know how to connect the source and targets. But in SSIS, it's easy for a layperson to understand how the data flows.

View full review »

We have not previously used a different solution. We chose Informatica because we needed an enterprise solution. The problem with Informatica data capture is that it is not an end-to-end solution. We have a different automation solution called Oracle GoldenGate. 

View full review »

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. 

View full review »

Most of my customers use solutions in the cloud so I've used Azure in AWS and GCP. There are lots of services, platform services, or software as a service, tools that are used for the same purposes or objectives, like data governance, data preparation, data integration. It's hard to compare because the environment is completely different and they have different issues. PowerCenter is quite a traditional technology. A product like Hadoop, for example, for storage and process management, has the same objectives but they are fulfilled in a completely different way.

View full review »

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.

View full review »

The legacy solution was using an in-house Java-based ETL, that had huge problems in scaling for high volume batches. As part of the re-platforming exercise, we switched to Informatica so as to get a more stable and standard solution.

View full review »

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

View full review »

I have used the Microsoft Business intelligence for developing SSIS packages for ETL development and Azure has more advantages where ETL development reporting and analysis can be done in a single  environment using synapse analytics 

View full review »

As we are a consulting and data management company, the instruments we have to use during the project are chosen by our customers.

View full review »

Initially, we were doing a custom PL/SQL ETL type of procedure.

We just decided to go to an automated tool, something that was more visual.

View full review »

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.

View full review »

I have been working on ODI (Oracle Data Integrator), but we prefer Informatica.

View full review »

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

View full review »

We have used some other tools, but we found this solution when we had a huge dataset. We felt that PowerCenter was capable of doing the extraction and loading better than other products. We were also using Microsoft SQL Server DTS in the previous year.

View full review »

Our company has always used this solution.

View full review »

No.

View full review »

I used other tools like IBM DataStage. The final decision is made by my clients but what I see is that clients using DB2 prefer to use DataStage over Informatica as both (DB2 and DataStage) are IBM products. View full review »

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

View full review »