Try our new research platform with insights from 80,000+ expert users
Developer at NorthCap Technologies
Real User
Top 10
Easy to setup and efficient tool for data management
Pros and Cons
  • "It's good for tool management, maintaining the golden record of customer status."
  • "Data integration should be improved."

What is our primary use case?

I mainly use it for data management.

What is most valuable?

It's for tool management, maintaining the golden record of customer status.

What needs improvement?

Data integration should be improved. Another area of improvement is customer applications, along with business 365 application case integration between applications.

For how long have I used the solution?

I have been using this solution for three years now. I work with the latest update.

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.
815,442 professionals have used our research since 2012.

What do I think about the stability of the solution?

I would rate the stability a six out of ten. There is room for improvement in the stability.

What do I think about the scalability of the solution?

I would rate the scalability of the solution an eight out of ten. There are currently nine end users in my team. There might be more people in the company. 

Recently, Informatica MDM upgraded, it transitioned from its traditional on-premise MDM offerings to a cloud-based platform called Informatica Intelligent Cloud Services (IICS). So, we are not planning to expand its further usage.

How are customer service and support?

The customer support and service are helpful. 

How would you rate customer service and support?

Neutral

How was the initial setup?

I would rate my experience with the initial setup an eight out of ten, where one is difficult, and ten is easy. 

It is very easy to set up. However, the deployment time depends on the configuration. It can take 10 to 15 minutes.

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

The pricing is reasonable.

Which other solutions did I evaluate?

 

What other advice do I have?

The users should have more training on Informatica MDM, especially practical training. The vendor should provide some practical training.

Overall, I would rate the solution an eight out of ten.

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
ArturKowalczyk - PeerSpot reviewer
Technology Innovation Leader at Netrix S.A.
Real User
Top 5
Reliable, has good support and offers a wide coverage of technologies
Pros and Cons
  • "The solution scales well."
  • "The solution is quite expensive."

What is our primary use case?

The product is used for data governance. It's a tool for data governance, a technical metadata dictionary, and a data lineage repository.

What is most valuable?

So far, we have been pleased with its capabilities. 

It has a wide coverage of technologies. 

The solution scales well.

It is stable and reliable. 

The technical support has been helpful.

What needs improvement?

The initial setup is very, very difficult. 

The solution is quite expensive. 

I would like them to extend the coverage to other technologies like web services and programming languages.

For how long have I used the solution?

I've been using the solution for six months. 

What do I think about the stability of the solution?

It is stable, and it is reliable. The performance is good. We haven't dealt with bugs or glitches. It doesn't crash or freeze. 

What do I think about the scalability of the solution?

We can scale the product.

We have about 50 users on the solution right now. It's not used too extensively just yet. It will be in the future, however. We do also have plans to increase usage. 

How are customer service and support?

We've used technical support previously and found them to be quite good. We are satisfied with the level of support we can get. 

How would you rate customer service and support?

Positive

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

We did not previously use a different solution. 

How was the initial setup?

The initial setup is not straightforward. We found it to be quite difficult. It took us about two weeks to deploy it.

We have ten people that can handle deployment and maintenance tasks, including a team leader and project manager. 

What about the implementation team?

The implementation can be done in-house with a lot of effort.

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

I'm not sure of the exact cost, however, the range is in the hundreds of thousands of dollars. It's very expensive. 

What other advice do I have?

I'm not an experienced user of it. I used it in workshops, and I use other Informatica products, so I have some relevant knowledge.

I deal with the latest version of the solution. 

I'd rate the product nine out of ten and can recommend it to others to use. 

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
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.
815,442 professionals have used our research since 2012.
reviewer1648275 - PeerSpot reviewer
Senior Architect at a computer software company with 5,001-10,000 employees
Real User
Can handle most use cases out of the box
Pros and Cons
  • "New tools are coming out that will enable you to achieve 90 percent of use cases with the out-of-the-box configuration, but I would like to keep Informatica tight here. Otherwise, you need a Java user edit course and other things to do multiple things that you cannot configure out of the box. They have to go through those use cases to do something if those can also be configured rather than coded."
  • "We promote our code changes from a lower to a higher environment, which is highly complex when working with a multi-domain MDM like Informatica. This is the biggest obstacle for Informatica MDM, and I think they should change it because that's very time consuming."

