Creating An Azure SQL Database As A Federated Data Source In Azure Data Lake Analytics - Part Two

This writing is a continuation of my previous article in which I created a storage account, created Blob for the Container, created a Container and uploaded a file into the Container. Here, I will be working on creating a SQL database Server, importing the database from the storage account and configuring Firewall settings.

Creating a SQL database Server

Move back to Microsoft Azure Portal account and sign in with the same Microsoft Azure account that you were using in the previous demo.

Click New - search for SQL Server and you can find SQL Server (logical Server). Click on it.

You can find that the SQL Server (logical Server) blade opens up here. Click Create button.

Fill the fields given below with the Server name, Server admin login, password, subscription and for resource group, select the existing resource group in which the database has been uploaded, location of the same and click Create.

You can find the deployment status here as the deployment started in the notification pane.

Once the Deployment is complete, you can find that the deployment has been complete in the notification pane with a green tick mark, as shown below.

As soon as SQL Server is created, a new Window will open up, as shown below.

Now, to add a database, click import database.

Select the storage of account, where the database is located. Here, it is “mydlstorage” under “rgdl” resource group.

Click on the respective container on the storage account and select the database named “academics-stackexchange-users.bacpac”.