How to create a SQL Server data warehouse in Azure (Azure SQL Database)

In the current data-driven scenario, the ability to store, manage, and access data efficiently is essential. Whether you are an experienced data professional or just a beginner, the need for a robust and scalable data storage solution is undeniable. We present our tutorial to help you get started with Azure SQL Database as a data destination in Kondado.

By the end of this tutorial, you will have a clear understanding of:

• Step-by-step instructions to set up your database.
• Instructions on how to allow access in your firewall to Kondado's servers.

The Azure SQL Database is equivalent to Kondado's Microsoft SQL Server data destination. We based this tutorial on these articles from Azure to create a database and allow access in your firewall.

1. Selecting the database type

Access the database creation page: https://portal.azure.com/#create/Microsoft.AzureSQL

In the first frame, SQL databases select Create

2. Basic settings

In Subscription, select the available option

In Resource group, click on Create new and type a name for your resource group, for example, “new_rg”

3. Database name

In Database name, choose a name for your database, for example, “kondado”

4. Server configuration

And, in Server, click on Create new

On the server configuration page, you should type in Server name a name for it. This name will become an address, so it needs to be unique. The created address will be server_name.database.windows.net, where server_name is the value you filled in this step.

Then, in Authentication > Authentication method select Use SQL authentication and define a username in Server admin login and define and repeat a password for this user in Password and Confirm password

Click OK at the end and you will be redirected to the database configuration page

5. Finishing basic configuration

Back to the Basics page, in Workload environment you can select Development to reduce your costs at this first moment

Your page should look similar to the image below. Click the Next: Networking > button at the end to proceed to network configuration

6. Network configuration

On the Networking page, in Connectivity method select Public endpoint

In Firewall rules, mark Yes for Allow Azure services and resources to access this server and Add current client IP address

Then, click the button at the end Review + create

7. Finalizing creation

Review the creation data and, at the end, click Create

On the next page, wait for the resource to be created

Once finished, click the Go to resource button

8. Firewall whitelist

On the resource page, click on the Set server firewall tab

In Public network access, select Selected networks

In Firewall rules, click on + Add a firewall rule and add all Kondado IPs, removing the “/32” and copying the Start IP and End IP value for each line

Your firewall whitelist page should look similar to the one below. Then, click the Save button

9. Adding your data destination in Kondado

Access the Kondado platform > Data Destinations > New data destination > Microsoft SQL Server

In Address, enter the Server name value generated in step 4 (in our example, kondado.database.windows.net)

In Port, leave 1433

In Database, enter the Database name value created in step 3

In User and Password, enter the values created in Server admin login in step 4

Now just save your data destination and test your connection