Informatica Intelligent Data Management Cloud (IDMC) Reviews

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.

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.

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.

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

I have had no trouble in terms of stability.

The scalability is quite good.

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

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

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

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.

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.

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.

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

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

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

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.

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

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.

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

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

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. 

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. 

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.

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. 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.

I have two years of experience with Informatica Data Masking.

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

Informatica Data Masking is scalable.

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.

Previously, we did not use another solution.

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.

It's good as a solution.

I would rate this solution a nine out of ten.

We use this solution for data quality management.

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.

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.

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.

This solution is stable.

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

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. 

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.

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.

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.

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.

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.

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

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.

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.

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.

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. 

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

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

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

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. 

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.

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.

We are using this solution for integration and development.

The most valuable feature is the building of mockups and tasks.

The user interface is fine.

I would like to see more functionality added so that it is a bit closer to how much you can do with Informatica PowerCenter.

Having a better dashboard would be an improvement.

This solution is stable, and we haven't had any issues.

This is a scalable solution.

I have not had to contact Informatica. Any issue that I have had, I've been able to solve it by looking for something online.

The initial setup of this solution is relatively straightforward. It usually takes about an hour to deploy.

We have six or seven people in our team, which is enough to support this solution. 

We perform the deployment ourselves.

For anybody who is implementing this solution, I would say that as long as they've got some kind of experience with ETL, or other Informatic products, then it should be absolutely fine.

This is a solution that I recommend.

I would rate this solution an eight out of ten.