Guide: Using Microsoft Azure with Databox

HOW TO

    Microsoft Azure connections are available in Plus and Business Accounts. Agency Basic Accounts have the ability to use MicrosoftAzure in the Agency Account only.

How to prepare your Microsoft Azure Database

Click Add and populate the form  click Add and populate the form like below.

1
 To prepare our Microsoft Azure database, we'll login to the Microsoft Azure portal ( https://portal.azure.com/) and navigate to the  SQL databases tab

add_user_popup@2x

2
 Next, we'll click  Add and will populate the SQL Database as seen below: 

add_user_popup@2x

3
 The database needs to run on a server. Since we don't already have one created, we'll create a New Server through the form below. Note that the Server Name must be unique. 

add_user_popup@2x

4
 On the SQL Database form, we'll click on the Select drop-down and will choose this new Server. 
5
 Next, we need to create a Resource Group. We'll call ours "rg1" 
6
 Finally, for the Source we'll create our Database. The final SQL Database form is populated as follows: 

add_user_popup@2x

7

 Click Create to create this new SQL Database. After a few minutes, this newly created SQL Database will show up in the Default Directory 

add_user_popup@2x

8

 Now we need to enable remote access our new SQL Database. Click on the Overview tab and select Set server firewall

add_user_popup@2x

9

 This will open the  Firewall settings panel. We'll enter Databox’s public IP (52.4.198.118), which will connect to this database with set credentials

add_user_popup@2x

10

 Click Save to update the Firewall rules

add_user_popup@2x

For further security and configuration considerations, please consult the official Microsoft Azure SQL Database documentation

How to connect Microsoft Azure to Databox

Once our Database is properly prepared, we'll connect it to Databox.

add_user_popup@2x

To connect Microsoft Azure to Databox, go to Data Manager > + New connection. Type Microsoft Azure in the search bar and click on the green Connect button. 

This will open the  Activation window, which is where you will be prompted to enter your connection data and authorize the Databox app. 

add_user_popup@2x

Click the green Activate button to complete the connection process. If Microsoft Azure was successfully connected, the Activation window will close shortly and you'll see a Connected notice. 

If you see a notice that says Wrong Credentials, doublecheck your user data before re-entering them in the Activation window. 

If the Activation window doesn't close for over a minute, there may be difficulty connecting to your server due to firewall issues. If you have difficulty connecting, be sure access is granted to Databox's public IP (52.4.198.118). 

How to use the Query Builder for Microsoft Azure

The Query Builder for Microsoft Azure allows you to create Custom Metrics using data from your Database to use in Databoards, Alerts, Goals, etc. Learn more about the Query Builder for Microsoft Azure here.

Additional Information

  • Query results are limited to 1000 rows. If you expect your query to return over 1000 rows or if you're not sure how many rows will be returned, be sure to LIMIT the query
  • The query must contain a column named "Date." If you need to, use AS in your SELECT statement to satisfy this requirement
  • "Null" values will not be recognized. Use a COALESCE function when needed. Learn more here.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us