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.

About AnithaEswaran

Hello all, Thanks for visiting my blog. I strongly believe in "Knowledge increases by sharing ,not by saving". With that in mind, I started this blog to share my learning with D365FO community. Since I am from technical background, most of my posts would be from X++, Azure integration and other topics. Thanks to my mentor and my colleague Romain Gasnier who guided and helped me in learning many new concepts in Ax. This instilled confidence in me to handle and troubleshoot complex issues.
This entry was posted in Uncategorized. Bookmark the permalink.

3 Responses to Connect to Azure SQL from logic apps to execute D365FO Enqueue

  1. Pingback: Connect to Azure SQL from logic apps to execute D365FO Enqueue - 365 Community

  2. Pingback: Date format issue in ‘Execute a SQL Query (V2)’ logic apps – D365FO integration | Anitha Eswaran – Dynamics Ax

  3. Pingback: Date format issue in ‘Execute a SQL Query (V2)’ logic apps – D365FO integration - 365 Community

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.