Try our new research platform with insights from 80,000+ expert users
reviewer2311707 - PeerSpot reviewer
Consultant at a computer software company with 1,001-5,000 employees
Reseller
Top 20
A scalable and stable product with good workflow functionalities
Pros and Cons
  • "It is a very stable solution...It is a scalable solution."
  • "There are some limitations with Informatica Axon when one tries to connect or integrate it with Jira."

What is our primary use case?

My company works with our different customers to implement and install the solution.

What is most valuable?

The workflow in Informatica Axon is intelligent and good. Informatica Axon provides good data collection and good search criteria. In Informatica Axon, workflow and business glossary are good.

What needs improvement?

There are some limitations with Informatica Axon when one tries to connect or integrate it with Jira. For example, I can't delete any workflows after the integration process. There are issues with the integration capabilities of the tool with third-party solutions, specifically Jira.

For how long have I used the solution?

I have experience with Informatica Axon for two to three years.

Buyer's Guide
Informatica Intelligent Data Management Cloud (IDMC)
November 2024
Learn what your peers think about Informatica Intelligent Data Management Cloud (IDMC). Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
817,457 professionals have used our research since 2012.

What do I think about the stability of the solution?

It is a very stable solution.

What do I think about the scalability of the solution?

It is a scalable solution.

I recommend the solution to big companies because its functions are suitable for high-end companies.

How are customer service and support?

The P1 support offered by the solution's technical support is very fast. If it is not P1 support, the support a user might get will be slow as it takes time. I rate the technical support a seven out of ten.

How would you rate customer service and support?

Neutral

Which solution did I use previously and why did I switch?

For data governance, I work with Informatica Axon only. I prefer Informatica Axon for enterprise metadata management at an enterprise level, data quality, and integration. I only recommend Informatica Axon, mainly for data governance.

How was the initial setup?

The product's initial setup phase is very easy.

For each of our company's customers, with an installation scope in place, it doesn't take much time. The product's implementation scope differs from the installation scope. I usually help our company's customers implement the tool.

The solution is deployed on an on-premises model.

What other advice do I have?

Informatica Axon is a very good product with an easy implementation phase and a lot of information about the tool available online on the internet.

I rate the overall tool an eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Reseller
PeerSpot user
InitZero - PeerSpot reviewer
Enterprise MDM Architect / Solution Arch at Volvo Group
Real User
Top 10
The best MDM solution in the market with good data cleansing capabilities and good stability
Pros and Cons
  • "Its data cleansing capabilities are very valuable. The match and merge and the audit trail functionalities are very good."
  • "Their support should be improved. We have had some trouble with their support from time to time. Its scalability should also be improved. I would also like to have a bit more modern and friendly UI for the end-users. There should definitely be a simplified way to configure and set it up."

What is our primary use case?

I have worked with two clients implementing Informatica MDM. One use case was for the regulatory master data in big pharma (using multidomain edition), on premise installation. The other installation was related to several data domains implemented using Informatica multi-domain MDM edition, but hosted by vendor.

How has it helped my organization?

Helped identifying and reducing data duplication. Helped in improving data quality.

What is most valuable?

Its data cleansing capabilities are very valuable. The match and merge and the audit trail functionalities are very useful. Review and approval workflows are widely used by the user community.

What needs improvement?

Informatica support should be improved, as resolution of some cases takes definitely too long. Scalability of the solution should also be improved.

I would also like to have a bit more modern and friendly UI for the end-users. There should definitely be a simplified way to configure the system and set it up for the end users.

For how long have I used the solution?

I have been working with Informatica MDM for three years - on premise and hosted version. I started with MDM 10.2, and then with version 10.3 upgrade to 10.4, which is the latest one.

What do I think about the stability of the solution?

Its stability is pretty good. We don't have any major concerns.

What do I think about the scalability of the solution?

It is scalable, but its scalability should be improved especially with the hosted version.

It is a strategic MDM solution in the company, so it is extensively used.

How are customer service and technical support?

We have had some trouble with their support from time to time. Resolution time could be improved.

Which solution did I use previously and why did I switch?

We have been replacing several very old solutions which reached end of extended support life and several old bespoke systems.

How was the initial setup?

It is a pretty complex product, so the initial setup is also complex. You require skilled resources to deploy this product. Its deployment can take several months.

