Try our new research platform with insights from 80,000+ expert users
it_user669330 - PeerSpot reviewer
Project Manager Oracle Applications at a tech services company with 5,001-10,000 employees
Consultant
Data synchronization tasks, mapping designer tasks and scheduling are valuable features.
Pros and Cons
  • "Data synchronization tasks."
  • "Error reporting and debugging need improvement."

What is most valuable?

The most valuable features are:

  • Data synchronization tasks
  • Mapping designer tasks
  • Scheduling

How has it helped my organization?

We are using this for integration of on-premise Oracle EBS, Navision and cloud applications, such as Salesforce, BigMachines, etc.

What needs improvement?

Error reporting and debugging need improvement.

They need to improve on the upgrade testing process from their end so that it does not cause any issue to existing functionality/setup.

For how long have I used the solution?

I have been using this solution for 36 months.

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

What do I think about the stability of the solution?

Sometimes after upgrades, it gives some trouble for already working tasks. We need to report bugs to get a solution from Informatica.

What do I think about the scalability of the solution?

We have not had scalability issues.

How are customer service and support?

I rate support 8/10.

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

We did not have a previous solution.

How was the initial setup?

Setup was straightforward and easy to work with.

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

I am not involved in pricing and licensing.

Which other solutions did I evaluate?

We looked at Dell Boomi.

What other advice do I have?

Informatica Cloud is easy for development and maintenance. It really works fast and is scalable.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user272106 - PeerSpot reviewer
Graduate Assistant with 1,001-5,000 employees
Real User
It helped us realize our goal of maintaining a distinct (golden) record for better decision making and reporting, but we used to face some Java application problems using it.

Valuable Features

It allows you to build your own rules to identify the golden records as part of master data management.

Improvements to My Organization

It helped my client, a technology company, to identify a unique customer and remove the redundant customer information. For example, a customer might be linked with a product to the organization directly, indirectly or as a retailer. Informatica MDM helped us realize our goal of maintaining a distinct (golden) record in our database for better decision making and reporting purposes.

Use of Solution

I've been using it for 15 months.

Stability Issues

In general, it is good. We used to face some Java application problems, approximately two issues a month.

Scalability Issues

As the data keeps growing, we have to clear temporary storage space. Otherwise, we encountered issues in starting the batch jobs.

Customer Service and Technical Support

Customer Service:

3.5/5.

Technical Support:

3.5/5.

Implementation Team

I worked as a vendor for one of my clients. As I heard recently, the contract is still on, so I think we are doing pretty well.

Other Advice

I used this product almost 18 months ago. Informatica is one of the renowned names in Enterprise Information Management and there has been some changes for their MDM product. I would suggest you check their recent upgrades and take an informed decision.

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)
September 2024
Learn what your peers think about Informatica Intelligent Data Management Cloud (IDMC). Get advice and tips from experienced pros sharing their opinions. Updated: September 2024.
802,829 professionals have used our research since 2012.
Architect at a tech services company with 501-1,000 employees
Real User
Offers great features; suitable for both technical and business users
Pros and Cons
  • "The solution is applicable for both technical and business users."
  • "The ability of the product to leverage the power of big data could be improved."

What is our primary use case?

Our primary use case of this solution is to improve issues of security, quality and accuracy. 
We are partners of Informatica and I'm an architect. 

What is most valuable?

In terms of Data Quality, the feature most valuable to me is that the solution is applicable for both technical and business users. I like that instead of using on-premises processing power, you can now use your on-cloud platform processing power to process the data and get a faster turnaround time. From a product perspective, everything is well done. 

What needs improvement?

I think improvements can be made regarding the ability of the product to leverage the power of big data. It would also help if we could get the software as a services product so that we feed in the requirements and it's a more customized solution. I think that would increase the adoption by customers. 

For how long have I used the solution?

I've been using this solution for three years. 

What do I think about the stability of the solution?

Informatica is a very stable product, I haven't had any issues with it. 

What do I think about the scalability of the solution?

