Use Azure SQL for Repository, Data Warehouse and Staging Databases
Overview
As cloud services grow ubiquitous and more and more powerful, Jet Analytics expands its support.
Jet Analytics17.5 and higher supports using Azure SQL Server for your repository, data warehouse, and staging databases (earlier versions require a local SQL Server for running Jet Analytics).
The main benefit is that it saves you the hassle of monitoring and maintaining your own SQL Server.
Naturally it depends on your specific situation if an Azure SQL Database beats an on-premise SQL Server installation on features, performance, and cost.
From a Jet Analytics perspective, there are two main differences between Azure SQL Database and SQL Server:
-
Azure SQL Database does not support SSIS. This means that you can’t use SSIS for data transfer in the Jet Data Manager, however you can use the Direct Read Option for transfers.
You will need to use SQL Server authentication since Windows authentication is not supported by Azure SQL Database.