Try our new research platform with insights from 80,000+ expert users
reviewer1447446 - PeerSpot reviewer
Data Analyst at a tech services company with 201-500 employees
MSP
Stable with a straightforward initial setup and a good user interface
Pros and Cons
  • "The solution's initial setup is quite straightforward."
  • "There may be some types of limitations with the performance."

What is most valuable?

The user interface is good.

The solution's initial setup is quite straightforward.

What needs improvement?

I haven't had too much time with the solution. There may be much to be improved. However, I still need time with it.

There may be some types of limitations with the performance.

For how long have I used the solution?

I've been using the solution for a couple of weeks. It hasn't been too long.

What do I think about the stability of the solution?

The solution is quite stable. We do not have any issues with it crashing and there are not bugs or glitches.

Buyer's Guide
Informatica Intelligent Data Management Cloud (IDMC)
April 2025
Learn what your peers think about Informatica Intelligent Data Management Cloud (IDMC). Get advice and tips from experienced pros sharing their opinions. Updated: April 2025.
860,592 professionals have used our research since 2012.

What do I think about the scalability of the solution?

The solution is very scalable. If a company needs to expand it, it should not face any issues doing so.

I am not sure how many users are actually on the solution in our organization.

We will be continuing to use the solution.

How are customer service and support?

We have dealt with technical support and they are very good. We are quite satisfied with their level of service.

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

We did previously use another solution.

How was the initial setup?

The initial setup is not complex. The implementation is quite straightforward, actually.

As a cloud solution, the deployment doesn't take too long.

What about the implementation team?

I handled the implementation and deployment myself.

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

I'm not sure what the licensing is for the solution.

What other advice do I have?

We're just a customer. We don't have a business relationship with Informatica.

We're using the latest version of the solution.

I'd recommend the solution to others. Overall, I'd rate the solution eight out of ten.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1080891 - PeerSpot reviewer
Architect at a tech services company with 501-1,000 employees
Real User
Offers great features; suitable for both technical and business users
Pros and Cons
  • "The solution is applicable for both technical and business users."
  • "The ability of the product to leverage the power of big data could be improved."

What is our primary use case?

Our primary use case of this solution is to improve issues of security, quality and accuracy. 
We are partners of Informatica and I'm an architect. 

What is most valuable?

In terms of Data Quality, the feature most valuable to me is that the solution is applicable for both technical and business users. I like that instead of using on-premises processing power, you can now use your on-cloud platform processing power to process the data and get a faster turnaround time. From a product perspective, everything is well done. 

What needs improvement?

I think improvements can be made regarding the ability of the product to leverage the power of big data. It would also help if we could get the software as a services product so that we feed in the requirements and it's a more customized solution. I think that would increase the adoption by customers. 

For how long have I used the solution?

I've been using this solution for three years. 

What do I think about the stability of the solution?

Informatica is a very stable product, I haven't had any issues with it. 

What do I think about the scalability of the solution?

It's a very scalable solution and it has all the other big data components. 

How are customer service and technical support?

We have a business partnership with Informatica and they are very responsive. 

How was the initial setup?

I've had a lot of experience with this solution so I don't have any issues with implementation. Perhaps someone from a different background or different circumstance, may face challenges but it is user friendly so it shouldn't be a problem. Implementation generally takes about six months depending on the dimensions required. This solution cannot be implemented in a day or a week.

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

The pricing of this solution is definitely at the higher end and they don't provide the option of a trial version. If you look at Talend, for example, they provide a free version, so the cost of IBM and Informatica is a little high. 

What other advice do I have?

The cost of the product is high, but feature wise, it provides a whole lot of features that can easily solve your problems. I would recommend this product. 