What is our primary use case?

We have it deployed on the cloud, but I don't think Informatica has been involved much with cloud-based solutions. They have multiple issues, especially related to LDAP and other configurations. Plus, their certified and supported versions are also not what every client has, so they're still evolving in terms of AWS. I don't think they have any support on Azure. They say that for the time being in the Azure setup, you can install MDM the way you would install it on-premise, but we don't have a built-in solution as they have for the on-prem database. That is my understanding for now.

What is most valuable?

With a Java user configuration, I will probably see 70 to 75 percent of the use cases met. I'm not talking about workflow integration. Instead of going to an active worksite, I'm managing everything from Informatica PowerCenter. I used to do those things, but now I'm just keeping my viewpoint specifically within MDM. I think with the configuration, you can achieve 75 percent of use cases. New tools are coming out that will enable you to achieve 90 percent of use cases with the out-of-the-box configuration, but I would like to keep Informatica tight here. Otherwise, you need a Java user edit course and other things to do multiple things that you cannot configure out of the box. They have to go through those use cases to do something if those can also be configured rather than coded.

What needs improvement?

We promote our code changes from a lower to a higher environment, which is highly complex when working with a multi-domain MDM like Informatica. This is the biggest obstacle for Informatica MDM, and I think they should change it because that's very time-consuming. You have to be very, very focused. Also, Informatica should develop a process where all the application servers are synced for people using multiple application servers. That's another significant drawback I've seen with Informatica MDM.

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

Informatica MDM's pricetag should come down. They have to cut some costs.

What other advice do I have?

I rate Informatica MDM nine out of 10. It's one of the best tools in its class. It gets a high rating because of the improvements in the latest version. I was working on a very outdated edition that was seven to 10 years old. There were multiple issues, but they have made a lot of progress, especially in the newer version. For example, they moved away from DB to a different DB-sorted feature. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user767937 - PeerSpot reviewer
Data Quality Manager at a financial services firm with 10,001+ employees
Real User
Works well and has a good interface
Pros and Cons
  • "I am impressed by the solution's interface."
  • "Informatica is very expensive."

What is our primary use case?

Our primary use case for this solution is purely for data quality analysis.

How has it helped my organization?

It took us a while to teach our users how Informatica works and to help them understand. We are still learning together with them because it also took us a while to master the tool. The contractors that come with Informatica are good on the ETL side but not that good on data quality.

What is most valuable?

The features I find most valuable are the mappings and rules. I am also impressed by the solution's interface. I really like this solution, as it works very well.

What needs improvement?

The visualization is very limited. It's not modern age, it's not self-service BI. It only has three levels of granularity on which you can present data and that's not enough. What's more, we had a few problems with the configuration. At times we found it difficult to integrate with other systems, but it turned out that the problem wasn't with the solution but with our firewalls. We had a couple of bugs but they are all fixed now. 

Another feature I would also like to see is tagging. At this stage, we can't tag data in the database of the data source with particular data flows. This is a nice feature that other solutions have and that Informatica lacks. We have to analyze and store data in a database and then we have to analyze it again and go through the servers. This takes up double storage. So if the data could be tagged at the database instead, anybody who has access to this data will know if there is a problem with the accuracy or anything else.

For how long have I used the solution?

I've been using this solution for three years now.

What do I think about the stability of the solution?

I don't think the solution is very stable because we have to refresh and restart the server at least once a month, or even more often. We couldn't understand what was causing this, perhaps we have a few bugs. But at times one team will be working and everything will be running, and then the other team will have some access issues. All we could do to fix this was to restart the server and then everything was up and running again. 

What do I think about the scalability of the solution?

The scalability is very good. We have about 30 users and this may increase because our organization constantly needs more people, so people see the benefit because it's stable and it gives consistency. We will probably move to big data analytics and purchase their big data applications.

How are customer service and technical support?

To be honest, we didn't really have any major issues yet but the technical support is good and they have a dedicated tech person assigned to us by Informatica to supports us. It works well because if we have a problem that our own IT team can't fix, they use Informatica to help them. 

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

I used IBM InfoSphere before but Informatica is much, much better; gold standard. There is no comparison. The interface and everything else is better.

