Version 5.2

New

  • Support for SQL Server 2017
  • Allow Target table to be defined for Copy All Tables from flat file or blob storage. When the Target table is defined, Loome Integrate assumes all of the source files will have the same format, and delivers them into the defined target. This is most useful when you have a standard format source file, named by creation date/time. Loome Integrate will pick up any files in the defined source folder and deliver into a single target table.
  • New Connectors:
    • Azure SSAS
    • Freshbooks
    • Hubspot
    • Magento
    • SendGrid
    • ServiceNow
    • Zuora
    • Added license expiry alert to front screen
  • Revised Similarity Task functionality, including support for incremental updates (ref Loome Integrate Similarity Task Set Up Guide, which will be provided on request) and improved performance.
  • SenderEmailAddress is now defined in System Settings. This value will be used as the Sender in all Loome Integrate email notifications.
  • Defaults new reconciliation steps to ‘Enabled’ and ‘Keep error data’.
  • Changed Persistent Staging Task layout to be consistent with Data Migration Task; added full support for staging via blob storage.
  • Added support for impersonation in Connections.

  • Generates views for historical and latest data from Persistent Staging tables.  

    Fixes

  • Task creation fails when first connection in connections list is a paused Azure DW connection.

  • Key column is excluded from Persistent Staging table.

  • Incremental Data Migration fails when target table has identity column.

  • Parameter values not updated when a parameter is deleted.

  • Copy All failing for Azure Blob Sources.

  • Creation of a new connection in Data Migration leaves the schema set to the first schema in the original default connection.

  • Similarity task failing when source column names contain spaces.

  • Similarity task failing when a column is added to the Match or Filter columns in MDS.

  • Persistent Staging fails when column name has special characters or is a keyword.

  • Data Migration fails when target schema name contains non-standard characters or starts with a number.

  • Data Migration fails when target is Azure DW and incrementally loaded with Refresh Period > 0.

  • File Definition Usage navigation to Task fails when in ‘All Projects’.

  • Removed the column listing when deleting from MDS; when choosing the ‘DataGovernor: Permanent delete…’ option for the Batch Type the column selection should be hidden.