Make HEDDA.IO data cleansing functionalities part of your data integration process with our SSIS Cleansing component.
With the HEDDA.IO cleansing component, you have the possibility to check data from different source systems directly in the loading process against your domains. Thanks to the HEDDA.IO Web API not only the simple values are checked for valid domain values (lookup), but 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 as well as a fuzzy search in existing data records.
Choose the SSIS component “Domain Cleansing” and add it to the Data Flow Task.
Opening the SSIS component, it is required to connect it with the Azure App Service using the service URL and API Key. If the connection is successfully established the Knowledge Bases and the associated Domains will be available.
In the “Data Mapping” tab all inputs the SSIS component receives from the source are shown and it’s possible to select a Domain the Input has 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.