How was the initial setup?

The initial setup was very complex. It is mainly our own fault because we didn't go for the solution that was recommended by Informatica. We used shortcuts that backfired on us and we've been struggling for a year. In the end, we did exactly what Informatica recommended at the beginning and now everything works fine.

We have an integration team that is responsible for maintenance and deployment.

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

Informatica is very expensive. But luckily we got enough free licenses, so we are still within limit. 

Which other solutions did I evaluate?

Informatica has been the best solution for the past 10 years, but now there are new tools emerging. So maybe we will switch in the future. 

What other advice do I have?

I would advise others to go for it because I love it. Maybe there are better tools, but I don't know about them. I would use it in conjunction with Tableau and Google Analytics for visualization. I would also suggest others to follow instructions during the initial setup and not to cut corners. Do the configuration exactly as Informatica suggests.
I love Informatica but I am not sure if it is value for money. Organizations that plan to increase their users may find it worth the money, but smaller organizations may want to use something simpler.

I will rate this solution an eight out of ten. My rating would have been nine if the solution offered tagging and if it was cheaper. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Associate at a tech services company with 10,001+ employees
Real User
Valuable features include data quality improvement, analytics, and reporting.

What is most valuable?

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

How has it helped my organization?

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.

What needs improvement?

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

For how long have I used the solution?

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

What do I think about the stability of the solution?

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

What do I think about the scalability of the solution?

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

How are customer service and technical support?

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

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

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

How was the initial setup?

The setup was pretty simple.

What other advice do I have?

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

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user852315 - PeerSpot reviewer
it_user852315Senior Technical Recruiter at a training & coaching company with 201-500 employees
Real User

Hi Man,

10/10 !!! Thank you for making your blogs an embodiment of perfection and simplicity. You make everything so easy to follow.

Q1, Update Strategy vs. Treat Source Rows As: wrong. The UPD just tells the pmdtm process whether the current record shall be inserted into the target, updated (according to the update details!), deleted from the target, or rejected. Data Driven just means that the flag set by the UPD shall be observed, instead of handling all records the same way.
When the UPD flags a record as DD_UPDATE, then the choice between Update Else Insert , Insert Else Update, or Update As Update will be followed.
In all other cases this choice does not apply.

OK, one additional BUT: if you flag a record for DD_INSERT but you don't check the checkbox "Insert", then the record will NOT be inserted into the target table.
The same holds true for the three Update flags and the Delete flag in the appropriate manner.

Q2, SCD without an UPD: if you want to work without an UPD transformation, then you will need separate mappings and sessions for the INSERT records, the UPDATE records, and the DELETE records.

Q3: where's the difference to Q2?

Q4, default values:
Treat Source Rows As = Insert
Insert, Update As Update, and Delete are checked by default.

I am so grateful for your blog. Really looking forward to read more.

Thank you,
Sanjay

See all 3 comments
it_user643899 - PeerSpot reviewer
Solution Architect at a computer software company with 201-500 employees
Vendor
One of the most valuable features is the mapping designer.
Pros and Cons
  • "The Mapping Designer allows for declarative ETL development (visual scripting) that leverages a wide array of different transformations."
  • "There are a small number of UI bugs that occur on occasion."

What is most valuable?

The Mapping Designer allows for declarative ETL development (visual scripting) that leverages a wide array of different transformations.

The designer allows for the creation of mappings to be leveraged as templates. Within the templates, parameters can be set up that serve as variables for deployment to mapping configuration tasks.

Mapping Configuration Tasks, MCTs, are specific uses of a mapping to fit a situation or set of circumstances.

How has it helped my organization?

With my firm, our use of Informatica Cloud is primarily to implement a set of financial integrations from various accounting systems into a Salesforce environment.

By leveraging Informatica Cloud Mapping Designer, we were able to create sets of reusable templates that were source agnostic. This made supporting the integration for hundreds of customers feasible with just a small team of integration specialists.

What needs improvement?

There are a small number of UI bugs that occur on occasion.

In several browsers, such as Chrome, elements of the UI can disappear when navigating through steps in any of the integration tasks' wizards. Additionally, on data synchronization tasks, the source fields in a mapping can disappear altogether as well.

Also, the product is so new, that any points not covered in the documentation prove difficult to research online.

