Try our new research platform with insights from 80,000+ expert users
it_user150897 - PeerSpot reviewer
Data Analyst / Data Integration at a comms service provider with 51-200 employees
Vendor
Solid Integration tool. GUI is poor and needs improvement.

What is most valuable?

IDQ integration with Power Centre Designer Repository. On the fly you can move your IDQ artefacts to Power Centre Designer. Later you can use them in a workflow and for scheduling etc.

How has it helped my organization?

Improved Data Quality, after we run the IDQ session which we customize for each client (Developed custom business rules in IDQ).

What needs improvement?

GUI is poor in IDQ

For how long have I used the solution?

Over a year
Buyer's Guide
Informatica Intelligent Data Management Cloud (IDMC)
April 2025
Learn what your peers think about Informatica Intelligent Data Management Cloud (IDMC). Get advice and tips from experienced pros sharing their opinions. Updated: April 2025.
856,873 professionals have used our research since 2012.

What was my experience with deployment of the solution?

No

What do I think about the stability of the solution?

No

What do I think about the scalability of the solution?

No (Depends upon your design and architect)

How are customer service and support?

Customer Service: Customer service is OKTechnical Support: Technical support is OK

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

Earlier we used ODI and IDPQ, but the new client wants the development in Informatica.

How was the initial setup?

It was a ittle complex, as there are post installation services you need to create in Informaitca Administrator.

What about the implementation team?

In house team (I was part of the team as an Informatica Administrator and IDQ Developer)

What was our ROI?

Better data quality

Which other solutions did I evaluate?

IBM Data Stage, IBM Information Analyzer and IBM Quality Stage (More cost Centric). Oracle ODI (Oracle Data Integrator) and ODPQ (Oracle Data Quality and Profiling).

What other advice do I have?

Informatica Data Quality is a solid Integration tool.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
it_user5943 - PeerSpot reviewer
Architect at a insurance company with 1,001-5,000 employees
Vendor
Excellent MDM in my opinion. Needs better workflows for our business users.

Valuable Features:

- Seamless integration of MDM, data quality and data integration modules - Repository of data models from other customers - very useful! - Support for multiple domains including product and location data - Flexible architecture supports registry, consolidation, coexistence, and transaction styles. We use the coexistence style. - Management of party data - Performance is good, even as our database has grown in size over the past year

Room for Improvement:

- When we compared Informatica to SAP, we realized that we lose the ability to integrate easily with our SAP business applications - Needs more preconfigured business rules and services - Weak in data stewardship. The UI in particular needs improvement. - Reporting can be improved.

Other Advice:

Facebook integration looks interesting, but we haven't taken advantage of it. Informatica is a very innovative company in my opinion.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
it_user68496 - PeerSpot reviewer
it_user68496Architect at a consultancy with 501-1,000 employees
Consultant

Regarding SAP integration- Depends on your scale, existing infrastructure, SLAs, etc. - it's always a minefield. In abstract terms, the products themselves will integrate without major issues. My personal biggest gripe with Informatica is their pricing model, it is outrageous for large data volumes, everything is good until one looks at the price tag.

Buyer's Guide
Informatica Intelligent Data Management Cloud (IDMC)
April 2025
Learn what your peers think about Informatica Intelligent Data Management Cloud (IDMC). Get advice and tips from experienced pros sharing their opinions. Updated: April 2025.
856,873 professionals have used our research since 2012.
Kholoud  Kandil - PeerSpot reviewer
Data Engineer at BBI
Real User
Top 20
Provides valuable functionality for task replication, but the user interface needs enhancement
Pros and Cons
  • "It allows the creation of identical tasks that can be applied across multiple tables, ranging from 100 to even 1,000 tables."
  • "The product interface could be improved to be more intuitive."

What is our primary use case?

The solution was part of building our data warehouses, where we needed a tool for bulk data migration that didn't require mappings when migrating from a source to a target.

What is most valuable?

The product's most valuable feature is the replication tasks. It allows the creation of identical tasks that can be applied across multiple tables, ranging from 100 to even 1,000 tables. 

What needs improvement?

The product interface could be improved to be more intuitive. It requires navigating through several steps to access mappings and pre-created metrics. Enhancing it to provide a more streamlined structure or dashboard would allow quicker access to maps and other essential features.

For how long have I used the solution?

We used Informatica Cloud Data Integration for six months. 

What do I think about the stability of the solution?

The product was stable. I rate the stability a ten. 

What do I think about the scalability of the solution?

We had 30 Informatica Cloud Data Integration users in our organization. I rate the scalability an eight. 