I would rate this solution an eight out of 10.

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
Buyer's Guide
Informatica Intelligent Data Management Cloud (IDMC)
April 2025
Learn what your peers think about Informatica Intelligent Data Management Cloud (IDMC). Get advice and tips from experienced pros sharing their opinions. Updated: April 2025.
860,592 professionals have used our research since 2012.
reviewer1282758 - PeerSpot reviewer
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
BI Consultant at a computer software company with 1,001-5,000 employees
Real User
Top 20
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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
it_user1240473 - PeerSpot reviewer
Project Manager at a tech services company with 10,001+ employees
Real User
A robust solution with an intuitive UI, but it needs more flexibility
Pros and Cons
  • "The most important features are the mastering of the data and the UI intuitiveness."
  • "They need more feature flexibility, as it is not fully developed."

What is our primary use case?

The primary use case of this solution is centralizing and mastering the data. It is also used for centralizing the data between your administrator and customer.

What is most valuable?

The most important features are the mastering of the data and the UI intuitiveness.

I find this solution to be the most efficient, immersive, and robust.

Also, they have a feature map that is flexible and robust.

What needs improvement?

They need more feature flexibility, as it is not fully developed.

For how long have I used the solution?

I have been using this solution for approximately 11 to 13 months.

How are customer service and technical support?

I have not contacted technical support. We have a team in our company for support and maintenance.

What other advice do I have?

My advice for anybody who is implementing this solution is to see the business needs and the requirements.

I would rate this solution a seven out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Lead Developer at Cognizant
Real User
Offers good structure and platform masking features but data discovery needs improvement
Pros and Cons
  • "The most valuable features are the structure masking and platform masking."
  • "The data discovery isn't that good yet for Salesforce. We have another tool that we use for this. It may be a problem because Salesforce on the cloud."

What is our primary use case?

We have a lot of applications with different functionality. We use Informatica mainly for sensitivity tests. 

What is most valuable?

The most valuable features are the structure masking and platform masking. 

I also like that for Salesforce integration we can use Informatica Cloud. For on-premise, normally we do the SQL server database.

What needs improvement?

I don't see where it has much room for improvement. 

For how long have I used the solution?

I have been working with this solution for the last two years. 

What do I think about the scalability of the solution?

We have a team of 10 users on-premise. Their roles are doing the initial analysis for identification.

We don't currently have plans to increase usage. 

What other advice do I have?

I would rate it a seven out of ten. 

It's not a perfect ten because the data discovery isn't that good yet for Salesforce. We have another tool that we use for this. It may be a problem because Salesforce on the cloud. 

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
reviewer966045 - PeerSpot reviewer
reviewer966045Data Scientist at a tech services company with 11-50 employees
Real User

We are using data discovery for on prem databases (Oracle, Microsoft sql, and DB2) and it is working really fine.
I guess the secret is in tuning and adjusting the data and metadata patterns.

reviewer966045 - PeerSpot reviewer
Data Scientist at a tech services company with 11-50 employees
Real User
Data transformation and test management features allow us to work with unstructured data
Pros and Cons
  • "The most valuable feature is data discovery. This is the most exciting feature for all of the banks."
  • "I have encountered some issues using the substitution, which is one of the techniques of data masking."

What is our primary use case?

We provide services mostly to banks. 

I am currently working at a bank where they are using Data Masking and Data Transformation at the same time. They are an old core banking system, which is COBOL, and it's unstructured data. We are using Data Transformation to transform and structure the data into a relational format.

We use the test data management to create test data from the relational data. To create the test data, we mask using different techniques for the discovery. After that, we re-transform the relational data into unstructured data to be fed into the core banking system.

What is most valuable?

The most valuable feature is data discovery. This is the most exciting feature for all of the banks.

What needs improvement?

I have encountered some issues using the substitution, which is one of the techniques of data masking. I used the substitution and software. I had issues in both when using the field, and specifying the field. Each one will have the same data for the same person, and they will have realistic data each time. This issue was raised with technical support and it was flagged as an issue that had no solution. They have indicated that it is a bug that would be resolved in the next release.

