Informatica Intelligent Data Management Cloud (IDMC) Reviews

Our use cases were related to the financial and banking sectors. We created data and transferred it to the enterprise level. 

The most valuable feature of Informatica Axon is features, interfaces, and data mapping. It represents clusters nicely. 

The solution should improve its integration. 

 I have been using the product for three years. 

Informatica Axon is stable. 

The product is scalable. 

The tool's support is fine. 

Informatica Axon's deployment is straightforward. 

I rate the product an eight out of ten. 

We use the solution for data modularization.

The solution has the best feature for parameterization. We can apply it at the mapping and task flow levels. It helps with auto-linking and dynamic linking options for flexible data integration.

The solution's capability to handle large volumes of data compared to its on-premise version needs improvement. Its features for partitioning and optimization could be better as well. There needs to be more options for partitioning, including database partitioning, pass-through partitioning, etc. Additionally, it doesn't support XML data types for SQL server databases. Also, it captures success and targets rows only within a system-defined area. It should be able to capture and track the number of rows processed by each pipeline.

Presently, users need to write code against the existing APIs to access information data. It is a complicated process due to the limited functionality of APIs. Instead, there could be an option to write queries against repository tables to fetch the data like its on-premise version.

We have been using the solution for two years.

The solution's technical support team could be responsive. We have to contact their global support team to raise new feature requests. Currently, we encounter issues with parameterizing email IDs at the task level to configure features for success, warning, and failure. We sent a request to them back in 2020, but they are yet to add those features.

I rate the solution a seven out of ten.

Informatica Cloud Data Integration is being used to transform data. Primarily, it is for creating data pipelines.

Informatica Cloud Data Integration is being used to transform data. Primarily, it is for creating data pipelines.

Integration is a valuable feature. Currently, the integration makes our security more robust, especially when compared to IICS, where we would need to make arrangements through native or other ways to handle that, and here using sum up makes our lives easier.

With the solution, we had some issues, and we have every day, and we used to open a ticket. Sometimes, there are data issues and transformation issues. So things are not very mature. They need to improve in the aforementioned areas. We are hoping that it will be sorted out in some time, and we will get to experience a hassle-free life.

My company does business with Informatica. We are using their product. I have been using Informatica Cloud Data Integration for four to five years. I am an end user of the solution. Also, I am using the solution's latest version.

I think they are working. Their engineers are still working on some transformations and some features. It is not as stable as they are thinking, but in the last two years, we have seen good progress. So, we are hoping for a similar thing in the future as well. So it is scalable. But, stability-wise, I think that a more stable version is going to come.

I think it is a scalable product. Around a hundred users are using the solution in my company.

The support is very good. On a scale of one to ten, I rate the technical support between eight and ten.

Positive

So we've got many solutions. Not before going to Informatica, but we were evaluating and working with other sets of tools as well. So, on AWS, it is EMR and Glue. We quite frequently use Glue for data pipelines. We also use SAP S/4HANA for delegation. I like IPC and IICS because I have experience in them for the last fifteen years, and I'm working using the same tools. So, I mean, it is my biased opinion. Otherwise, since I have not caught exposure to the other tools in the market that the people in my company are using in different teams, I don't have much exposure to them. Had I gone through those experiences, I would probably have recommended some other tools as well. Currently, I'm in this industry using this tool only, so I recommend it only for that reason. 

The initial setup was very easy. Currently, we are in a deployment process. We've not yet orchestrated that part, but we are in the process of creating the deployment pipelines.

I have deployed the solution on the cloud. Also, there is no maintenance required for the solution.

Cost-wise, I think it is on the higher side, and that is why we are looking for some better options. Licensing costs are huge compared to other players in the market and for my company.

It's a good tool to start with in the beginning.

The product is maturing and has not matured yet. If I look at the market, there are other tools that are providing this stable solution. I rate the overall solution between five to six out of ten.

We use Informatica as our one-stop cloud integration solution. We are connecting two different data systems like SAP or Salesforce, integrating on-site financial data with some applications that process financial information like an ERP to plan budgets and forecast revenue. I'm creating a data warehouse and using that with tools like Power BI to create reports and dashboards.

Informatica is good for integrating data and cloud applications. We have connectors for integrating cloud applications like Salesforce. You can quickly integrate anything with an exposed API or a REST API.  The industry is increasingly shifting to the cloud, so we need more products that can connect to cloud-based applications. The integration is seamless and works in real time. It's also secure because you don't need to expose databases or tables. 

There is room for improvement at the highest level in terms of useability and connectors for various types of new applications. The row processing performance could be better because you experience some latency dealing with high volumes of data. Most organizations will be dealing with multiple cloud applications, so you could see performance issues moving from one system to another. 

I have worked with Informatica products for about seven or eight years.

I rate Cloud Data Integration seven out of 10 for stability. Even though Informatica is based in the cloud, it still depends on a secure agent deployed on-prem. The performance of the individual machine where you install the gateway can affect the stability. 