It's a very scalable solution and it has all the other big data components. 

How are customer service and technical support?

We have a business partnership with Informatica and they are very responsive. 

How was the initial setup?

I've had a lot of experience with this solution so I don't have any issues with implementation. Perhaps someone from a different background or different circumstance, may face challenges but it is user friendly so it shouldn't be a problem. Implementation generally takes about six months depending on the dimensions required. This solution cannot be implemented in a day or a week.

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

The pricing of this solution is definitely at the higher end and they don't provide the option of a trial version. If you look at Talend, for example, they provide a free version, so the cost of IBM and Informatica is a little high. 

What other advice do I have?

The cost of the product is high, but feature wise, it provides a whole lot of features that can easily solve your problems. I would recommend this product. 

I would rate this solution an eight out of 10.

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
PeerSpot user
it_user912336 - PeerSpot reviewer
Master Data Analyst at a healthcare company with 10,001+ employees
Real User
We can see all our information on a single screen. However, we can't sell the product without an additional layer.
Pros and Cons
  • "We can see all our information on a single screen."
  • "We cannot sell the product directly with an additional layer."

What is our primary use case?

We are using the product data for building maintenance and item creation, then putting all the structures in for our new e-Catalog launch. It has been performing well.

How has it helped my organization?

  • Its key capability is in data maintenance.
  • We can maintain all the organizational data in a single software. 
  • It is nice to learn. 
  • We can see all our information on a single screen.

What is most valuable?

It is good for centralized data.

What needs improvement?

We cannot sell the product directly with an additional layer.

For how long have I used the solution?

One to three years.

What do I think about the stability of the solution?

It would be more stable if we could merge all the products into a single software.

How is customer service and technical support?

I haven't used the technical support.

How was the initial setup?

I wasn't involved in the initial setup.

What other advice do I have?

We were looking to market this solution, which is how we ended up using it.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner.
PeerSpot user
Informatica Product Manager at a tech services company with 11-50 employees
Real User
Excellent mass ingestion functionality and great elasticity
Pros and Cons
  • "The mass ingestion functionality and the elasticity of the solution are great."
  • "The price modeling could be more flexible."

What is our primary use case?

Our primary use case of this solution is for data integration; integrating cloud warehouse or cloud layout. Cloud Data Integration offers capabilities that didn't exist in the on-prem version. I'm the company product manager.

What is most valuable?

The mass ingestion functionality and the elasticity of the solution are great. It enables you to leverage the elasticity capability that the cloud provides. You can build a process, scale-up and leverage all the elasticity and the automatic provision the cloud has. What took 10 hours to do in the on-prem version, takes less than an hour in the cloud. It's a huge difference. The solution is designed for a cloud-native approach with native components and connectors for all the cloud-ready solutions we need nowadays.

What needs improvement?

I think the price modeling could be improved. Currently, the IPU consumption is defined on a monthly basis and if you don't use all the IPUs available in a particular month, they are lost. A more flexible pricing model is something Informatica should look at. 

What do I think about the scalability of the solution?

The solution is scalable. 

How are customer service and support?

The technical support is good, we raise the tickets in the Informatica Support Portal. 

What other advice do I have?

The solution is great once you have a clear roadmap of migration to the cloud. In the cloud migration journey, it's important to be clear of the entire process.

I rate this solution nine out of 10. 

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Data Scientist at a tech services company with 11-50 employees
Real User
Data transformation and test management features allow us to work with unstructured data
Pros and Cons
  • "The most valuable feature is data discovery. This is the most exciting feature for all of the banks."
  • "I have encountered some issues using the substitution, which is one of the techniques of data masking."

What is our primary use case?

We provide services mostly to banks. 

I am currently working at a bank where they are using Data Masking and Data Transformation at the same time. They are an old core banking system, which is COBOL, and it's unstructured data. We are using Data Transformation to transform and structure the data into a relational format.

We use the test data management to create test data from the relational data. To create the test data, we mask using different techniques for the discovery. After that, we re-transform the relational data into unstructured data to be fed into the core banking system.

