Below is a high level general feature comparison. If you have a specific question outside what I provided please let me know. Please note safe harbor applies on any future dates.
Profiling delimited/relational sources: Both
Profiling Complex file formats: IDQ only currently. CDQ in 2021
Domain discovery: IDQ yes, CDQ 2021
create business rules: yes for both
dictionaries: yes for both
parse: yes for both
dedup/consolidation/address validation/standardization: yes for both
exception management: IDQ yes. CDQ 2021
Scorecarding: IDQ yes. CDQ 2021
Spark based processing: IDQ yes. CDQ 2021
Thanks Scott. What are the other source types that CDQ supports? (noSQL, hadoop, hive?) is there a list of supported sources? How is the rules management achieved in both? Where are the business and data quality rules stored? Is there also any document around data quality best practices using Informatica?
I have attached the connecivity PAM so you can see what data sources are supported in CDQ and CDP( Cloud data profiling).
The rules are stored in the metadata repositories. In IDQ that would be your database used for IDQ. CDQ that would be the metadata database Informatica hosts as part of the IICS platform.
For rules management not sure the ask.
Here is a list of supported sources for CDQ profiling.
Thanks so much for sharing. Is there also an architecture diagram for IDQ that I can refer to?
Honestly I would look at CDQ first. IDQ is not actively being sold unless there is a exception that requires IDQ which is very little. Also there will likely be zero improvements to the IDQ platform as Informatica is a cloud first company now.
Is cloud DQ integrated with Axon and EDC?
There are ways to show the profiling results in Axon from CDQ but the direct integration in Axon is from IDQ.
In the next few months the first cloud DG offering will be released which has axon and edc together with the full cloud catalog released later this year/early 2022.
Could you please share any documents on why should we recommend Informatica Data Quality for customers? It will be really helpful for reference. Also I am looking for any documentation on how rules can be stored and managed by various users in the data quality platform along with reference data.
Is there an architecture diagram for Cloud DQ as well IDQ? Also any documentation explaining the difference between the two products would be helpful.
You can refer Support article which will help you answer all your basic queries regarding Cloud Data Quality.
This article also has few points explaining advantages of CDQ over traditional DQ platform.
Hope this helps!