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)

Customizable Expiration Dates for Data Clinic Reports (25 March 2025)

We're excited to announce a new feature that empowers you to set expiration dates for your data clinic reports. When generating a report, you can now select how long it will remain available from the following options:

  • 1 month
  • 3 months (default)
  • 6 months
  • 1 year


The chosen expiration date is clearly displayed in the reports table. Once a report reaches its expiration date, the associated files are automatically removed, making them inaccessible. We recommend downloading any important reports soon after they’re created, as the expiration date cannot be changed.


Previously, reports were manually deleted every 3 months. This new feature streamlines the process, offering you greater flexibility and control over your data management.

Temporary suspension of UK.VAT data source (24 March 2025)

We would like to inform you that the data source "HM Revenue and Customs VAT Check" (UK.VAT) is currently unavailable for updates in our Data Clinic service. Additionally, no new business partner data is available in the BP Lookup service. The status of this data source has changed from LIVE to DISCONTINUED.
This means that the data source will no longer provide new business partner data or updates to existing records. However, historical data from this source will remain accessible.

This situation follows a change in HMRC's data access policy in February this year. Previously, the data was available through an open API; however, HMRC now requires registration and compliance with several requirements to access the new API. Despite our efforts, we have not yet obtained access to this new API.

We are actively working to restore access to this data source and will provide further updates as soon as possible.

Thank you for your understanding.

Integration of California Business Register (13 March 2025)

Summary

We are excited to announce the integration of the California Business Register into CDQ's Business Partner Lookup service. This new data source enhances our coverage of businesses registered in California, providing valuable insights to support compliance, data enrichment, and risk management efforts.

Details

The California Business Register data is sourced from the California Secretary of State's BizFile Online database and the publicly available business entity dataset. It contains over 8 million records and is updated weekly to ensure the most current information is available.

Each record may include the following details:

  • Entity name
  • Entity number
  • Business partner status
  • Address information, including:
    • Principal address
    • Mailing address
    • Principal address in California (if applicable)

... 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.RF64,547,681
Data source CDQ.INTEL50,525,087
Data source VIES50,000,000
Data source FR.RC40,409,328
Data source US-CA.BER8,704,706
Data source GB-EAW.CR8,575,386
Data source US-FL.BER6,140,140
Data source JP.CR5,594,536
... 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.