What about the implementation team?

We use an experienced system integrator and seasoned external consultants.

What other advice do I have?

It is a pretty good and advanced tool, but at the same pretty complex to set up. To implement Informatica MDM, you should look for very skilled resources with past experience in deploying Informatica MDM, not competitive solutions. 

Informatica MDM is one of the best in the market in the master data management area. Make sure that you realize the potential of this solution and like with all other MDM projects - plan your roadmap carefully. Start small, enable most important capabilities and then work on enabling additional features.

Don't overengineer. Informatica MDM is very flexible in defining the underlying models, setting up workflows, enabling cleansing, etc. Hence a risk of misusing the product or make it too complex and downgrade its performance of usability. If you don't have really skilled resources who have worked with Informatica MDM, there is a good chance that the project will simply fail, or it will take you much longer than expected to deploy and benefit from this product.

I would rate Informatica MDM a nine out of ten.

Which deployment model are you using for this solution?

Private Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Informatica Intelligent Data Management Cloud (IDMC)
November 2024
Learn what your peers think about Informatica Intelligent Data Management Cloud (IDMC). Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
817,457 professionals have used our research since 2012.
Senior Solutions Architect at NessPRO Italy
Real User
A centralized repository for orchestrating and sharing data but performance can be a little slow
Pros and Cons
  • "Performance and flexibility-wise, they're very user-friendly."
  • "The initial setup was not very straightforward. Not complex, but not very simple either."

What is our primary use case?

We are simply service providers; I don't think our relationship with Informatica is that strong. We have a financial client that has a very good relationship with Informatica. They were recently using PowerCenter and IDQ, but a couple of years ago, they purchased DIH. Recently they have been doing some POC using Informatica, Enterprise Data Catalog. They have a great relationship with Informatica. 

What is most valuable?

We don't use Informatica Data Integration Hub extensively. I enjoy using it to create multiple publishing models.

What needs improvement?

The solution is good but recently, we have stopped using this product because we were not using it extensively. If you are using Data Integration Hub, it should be as a centralized repository, where it can communicate with many systems. For our current client, we are only using it for two source systems, which are not driving big revenue. For this reason, we stopped using Data Integration Hub and started publishing the news directly.

At present, I am not sure how many sources it can communicate with (how many multiple connectors are available). Nowadays, they're coming up with many connectors. It can communicate with all of the Cloud connectors and Cloud databases. If they could leverage social media connectors, I think that would be great a great asset. If they added this feature, it would be much more scalable.

For how long have I used the solution?

I have been using this solution for almost two years. 

What do I think about the stability of the solution?

We encountered a few bugs in the coding page, but we faced bigger issues with Informatica PowerCenter. The data was not loading correctly for certain multi-regional datasets; when we analyzed the data, we tracked it to the same code page from the starting point to the end. Other than that, we never faced any difficult situations.  

How are customer service and technical support?

We never had to use their technical support. We resolved any issues ourselves and thankfully, we never experienced any problems that we could not handle. 

How was the initial setup?

The initial setup was not very straightforward. Not complex, but not very simple either.

What about the implementation team?

Deployment took roughly one week — 40 hours max from start to finish.

We have a team of 30 to 40 people who handle all maintenance-related issues. 

What's my experience with pricing, setup cost, and licensing?

Informatica products are always increasing in price. Nowadays, many of their customers are leaving and seeking other data integration tools. That's the only drawback with Informatica. Performance and flexibility-wise, they're very user-friendly, but comparatively, their prices are a little bit too high.

What other advice do I have?

Presently, everything is moving to the cloud, and moreover, many people are moving to Snowflake Data Warehouse, as it provides more scalability. I feel the usage of DIH is very limited compared to Snowflake because Snowflake holds and stores highly compressed data and allows you to use different cloud-based tools, including AWS services, DCP, and other services. Snowflake also comes with Matillion, which is a very good ETL tool.

The use of DIH is very limited. Anything that we do with DIH, can be done with Snowflake, regardless of the subscription you may have. There are plenty of use cases — you can use it to build tables and consume it from the downstream. For these reasons, I believe that DIH is currently not doing as well as Snowflake in the market.

