Data Analytics Director at a computer software company with 1,001-5,000 employees
Real User
Versatile, robust, and great for large-scale organizations
Pros and Cons
  • "The product is scalable and excellent for enterprise-level organizations."
  • "Cost-wise, it could be better."

What is our primary use case?

We primarily use the solution for data integration, management, and more recently, data cataloging in the lineage.

What is most valuable?

It's great as a unified enterprise data management platform. It's useful for cross-platform functionality.

The solution is stable.

The product is scalable and excellent for enterprise-level organizations.

Technical support has been good.

What needs improvement?

Cost-wise, it could be better. Informatica has a bit steep upfront cost. Upfront, it requires upfront investments. Many models of Informatica still require licenses. I would really like to see Informatica moving more and more into pay as you go model, so to move completely from CapEx to OpEx.

For how long have I used the solution?

I've personally used the solution for many years. 

Buyer's Guide
Informatica Cloud Data Integration
March 2024
Learn what your peers think about Informatica Cloud Data Integration. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
769,479 professionals have used our research since 2012.

What do I think about the stability of the solution?

The product is stable. They've been on the market for many years. They're key industry players.

What do I think about the scalability of the solution?

Everything is scalable nowadays,

Normally, I wouldn't offer Informatica for small clients - small or medium enterprises. It's an enterprise-grade solution. We are talking about many, many users.

How are customer service and support?

I have some experience with technical support and found them to be good enough.

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

We've used a combination of different solutions.

Informatica is really versatile, robust solution. That said, there are competitors on different levels for Informatica. For example, for MDM, master data management, Prophecy, would be good, for example.

How was the initial setup?

Normally, if you implement a complex solution, not only the data integration model of Informatica, like PowerCenter, and more of a complex solution, like an enterprise data management platform, it's a multifaceted, multi-phase approach.

The deployment depends on the client's requirements, however, normally, I would say it's something that we would be planning for as a baseline for around one year, or maybe 10 to 12 months.

The deployment itself is never on-premises. It's public cloud mostly. Informatica can be deployed on Azure, on Amazon, and on the Informatica cloud as well.

Maintenance can be really straightforward if it's only one model like data integration. Maybe a few guys would handle it. However, if it's a complex enterprise-level implementation, again, enterprise data management platform with multiple components, multiple integrations between them and with the legacy stack on the premises, off-premises, then it's a big, and maintenance can require ten to 12 people. 

What about the implementation team?

We are an integrator for Informatica. We can help clients deploy it.

What was our ROI?

I'm not measuring ROI due to the specifics of my job. With what I'm doing, I'm not measuring ROI.

What other advice do I have?

I work as a director in a consulting company. We don't implement it. We implement it for our clients. We don't implement it internally.

I recommended the solution only for particular use cases. For example, let's say if you have a simple use case just simply integrating data, it would probably not be my first choice, Informatica. However, if it's an enterprise-grade implementation of a data platform, a data management platform for creating data from A to Z, then this is a perfect option.

I'd give the solution a solid none out of ten rating.

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: Partners
PeerSpot user
Guirino Ciliberti - PeerSpot reviewer
Data Governance & Lineage Product Manager at Primeur
Real User
Top 5
Integrates our applications on our site and cloud but the user experience is complex
Pros and Cons
  • "The program is stable and scalable."
  • "One area that needs to improve is the user experience because it is very complex. The trial version is very complex so it's not easy to start using the program immediately. You must study the rules first."

What is our primary use case?

Our primary use case for this solution is managing different environments. We have some applications on our site and some applications on the cloud so we use Informatica to integrate everything.

What is most valuable?

When we use Informatica, we have a complete global vision of our clouds and the local application data and that is very important for us.

What needs improvement?

One area that needs to improve is the user experience because it is very complex. The trial version is very complex so it's not easy to start using the program immediately. You must study the rules first. 

For how long have I used the solution?

I have been using the program for two to three months.

What do I think about the stability of the solution?

The program is very stable and more complex than other solutions.

What do I think about the scalability of the solution?

When it comes to network tests, the solution is very scalable. 

How are customer service and technical support?

The technical support is great and the team is very resourceful and helpful.

How was the initial setup?

I found the initial setup rather complex and difficult. Our first project took about a month to deploy. The program is very powerful and it has many features. In order to understand everything and to know what each feature does, is rather complex. As system administrators, we used people from TCS, Tata Consultants, to help us with the deployment. We currently use two people for deployment, to create a standard blueprint, and two people for maintenance. 

