Informatica Intelligent Data Management Cloud (IDMC) Reviews

We are currently working on a project with the Oracle Fusion system, so we have multiple use cases and often need to pool data in different source systems. In the project, we have multiple sources and target systems. Based on the requirements, clients, and what they propose, we need to make decisions or check the technical feasibility of whether it is possible to complete the integration.

Product-wise, compared to other on-premise tools, Informatica Cloud Data Integration can be deployed on-premises and cloud. So when we were working on-premises, there were a lot of challenges with the hardware. For example, there were memory space issues, but once we switched to cloud, there were no more issues. 

There are challenges when we use Cloud Application Integration (CAI). We want add-ons when we complete data integration and merge images. The current features are a bit complicated, and we need to write big scripts and test.

We have been using this solution for more than six years. We are using a cloud version and the most recent version, 10.4. We have also used versions 8.6, 9 and 10, and we have observed that there isn't that much of a difference between versions, just additional features added. We do not have private or public cloud for Informatica Cloud Data Integration, just cloud.

The solution is stable. 

The solution is scalable. We have more than 20 people using this solution.

We hardly raise an SR for this solution. But, whenever we require technical support, we do not get a satisfactory response. This is because their knowledge base may not be developed.

We used this same tool but on-premises in the past. We have also worked with AWS Snowflake, an ELT tool similar to Informatica Cloud Data Integration but with a different architectural approach. If we had to rank them, Informatica Cloud Data Integration would be the best, followed by Snowflake, then AWS.

Informatica Cloud Data Integration has some advantages over the others. It has a more UI-based tool, and the scripting is good. AWS also has an ETL tool called Glue, but it does not have everything we need to write in a script. We still need to write a script if we want to perform a small task. AWS is also challenging to teach. Informatica Cloud Data Integration and Snowflake are easier to use.

The initial setup is easier for cloud compared to on-premises. Deployment does not take much time and takes about 20 to 30 minutes.

The pricing of Informatica Cloud Data Integration and other solutions are almost the same but with slight differences. It differs from project to project, their use case, source and target. Unfortunately, I do not have information on precise licensing costs.

I rate this solution a nine out of ten. Regarding advice, it is a great solution, but users should understand their source and target system. For example, we also deal with Oracle Fusion, and it's a bit challenging to push data because Oracle has multiple models, financial supply chain and HR. Hence, it is difficult for a developer. Therefore, it is difficult to push data.

They should decide whether they are comfortable using Informatica Cloud Data Integration as their middleware tool or whether they want to use Oracle or OCI. OCI is a different middleware tool owned by Oracle.

Regarding additional features in the next release, Informatica Cloud Data Integration doesn't have image merging transformation or capability. We can do it without the solution, but it is a lengthy process. So, it would be helpful if they added the transformation to play with images and deal with invoices and financial data. We sometimes need to add 200 out of 800 invoices, and it's a bit challenging without the additional features.

The organizations I work with often have trouble getting buy-in from business users and understanding how data governance relates to them or where the data lineage is. We use Axon in two key areas. 

The first is automating data governance processes, policies, and roles in terms of data stewards, data owners, etc. Those process flow charts are typically stored in a PowerPoint, Excel, or board document. Everyone involved in data governance would have to send emails manually and such. Axon allows them to automate all that. So if there's a data owner that needs to update a definition, a request that needs to be flagged, or a data quality error, all that is embedded into the Axon system. That's one reason our clients go with it. 

The use case is embedding the data or the business glossary into the day-to-day workflow. For example, we could integrate it with Tableau. When people are looking at a Tableau report, they understand exactly what the data lineage is and where this data is coming from. They'll also know exactly what those business glossary terms mean, so they can more accurately interpret and analyze the report.

Axon does one interesting thing that I don't think other tools do as well. It lets you rate data and incorporates Informatica's data quality feature into it. There are little indications and graphics that show you how good the data quality is, and you can drill into it to see where potential issues lie. 

