Create a project with only Azure SQL databases
Since the release of version 17.5 we have the possibility of creating and using databases on a Azure SQL Database.
What is needed
To use TX DWA and Azure SQL Database together, TX DWA 17.5.xxx, CLR and SMO is required. Here is a link to those ENU\x86\SQLSysClrTypes.msi ENU\x86\SharedManagementObjects.msi
A full SQL server is also possible, but it is not needed to connect and create to Azure.
If you want to use the scheduler service, it is also important that you install TX DWA on a server, or computer that is always on. It could be a Azure virtual machine, like i used i my own test, or another form of server.
It is also necessary to know the Azure SQL server name and have a SQL user with the rights to create databases on it.
How to set it up
The first step is to create a repository on the Azure SQL database.
Add the server name, repository name, set it to use SQL server authentication and add the SQL user.
Press create and it will then give a visual representation of what is being done.
Create a new project, make sure SSIS is not selected, add a BU and a STAGE/DSA database.
Add the server name, use SQL Server authentication and add the same user. It should not be named xxx_STAGE, as it will be used for both DSA and DWH.
Create the database.
Attach a data source. It can be anything really, but in my test case i used a NAV database, that was conveniently placed on the same Azure SQL database.
Add some tables and fields. Then create a DSA schema. This is to split up the two parts of the database in DSA and DWH. It need to be set up as the "Main default schema".
Then add the Data warehouse. It is set up so it points to the database that were created earlier. Use the same server and user account. The only exception is that the Direct Read option is used. It is important that it is set to "Matching Server and Database". In Azure SQL Database, two tables cannot transfer between each other. As it will not be able to do distributed database queries.
Before the the fields from stage to DWH are attached, The other Schema needs to be set up, so you avoid tables having the same names.
Deploy/Execute. See that the Azure SQL Database set up.
The use of SSIS is not available.
It is not possible to create OLAP servers on Azure Analysis Services. It does not work with Azure SQL Databases yet. It is going to be added in the future.
If you want to create a DWH database and STAGE database you cannot use direct read.
Alternative ways of using Azure Databases
Perhaps you want only the DWH table to be located on Azure. This is possible, as long as you do not use Direct Read and SSIS. You can also do it the other way, where it is STAGE that are on Azure and DWH is locally.
You can also set up multiple environments, have a Dev environment locally and a Prod environment fully on Azure.
Do you have questions regarding a way to use Azure and set it up? Please add it in the comments.