This function uses Fuzzy Matching techniques to match data rows within a SQL Server source table or view to each other; the results and matching rules are retained in MDS. Matching rules are predefined in accordance with the Loome Integrate Similarity Task Set Up Guide, which will be provided on request.
Moved Reconciliation Datasets and execution results to DGStg schema;
In the PerspectiveData database for existing clients
in the client Staging or Data Warehouse database for new installations
Replaced accuracy at Reconciliation Step level with tolerance % and value per compared column
Enabled one-to-many and many-to-one Reconciliations, with drill through to detail.
Replaced Install Key licensing in backend with Soraco licensing in UI
Replaced the Deployment process with Export to XML and Import from XML functions.
Revised email content; now includes source environment and error details.
Support for Azure Blob Storage as a Data Migration Source.
New admin function to enable sharing of Connections and File Definitions across Groups
New Task types for import to and export from MDS & Kepion.
Support for Oracle ODP Connections
Support for PowerShell Write-Warning and Write-Debug in Loome Integrate Log.
Caters for unprintable character as delimiter in File Definitions.
Upgraded to .Net V4.5 for Azure compatibility.
Support for SharePoint Office 365 lists as Data Migration source or target.
Additional validation in the Installers.
SQL command task now supports any database connection (e.g. Oracle).