On a scale from one to ten, I would give this solution a rating of seven. Performance-wise, it could be better. The performance-related Issues could be due to low infrastructure, but for whatever reason, sometimes the performance is slow.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Technical Architect at Cognizant
Real User
Great user interface; could be more user friendly with a simplified mapping task
Pros and Cons
  • "The user interface which is very easy to use if we have any problems to solve."
  • "A general improvement in icons and the virtual interface would be good."

What is our primary use case?

Our primary use case for the solution has been in some of our smaller pilot projects.

What is most valuable?

One of the main valuable features is the user interface which is very easy to use if we have any problems to solve. We don't need to install any client machines to do this, we can access from any machine. 

For the past six and a half years I also worked with PowerCenter, so I used to see the big icons and it's very easy for me to do. But with moving to Cloud there have been some challenges but it's getting better. We are able to connect to a lot of structured data, there are a lot of provisions. 

What needs improvement?

The user interface could be more user friendly with a simplified mapping task. In general, improvements could be made in mapping. When we create mapping from uploaded data, I'd like to see integrational mapping. I possibly need some extra time to grasp it all but a general improvement in icons and the virtual interface would be good for us. We are working as developers and we're working with the solution on a daily basis so any improvement would be good in this area. 

What do I think about the stability of the solution?

As far as my knowledge base goes, I feel pretty good with the stability of the product. 

How are customer service and technical support?

I think technical support is awesome. Initially it feels challenging connecting with IACS, but I am able to get assistance and then apply it immediately. I feel like we're always getting good support from Informatica, even when there are technical challenges, it's one of the best things about the solution. 

What other advice do I have?

I would rate this product a six out of 10. 

Which deployment model are you using for this solution?

Private Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Reviewer312 - PeerSpot reviewer
Software Architect at a manufacturing company with 501-1,000 employees
Real User
It has become an easy way to exchange information through any cloud application.
Pros and Cons
  • "It has become an easy way to exchange information through any cloud application."
  • "The biggest challenge I see is the IDE's for the cloud and automization are different."

What is our primary use case?

Our primary use case for this product is two-fold: 

  • Reporting- If the users want to visualize into a meaningful report then they would pass on that as a requirement to the Informatica team. This goes to the Informatica team, which will then apply the business rules and validation, cleansing or whatever else is needed on top of the data set.
  • ETL-There is a lot of information that is required by multiple downsizing applications. So, if the file of information is huge, it does not fit into application integration use case so then Informatica can take a huge set of data and pass it onto several downsizing applications.

How has it helped my organization?

It has become an easy way to exchange information through any cloud application. As the overall solution guidelines that we get from our solution checking, a connection to an outside cloud application cannot be a direct integration.

What is most valuable?

My most valuable features of this solution are that the DI team uses the Informatica Powercenter, which is an automized tool that Informatica provides. For quite some time, they have been using this. So, the cloud products are coming from the same school of thought, which makes it more believable that it can do whatever it is required to do. And, I think that was the primary reason for going with Informatica on Cloud The majority in terms of dating their product promptly is something that is quite apparent.

What needs improvement?

The biggest challenge I see is the IDE's for the cloud and automization are different. They could have made an IDE in such a way that you can write an integration for the cloud. If I had the flexibilty of making that decision later, that would be a great benefit to have.

In addition, another improvement could be if you develop and design your integration without being connected to the server. If you could deploy it anywhere, that would be helpful.

For how long have I used the solution?

One to three years.

What do I think about the stability of the solution?

I think that it is the best in the category.

What do I think about the scalability of the solution?

It is scalable.

How are customer service and technical support?

We have our own team that helps us with support issues. I do not have any experience with the Informatica tech support team.

Which solution did I use previously and why did I switch?

We also have prior experience with IBM Cast Iron.

How was the initial setup?

I was not involved on the initial setup.

What was our ROI?

A product must have: quality, performance,good pricing and scalability.

Which other solutions did I evaluate?

We also considered MuleSoft. We reviewed MuleSoft and found it to be a competitor that has some of the features missing from Informatica. But, it is not completely a perfect competition because it is more into application integration and API management. But, I think that Informatica can aspire to do the same.

We also considered Dell Boomi Atmosphere, but we did not do much research into that particular solution.

What other advice do I have?

The amount of usage that we see in Informatica on Cloud is going to increase. And, correspondingly, the usage of the automized version of Informatica that we use is going to decrease because exchanges are going to be more towards the cloud.

