Informatica Intelligent Data Management Cloud (IDMC) Reviews

To cleanse and create standardization third-party data by implementing business rules and Address Doctor.

• Manually checks on applying business rules, 
• The tool helps to implement business rules.
• It helps to get quick results as well.

Address Doctor. This is the best feature to gives an accurate combination of the information provided with a level of returned threshold value.

To implement the new workflow with simple steps and a quick visualization with a 360 view of the data.

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. 

Valuable features include:

• 360 degree view of customer data
• Data quality improvement through better decision making with respect to BI
• Analytics and reporting
• Improvement in he customer experience with better services provided to the application users
• Consistent support to the business through process standardization supported by effective Change Management and Data Governance

We had implemented it across leading Life Science domain. Clients looked to implement a MDM solution for Customer data, which will create a Golden Record from multiple source systems.

Single and consistent view of Customer Data arising from a centralized data set with unique customer records.

Customer data is a critical asset that must be managed within the enterprise.

An integrated Master Data Management solution is needed to enable a 360-degree view of its Customers and provide accurate and timely Customer information.

The ability to link customer information across HCPs (Healthcare Providers), managed markets, hospitals and institutional accounts enables an enhanced view of the customer.

I am looking forward to integration with leading data providers, such as DaaS in the Life Science domain.

I'm using Informatica MDM since 2012 in various version XUSP2,9.1,9.5.1,10.1 and 10.2

There were a few stability issues, but overall it is a stable product.

When it comes to scalability, it is the best product in the market.

I would give technical support a rating of 9/10.

I looked into other products in this segment, but we never implemented them.

The setup was pretty simple.

I would suggest to just go for it. It is the best MDM solution in the market.

The Match-and-Merge feature is valuable.

We are now more equipped to address the customers' issues.

• Performance issues can be looked at
• Improved release documentation is expected because I feel that the current release document doesn't give you the clear picture of what has been fixed and what has not been fixed from previous versions.

3 Years

We faced issues with User Exits post deployment, but those were addressed by Informatica.

If the guides are followed then the instructions are very well documented about issues that may crop up during up-scaling/upgrading.

Excellent. Informatica has one of the best customer services with an excellent turn around time.

Very good, a couple of technical support team members are excellent and they handle the case very professionally.

Complex, it is not just a NEXT NEXT NEXT button click setup, it requires understanding of PAM document provided by the vendor and mapping it with your hardware and then carefully setting up each of the elements - database, application server and then the software itself.

In-House along with some help from third parties. Understanding the business and collecting the initial requirement is the most important aspect and moreover verifying the collected requirement should be done so that there are no disconnects or gaps in understanding how the eventual implementation will look like.

The product is the best in the industry (as it is multidomain) and the vendor support is excellent.

The flexibility to interact with many different sources and targets like Oracle, MySQL , Flat Files, Informix, SAP thru PowerExchange, applying different transformations that you can configure in an intuitive way, gives both business and IT teams the opportunity to track the data lineage and also to provide value to the data workflows you create, integrated to feed the MDM solution together with Data Quality processes.

The portability to use your integration flows into MDM and Data Quality helps to improve the data stewardship and also provides value for the metadata management you can take advantage of to document your business rules while interacting with different business data.

The product ranking we provide is 8 out of 10 -- because there are parts of connectivity with SAP Non-Unicode that are not supported by Informatica, since they only provide connectors to write on SAP Unicode. Then, we had to develop and enable the connectivity to write into SAP Non-Unicode.

Mainly, MDM requires improvement when you need to migrate your version to a later one -- because it is very difficult and takes a lot of time to convert the processes you have already developed and implemented on a previous version, and can cause a need to rework the processes.

We've been using the Informatica Solution for Data Integration and Data Quality for 12 years. We've been using MDM for seven years.

Sometimes the IDD console connectivity.

The difference between components and functionality from one version to the immediate latest one.

It is good, however response time is always depending on the support contract you acquire.

SAP MDG. At that point in time, it was not prepared to provide flexible integration and data quality process to generate a 360 view.

The initial setup was kind of complex while polishing the business requirements to be translated into technical flows.

I recommend reviewing and assessing the volume of data you will incorporate into the MDM, because the pricing seems to be based on row count used at the MDM Entities you built.

Yes -- SAP MDG and IBM MDM .

First, you need to assess the status quo of data integration and data quality at your organization, then, after you settle these strategies and implement the solutions, it is advisable to go for MDM.

If you do it the other way around, it will cause a lot of headaches and will cost you many more resources, time, and overall creditability to generate value beyond just results.

Having access to PIM production, we get all the details of the supplier from here and we also get to update the information on the master catalog for urgent tasks.

In our department, it's easier to get the information needed in a report or task. I cannot go into details due to confidentiality issues.

From my point of view, a quick response time is needed when searching for an item.

I have been using this system for almost ten months.

There were no stability issues so far.

There were no scalability issues so far.

I would rate the technical support a 10/10. They are very helpful and provide updates as and when needed.

I like the fact that you can find almost any product connection that you need and the list is always expanding.

Basically, it just allows connections with Amazon AWS/S3/Redshift.

It needs to be a little more intuitive but it’s really not bad. There are plenty of examples as how to use the product from Informatica and YouTube.

I have used this solution for less than a year.

After the initial setup, the tool seems pretty stable.

There is plenty of online support available from Informatica.

In the past, we have used Informatica PowerCenter.

We implemented this product in-house and my advice is just read all the available online support documentation that you can find.

Read through the online documentation that is available.

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.