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
