Data Sharing Community

From CDQ
Jump to navigation Jump to search

Welcome to the Portal of the CDQ Data Sharing Community

What's new? (RSS)

Redesigned Updates Report with New Structure and Features (10 January 2025)

We’re thrilled to introduce an enhanced Updates Report, with a redesigned structure and powerful new features. This significant update ensures that all business partner elements from official registers are included, minimizing the risk of missing important changes and helping prevent overlooked updates in the future.


Key Improvements

  1. Improved Data Structure
    • Unified Rows: Each row now contains all changes from a specific register. Unlike the previous version (where each row corresponded to a single change), this eliminates the need to scroll through multiple rows to gather complete information about a single business partner.
    • Comprehensive Updates: Each update now includes the entire business partner profile from the reference data source, as opposed to just a list of detected changes at current moment.
  2. Advanced Filtration
    • Summary Classification: The filtration system has been upgraded from Concept Classification to Summary Classification, ensuring all changes for a business partner (where at least one is critical) are displayed.


Detailed Update Information

Each element in the report is grouped by concepts (e.g., "Business Partner Name Local") and may include multiple details such as value, type, short name, code, number, etc. Each concept also features its own update assessment with the following details:

  • Update Classification: Indicates the importance of the update.
  • Update Action: Shows whether the item was added, modified, deleted, or remains unchanged.
  • Before Value: Displays the data from the customer mirror.
  • Modified At: Notes when our service created the update.
  • Provenance: Specifies the reference data source (e.g., VIES, FR_RC, CH_UIDR).


Filtration Options

The report allows for flexible filtering to meet your specific needs:

  • Created At: Filter by the date the update was generated in CDQ services.
  • Summary Classification: Filters Business Partners based on the highest classification level among all concepts.
  • Provenance: Focus on updates from specific reference data sources, such as VIES, FR_RC, or CH_UIDR.


Looking Ahead

The report will be extended over the coming weeks and months with additional features and improvements to enhance usability and value. Stay tuned for updates!

Comprehensive Confirmation Services (20 December 2024)

Our Business Partner Confirmation Solution ensures the integrity and reliability of partner data within self-service portals. By seamlessly integrating Partner Guard, Tax Guard, Data Quality Guard, and AML Guard, businesses can confirm critical company information, validate VAT identifiers, ensure data quality, and conduct sanction list screenings with confidence.


Comprehensive Confirmation Services

  1. Company Confirmation
    • Partner Guard cross-references company and address details with trusted sources such as business registers, tax registers, community data pools, and third-party databases.
    • Creates a "golden record" with enriched, accurate company names, legal forms, identifiers, and standardized addresses.
  2. Data Quality Confirmation
    • Data Quality Guard enforces over 2,500 global data quality rules to ensure input data integrity.
    • Identifies and resolves data quality issues, ensuring consistency and accuracy across records.
  3. VAT Number Confirmation
    • Tax Guard validates VAT identifiers against trusted databases.
    • Ensures that VAT numbers align with associated names and address details for added accuracy and compliance.
  4. Sanction Compliance Confirmation
    • AML Guard incorporates advanced sanction and watchlist screening, going beyond traditional verification methods.
    • Screens partners against global sanction lists and watchlists to identify matches, ensuring regulatory compliance.
    • Mitigates risks of engaging with sanctioned entities, safeguarding businesses from potential legal and reputational damage.


Empowering Authenticity: Confirmation Badges

  • Enable customers to create and deploy Confirmation Badges directly in their self-service portals.
  • These badges signify authenticity and credibility for confirmed partners, similar to the blue checkmarks on platforms like Instagram, Twitter, or B2B marketplaces such as Alibaba and Amazon Business.
  • Boosts trust and transparency, creating a more secure business ecosystem.


Take Action: Explore the Endpoint

  • For seamless integration and robust confirmation services, check the endpoint: Data Clinic.

Elevate your partner management processes today with our state-of-the-art Business Partner Confirmation Solution!

New Product Tax Guard Identifier Qualification Available (12 December 2024)

We are excited to announce a new product called Tax Guard with its Identifier Qualification functionality. It is a comprehensive Software as a Service (SaaS) product designed to streamline and enhance the accuracy of tax compliance for businesses globally. It for verification and validation of both direct and indirect tax identifiers while using multitude of data quality rules and official databases (e.g. VAT registers). Tax Guard Identifier Qualification provides the following benefits:

  • Enhanced Compliance: Ensures adherence to local and international tax laws, reducing the risk of penalties and legal issues.
  • Operational Efficiency: Streamlines tax-related processes, saving time and reducing manual errors.
  • Real-Time Validation: Offers immediate verification during transactions, enhancing accuracy and trust.
  • Versatility: Adaptable to various business needs, whether for instant checks or continuous monitoring.
  • Data-Driven Insights: Access to comprehensive tax data aids in informed decision-making and strategy development.
  • Scalability: Suitable for businesses of all sizes and scales seamlessly as business needs grow.


