Informatica Intelligent Data Management Cloud (IDMC) Reviews

The Mapping Configuration and PowerCenter wizards are valuable. We use them to run our business logic.

• Provides the basic functionalities to implement ETL logic
• Can be accessed from a web browser or from any device with internet connectivity.
• We need not be in the office to perform tasks
• We use it to run jobs, even at midnight, based on the requests of the business users.

It needs lot of improvement from the admin to the development side. There are many known issues while mapping. The error information provided is not informative, as compared to Power Center.

I have used this solution for around six months.

There used to be performance issues. Throughput is slow when we do not have the Informatica Secure Agent running on the DB instance.

It has not yet been identified.

I would give the technical support a rating of 2/5. Informatica doesn't provide on-call or technical support for AWS instances. We need to rely on responses from the forums if we raise any queries.

I have used Power Center. I switched to the Informatica Cloud (IC), as it is cheaper compared to Power Center. It gave us a chance to explore a new tool and technology.

The setup is straightforward

It is cost effective and an easily accessible tool.

It totally depends on the business requirements and the budget. I have been working on Informatica for more than nine years, and I recommend using their products.

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

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.

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

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

The solution is very stable.

The solution is scalable.

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.

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.

The user interface is good.

The solution's initial setup is quite straightforward.

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.

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

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

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.

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

We did previously use another solution.

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

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

I handled the implementation and deployment myself.

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

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.

The most valuable features are:

• Data synchronization tasks
• Mapping designer tasks
• Scheduling

We are using this for integration of on-premise Oracle EBS, Navision and cloud applications, such as Salesforce, BigMachines, etc.

Error reporting and debugging need improvement.

They need to improve on the upgrade testing process from their end so that it does not cause any issue to existing functionality/setup.

I have been using this solution for 36 months.

Sometimes after upgrades, it gives some trouble for already working tasks. We need to report bugs to get a solution from Informatica.

We have not had scalability issues.

I rate support 8/10.

We did not have a previous solution.

Setup was straightforward and easy to work with.

I am not involved in pricing and licensing.

We looked at Dell Boomi.

Informatica Cloud is easy for development and maintenance. It really works fast and is scalable.

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

We used Informatica Enterprise Information Catalog to find hidden data assets in our organization. We have data spread across disparate systems like Oracle, SQL Server, Teradata, Redshift, mainframes, etc. Informatica EIC has connectivity to a surprising number of systems and we use this to our advantage creating connections to most of our data sources. We used a 40 node hortonworks cluster and ran the scanners to crawl through our data swamp. It has ran for three days now and we have a fair understanding of our data sources.

• Lineage
• Provenance
• Flow of data through various sources
• Data domain discovery to find out sensitive data.

One thing we find very useful is a feature which lets us know who are the stakeholders of a particular data source, and if you are making any changes to a source, then which users must be informed prior. 

Many dark data silos were identified and many hidden assets were uncovered. It helped IT in initial data integration efforts. We were creating data lake-based on MapR Converged Data Platform EIC, which helped us in initial prep.

Speed. The solution is bit slow.

Six to seven months as of October 2017.

Yes. Installation of the product is bit challenging. It is not straightforward and requires many configurations.

A few bugs here and there.

No.

Technical support and Informatica Professional Services are friendly and helpful. They helped us iron out the installation issues and provided training for our team on how to use the product. 

We used to use Metadata Manager from Informatica, Ab Initio, and Ataccama Data Quality Analyzer. It was a custom made solution based on integration of the above mentioned products. It was difficult to maintain, scale, and required cross team collaboration, which kind of slowed done our pace of operations. Our team does not specialize in Software and IT functionality. EIC provided a one stop solution instead of a lego bricks like solution.

It was kind of complex. It required many prerequisites and required a team of professionals well-versed in Linux and big data technologies.

We implemented it in collaboration between our in-house IT folks and Informatica Professional Services. Informatica sent a team of subject matter experts, who had considerable amount of understanding about the project and the big data ecosystem.

We are yet to recover the full cost of the product, but it seems good thus far. 

Licensing is simple, but cost is bit steep.

No. We are not aware of any other product that solves this problem.

The product requires more polishing and hardening. It might take few more releases until the full power and capabilities of this product are unleashed.