In the next release, I would l like to see the bug with the substitution resolved.

For how long have I used the solution?

I have two years of experience with Informatica Data Masking.

What do I think about the stability of the solution?

This solution is stable and we have not had any issues.

What do I think about the scalability of the solution?

Informatica Data Masking is scalable.

How are customer service and technical support?

The technical support is good, although sometimes they don't respond quickly. Overall, they are good.

I raised the case where I was having some issues with the substitution, and it took two months. Finally, the answer was that they have no solution for this, but said they will flag it as a bug to be resolved for the next release.

As I was not able to stop the project because of the bug, I created a workaround using PowerCenter to make it work. The data was not unique. I used PowerCenter and added an ID to all of the columns, then I concatenated the ID with the columns. As an example of why this was complete is if my name is Donna, it will show as Donna123. That way, any other person named Dana in the same database or table would show as Donna246 and they would no longer be the same. With this, I would then offer a substitute.

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

Previously, we did not use another solution.

How was the initial setup?

The initial setup is straightforward.

The length of deployment depends on the solution. For example, I find security was very easy, but the data integration was more complex. This is because it has many features and you can do many things. Setting up the data quality was also very easy.

We have deployed both on-premises and on the cloud. Mostly, I work in Lebanon and some  Arab countries also. There have been some issues with the Cloud, so they prefer on-premises software. We implemented some iPaas on the Cloud for Data integration.

What other advice do I have?

It's good as a solution.

I would rate this solution a nine out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer. Partner
PeerSpot user
Hariprasad-Sharma - PeerSpot reviewer
SAP Manager at a tech services company with 10,001+ employees
Real User
Top 10
Data profiling features help us to improve quality and mature our business processes
Pros and Cons
  • "We are able to set rules, establish a data quality management platform, and monitor the quality."
  • "I would like to see better visuals for business users, such as a dashboard where they can precisely track where problems are."

What is our primary use case?

We use this solution for data quality management.

How has it helped my organization?

We have matured as an organization with regards to better quality management, and we have evolved over time. This solution has had a positive impact on our efficiency, especially with regard to finance officers. They rely on the quality of data for customers and vendors so that they can invoice properly.

From a sales point of view, there are also improvements.

What is most valuable?

The most valuable feature of this solution is data profiling. We are able to set rules, establish a data quality management platform, and monitor the quality. These features are excellent.

What needs improvement?

I would like to see better visuals for business users, such as a dashboard where they can precisely track where problems are. You should be able to better visualize data quality.

For how long have I used the solution?

We have been using this solution for about nine years.

What do I think about the stability of the solution?

This solution is stable.

How are customer service and technical support?

The technical support for this solution is good. They have a good mechanism for support and I haven't experienced any problem with it.

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

Prior to using this solution, we did not use a dedicated product for data quality. Rather, we used a combination of other products. One of these was CranSoft, by BackOffice Associates.

We switched because this product was quite immature, not covering the governance part of it. It was more for data quality, only. 

How was the initial setup?

The initial setup of this solution is pretty much straightforward.

The deployment should not be complex, although there are other factors that influence the time it takes to complete.

What other advice do I have?

The suitability of this solution depends on your environment. If you need large scale data quality and rely heavily on different connections to ge the data, then you really need a good powerhouse and this is the best. But, for example, if you already have SAP in your organization then you may not need IDQ on top of it. There are different factors to consider.

This is a good solution, but I can't say that you can solve all of the problems using it. Informatica is focusing only on master data quality. In this regard, there is room for improvement, but it depends upon the use case.

I would rate this solution an eight out of ten.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Download our free Informatica Intelligent Data Management Cloud (IDMC) Report and get advice and tips from experienced pros sharing their opinions.
Updated: April 2025
Buyer's Guide
Download our free Informatica Intelligent Data Management Cloud (IDMC) Report and get advice and tips from experienced pros sharing their opinions.