Users can comment on the data, tag people, and ask questions or rate the data one to five based on their experience, which helps eliminate data silos. You have all your information right there, and it's easier for future users to know which data to draw from.

The cloud version of Axon is far behind the on-prem, and many of my clients want to go fully to the cloud. However, Axon has to be an on-prem installation. I would like to see their cloud products catch up with their on-prem capabilities. 

I would like to see Informatica add more automation and AI. Some of that is already there, but it would be helpful to have some automation to speed up the process of manually tagging and moving components of your IT setup into your business glossary and the front end.

We started our first Axon implementation at one of our clients in the fall of 2021. Two of my other clients are about to purchase the technology and start using it.

Axon is stable. 

Axon is scalable.

Informatica support has been good. These data governance and metadata products are some of the newer products on the market technology-wise, so I've been impressed with their responsiveness and the tool's maturity.

Installing Axon is straightforward. If the cloud version were more robust it would be easier, but it's just fine for the on-prem solution. Two people should be enough to deploy and support it. 

I rate Informatica Axon nine out of 10. If you're planning to implement Axon, I recommend having an identified data governance lead. I think the most difficult part of implementing this is getting your people and processes aligned, so you know what you're putting into the system. Having a clear data governance manager is the most helpful data governance practice for an organization.

We use Informatica Cloud Data Integration to migrate to the cloud, upgrade our data warehouse, and implement master data management. It helps us with in-depth analysis, leveraging shared history, and addressing data governance questions.

The most valuable features of Informatica Cloud Data Integration for our clients are the AI capabilities within Informatica Intelligent Cloud Services. It excels in mapping development, searching for contracts in data governance, creating data quality rules, and designing merging processes. The ability to identify duplicates and automate analysis coverage is particularly beneficial. Additionally, the cost-effective option of using Informatica Cloud Data Integration for smaller projects or departments has made it more accessible and attractive for experimentation.

One area where Informatica Cloud Data Integration could improve is in providing more accelerators for certain functionalities. For example, for master data management, having additional accelerators could streamline implementation. Additionally, enhancing compatibility with metadata sharing across different applications, similar to what is achievable with PowerCenter, would further enhance the product's capabilities.

I would like to see more connectors for on-premise databases in the next version of Informatica Cloud Data Integration. Currently, CDI free is a great option for cloud integration, but expanding the connectors to include databases like Oracle or MySQL for on-premise environments would make the tool more versatile and accessible for smaller businesses or those not fully in the cloud.

I have been working with Informatica Cloud Data Integration since 2016.

Informatica Cloud Data Integration has been generally stable, with occasional editor issues. However, SLAs are consistently respected, and we typically experience minimal downtime, averaging around two to three hours per month.

The scalability of Informatica Cloud Data Integration is high. With advanced pushdown optimization, it performs well in various environments like Snowflake and AWS. It is suitable for companies of all sizes; for small to medium enterprises, starting with fewer IPUs is cost-effective, and scalability allows for growth as needed.

I would rate Informatica's vendor support as a seven out of ten. It is generally good, but there is room for improvement, especially as they shift focus from on-premise to the cloud. We often find answers in the community for software issues, but sometimes we encounter challenges that require official support tickets.

Neutral

The initial setup for Informatica Data Integration is straightforward. Deployment is simple, involving exporting and importing development processes. The ability to pilot the Informatica Data Integration platform from various APIs makes continuous integration and deployment easy to manage through API calls.

I would rate Informatica's pricing as an eight out of ten in terms of affordability. Starting with a small IPU volume is cost-effective, and as we grow, the pricing adjusts favorably based on consumption, which makes it reasonable for our needs.

I would rate Informatica Cloud Data Integration overall as an eight out of ten. It is a comprehensive platform covering data integration, API integration, data quality, data governance, master data, and privacy tools—all within one platform. The accessibility to all functionalities with the purchase of IPUs is a significant advantage compared to the past where certain features required additional payments and permissions.

Some of my clients use it as a front end tool for the data quality governing process.

