Fetch Data From Azure SQL Database Using Nintex Workflow NWC (Nintex Workflow Cloud)

Before starting this article, I will give a short introduction about NWC.

NWC (Nintex Workflow Cloud) is state-of-the-art Cloud architecture, which gives you an intuitive, yet powerful set of capabilities to help you build the enterprise-grade process applications.

• IPaaS (Integration Platform As A Service).
• Integration with many 3rd party technologies like Box, DocuSign, Salesforce.

Please find the list given below of connector in NWC (Nintex Workflow Cloud), using these connectors. We can communicate NWC to other Clouds.

 

Approach

Follow the steps given below to fetch the data from Azure SQL database (PAAS) through NWC.

NWC home screen

 

From left side panel, click Workflows tab. This will redirect to designer screen.

In designer screen, just click Create Workflow from left top corner and start to create the Workflow.

 

NWC new Workflow screen

In new Workflow screen, we can see the list of NWC Workflow actions in the left side panel and we can drop and drag the actions simply like Nintex Workflow.

 

 

Search Execute a query action in search box and select SQL action. Drag and drop the action from action panel.



 

Go to Configuration screen from Execute a query action.

Configuration Screen

 

Connection

Click Connection link and create the new connection. In Connection screen, you can see the add new button. Click it and provide the values given below.

• Connector - Select Microsoft SQL Server from Connector dropdown.
• Connection Name - It can be anything (reference name).
• Database Host - Azure SQL Server name.
• Database Name - Azure database name.
• User Name - It should be provided like [email protected]@servername.
• Password - Provide Azure password.
• SQL Script - Write a SQL script, which you want to execute.
• Column to Retrieve - Provide a column name, which you want to retrieve from the database.
• Retrieved Column - Variable to save the Workflow output (should be a collection variable).

Save the settings, save and publish NWC Workflow. Once published, it will redirect to NWC home page there and you can see the list of the existing Workflow.

 

 

For this article, I am going to run this Workflow through manual Ssart but we can associate the NWC workflow for new and update events in Box, OneDrive, Salesforces etc.

Azure Firewall settings

To run Workflows, connect to SQL databases or related systems, first configure its firewall rules to allow traffic from the potential source IP addresses for these Workflows. If Firewall rules are in place but not configured to allow these IP addresses, then contact does not occur and the Workflow fails.

Potential source IP addresses for Workflows follow.

52.41.68.127

52.41.39.46

52.40.183.180

52.40.93.175

52.42.136.247

52.25.82.169

52.42.11.70

52.42.145.250

52.42.147.152

52.39.238.82

 

Keynotes

• Fetch the values from Azure SQL database, using Execute a query action in NWC (Nintex Workflow Cloud).
• Configure Azure SQL Server Firewall settings.