I suggest that someone considering this solution should take a minimilaistic free license, and do a proper analysis of the solution. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
AJAY PANDEYA - PeerSpot reviewer
Member at Nice Software Solutions Pvt. Ltd.
Real User
Top 20
Provides businesses with a 360-degree holistic view of their data
Pros and Cons
  • "It is a highly scalable solution."
  • "If I want to scan the metadata from the data lineage or the Python code, such areas can get tedious in the tool."

What is our primary use case?

I use the solution in my company and have worked with two tools from Informatica, both on on-premises and cloud models. I have experience with Informatica Axon, and I have used the cloud services under Informatica CDGC.

The use case of the tool is basically in the banking sector. It is used to optimize certain areas of a project. In Europe, we have a GDPR implementation. In the Middle East, there is the Central Bank of the UAE and UAE data protection law. Implementing data protection laws and ensuring that all the policies are enforced for financial security is my use case. I have to make sure the bank or financial institution meets the requirements of the Central Bank of the UAE. Data quality is another use case where my company handles corporate and retail customer data, and protecting their information is known as PII. The tool ensures that the system holds the PII data properly.

What is most valuable?

For data lineage, we look for things at a transformation level and how the data is transforming and managing the ETL mapping. Every tool gives this information about how the data goes, but our company is interested in knowing how the data is transforming and the transformation logic between the two data sources.

What needs improvement?

There are some tool limitations. Some connectors do not scan the metadata properly. If I want to scan the metadata from the data lineage or the Python code, such areas can get tedious in the tool. To manage such areas, one needs to have a lot of coding knowledge, and you need to know how to apply the code, and only then can you get it fixed. There is no user-friendly enterprise.

There are certain shortcomings even if we opt for subscription-based technical support.

For how long have I used the solution?

I have been using Informatica Axon for four years. I work as a consultant.

What do I think about the stability of the solution?

It is a stable solution. Once it is implemented, we will handle everything for the business. Stability-wise, I rate the solution an eight out of ten.

What do I think about the scalability of the solution?

It is a highly scalable solution. Scalability-wise, I rate the solution an eight out of ten.

The tool is meant for enterprise-sized businesses.

How are customer service and support?

I rate the technical support a six out of ten.

How would you rate customer service and support?

Neutral

Which solution did I use previously and why did I switch?

I have experience with Informatica Data Governance.

How was the initial setup?

If one is difficult and ten is easy, I rate the product's initial setup phase an eight out of ten.

The solution is deployed on the cloud, specifically if you have cloud-based virtual machines. If there are compliance issues, and you need to hold the metadata only on-premises models, you can do that, too.

The solution can be deployed in a few days.

What's my experience with pricing, setup cost, and licensing?

It is an expensive solution. I would say it is the most expensive solution in the market.

For the features of the software, the price is justifiable.

What other advice do I have?

Speaking about how the tool enhances data governance tasks, I would say that we have three types of users, consisting of the consumer, who are normally a business user, then we have a developer and finally the admin. Our company onboards the user, and then the user can collaborate, comment, ask questions, give ratings to their assets, publish the data to the marketplace and go for downloads.

One needs to resolve the problem that stems from the fact that different people can have different understandings of the concepts associated with the tool. A database administrator may see an area as a table, but for a business, it may be a person. The tool gives you a common understanding of the business concept. The tool also provides lineage data and how the business data is performing. It provides an interface between organizational policies, the different processes governed by a certain policy, and the different systems governed by which policy. The tool gives you a 360-degree holistic view of the data.

The cloud version of Informatica Axon utilized the AI for the classification purposes, data domain and automatic data tagging. In my company, we use the tool's AI capabilities.

I will recommend the tool to others.

I rate the tool an eight out of ten.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Flag as inappropriate
PeerSpot user
Rohit-Verma - PeerSpot reviewer
Practice Head Director at Coforge
Real User
Has a good match and merge function and is very stable
Pros and Cons
  • "It has improved our organization because it has made our data more reliable. Data is the most important asset these days, and in order to trust your data, you need these tools to make sure that your data is clean and reliable."
  • "New machine learning could be added to Informatica MDM because the solution is outdated and is not moving with the current trends. The solution is good, but it definitely needs a lot of improvement and needs to speed up as per the market."

