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

Guest User
Feb 15, 2017

5k
0
3
- facebook
- twitter
- linkedIn
- Reddit
- WhatsApp
- Email
- Print
- Other Artcile

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 an Azure SQL Database As A Federated Data Source In Azure Data Lake Analytics

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”.

Give a username and password for the same, as shown below. Click OK, as soon as configuring the details is done.

Again, you can find the status of the database getting imported under the notification pane of Microsoft Azure portal as the database import is in progress.

In the mean time, until it gets imported, let's configure the Firewall on our database instance. Move back to the home page of Microsoft Azure portal, click on the database Server named “datalakedbserver”.

Once the Window opens for the Server, click Show Firewall settings.

Configure it with the the details given below.

Rule Name: Allow Data Lake

Start IP: 25.66.0.0

End IP: 25.66.255.255

Again, you can find the notification pane as the Firewall rule has been successfully updated. Click OK for it.

Again, move back to the Microsoft Azure portal home page and click on Data Lake Analytics “dlanalyticsnaju”.

Click "New Job".

Paste the query given below and click Submit.

CREATE DATABASE UserIntegration;

Now, click on Submit job.

Open your Windows Powershell now and run the command given below.

Azure login

You will be getting a URL and a code, as shown in the image given above, open a Web Browser, paste the URL and authenticate with the help of the code, as shown below.