I rate Cloud Data Integration eight out of 10 for scalability. 

I rate Informatica support eight out of 10. They have a dedicated customer success portal where you can search a lot of knowledge base articles that tell you how to use Informatica in various scenarios. You can also use the portal to raise a support ticket describing your scenario, what you hope to achieve, and where you're having problems. The technical support responsiveness and dedicated customer support are decent enough. 

Positive

I have some experience with Azure Data Factory, and I worked with another Informatica product called PowerCenter. I switched to Informatica Cloud Data Integration because my customers' needs changed. More companies began prioritizing clouds. As developers, we also needed to scale up our services.

I'm not aware of the exact licensing cost because the senior management handles that, but I know that products like Azure Data Factory are less expensive than Informatica. At the same time, Informatica gives you more options and connectors. Everything is possible, whether you want to do API-based integration, traditional data integration, etc. 

Azure Data Factory is more useful for connecting with the Azure cloud. You can also play around with the native data integration tools that other cloud providers offer, like GCP or AWS.

I rate Informatica Cloud Data Integration eight out of 10. I recommend Informatica as an integration tool for large and medium-sized enterprises migrating to the cloud. Cost is something to keep in mind because Informatica might be too pricey for smaller companies. Large and medium-sized companies can easily afford it if they plan to use it as a one-stop solution for all their cloud integration and management needs.

If you need a middle layer to build your pipeline, that can be achieved using Azure Data Factory or any other data integration tool. Still, Informatica has some advantages in terms of connectors and help desk resources. When you contact the Informatica help desk, you can speak with engineers who helped develop the Informatica platform, so they have rich experience with integration technologies. The product itself is highly reliable and suitable for your integration needs. 

Azure Data Factory has almost 80 percent of the same features, and it might work for you if you have a Microsoft ecosystem. Using Data Factory is cheaper. However, if you're a large or medium-sized organization or a reseller and your data is more valuable, it might make more sense to use Informatica at that scale. You'll be interacting with many more types of applications and might need to integrate the applications in various ways.

We use Informatica Cloud Data Integration because we have multiple sources for data integration, and we transform that data and load it into the database or QuickBooks.

There are fewer than 10 people using this solution in my organization.

I'm an integrator. I'm working with the latest version. 

It's deployed on cloud.

Data integration is the most valuable feature. The ability to connect to any of the sources and enterprise applications makes our lives easier.

We would like to have accessibility to the repository. We had that feature in Informatica PowerCenter, and we were able to have access to the repository query, which helped us build some tools, audit tools, and review tools. In Informatica Cloud, accessing the repository query is a challenge.

I have used this solution for about six years.

It's very stable.

It's scalable. 

We reach out to technical support frequently. We've had good experiences with them.

We previously used PowerCenter, DataStage, and Oracle Data Integrator.

I prefer Informatica Cloud Data Integration because of the ease of connecting to various connectors and various enterprise applications. The UI is also a valuable feature.

Initial setup isn't straightforward or complex. It's about medium difficulty. 

Deployment took about one week. It's not difficult to maintain.

Deployment was done in-house.

From the usage perspective, there is minimum ROI.

The pricing is high compared to other tools on the market.

We chose Informatica Cloud because we have Salesforce. If you're using Data Integration, App Integration, and many other features like operational insights, then the price is worth it. If you're only using the solution for data integration, then the price definitely isn't worth it.

We export APIs, and anyone can seek those APIs to have the data for target use cases. We hit the APIs that are exposed by external systems, and we get the data from them and process it.

We're using the latest version. It's deployed on cloud.

There are about five people who are using this solution in my organization.

We chose Cloud API Integration to connect to Salesforce.

The OAuth feature is the most valuable for authentication.

Recently, we're trying to connect to the Amazon API. There's no direct way to connect to Amazon APIs from Informatica Cloud. From Postman, there's a signature site called AWS Signature, which would actually generate the signatures for us with AWS APIs. In Informatica Cloud, we have to build the logic, and then we can generate the signature and hit the AWS APIs. Instead of generating that signature, it would be better if we could have the same connector in Informatica Cloud.

Sometimes when I open the processes or any service connectors, the labels are not properly displayed. The backend names are displayed rather than the front end label. I usually log out and log back in, and sometimes it disappears, and sometimes it doesn't.

I have used this solution for six years.

It's pretty stable. We don't have any concerns.

It's scalable.

I would rate technical support as six out of ten.

Setup is straightforward. It takes a week to do the installation and configuration.

It's not difficult to maintain.

I would rate this solution as eight out of ten. 

I would recommend this tool to other users.

We use MDM to get more data quality. We are partners with Informatica and I'm a senior technical lead and practice architect.

The fuzzy matching capability is a great feature as is the network hierarchy which is the new concept code. 

I think the UI could be improved. We're also currently facing issues with real-time integration and if Informatica had their own it would be helpful. They need to look into the user mechanism and the security access mechanism in the data governance process. One of the major features is access control and access data management and they need to work on that because I have observed some data glitches.

