Version 5.0

New

  • Loome Integrate cloud
  • A New UI, with a new theme
  • Similarity Task. 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).