Nishant Rana

Azure: Execute Stored Procedure using Azure Data Factory

In this blog post, we’ll see how to execute Stored Procedure in Azure SQL Database inside Azure SQL Server. Let’s go through the steps to see it in action.

Login to Azure Portal.
Click Create a resource –> Databases –> SQL Database.

Give a unique name to the Azure SQL Database. Click on Server field to create Azure SQL Server on the fly.
Give a unique name to the Azure SQL Server, provide credential for login and click Select.

Make sure the Azure SQL Server that we just created is selected as Server while creating Azure SQL Database. Fill the mandatory fields and click Create.

Let’s connect to the Azure SQL Server using SSMS. On clicking Connect a new pop up will open where we need to put Azure subscription credential to login.

Using Azure subscription credential we need to create a firewall rule so that…

View original post 272 more words

SSIS and Microsoft Dynamics 365

Listing down the posts on SSIS and Microsoft Dynamics 365 for quick reference

Using Azure Bot Service to create Bot

Using Microsoft Bot Framework

Azure Bot Service is an integrated environment that allow us to easily register, build, deploy our bots. It provides the required components and hosting environment for creating bots through Bot Builder SDK using either C# or JavaScript and connector service to connect to various channels.

https://portal.azure.com

Search for Web App Bot

We have selected Basic Bot template.

After the Bot Web App is created, we have the option to either Download Bot Source Code to keep developing using Visual Studio or we can open it in online code editor.

Online Code Editor allows to update the source code within the App Service Editor

As the basic bot app template uses the Language Understanding Intelligent Services, we can log on to the Luis

https://www.luis.ai/welcome

There we can see the app.

With all the corresponding Intents, Entities and Utterances.

To test the bot either we can either download the emulator for testing locally or can test online using Web Chat.

Select Test in Web Chat

After we have tested it, next we add channel to our Bot, here we will add Skype.

Below are some of the configuration that can be applied for Skype.

Messaging gives the option of enabling the messaging, Calling let us to enable calling, groups allows us to add the bot to groups and Publish option allows to publish the bot and also submit it for review if it to be used by more than 100 contacts as shown below.

Clicking on Save publishes the bot and we can see the Skype added as one of the channels.

Click on Skype icon to add it to skype.

Add to contacts will add it to Skype and can start our conversation.

Hope it helps..

Power BI and Microsoft Dynamics 365

Listing down the posts on Power BI and Microsoft Dynamics 365 for quick reference

Azure: Copy Data from D365 CE to Azure SQL Database using Azure Data Factory

Ajit Patra

In this blog post, we’ll see how to copy data of an entity “Contact” in D365 CE to Azure SQL Database. Let’s follow the below steps to see it in action.

Login to Azure portal.
Create Azure SQL Database where we need to copy the data. Click Create a resource –> Databases –> SQL Database

Give a unique name to the database. Click on server field to create a Azure SQL Server. Give a unique name to the Azure SQL server, username and password for logging in. Click Select.