The solution allows the complete governance process, starting from the data quality, those definitions, and it can get the data quality in the EDC.

I would like to see more API integration to have the capability to build a report using other third party reporting tools allowing things to be streamlined.

I have been using this solution for one year.

It is a stable solution, we do not see any kind of issues. When we do find issues we have to go to Informatica to get help, I would say it is not completely matured.

The technical support is very good, they have resolved any issue we have had.

The installation is simple.

You can purchase licenses for this solution at different intervals. For example, annually or every three years. They recently changed their terms for licensing and now it is more flexible.

When choosing this solution you need to identify a path by asking yourself a few questions. Where are we going to start? What are the sources? What are the business pain points in terms of the data governance process?  Are you looking for metrics in terms of streamlining the whole process? Are we looking mainly in the bigger lineage? Are we looking to build reference data? We need to identify those areas and prioritize what is more important. Start small and then eventually add more sources, do not commit too much at the beginning you will not be able to be successful. Start thinking in terms of what are the business pain points currently. What would be the first result that you feel would make the business happier and then adjust accordingly, you can build on it further later.

I rate Informatica Axon a nine out of ten.

We use the solution for ETL purposes. 

Informatica Business Process Manager is easy to use and learn. 

I need to have some insight into the tool's cloud capabilities. 

I have been using the solution for four to five years. 

The solution is fairly stable. 

The product is scalable and my company has 20-25 users for it. 

The tool's support is excellent. 

Informatica Business Process Manager's setup was easy and fast. 

Informatica Business Process Manager is very good and I would rate it a ten out of ten. 

The most valuable features of Informatica MDM are the IDQ and RDM data management. PowerCenter is the most widely used feature of Informatica MDM.

Informatica MDM has a complex user interface, which could be improved.

I have been using Informatica MDM for four years.

I rate Informatica MDM an eight out of ten for stability.

I rate Informatica MDM a ten out of ten for scalability. We plan to increase the usage of the solution in the future.

I rate Informatica MDM a four or five out of ten for ease of initial setup.

Our organization's deployment process for Informatica MDM took two to three months. A third-party team did the solution's deployment. Around 10 to 12 IT specialists and engineers were required for the solution's deployment.

Informatica MDM's pricing is not cheap but comparable to other vendors.

I advise others looking into using Informatica MDM in the future to have their use cases in order and know what they want to use it for.

Overall, I rate Informatica MDM a six out of ten.

The most valuable features are data quality, data integrate transformations, match-merge, and a few MDM solutions we build into data quality transformation. 

One area that could use improvement is the speed of the web interfaces. At present, they are very slow. I think it is essential that we are original and robust on-premises.  

I have worked with Informatica Data Quality for the past four and a half years.

You have excellent stability in the market in comparison to other data solutions.

We find that scalability is not an issue and have installed it on fourteen servers.

I have a lot of issues with their customer support and not getting the required technical information, which we actually need unless you can do a call with their senior technicians. Most of the cases that you raise are assigned to a junior technician. 

Positive

The initial setup is simple for a person who knows the company. If you already have one of their products you will find yourself comfortable doing the deployment. If you do not have experience with the company it is medium in relationship to complexity. 

I would continue to encourage the upgrades that are taking place every other one in order to release the new and relevant features. I would rate Informatica Data Quality an eight out of ten.

We don't use profiling as much, however, we do use it, in certain cases, for profiling. We use the Analyst tool to do out-of-box, high-level profiling of data to see high-level quality of completeness, and uniqueness, et cetera. Mainly, we use the Developer tool to connect to the sources and to write data quality rules.

It has improved our organization. 

We started from just pretty much having flat files, and then doing some basic transformations, then writing back to Excel or QFD files. 

We gradually moved to more analytical tasks. You don't just do statistical data quality you also do analytical. You do lots of joins with other sources and do the consistency checks, and to do more complex logic, and build metrics. 

