5th of August, 2019

Service

The following changes concern the central Loome Integrate Online service. No explicit action needs to be taken to utilise these features.

New Features

  • Integrate: Target Filters can now be applied in the Data Migration builder. These are simple conditions which will be applied to the source when pulling data.

Improvements

  • Integrate: Improved structure of Snowflake connection string template to prompt the user for a Data Warehouse.

Fixes

  • Integrate: Fixed bug where users would be able to proceed to next page of blob as a source migrations without selecting a file definition.
  • Integrate: Fixed bugs with cancellation of data migration modals. Cancelling modals will now undo any changes as was previously the case.

Agent

Minimum Version Number: 2019.8.2.1

The following changes concern the Loome Integrate Agent that you install yourself. To acquire these changes you will need to update your agent.

New Features

  • Integrate: When using Snowflake as a target, you can now use Snowflake’s internal store as a configuration-less staging connection.
    • This feature does require the SnowSQL CLI to be installed on the same host as the agent.
  • Integrate: Target filter support for connection types such as SQL Server, ODBC and many other API connectors.
  • Integrate: Support for Aconex Package and Document data import.
  • Integrate: Incremental configuration support for Aconex mail and document entities.

Improvements

  • Integrate: Improved syntactic parsing and validation when verifying SQL statements.
  • Integrate: Testing a Snowflake connection will now try to use the provided data warehouse so that validation works better.

Fixes

  • Integrate: Fixed issues with Google BigQuery not supporting spaces in object names.
  • Integrate: Fixed bug where forward slashes would be misinterpreted as a file path in SQL queries on Linux based agents.
  • Integrate: Fixed bug where using Query as a Source with a Snowflake connection may fail from time to time.
  • Integrate: Fixed bug where verifying CREATE statements actually created the object.