In last post we saw how to Insert a single Record in SQL Table which is on Prem using Logic App -  Inserting data in On Premises SQL Database using Logic Apps Here I intend to walk through the process of inserting multiple records using single Logic App, to do this we have two options we can choose from  1. Split On   2. For Each So either we debatch/split the  Request  message and insert in table or loop through the array of records and insert in table, here I am using the later method. Input In earlier post we had single record  thus input was - {         "Description": "Edifice",         "ID": "123",         "Price": "3424"     } Here we want multiple records thus we need to create an array of records as following- { "Products":[     {         "Description": "Edifice",         "ID": "123",   ...

If you are a BizTalk developer and get to know about any other integration tool/offering, and if you have to evaluate that - the first couple of things that would come in to your mind is(at least in my mind ;)) 1. How to route file from one location to another  2. How to perform CRUD operation on database Thus, I thought of creating a simple Logic app which will receive a Product information and insert into table, but the table is part of database which is on premises. Following are needed to do this 1. Azure Subscription 2. On premises machine with database to be used 3. On Premises Data Gateway installed on the on premises machine and registered on Azure Now lets create the Solution 1. Create a database and a table    To  keep it simple have created a DB called DemoDb with table having three      columns  2.Install,Configure and start OPDGW   If installation and configuration of OPDGW is done then ma...

This post is intended to walk-through the process of   Installing and Configuring On Premises Data Gateway when you don't have work account (But you have a Microsoft account) It is stated that Microsoft account can't be used to configure/register OPDGW, instead you need to use school account or work account. So does that mean a person not having work/school account cannot explore/use OPDGW- Well there is a way, you add a user to Active Directory. Let's see how we do it 1. How to add user to Active Directory 2. Install OPDGW on local machine 3. Configure OPDGW on machine 4. Register OPDGW on Azure Portal 1. How to add user to Active Directory To add user to AD, login to portal and search for Active Directory Click on Acive Directory and Under Quick Links - select Add a user  Before adding user, remember you have to use following pattern Say your Microsoft account is - xyz@gmail.com then new user should be something@xyzgmail.onmicr...