Jet Analytics can use an Azure SQL Database for the repository, data warehouse, and staging databases and includes a Direct Read Option for transfers to cut Jet Analytics out of the loop.
(Previous versions of Jet Analytics supported two ways of transferring data: with ADO.net or through SSIS. With either, the Jet Data Manger needed to act as a middle man between the source and destination. This is usually not a problem with on-premise servers but it can be an issue when you move to the cloud)
When you enable Direct Read, Jet Analytics will generate T-SQL code that will move data directly from the staging database to the data warehouse. For the feature to work, some prerequisites must be met:
- On Azure SQL Database, the staging and data warehouse databases need to be in the same database.
- On SQL Server, the databases need to be on the same server.
The feature can be enabled on the data warehouse level: