Azure SQL

Azure SQL is a cloud-computing database service (Database as a Service) offered by Microsoft Azure Platform that helps to host and use a relational SQL database in the cloud without requiring any hardware or software installation. For more information on Azure SQL, see the company website.

In the context of Nintex Automation Cloud, Azure SQL is a connector A software component that allows seamless integration with third-party services, business applications, and content stores. Examples include Salesforce, Box, and Microsoft SharePoint. Connectors are used to create connections required for workflow actions and start events. and it's used to create connections for Azure SQL actions A tool for building the processes, logic, and direction within workflows. Actions are the steps the workflow performs to complete a process.. Use the Azure SQL actions to create, delete, and update SQL records. You can also execute a stored procedure and query an SQL table or view.

Jump to:

Create an Azure SQL connection

Note: Your browser-stored credentials are accessed to create connections. Either clear credentials from browser memory or make sure the stored credentials are for the intended environment.

Create a connection from the connections page or from the action configuration panel when configuring the action. For information about creating connections and assigning permissions, see Manage connections.

Use SQL authentication to connect to Azure SQL. The password and username are transported with an encrypted connection to Azure SQL, ensuring a secure connection.

Important: 

There are IP addresses that you have to add to the allowlist in your firewalls and networking devices to enable communications with Nintex Automation Cloud. For more information, see the Azure SQL section in the Allowlist IP addresses help topic.

Consideration

  • 'EXECUTE' cannot be used within a stored procedure as this is not supported by the Azure SQL connector. See EXECUTE (Transact-SQL) for additional information.
  • See the following topic on how to add Null values : Variables with null value.

  • Depending on the column type selected, this can cause the UI to remove trailing spaces eventhough they are still present as HTML ignores trailing spaces.

Create an Azure SQL data lookup

Use the Azure SQL data lookup to create a drop-down list in a form of available Azure SQL databases. Each data lookup is configured for a specific Azure SQL connection. You can create as many data lookups as you need. For more information on creating a data lookup and assigning permissions to it, see Data lookups.

You can create an Azure SQL data lookup to:

  • Get databases: List all the databases in the Azure SQL account.

Azure SQL data lookup fields

To access the data lookup fields, in the Add data lookup section, select the Azure SQL Connector and the Operation.

Operation

Field or selection

Description
Get databases Connection

The available Azure Active Directory connections.
  Subscription Subscription credentials which uniquely identify Microsoft Azure subscription. Select the subscription from the drop-down.
  Resource group name

The name of the resource group that contains the resource. You can obtain this value from the drop-down or get it from your Azure portal.
  Server name

The name of the server. Select the server from the drop-down.