Overview
What is Informatica Cloud Data Quality?
The vendor states that Informatica Data Quality empowers companies to take a holistic approach to managing data quality across the entire organization, and that with Informatica Data Quality, users are able to ensure the success of data-driven digital transformation initiatives…
Informatica IDQ leads the way with Data Quality automation
A very viable tool that helps to leverage the agility of the enterprise to make better decisions.
Swift, Manageable, and Progressive App for Database Enhancement.
A guru in providing AI driven insights.
IDQ-Good Tool
Informatica Data Quality review
Ínformatica data quality
Informatica Data Quality - Know Your Customer
Best Product!
IDQ - Simple yet effective
Informatica Data Quality
IDQ-Quality enhancer
IDQ cheap and popular!
IDQ Review
Power of IDQ
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Popular Features
- Data source connectivity (6)9.393%
- Data profiling (6)9.292%
- Master data management (MDM) integration (6)8.989%
- Data element standardization (6)8.282%
Pricing
What is Informatica Cloud Data Quality?
The vendor states that Informatica Data Quality empowers companies to take a holistic approach to managing data quality across the entire organization, and that with Informatica Data Quality, users are able to ensure the success of data-driven digital transformation initiatives and projects across…
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
56 people also want pricing
Alternatives Pricing
What is HubSpot Operations Hub?
HubSpot Operations Hub (based on technology from the former PieSync that was acquired by HubSpot November 2019) is a two-way contacts integration platform. The vendor emphasizes quick and easy setup automated customer and client data matching and updating between apps.
What is Clear Analytics?
Clear Analytics is a business intelligence solution that enables non technical end users to perform analytics by leveraging existing knowledge of Excel coupled with a built in query builder. Some key features include: Dynamic Data Refresh, Data Share and In-Excel Collaboration.
Product Demos
Informatica IDQ Training for Beginner | Informatica Data Quality Tutorial
Informatica Data Quality Training Demo Video | Informatica Data Quality Tutorial
How to Join Profile in Informatica Data Quality?
Informatica Data Quality online training | Informatica Data Quality Training Demo
#Informatica #Union #Transformation Training Session - Part 16 || Free Course
Features
Data Quality
Data quality tools are designed to ensure that business data is as reliable as possible so that it can provide a solid basis for effective decision-making
- 9.3Data source connectivity(6) Ratings
Ease of connection to multiple data sources
- 9.2Data profiling(6) Ratings
Ability to find anomalies and hidden relationships between data elements
- 8.9Master data management (MDM) integration(6) Ratings
Quality of integration with MDM systems
- 8.2Data element standardization(6) Ratings
Parsing and standardization of data elements according to predefined rules
- 8.7Match and merge(6) Ratings
Ability to identify potential matches and then merge
- 9Address verification(6) Ratings
Data format checking and valid address checking
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is Informatica Cloud Data Quality?
Informatica Cloud Data Quality Video
Informatica Cloud Data Quality Competitors
Informatica Cloud Data Quality Technical Details
Operating Systems | Unspecified |
---|---|
Mobile Application | No |
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(40)Community Insights
- Business Problems Solved
Users of Informatica Data Quality, or IDQ, have found the software to be highly effective in addressing various data quality challenges. One key use case is the validation of customer and vendor addresses, ensuring that there are no duplicates and verifying consistency in product descriptions. With simple and logical interfaces, IDQ eliminates the need for complex coding, making it accessible even to nontechnical citizen integrators. This democratization of integrations enables self-service capabilities and empowers users to easily scale up or down to accommodate different workloads without impacting performance.
Another important use case is the tool's support for data validation and cleansing processes. From address verification to content filtering, IDQ offers reliable data quality powered by AI. This allows users to identify and resolve quality issues that can potentially impact business initiatives. The software caters to both business users and developers, providing customization options and seamless integration with Informatica Power Center. Users can gain insights into their data by performing data profiling within the tool. This helps them make informed decisions before executing data quality operations.
IDQ has been extensively used across organizations for contact and address validation, enriching data to drive more effective campaigns. It has proven instrumental in resolving issues related to duplicate customers and products, resulting in improved sales projections and estimates. Users have relied on IDQ to address data inconsistencies, foreign character problems, as well as formatting and formula issues. The software also facilitates standardization of customer addresses, identification of duplicate records, and optimization of data for reporting tools.
Furthermore, IDQ seamlessly integrates with various applications such as Salesforce and SAP. This enables smooth handling of large volumes of records. Its capabilities extend beyond data validation; users leverage IDQ to update customer data with accurate details while identifying duplicate customers. Moreover, it serves as a comprehensive solution for monitoring overall data quality organization-wide, ensuring compliance with data quality standards. By automating technical and business data quality checks across multiple sources, users gain enhanced trust in their data and make more informed, data-driven business decisions.
Attribute Ratings
Reviews
(1-20 of 20)- Data quality profile
- Automation of data quality check
- Exception management
- Customizable template to capture metadata
- The cloud offering does not have all the features of on-prem version
- The DQ report has limit of only a few sample records it shows, it could show more
- Ability to delete an older version of metadata from the business glossary
A very viable tool that helps to leverage the agility of the enterprise to make better decisions.
- Scales elastically.
- Effectively monitor and manage integration.
- Lets you build intelligent processes.
- Quickly connect our lines of business, customers, and partners to any app, any process and at any speed with Intelligent APIs.
- Covers a broad set of use cases and patterns including real-time integration process orchestration and API management.
- Orchestrates our business by integrating processes, data, and applications for real-time automation and data flows.
Swift, Manageable, and Progressive App for Database Enhancement.
- Perfect data collaboration and detailed standardization. The two procedures support universal acceptability.
- Further, the concerned address control and validation increase the accuracy, effectiveness, and reliability of the database.
- Finally, Informatica Data Quality has an outstanding cleanser, very rapid, robust, and speedy.
- Data reviewing is not fully encompassed by Informatica Data Quality, which would validate the database.
- Besides, third party applications face challenges, due to poor integration support.
- Nonetheless, there are proficient, reliable, and contained safety and analytical measures.
A guru in providing AI driven insights.
- Has rich set of transformation.
- Reusable rules and accelerators.
- Exception management.
- It allows business users to review, correct and approve exceptional throughout the automation process.
- Apply rebuilt business rules and accelerators and reuse common data quality rules to save time and resources.
- Discover,search and profiling.
IDQ-Good Tool
- Address Validator Transformation - makes things so easy.
- The algorithm for address validation to would take years to write.
- Address doctor standalone application is powerful and can use any ui for performance improvements.
- Geocoding of Address doctor is so useful.
- It would be great if it could merge with PC Designer.
- This tool will be used in the front end systems -where addresses can be visible to the users.
- If address doctor improve like google api for lat n longs when we pass input attributes ang combinations.
Informatica Data Quality review
- It performs quality Data Profiling operations.
- A web-based data quality check (without the need for any client tool installation).
- Seamless integration with other Informatica products.
- Ease of use (2 days of training for profiling, 4 days for intermediate development, and 4 days for advanced development skills).
- A hardware monster.
- Needs easier security.
- Could provide easier administration.
- Needs easier installation steps.
Ínformatica data quality
- It's a great tool for profiling and score carding and cleansing bad data
- Matching, standardization, address doctor, exception record management
- Data services, web services, entity discovery, show lineage
- Scorecard export functionality for bad records - and it only displays the first 100 records
- There are no filtering conditions on scorecarding
- In IDD we cannot import bad record tables or duplicate records table as we did it in 9.1
- Profiling results should be displayed in charting mode, as with other tools
Informatica Data Quality - Know Your Customer
- Each night we process every customer, vendor and product. We generate reports of exceptions and these are distributed to the stewards of the data to allow them to correct issues.
- IDQ has extreme flexibility in how you create rules to identify what is out of compliance. No matter how complex your rules, it will likely handle it in an easy to program user interface.
- It is not the cheapest solution, but at this time I believe it is the best solution. Knowing your customers and accurately managing them justify getting the best product.
Best Product!
- Informatica provides high-quality data regardless of size, data format, platform, or technology
- Address parsing, formatting, and standardization
- It is perfect!
IDQ - Simple yet effective
- Correcting error prone manual data entry across the organization, correcting formulas, rules and methods. Understanding the data properly first to begin with. Improving and approving the accuracy overall.
- Makes sense of our own data, which in turn gives us confidence that we can provide to the end users. IDQ helped us with erroneous data in accounting and HR for accurate and immaculate reports.
- IDQ decreased the capital on Production support and QA time especially.
- I did not spend any time researching the tool for improvements, but the interface with Power Center will me more interactive and connected to the developers.
Informatica Data Quality
- Fact & multi-dimensional loading
- Tracking Changes in slowly changing dimensions
- Integration of data from SAP and Salesforce is better with this ETL tool compared to other tools in the market
- Modularity
- Several partnerships diminishing the value of technologies
- Unable to get list of objects from Repository (like sources & targets) that don't have any dependency
- Scheduling: The built-in scheduling tool has many constraints such as handling Unix/VB scripts etc. Most enterprises use third party tools for this.
IDQ-Quality enhancer
- Watch the data real time- After creating the job the data quality engine checks and run the custom rules creating a navigation window at the bottom for review and accessing the data right away.
- Character Set Mapping
- Makes sense of our own data, which in turn gives us confidence that we can provide to the end users. IDQ helped us with erroneous data in accounting and HR for accurate and immaculate reports
- I think its high time Informatica integrated all tools like PowerCenter, IDQ, IDE , powerexhange into one which will simplify development and maintenance
IDQ cheap and popular!
- Address Doctor: Automatically suggests and corrects the customer address based on the globals address database. Thus ensuring the correct physical address of the customer
- IDQ can be merged with Powercenter very fast and adequately
- IDQ needs some more integration with other ETL tools and databases like Ab nitio, Cognos and Oracle
IDQ Review
- The matching algorithms in IDQ are very powerful if you understand the different types that they offer (e.g., Hamming Distance, Jaro, Bigram, etc..). We had to play around with it to see which best suit our own needs of identifying and eliminating duplicate customers. Setting up the whole process (e.g., creating the KeyGenerator Transformation, setting up the matching threshold, etc..) can be somewhat time consuming and a challenge if you don't first standardize your data.
- The integration with PowerCenter is great if you have both. You can either import your mappings directly to PowerCenter or to an XML file. The only downside is that some of the transformations are unique to IDQ, so you are not really able to edit them once in PowerCenter.
- The standardizer transformation was key in helping us standardize our customer data (e.g., names, addresses, etc..). It was helpful due to having create a reference table containing the standardized value and the associated unstandardized values. What was great was that if you used Informatica Analyst, a business analyst could login and correct any of the values.
- I wish some of the functionality was combined with PowerCenter, especially being able to create workflows, etc. and schdeuling them.
Power of IDQ
- IDQ'S Delivery Point validation is very powerful and many competitive tools don't provide this
- IDQ supports WGS 84 geocoding standards
- IDQ validate addresses up to to a very high degree of accuracy
- IDQ doesn't support heavy duty data integration
IDQ -the best cleanser!
- Better compatibility with PowerCenter. This way you can do mix- match with existing mapping rules in ETL and also value add with quality check and exception reporting
- Address Doctor - Optimize the accuracy of your company's global address data by using the only software with all five postal certifications in one engine. It parses, cleanses, and standardizes it, then appends accurate geocodes and consumer segmentation codes for specific countries
- Watch the data real time- After creating the job the data quality engine checks and run the custom rules creating a navigation window at the bottom for review and accessing the data right away.
- I think its high time Informatica integrated all tools like PowerCenter, IDQ, IDE, powerexhange into one package will simplify development and maintenance
Informatica Data Qualtiy
- It can profile the data pretty well and provide you overall statistics of the data quality based on your defined rules... It can show you in the graphical representation as well by showing that if the data qualtiy has dropped then it could display the bar in RED
- It can be useful for validating the address and telephone numbers as well as SSN numbers for example if someone has mistyped SSN or not provided SSN or may be phone number format is wrong then It can help you to highlight as well as drilldown and figure it out for which particular record the data has not met the data quality standard.
- Its awkward to go back and forth from Informatica Developer to Informatica Analyst to view and run and edit the profiles or scorecards that we create. Also tags can be enabled and edited from analyst or developer only (something like that) Tags on the scorecard or profiles should be fully accessible from the Informatica Developer since because developer is the main point of development... I personally consider that Analyst is more like Client side tool on which we should not provide Tag editing features on any scorecards otherwise any user can go to scorecard and change the tags and that might create confusion for another user.
Quality at its best - Faster and economical
- Address Doctor-Optimize the accuracy of your company's global address data by using the only software with all five postal certifications in one engine. It parses, cleanses, and standardizes it, then appends accurate geocodes and consumer segmentation codes for specific countries
- Watch the data real time- After creating the job the data quality engine checks and run the custom rules creating a navigation window at the bottom for review and accessing the data right away.
- Better compatibility with powercenter. This way you can do mix- match with existing mapping rules in ETL and also value add with quality check and exception reporting
- Character Set Mapping
- I think its high time Informatica must integrate all tools like powercenter, IDQ, IDE , powerexhange into one which will simplify development and maintenance
Informatica Data Quality or Profiler with reporting?
- The tool was designed with the intent to link quality to the data steward/owner
- The functionality from the ETL allowed for great flexibility when designing quality filters
- The tool is a profiling tool that is completly disconnected from ETL flow so no realtime processing
- The sheduling is apalling
- There is no alerting; but I guess if you're only profiling data, there is not much point
Use IDQ with Power Centre to get max benefits
- IDQ does a good profiling, and it is easy to create rules.
- Use IDQ ONLY if you use Informatica Power centre as the ETL tool, else IDQ is not very effective. The major work of IDQ is called standardization, in which business can correct the data and repost the corrected data in a file, But it is possible only if IDQ is integrated with Power centre.
- There is a scorecard that provided good graphical interface to the results.
- The issue was on how badly it was implemented. All the files were uploaded to IDQ server using same file name minus the date. So IDQ wasnt able to display the historical metrics.
- The performance was too slow, with multiple users.
- While it is easy to create rules, you cannot view the actual code in the rules if it is written by someone else.