5th of August, 2019

The following changes concern the central Loome Integrate Online service. No explicit action needs to be taken to utilise these 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.
- Learn more here.

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

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.

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.

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.

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.

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.