Connect to Azure SQL from logic apps to execute D365FO Enqueue

In one of my assignments, I am using Azure SQL database acting as staging where I am importing the data on to it for further transformations.

In order to push the data to D365 FO using recurrence, I used logic apps to establish connection to the azure db . Given below the steps

Create a logic apps and select ‘SQL Server’ connector. On clicking, there will be list of actions displayed to the user

In my case, I am choosing ‘Execute a SQL Query’ where a simple SQL select is going to be used.

The important step is to initiate a connection to the target Azure Db. Credentials can be found in Azure portal based on the access the user has.(Usually Administrator has the control of the Azure Dbs and its access)

Given the screenshot

On clicking Create, user will be able to see the list of tables available in the database.

Now, a simple select statement is given and the results are imported to a CSV table.

Save and start the execution.

Given below the screenshots of execution results for the above steps.

This can be further used to call enqueue job configured in D365FO which pushes the data in a single call.

In the below screenshot, result of the csv step is passed input to the enqueue operation.