How was the initial setup?

The solution didn't require much setup, and since it was browser-based, it was fairly easy to use. I rate the process a ten out of ten.

What other advice do I have?

The product was pretty easy to use. The connections to other platforms worked fine. 

I recommend it to others and rate it a seven. 

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Novneet Jain - PeerSpot reviewer
Data Integration Architect at InfoCepts
Real User
Top 20
Great solution for Salesforce data integration, multi-cloud approaches and processing bottlenecks
Pros and Cons
  • "The serverless capability and the packaging application of the solution are valuable."
  • "It could be improved by including a buffer that saves data when there is a connectivity issue."

What is our primary use case?

We use the solution for Salesforce data integration, multi-cloud approaches and processing bottlenecks. We deploy the solution in a hybrid format.

What is most valuable?

The serverless capability and the packaging application of the solution are valuable, as all tools come with the solution and do not require additional license purchases.

What needs improvement?

Although the solution seems complete currently, it could be improved by including a buffer that saves data when there is a connectivity issue.

For how long have I used the solution?

We have been using the solution for a year and a half and are currently using the latest version.

What do I think about the stability of the solution?

The solution is very stable.

What do I think about the scalability of the solution?

The solution is scalable.

How was the initial setup?

The initial setup is straightforward. It takes a couple of days, but for migration, if you have to move over the code from one tool to another, it takes a lot of time.

What other advice do I have?

I rate the solution an eight out of ten. The solution is good but can be improved by a buffer that saves data when there is a connectivity issue. I recommend the solution because it has existed for a long time, and a lot of people already understand the tool. Additionally, the learning curve is effortless compared to the other tools.

Disclosure: My company has a business relationship with this vendor other than being a customer: Integrator
PeerSpot user
reviewer1764114 - PeerSpot reviewer
Architect at a tech vendor with 1,001-5,000 employees
MSP
Top 20
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
    reviewer1717605 - PeerSpot reviewer
    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
    PeerSpot user
    Data Engineer at a tech services company with 51-200 employees
    Real User
    Top 10
    Flexible user interface, good visibility of data, good support
    Pros and Cons
    • "The user interface is flexible and the visibility of the data flow is amazing."
    • "The tool's performance is an area that should be given further consideration."

    What is our primary use case?

    I starting with the design and discovery phase to detect data issues by using the profiling service, then started to analyze the data to determine and fix issues with it.

    How has it helped my organization?

    This product really improves my organization and fits all of the needed requirements for working with cleansed data. This helps to prevent issues from appearing in the business layer.

    What is most valuable?

    The user interface is flexible and the visibility of the data flow is amazing. You can see your data throughout the flow and then you can determine where issues are before fixing them.

    What needs improvement?

    The tool's performance is an area that should be given further consideration.

    For how long have I used the solution?

    I have been using Informatica Data Quality for more than one year.

    What do I think about the stability of the solution?

    This is a stable product.

    What do I think about the scalability of the solution?

    The solution is scalable.

    How are customer service and technical support?

    Technical support has been very helpful. Whenever we have a problem, they are able to solve it.

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

    I have experience with a similar solution by IBM.

    How was the initial setup?

    Informatica platform installation is straightforward. As long as the prerequisites check is done successfully, it will be very easy to do.

    Which deployment model are you using for this solution?

    On-premises

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

    IBM
    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    Director of Sales and Marketing at Informatic Technologies
    Real User
    Top 5
    A stand-alone application used for any integration with third party tools
    Pros and Cons
    • "The data mapping capability is a valuable feature."
    • "Certain applications are not being synced with the ION."

    What is our primary use case?

     A stand-alone application used for any integration with third party tools, like Oracle, it may be SAP, or it can be their local in-house build, or HRMS. It can be any application from A to Z. But this acts like in the web services. 

    What is most valuable?

    The data mapping capability is a valuable feature. 

    What needs improvement?

    Certain applications aren't accepted. For example, for IBM applications, it takes a lot of time. And certain applications are not being synced with the ION.

    For how long have I used the solution?

    I have been using Informatica Cloud Data Integration for two and a half years. 

    What do I think about the stability of the solution?

    Its a very stable solution. 

    What do I think about the scalability of the solution?

    There are twenty five customers at present. 

    How was the initial setup?

    The initial setup is straightforward. The deployment takes two hours time. 

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

    It's an expensive solution. 

    What other advice do I have?

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

    Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
    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: April 2025
    Buyer's Guide
    Download our free Informatica Intelligent Data Management Cloud (IDMC) Report and get advice and tips from experienced pros sharing their opinions.