Links and Materials

We provide Tax Guard as a First Time Right functionality hidden behind the Qualify button. We published also a couple of tutorials and comprehensive article about the qualification process that Tax Guard performs. All the necessary links to the aforementioned publications are available below:

... further results

Data model

An important prerequisite for collaborative data management is a common understanding of the shared data. For the CDQ Data Sharing Community, this common understanding is specified by the CDQ Data Model. The concepts of this model are defined and documented in this wiki which can be used as a business vocabulary. Moreover, the wiki provides a machine-readable interface to reuse this metadata by using semantic annotations.

This is a graph with borders and nodes that may contain hyperlinks.

Data maintenance procedures

A procedure is a common standard or "how-to" for a specific data management task. Within the CDQ Data Sharing Community, companies agree on such procedures to ensure similar rules and guidelines for similar tasks. For several countries, the CDQ Wiki provides such information, e.g. data quality rules, trusted information sources, legal forms, or tax numbers. Try

or select another country from the list.

Data sources

Active data sourcesRecords
Data source BR.RF63,723,769
Data source CDQ.INTEL50,195,360
Data source VIES50,000,000
Data source FR.RC40,047,784
Data source GB-EAW.CR8,437,855
Data source US-FL.BER6,006,606
Data source JP.CR5,562,945
Data source AU.BR4,784,624
... further results
The CDQ Data Sharing Community uses a collaboratively managed reference data repository. This incorporates the integration of external data sources for enriching or validating business partner and address data. Examples of available data sources are 316 countries (e.g. WORLD (World), AT (Österreich, Austria, Autriche, 奥地利), BE (Belgien, Belgium, Belgique, België, 比利时)), 993 legal forms (e.g. ), and 72 active business partner data sources (e.g. Data source CDQ.POOL, Data source VIES, Data source CH.UIDR).

Metadata and Standards: Metadata-driven Data Quality

Data quality plays a pivotal role in ensuring compliance with legal, regulatory, and industry standards. One of the core challenges in achieving high data quality is adhering to dynamic data requirements that evolve due to changes in national regulations. These requirements vary by country, making it essential for businesses to track and update compliance criteria continuously.

In many countries, official company information is available as Open Data, but the lack of a standardized data model or provision method complicates the process of integrating this data. The Data Sharing Community actively collaborates to identify global data requirements and reference data sources, whether Open Data or commercial.

Short description
Managed reference data for administrative areas with language-specific terms and short names according to ISO 3166-2.
Managed reference data for bank accounts worldwide.
Managed reference data for types of identifiers per country.
Basic data concepts of CDQ Cloud Services.
Managed reference data about compliance lists considered in the sanction and watchlist screening services
Managed reference data for countries with language-specific names and short names according to ISO 3166-2.
Documentation of data quality rules with explanation and technical constraints to validate business partner data records.
Data quality rule functions are methods implemented in a programming language for being used in data quality rule implementations. They can be e.g. used in custom data quality rules similar to functions employed by business users in popular spreadsheet applications such as Microsoft Excel.
Managed reference data for legal forms with official and commonly used abbreviations and corresponding country.
Managed reference data for localities, such as exonyms.
Managed reference data for post codes
Managed reference data for postal delivery points, such as Post Office Boxes used for identification, extraction, harmonization and standardization.
Managed reference data for issuing bodies of identifiers
Managed reference data for thoroughfares of type Street (CDQ.POOL) used for harmonization and standardization.

Data Quality Rules

Transformation of human-documented data requirements into executable data quality rules is mostly a manual IT effort. Changing requirements cause IT efforts again and again. Some checks, e.g. tax number validity (not just format!), require external services. Other checks, e.g. validity of legal forms, require managed reference data (e.g. legal forms by country, plus abbreviations). Continuous data quality assurance (i.e. batch analyses) and real-time checks in workflows often use different rule sets.

Data requirements and related reference data are collected and updated collaboratively by the Data Sharing Community. Data quality rules are derived from these requirements automatically. All data quality rules are executed behind 1 interface, in real-time. Batch jobs and single-record checks use the same rule set and can be integrated by APIs.

For proving that a data quality rule is content-wise correct we maintain supporting document(s) per data quality rule which share the rule's source. This could be:

  • a public authority source
  • any other trustful webpage
  • a data standard of a specific community member

We manage the URL (if any), a screenshot of the relevant parts (if any) and the source's name (e.g. Community member data standard, European Commission, National ....) See Identifier format invalid (SIREN (France)) as an exemplary rule that was specified and implemented based on information provided by the OECD.