I've been using this solution for six years. 

The solution is stable.  

The solution is scalable. There is room for improvement in terms of scalability with the MDM SaaS. With limited data it's fine, but with a large volume the scalability is questionable, the threshold of data transaction is different. We are a service-based company, so there are limited users within the company. From the customer side, there are multiple users. 

We sometimes have technical issues and the customer support responds in a timely manner and is quite good.

The initial setup is easy. Deployment takes around 15 minutes and we have 22 internal users in our company. 

We pay an annual license. Mobile players are unable to afford the product. Different MDMs have different pricing approaches but there needs to be room for mobile players.

We went with Informatica because we have functional and non-functional requirements with respect to the market data management of our customers and Informatica is a suitable product for their needs.

This is a good solution although it's expensive and even though we are integrated with Oracle DB2, we're unable to integrate with multiple things. The market is changing and there are many more options so we have to think about the integrations of multiple databases. 

There are some additions or improvements that could be made so I rate this solution eight out of 10. 

We were trying to publish a compendium of all our various assets using an Oracle-based data warehouse. We also had vendor-based solutions like Epic for electronic medical records on an SQL Server base. We had many research systems on various platforms because it's a cancer research institution. 

We wanted to pull together a comprehensive data catalog to show people all the different assets we had and where they could go to find things. If there were vendor-based definitions of things, we'd pull in the definitions and various attributes. It's a heterogeneous environment data-wise. We get a lot of value from a comprehensive enterprise catalog.

It's available on our intranet through a data governance portal. You could go there for a catalog, quality reports, etc. In a year, there may have been 500 unique visitors. It was my job to publicize it, but I didn't necessarily do a good job. I worked with research groups and clinicians to get their stuff on it, and they would tell other people about it. The nice thing about Informatica is that it was easy to link from our internal web portal to their catalog. I had excellent developers working for me. It didn't require much development, and it took less and less as time went on. 

I like EDC's self-service capabilities. You can put the catalog on the intranet inside the organization, so users can search for something. People in the research world have specialized systems, and you might find data from various places that sound similar. 

The purpose of the Enterprise Data Catalog was to build an internally searchable catalog of stuff. You may not have permission to see this data but at least you could find out where it was and contact the person who owns it. 

Interoperability is one area where EDC has room for improvement. It was challenging when the faculty took over the data world and had specific vendors they wanted to use, and some were not particularly open platforms. 

It was a challenge to promote data visibility while also jumping through hoops to take some of the proprietary things and make them part of the calling, especially when the vendor doesn't necessarily support interoperability. You need to export things from a vendor program and import them again. 

We used Informatica for a lot of the data governance stuff I worked with when I joined the company, including things like cataloging and profiling data. The organization has really changed a lot in the last year and went with Informatica EDC. They're moving from the on-prem version to the cloud.

Informatica is a strong company, and EDC is a solid platform. 

The scalability is excellent. Informatica really knows what it's doing. They're smart people and great engineers. 

Informatica's customer service and support were decent. They listen to their customers. If something is missing or wasn't working, they will put it on their roadmap. They were listening to customers for roadmap stuff. 

We wound up building a staging database to pull stuff out of the EDC, stage it, and then access that. It was open, so we would often have an intermediary layer at Oracle. If we wanted to show, for example, data quality over time, we would have a weekly quality process that would run. We staged that in an Oracle database, and the portal could access that.

We had to build Informatica pipelines and do some Azure work to feed data to them. With data warehousing, you typically have static data that is timestamped daily or weekly and sometimes monthly or annually.  We were trying to get real-time data, like blood pressure monitoring and stuff like that. That was a lot of work. I didn't do it. The integration team. 

When I joined the company, it was an Oracle-based solution. Then Epic took over, which was SQL Server-based. After that, they went to Azure. Now, all the analytics are supposed to be on this platform, and it's not particularly open. 

Setting up Informatica EDC is usually pretty straightforward. The challenge is working with vendors like Oracle and Microsoft, which have APIs for integrating things. You can query what they have. They want it to play well with other vendors because they know customers don't only have one brand of product. In some cases, you get vendors in there that are, "No, we're not going to do that because we're so special." It was a challenge. The platform of choice for data initiatives at the cancer research institution is Palantir. 

We didn't look for an alternative, but Azure has its own catalog.

I rate Informatica Enterprise Data Catalog nine out of 10. It's a great solution, and I was happy with it. It did everything I wanted, and Informatica dramatically increased the integration points over time. When we started, it was like Oracle and SQL Server, but now they're adding NoSQL databases and others.

Informatica has user groups and listens to user input. One of the people that worked for me hosts an annual Informatica user group in Houston. You can try to build your own Oracle-based or SQL-based solution. They listened to the market, and they're working on improving the interoperability. Maybe it works better with Palantir since I left, but they work across all platforms. They're making it Cloud-based. I didn't know anything about them before I got here. I was dropped into a department where Informatica had been for at least five or six years, and it was a good choice.