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 Service used to define a connection required for associated actions and start events. Examples include Salesforce and Box. Method of integration to cloud services, business applications and content stores. and it's used to create connections for Azure SQL actions A tool for building the processes, logic, and direction within workflows.. 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.
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.
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 source
Use the Azure SQL data source to create a drop-down list in a form of available Azure SQL databases. Each data source is configured for a specific Azure SQL connection. You can create as many data sources as you need. For more information on creating a data source and assigning permissions to it, see Data sources.
You can create an Azure SQL data source to:
- Get databases: List all the databases in the Azure SQL account.
Azure SQL data source fields
To access the data source fields, in the Add data source 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. |