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

  • 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

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

Fixes

  • Fixed bug where users would be able to proceed to next page of blob as a source migrations without selecting a file definition.

  • 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

  • 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.
  • Target filter support for connection types such as SQL Server, ODBC and many other API connectors.

  • Support for Aconex Package and Document data import.

  • Incremental configuration support for Aconex mail and document entities.

Improvements

  • Improved syntactic parsing and validation when verifying SQL statements.

  • Testing a Snowflake connection will now try to use the provided data warehouse so that validation works better.

Fixes

  • Fixed issues with Google BigQuery not supporting spaces in object names.

  • Fixed bug where forward slashes would be misinterpreted as a file path in SQL queries on Linux based agents.

  • Fixed bug where using Query as a Source with a Snowflake connection may fail from time to time.

  • Fixed bug where verifying CREATE statements actually created the object.