What is most valuable?

The most valuable feature is data discovery. This is the most exciting feature for all of the banks.

What needs improvement?

I have encountered some issues using the substitution, which is one of the techniques of data masking. I used the substitution and software. I had issues in both when using the field, and specifying the field. Each one will have the same data for the same person, and they will have realistic data each time. This issue was raised with technical support and it was flagged as an issue that had no solution. They have indicated that it is a bug that would be resolved in the next release.

In the next release, I would l like to see the bug with the substitution resolved.

For how long have I used the solution?

I have two years of experience with Informatica Data Masking.

What do I think about the stability of the solution?

This solution is stable and we have not had any issues.

What do I think about the scalability of the solution?

Informatica Data Masking is scalable.

How are customer service and technical support?

The technical support is good, although sometimes they don't respond quickly. Overall, they are good.

I raised the case where I was having some issues with the substitution, and it took two months. Finally, the answer was that they have no solution for this, but said they will flag it as a bug to be resolved for the next release.

As I was not able to stop the project because of the bug, I created a workaround using PowerCenter to make it work. The data was not unique. I used PowerCenter and added an ID to all of the columns, then I concatenated the ID with the columns. As an example of why this was complete is if my name is Donna, it will show as Donna123. That way, any other person named Dana in the same database or table would show as Donna246 and they would no longer be the same. With this, I would then offer a substitute.

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

Previously, we did not use another solution.

How was the initial setup?

The initial setup is straightforward.

The length of deployment depends on the solution. For example, I find security was very easy, but the data integration was more complex. This is because it has many features and you can do many things. Setting up the data quality was also very easy.

We have deployed both on-premises and on the cloud. Mostly, I work in Lebanon and some  Arab countries also. There have been some issues with the Cloud, so they prefer on-premises software. We implemented some iPaas on the Cloud for Data integration.

What other advice do I have?

It's good as a solution.

I would rate this solution a nine 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
Senior Principal Architect at a computer software company with 5,001-10,000 employees
Real User
Reliable, scalable, but integration could improve
Pros and Cons
    • "I have received feedback from certain teams and there is a steep learning curve to use this solution."

    What needs improvement?

    I have received feedback from certain teams and there is a steep learning curve to use this solution.

    In a future release, there should be better integration with other governance tools.

    For how long have I used the solution?

    I have been using Informatica Cloud Data Integration for approximately three years. We have been using it consistently for one year in a large project.

    What do I think about the stability of the solution?

    The solution is reliable.

    What do I think about the scalability of the solution?

    Informatica Cloud Data Integration has a strong enterprise customer base and this is one of the main reasons why we choose to work with them. The solution is scalable.

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

    We use other similar products similar to Informatica Cloud Data Integration.

    How was the initial setup?

    The initial setup is not easy.

    What about the implementation team?

    The implementation would be best to be done by experts.

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

    Our customers sometimes are able to negotiate a much better price for Informatica Cloud Data Integration based on their relationship with the vendor.

    What other advice do I have?

    I rate Informatica Cloud Data Integration a seven out of ten.

    Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
    PeerSpot user
    PeerSpot user
    Assistant Consultant at a tech services company with 1,001-5,000 employees
    Consultant
    ​The tool manually checks on applying business rules and helps to implement them
    Pros and Cons
    • "Address Doctor gives an accurate combination of information provided with a level of returned threshold value."
    • "​The tool manually checks on applying business rules and helps to implement them."
    • "Needs to implement the new workflow with simple steps and a quick visualization with a 360 view of the data."

    What is our primary use case?

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

    How has it helped my organization?

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

    What is most valuable?

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

    What needs improvement?

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

    For how long have I used the solution?

    One to three years.
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Monirul Islam - PeerSpot reviewer
    Monirul IslamAssociate at a tech services company with 10,001+ employees
    Real User

    It has the capability to integrate other data cleansing suites such as Trillium, which need to be configured in landing to staging mappings or we can use Platform staging.

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