No more typing reviews! Try our Samantha, our new voice AI agent.
PeerSpot user
Senior IT Application Specialist at a tech company with 10,001+ employees
Real User
Top 20
Sep 11, 2014
We started with Firstlogic then switched to Informatica for it's ease of use.
Pros and Cons
  • "It has improved the customer data management where we had the incorrect addresses and data cleansing, also in finding the duplicates so as to ensure the customer data is not duplicated."
  • "Asia pacific region address validation needs to be improved."

What is most valuable?

Data cleansing and address validation are the most valuable features. Also the web services which can be called on the fly. Data Duplication plays a very important role.

How has it helped my organization?

It has improved the customer data management where we had the incorrect addresses and data cleansing. Also in finding the duplicates so as to ensure the customer data is not duplicated.

What needs improvement?

Asia pacific region address validation needs to be improved.

For how long have I used the solution?

3 years
Buyer's Guide
Informatica Intelligent Data Management Cloud (IDMC)
June 2026
Learn what your peers think about Informatica Intelligent Data Management Cloud (IDMC). Get advice and tips from experienced pros sharing their opinions. Updated: June 2026.
900,747 professionals have used our research since 2012.

What was my experience with deployment of the solution?

None

What do I think about the stability of the solution?

None

What do I think about the scalability of the solution?

None

How are customer service and support?

Customer Service: 4 out of 5Technical Support: 4 out of 5

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

We previously used Firstlogic as a data quality tool. We found that Informatica is more feasible and user friendly than Firstlogic.

What about the implementation team?

In-house.

Which other solutions did I evaluate?

Yes. Trillium.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
it_user845028 - PeerSpot reviewer
it_user845028Staff Software Engineer at a tech services company with 10,001+ employees
Real User

Hi There,

You make learning and reading addictive. All eyes fixed on you. Thank you being such a good and trust worthy guide.

Thank you for your helpful sugestions Informatica IDQ training USA.
I tried the option IS_EXPR_VAR and it is treating the string as a expression.
But my requirement is that I have this expression logic changing for each record.
so I need to lookup for each record, fetch the logic and set this to mapping variable.
But when i try to set it , it gives me below error.

Excellent tutorials - very easy to understand with all the details. I hope you will continue to provide more such tutorials.

Best Regards,
Kevin

See all 5 comments
it_user150897 - PeerSpot reviewer
Data Analyst / Data Integration at a comms service provider with 51-200 employees
Vendor
Sep 8, 2014
Solid Integration tool. GUI is poor and needs improvement.
Pros and Cons
  • "Informatica Data Quality is a solid integration tool."
  • "GUI is poor in IDQ"

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

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 technical 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
Buyer's Guide
Informatica Intelligent Data Management Cloud (IDMC)
June 2026
Learn what your peers think about Informatica Intelligent Data Management Cloud (IDMC). Get advice and tips from experienced pros sharing their opinions. Updated: June 2026.
900,747 professionals have used our research since 2012.
it_user5943 - PeerSpot reviewer
Architect at a insurance company with 1,001-5,000 employees
Vendor
Mar 15, 2013
Excellent MDM in my opinion. Needs better workflows for our business users.
Pros and Cons
  • "Seamless integration of MDM, data quality and data integration modules."
  • "When we compared Informatica to SAP, we realized that we lose the ability to integrate easily with our SAP business applications"

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
Real User

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.

Director of Sales and Marketing at Informatic Technologies
Real User
Top 10
Apr 16, 2024
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
Mark Bielz - PeerSpot reviewer
Principal Delivery Lead at Arq group
Real User
Nov 3, 2023
Data extraction process could be easier and requires a feature to provide data streaming insights
Pros and Cons
  • "The product seems stable enough."
  • "It is more complicated to extract data using the product compared to Visio. The system could display the details on the screen."

What is our primary use case?

We use the product for building static and automatic data lineages.

What needs improvement?

It is more complicated to extract data using the product compared to Visio. The system could display the details on the screen. Additionally, they should add AI features and the capability to provide data streaming insights.

For how long have I used the solution?

We have been using Informatica Enterprise Data Catalog for two and a half years.

What do I think about the stability of the solution?

The product seems stable enough.

What do I think about the scalability of the solution?

We have 30 Informatica Enterprise Data Catalog users in our organization.

How was the initial setup?

The product requires maintenance.

What other advice do I have?

I advise others to understand their business use cases. I rate Informatica Enterprise Data Catalog a three out of ten.

Which deployment model are you using for this solution?

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