Which other solutions did I evaluate?

We did look at another solution but it is very complex. Although it is a fast solution, it doesn't have the same level of power as Informatica.

What other advice do I have?

My advice would be to maintain the program as it is very powerful. I rate this solution a seven out of ten. Not a ten because of the complexness.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Informatica Cloud Data Integration
March 2024
Learn what your peers think about Informatica Cloud Data Integration. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
769,479 professionals have used our research since 2012.
BI Consultant at a computer software company with 1,001-5,000 employees
Real User
Powerful data transformation capabilities and a strong technical support team
Pros and Cons
  • "I do a quite a lot of data transformations, and the fact that I can do them without changing any of my SQL queries from the code, using the inbuilt tools, is very helpful."
  • "I would like to see support for more data sources."

What is our primary use case?

Our primary use case is connecting to the AWS S3 buckets and AWS instances in the cloud, extracting data from on-premises, and pushing it to the cloud. I think that's a perfect use case for Informatica Cloud.

What is most valuable?

I do a quite a lot of data transformations, and the fact that I can do them without changing any of my SQL queries from the code, using the inbuilt tools, is very helpful. Very few tools outside of Informatica have the ability to do that.

What needs improvement?

I would like to see support for more data sources. At this point in time, I'm not sure if they are supporting Microsoft Azure or Google Cloud, but continually adding new data sources is one area that they can improve on.

The deployment could be somewhat simplified. One drawback is that you need a separate server for it. However, from an enterprise point of view, it is worth it because the product is good.

For how long have I used the solution?

I have been using Information Cloud Data Integration for about one year.

What do I think about the stability of the solution?

I have had no trouble in terms of stability.

What do I think about the scalability of the solution?

The scalability is quite good.

How are customer service and technical support?

Informatica has a strong support team and they are very good.

How was the initial setup?

The initial setup is complex. It isn't easy because it needs a separate server of its own.

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

My understanding is that Informatica is quite expensive compare to other tools that are available in the market.

What other advice do I have?

I am a fan of Informatica and it is definitely a product that I recommend because of its inbuilt capabilities. At the same time, I would like to see more data sources added. Inclusion of support for Azure and Google Cloud would be a game-changer, wherein companies can move their analytics capabilities to the cloud instead of being on-premises.

If you have the money then you should implement it. Otherwise, there are many open-source tools in the market, although you will still have to invest quite a lot in terms of resources because the individual transformations still need to be built.

I would rate this solution an eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user664641 - PeerSpot reviewer
Informatica Cloud System Lead at a pharma/biotech company with 10,001+ employees
Vendor
Some of the valuable features are data replication tasks and REST APIs.
Pros and Cons
  • "REST API: Excellent for scripting control and reporting mechanisms"
  • "User/group administration could use improvement."

What is most valuable?

  • Data Replication Tasks: Easy to configure, for the most part reliable, and also what my system deals with the most.
  • REST API: Excellent for scripting control and reporting mechanisms

How has it helped my organization?

Ease of use, configurability, maintainability, and good aesthetics make for a more fluid functional process.

What needs improvement?

User/group administration could use improvement.

For how long have I used the solution?

I have been using this solution for 15 months.

What do I think about the stability of the solution?

No stability issues as of yet.

What do I think about the scalability of the solution?

The REST API could have the ability to generate tasks, and certain manual functions like updating/deleting data replication tasks could come with a bulk update option somehow.

How are customer service and technical support?

I would give technical support a rating of 10/10. They are just incredible.

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

I inherited this solution in its infancy, but I don't have the details.

How was the initial setup?

The setup was straightforward.

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

Licensing is difficult to understand, but the team is always available to explain anything. They are very helpful.

Which other solutions did I evaluate?

I did not evaluate any alternative solutions.

What other advice do I have?

Pose any and every question/doubt/concern to the team, especially with respect to licensing. They are excellent in their communication.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
ChristopheFournel - PeerSpot reviewer
Fondateur at Data Integration Consulting
Real User
Top 10
The data integration features are good and the technical support is fast and effective
Pros and Cons
  • "The features I find most valuable is the synchronization, verification, functionalities and all the data integration features."
  • "I would also like to have profiling functionalities and quality transformations in the cloud."

What is our primary use case?

We use Informatica Cloud Data Integration mainly for monthly mapping tasks. We work with it on cloud because we help customers to use the solution and to integrate it on their database and on their information systems.

What is most valuable?

