Additional information


SQL Server Version



oh22’s HEDDA.IO is a knowledge-driven data quality product completely built in Microsoft Azure. HEDDA.IO enables you to build a knowledge base and use it to perform a variety of critical data quality tasks, including correction, enrichment and standardization of your data. HEDDA.IO enables you to perform data cleansing by using cloud-based reference data services provided by reference data providers or developed and provided by yourself.

Visit the HEDDA.IO website.


With the HEDDA.IO cleansing component, it is possible to check data from different source systems against your configured Domains during the loading process, and have it validated accordingly.

Thanks to the HEDDA.IO Web API, not only the simple values are checked for valid domain values (lookup), but also all validation functions of HEDDA.IO are applied to the data to be checked. This includes the verification of business rules, the use of Reference Data Services (RDS), as well as a fuzzy search within the existing data records.

Choose the SSIS component “Domain Cleansing” and add it to the Data Flow Task. 

Upon opening the SSIS component, it is required to connect it with the Azure App Service using the service URL and API Key. Once If the connection is successfully established, the Knowledge Bases and the associated Domains will be become available.

Every input the SSIS component receives from the source, is shown in the “Data Mapping” tab. It is also possible to select a Domain for the input to be processed with.

The tab “Output Columns” shows how the columns in the destination will look like. It is possible to un-/select each and every column.

More information is available at www.hedda.io

Request a License

NOTE: don’t forget to select the product and the license type.