For how long have I used the solution?

I have been using Informatica Cloud for two years.

What do I think about the stability of the solution?

There is currently no active failover for Informatica Cloud Secure Agents. This is the service used to process source information in client environments.

Therefore if a Secure Agent running a job goes down, the job will not wait or failover to another agent. It will fail as well.

What do I think about the scalability of the solution?

We have not had any scalability issues so far.

How are customer service and technical support?

Technical support is stellar. The time zone can prove an issue, as their support is all in Pacific Standard Time (PST).

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

We did not have a previous solution.

How was the initial setup?

The installation and configuration of the Secure Agent is a breeze.

Which other solutions did I evaluate?

Jitterbit, SnapLogic, and MuleSoft were evaluated.

What other advice do I have?

Informatica is likely to make this their flagship product. It is a solid investment to move to this ETL now. There will continue to be a slew of new features and product improvements in the near future that may increase the cost of the license.

Disclosure: My company has a business relationship with this vendor other than being a customer: OEM agreement/partnership.
PeerSpot user
Sr Data Governance Architect at Mresult
Real User
Top 5
Provides good scalability, but its technical support services need improvement
Pros and Cons
  • "It is a scalable product."
  • "It is complicated to establish the lineage in EDC using PowerCenter mappings."

What is our primary use case?

We use the product to define policies and for data discovery management.

What needs improvement?

It is complicated to establish the lineage in EDC using PowerCenter mappings. We have to do the process manually every time. This particular area needs improvement.

For how long have I used the solution?

We have been using Informatica Axon for five years.

What do I think about the stability of the solution?

It is a stable platform. However, we need to raise the ticket even for the smaller issues. There needs to be proper documentation available. They should provide enough information.

What do I think about the scalability of the solution?

We have eight to ten customers for Informatica Axon. It is a scalable product.

How are customer service and support?

The technical support team takes time to complete the debugging process.

How was the initial setup?

The initial setup process is fine, but there are a lot of infrastructure issues. It includes errors on the node cluster for EDC. Deployment is easy, but debugging is time-consuming. Whenever we raise the ticket to the support team, they take two to three days to evaluate the issue.

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

The licensing price of the product depends on the organization's requirements. It is less costly than Collibra.

What other advice do I have?

I recommend Informatica Axon to others and rate it a seven 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: Partner
PeerSpot user
Yauheniya Sazonava - PeerSpot reviewer
Lead Software Engineer at a tech vendor with 10,001+ employees
Real User
Provides good deduplication capabilities but the UI is outdated and not user-friendly
Pros and Cons
  • "It provides all the typical MDM capabilities like deduplication and machine survivorship."
  • "The UI is terrible and not user-friendly."

What is our primary use case?

We use this solution for MDM in the commercial sector. I'm a lead software engineer for EPAM Systems.

What is most valuable?

The product provides all the typical MDM capabilities like deduplication, machine survivorship, and other things. 

What needs improvement?

The downside of this solution is that the UI is terrible and not user-friendly. The solution was developed a long time ago and it no longer provides a lot of value. Our organization is considering decommissioning the solution or reducing usage. The problems seem to be more about the design and not the tool. The UI and general user experience need to be improved. Making changes on Informatica takes a lot of time compared to making changes on other MDM tools.

For how long have I used the solution?

I've been using this solution for seven months. 

What do I think about the stability of the solution?

I haven't heard any complaints about stability. 

What do I think about the scalability of the solution?




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

Before my time, the company used a legacy MDM solution for dealing with customers. It was created for reporting purposes, to create some compliance reporting, but its functionality didn't allow the addition of more MDM features, so they decided to build a new solution based on Informatica MDM, and from there they basically merged two solutions, the legacy one and this one into Informatica MDM.

How was the initial setup?

The initial setup was carried out prior to my joining the company. 

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

A lot of the solutions on the market are expensive and Informatica is at the top end in terms of licensing costs. They use a bundle model so you choose what you want to include in your bundle and that's what you pay for.

What other advice do I have?

Informatica MDM is a typical MDM tool. I've worked with others and they are all more or less the same. It requires more work than some other tools in terms of development and adding additional features. It has lots of features and is rated highly by Gartner. 

I rate this solution seven out of 10. 

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