The features I find most valuable is the synchronization, verification, functionalities and all the data integration features. I have been academically trained and earned the Cloud Academy badges 101 and 201. Currently, I am training to use this solution in real-time.

What needs improvement?

It's very easy to develop with the solution whenever we have an evolution for the data integration. Perhaps the web services need to improve because when you create a new data file and add some changes, we must edit it and create a web service transformation again. So, in my opinion, the functionality is bad and it needs to improve to make web service transformation better and easier.

For how long have I used the solution?

I have been working with Informatica solutions for more than 16 years now.

How are customer service and technical support?

I have developed a good relationship with the technical team and they usually assist me immediately whenever I have an issue.

What other advice do I have?

On a scale from one to ten, I rate this solution an eight. I haven't seen the functionalities of this tool yet. The data quality is good but I still need to test the B2B gateway of the data quality. I would like to have profiling functionalities and quality transformations in the cloud so that I can directly integrate quality transformations inside the cloud. In the next version, I would like to have more tools for monitoring and perhaps also a system dashboard on our homepage.

Disclosure: My company has a business relationship with this vendor other than being a customer: Reseller.
PeerSpot user
Raja ShahnawazSoni - PeerSpot reviewer
Data Architect at a retailer with 10,001+ employees
Real User
Top 10
Flexible licensing, good connectors, and timely upgrades and patches
Pros and Cons
  • "Their new licensing is very flexible. With Informatica Cloud, you have plenty of items under the same umbrella, such as services, offerings, data quality, and data masking. You have also got master data management and API management. What I really like about them is that you don't need to go to Informatica and say that you need a data integration module. You would say that you need iPaaS or Informatica Cloud. They'll then try to understand your needs and give you IPUs, which are the processing units. If I purchased a hundred IPUs from Informatica as a customer, I can use 70 IPUs for data integration. I would also need data quality, so I can use 10 IPUs for data quality. I can use the remaining 20 IPUs for API management. Down the line, if I see that my initial data integration needs for the development phase are met, then out of the 70 IPUs assigned for data integration, I can use 30 IPUs for data masking. I can shuffle these numbers in any way within the Informatica Cloud umbrella for the tenure for which I have subscribed to these IPUs. I can use all services the way I want. This flexibility is what I really love about Informatica. It also has got good connectors."
  • "The regions in which the data resides are still limited. This could be an issue in terms of the data residency laws of some of the countries. They should get more regions."

What is most valuable?

Their new licensing is very flexible. With Informatica Cloud, you have plenty of items under the same umbrella, such as services, offerings, data quality, and data masking. You have also got master data management and API management. What I really like about them is that you don't need to go to Informatica and say that you need a data integration module. You would say that you need iPaaS or Informatica Cloud. They'll then try to understand your needs and give you IPUs, which are the processing units. If I purchased a hundred IPUs from Informatica as a customer, I can use 70 IPUs for data integration. I would also need data quality, so I can use 10 IPUs for data quality. I can use the remaining 20 IPUs for API management. Down the line, if I see that my initial data integration needs for the development phase are met, then out of the 70 IPUs assigned for data integration, I can use 30 IPUs for data masking. I can shuffle these numbers in any way within the Informatica Cloud umbrella for the tenure for which I have subscribed to these IPUs. I can use all services the way I want. This flexibility is what I really love about Informatica. It also has got good connectors.

What needs improvement?

The regions in which the data resides are still limited. This could be an issue in terms of the data residency laws of some of the countries. They should get more regions.

For how long have I used the solution?

I have been using this solution for roughly three or four years, but overall, I have around 12 or 13 years of experience in data integration. It is a cloud solution, and it is managed by Informatica. We are always on its latest version.

What do I think about the stability of the solution?

It has been stable for us. I haven't seen any issues. They provide the upgrades and patches in a timely manner. We don't even realize that the patch has been applied. 

What do I think about the scalability of the solution?

This is not a traditional cloud like AWS and Azure, which offer virtual machines, data storage, and compute power. With Informatica cloud, this is not the offering. You need to understand the offering. They are offering a data integration service. The scalability context here would be from the services aspect. If you want to have more data integration, you can do it instantly the way you want. You will be charged if it is beyond your subscription. They also have data quality and all the data management tools.

How was the initial setup?

Its initial setup is pretty straightforward and not at all time-consuming. They just offer one simple software that communicates on your local system. You have to enter the org IDs, etc. It also doesn't require a lot of hardware.

What other advice do I have?