We use Tableau on the back of it to present the data and data quality, and then monitor it. We use it more like a batch process to build pipelines, and then, using Tableau, monitor the results of it and those metrics. Now, we work more with live updates and do that more than the batch.

It's probably one of the leading lights in ETL. They have really good built-in functionalities, or algorithms, that you can use to transform or process data and validate and standardize.

The solution is stable.

It's not too had to set up the cloud version. 

Support is helpful and responsive. 

We are in this transition mode, where we haven't yet got IDMC, the cloud version, so we don't actually have hands-on experience and have not actually seen the features. All we rely on, at the moment, is just the available documentation. What I don't like on the IDQ side is just the fact that in the on-premises version, you have all these applications, with separate configurations. In the cloud solution, it is fixed so that you have everything on one platform.

The performance isn't as good on-premises. For example, when you install clients, it's slow compared to the cloud. Still, we need to see. We haven't experienced it ourselves. 

The upgrades are a downside. On-premises you manage all the changes in the software. You have to do that yourself, and if there's some problem with compatibility, it makes things that much harder. With the cloud, everything is managed by Informatica on the servers.

Managing the licenses with the on-premises version was difficult. However, with the cloud, it will be much simpler. 

I've been using the solution for the last six or seven years. 

Once you set everything up, it is pretty stable. It's reliable. There are no bugs or glitches and it doesn't crash or freeze. It is way more stable than Hadoop and other applications. 

In terms of scaling, we used the clusters, and the processing was on Hadoop side. If we needed any extra space or any service, it was just managed there, so it was outside of Informatica.

Originally, we had 20 people using the solution, and then it was reduced to less than ten.

We do use it as much as we can for its purposes. In the past, we used that for the whole ETL process with data loads, and then we moved to Hadoop storage. At the moment, we are only going to be using Cloud Data Quality and others for cleansing, standardization, and deduplication, and then using some other Azure capabilities.

I've dealt with support in the past. There were issues, and we had to deal directly with Informatica for some hotfixes. They were good. They just got straight to the point and were helpful overall.

Positive

It is way more complex to install on-premises than in the cloud.

With the cloud, the installation will be way easier since you only install these secure agents. They have many different connectors, so it is definitely less hustle to install all these machines, and all these applications. On-premises, it was more user-based. Now, it's service-based, and you just pay for what you use and the licenses as well. 

We had myself, an architect, and a developer as well as help from Informatica while handling the setup.

We have about two or three people that can deploy and maintain the solution. They also cover other applications, not just Informatica.

We had Informatica support, and we had an internal group of people with Informatica knowledge who handled the solution. For some parts, we were involved as well, and we handled them ourselves. 

We're still in the early stages of moving toward the cloud. We have not seen an ROI yet.

When you are using the on-premises version, managing the licenses is quite difficult. However, on the cloud, you just pay for what you use, and it's a lot easier. With the cloud, if you want MDM, you pay for it, and if you want PowerCenter, you pay for it; however, if you don't want it or don't use it, you don't pay. We'll just pay for Data Quality, as it has all of the features we need inside it. 

I'm not involved in the conversations around licensing and agreements. That said, my understanding is that Informatica is pretty expensive. I'd likely rate it two to two and a half out of five in terms of affordability.

We definitely considered others and had StreamSets used for some other purposes. The company that I moved out of was going to be switching off Informatica at some point due to licensing, et cetera, and they just chose to go to StreamSets with Snowflake for storage. 

I haven't researched enough about other products in relation to Informatica.

We are moving to the cloud version. On-premises, we were on version 10.4.2, and that moved to 10.5. Soon, we will be on the cloud.

We're using IDMC, which is not just Data Quality. It has governance, Axon, and other applications in it.

We're just a customer.

I'd advise people to research use cases before beginning. Companies need to understand what they are trying to achieve, figure out their requirements, and then appraise the solution. 

While Informatica is good in terms of Data Quality and is probably the leading option, you need to be clear about budget, et cetera.

I would rate the solution seven out of ten.