What is our primary use case?

We use Informatica MDM for various clients for integration, removing duplicates, and centralizing data in one place.

How has it helped my organization?

It has improved our organization because it has made our data more reliable. Data is the most important asset these days, and in order to trust your data, you need these tools to make sure that your data is clean and reliable.

What is most valuable?

The match and merge function is good.

What needs improvement?

New machine learning could be added to Informatica MDM because the solution is outdated and is not moving with the current trends. The solution is good, but it definitely needs a lot of improvement and needs to speed up as per the market.

Artificial intelligence is something which they should add to the solution.

They need to do MDM on real-time data as well.

The price is a big factor. We try to convince our clients to go for Informatica, but the cost is too high, and they choose another product.

For how long have I used the solution?

I've been using this solution for 15 years.

What do I think about the stability of the solution?

It's a reliable and perfectly stable solution.

What do I think about the scalability of the solution?

It is scalable but to a certain limit.

How are customer service and support?

I'm satisfied with the technical support.

Which solution did I use previously and why did I switch?

Previously, I used IBM MDM, Orchestra Networks MDM, SAP MDM, and Oracle MDM. I have used a lot of MDM tools, and I've found that Informatica is the best solution out of all of them in terms of the architecture and user-friendliness. Also, the graphical user interface is very simple to use.

How was the initial setup?

The initial setup is not very straightforward but not very complex either. It's somewhere in the middle.

Deployment can take six to seven months to a year or two years. It depends on the number of domains and the number of data sets you need to implement.

A team of eight to nine people can usually handle the deployment.

We mostly deploy on-premises and sometimes on the cloud. Informatica is very weak on cloud-based computing though.

What about the implementation team?

We implement the solution for our clients.

What was our ROI?

Based on my clients' feedback, they have seen a return on investment in the long-term. After five or six years, they can definitely see that the value of their data is growing.

What's my experience with pricing, setup cost, and licensing?

Informatica MDM is very expensive. Apart from licensing fees, they have broken down their products into multiple products, and they charge for each and every product. If the data is huge, they charge for the data. At times, we have to use third party services for data cleaning, and they charge for that as well.

What other advice do I have?

If you are choosing Informatica, then you need to employ the right kind of service provider. If you don't have good implementers, you'll not be able to leverage the product. So, choose your consultant and service provider wisely; then, you will not have any issues when implementing Informatica.

I would rate Informatic MDM at eight on a scale from one to ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
PeerSpot user
Raghavendra Rao - PeerSpot reviewer
Solution Architect at Refinitiv
Real User
Lacking features, migration strategy needs improvement, but reliable
Pros and Cons
  • "Informatica Cloud Data Integration is stable."
  • "The cloud version of the Informatica, it's a very substandard product. They might say it's enterprise-ready but it's not at all ready. They need to add more features, such as improved data replication features. If you look at other tools, such as Matillion they are now cloud-native and flexible. Additionally, Informatica Cloud Data Integration should have a good migration strategy from Informatica PowerCenter to Informatica Cloud Data Integration."

What needs improvement?

The cloud version of the Informatica, it's a very substandard product. They might say it's enterprise-ready but it's not at all ready. They need to add more features, such as improved data replication features. If you look at other tools, such as Matillion they are now cloud-native and flexible. Additionally, Informatica Cloud Data Integration should have a good migration strategy from Informatica PowerCenter to Informatica Cloud Data Integration.

For how long have I used the solution?

I have been using Informatica Cloud Data Integration for approximately 17 years.

What do I think about the stability of the solution?

Informatica Cloud Data Integration is stable.

What do I think about the scalability of the solution?

The scalability of Informatica Cloud Data Integration can be good if you plan well with your enterprise.

How are customer service and support?

The technical support from Informatica Cloud Data Integration is good.

I rate the support from Informatica Cloud Data Integration a four out of five.

What was our ROI?

We have received a return on investment using Informatica Cloud Data Integration.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free Informatica Intelligent Data Management Cloud (IDMC) Report and get advice and tips from experienced pros sharing their opinions.
Updated: November 2024
Buyer's Guide
Download our free Informatica Intelligent Data Management Cloud (IDMC) Report and get advice and tips from experienced pros sharing their opinions.