I would definitely recommend this solution. It is definitely worth a try, and you will definitely benefit from it and see the value of implementing it in your organization. They are a leader in the Gartner Quadrants. The offerings that these guys are giving with the new licensing model, such as IPUs consumption, are excellent. You don't need to worry about what do you want to purchase. You just need to worry about the number of IPUs that you need to purchase. You can shuffle around all types of services under the same umbrella.

I would rate Informatica Cloud Data Integration an eight out of ten. It loses two points because of the region limitations.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Other
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Senior Technical Architect at a tech services company with 10,001+ employees
Real User
This is a one-stop shop with everything provided in one platform
Pros and Cons
  • "Whether we need data cleansing or data mastering, we get it all in one platform."
  • "Connectivity could be improved, it can be a little slow."

What is our primary use case?

We use the solution for cloud-to-cloud migration so our clients have all applications and data on their Oracle solutions, and we move it from there to AWS cloud and then to Salesforce. We're an implementation partner with Informatica and I'm the senior technical architect in the company. 

What is most valuable?

The connectivity and their whole suite are valuable features. Whether we need data cleansing or data mastering, we get it all in one platform. There's no need to test different cloud vendors and then integrate with one solution. Informatica is a one-stop shop.

What needs improvement?

The one thing that I think could be improved is connectivity with the Salesforce because if you're loading a huge amount of data, whatever optimization is carried out, takes some time and it could be a little faster. 

For how long have I used the solution?

I've been using this solution for a year. 

What do I think about the stability of the solution?

We had some very minor issues initially, but the product is stable. We haven't experienced any down time. 

What do I think about the scalability of the solution?

We've just completed the first part of the implementation. In the upcoming months we plan to carry out multiple implementations and then we might see some challenges in the scalability. I think it will be fine. I have about 35 users in my team - around 40% are developers, 30% are testers and QAs and then a few are designers, data modelers, and architects.

How are customer service and technical support?

The way we carried out our transformation was throwing some junk value as an output and that meant we had to reach out to Informatica to see what kind of configuration changes might be required. They were pretty quick to respond and knowledgeable about the issue, and dealt with it very well. 

How was the initial setup?

The initial setup was very simple and took a couple of days. AWS provided everything for us. 

Which other solutions did I evaluate?

We initially wanted to build the programming language in Python but the client's needs made us realize that Informatica was the way to go. Our initial design was something different and it was the cost that put us off going with Informatica as a first choice. If we had worked with something like Python, it could possibly have been more scalable and the cost reduced.

What other advice do I have?

If cost is not a issue then I would recommend Informatica as the tool of choice. 

I would rate this product an eight out of 10. 

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Amazon Web Services (AWS)
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Novneet Jain - PeerSpot reviewer
Data Integration Architect at a tech services company with 1,001-5,000 employees
Real User
Top 20
Great solution for Salesforce data integration, multi-cloud approaches and processing bottlenecks
Pros and Cons
  • "The serverless capability and the packaging application of the solution are valuable."
  • "It could be improved by including a buffer that saves data when there is a connectivity issue."

What is our primary use case?

We use the solution for Salesforce data integration, multi-cloud approaches and processing bottlenecks. We deploy the solution in a hybrid format.

What is most valuable?

The serverless capability and the packaging application of the solution are valuable, as all tools come with the solution and do not require additional license purchases.

What needs improvement?

Although the solution seems complete currently, it could be improved by including a buffer that saves data when there is a connectivity issue.

For how long have I used the solution?

We have been using the solution for a year and a half and are currently using the latest version.

What do I think about the stability of the solution?

The solution is very stable.

What do I think about the scalability of the solution?

The solution is scalable.

How was the initial setup?

The initial setup is straightforward. It takes a couple of days, but for migration, if you have to move over the code from one tool to another, it takes a lot of time.

What other advice do I have?

I rate the solution an eight out of ten. The solution is good but can be improved by a buffer that saves data when there is a connectivity issue. I recommend the solution because it has existed for a long time, and a lot of people already understand the tool. Additionally, the learning curve is effortless compared to the other tools.

Disclosure: My company has a business relationship with this vendor other than being a customer: Integrator
PeerSpot user
Buyer's Guide
Download our free Informatica Cloud Data Integration Report and get advice and tips from experienced pros sharing their opinions.
Updated: March 2024
Product Categories
Cloud Data Integration
Buyer's Guide
Download our free Informatica Cloud Data Integration Report and get advice and tips from experienced pros sharing their opinions.