Azure SQL Database Management

Azure SQL Database Management is a management API for Azure SQL Database, which is an intelligent, scalable, relational database service built for the cloud. Optimize performance and durability with automated, AI-powered features that are always up to date. With serverless compute and Hyperscale storage options that automatically scale resources on demand, you’re free to focus on building new applications without worrying about storage size or resource management.
For more information on Azure SQL Database Management see the company website.
In the context of Nintex Workflow Cloud, Azure SQL Database Management 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..
The Azure SQL Database Management 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. is used to create connections for Azure SQL Database Management actions A tool for building the processes, logic, and direction within workflows..
The following actions are available:
Use Azure SQL Database Management actions to actions to create, delete, retrieve, and update SQL databases.
Create an Azure SQL Database Management connection
You can create connections from the Automate or Designer page.
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.

- The account you use to create a connection for Azure SQL Database Management is the account that has access to the Azure SQL Database Management actions.
-
You must register a single tenant app in Azure Active Directory, and configure a client secret. See Quickstart: Register an application with the Microsoft identity platform for the steps to register a new application. This must be a single tenant app.
-
The following permissions are needed in Azure tenant app:
Azure Active Directory -> App registrations -> Your SQL Database Management App -> API permissions ->
-
Add user_impersionation permission for Azure Service Management
-
Add User.Read permission for Microsoft.Graph (usually given as default)
Subscription -> Access control (IAM) -> Role assignments ->
-
App/Service principal must at least be a Contributor
-
-
You need the app's client ID, client secret, and the tenant ID. You can find them on your Azure portal tenant settings page.

-
On the top navigation bar, click Automate, and then select Connections from the left navigation.
-
On the Connections page, click Add new.
-
In the Add a new connection section that opens, fill in the following.
In this field
Select or enter the following
Connector Azure SQL Database Management -
Click Connect.
-
In the Configure a connection window, fill in the fields as follows.
In this field
Select or enter the following
Connection name A name for your new connection Client ID The client ID generated from the Azure portal tenant settings page. Client secret The client secret generated from the Azure portal tenant settings page. Tenant ID The tenant ID displayed on your Azure portal tenant settings page. -
Click Connect.
-
Follow the prompts to enter credentials and grant access to Nintex Workflow Cloud.
- In the permissions dialog, you can do one of the following:
- Edit the Owners or Users permissions according to data source usage requirements and click Save permissions.
Tip: You can assign connection owners or users permissions according to your access requirements. For more information, see Permissions.
Your new connection appears on the Connections page.

-
Access the Designer page
- On the top navigation bar, click Automate > Workflows, and then select the required workflow.
(Or)
- On the top navigation bar, click Automate > Create workflow.
- Click the Azure SQL Database Management action you want to add the connection to, or drag an Azure SQL Database Management action into the workflow and select it.
-
In the drop-down list for Connection, select Add new connection.
-
In the Connection window, fill in the fields as follows.
In this field
Select or enter the following
Connection name A name for your new connection Client ID The client ID generated from the Azure portal tenant settings page. Client secret The client secret generated from the Azure portal tenant settings page. Tenant ID The tenant ID displayed on your Azure portal tenant settings page. -
Click Connect.
-
Follow the prompts to enter credentials and grant access to Nintex Workflow Cloud.
- In the permissions dialog, you can do one of the following:
- Edit the Owners or Users permissions according to data source usage requirements and click Save permissions.
Tip: You can assign connection owners or users permissions according to your access requirements. For more information, see Permissions.
Your new connection appears in the Connection field of your action.
Permissions
Permissions enable you to manage access for other users to use, edit, and delete connections.
Use |
Edit |
Delete |
Assign |
|
---|---|---|---|---|
Owners |
![]() |
![]() |
![]() |
![]() |
Users |
![]() |
![]() |
![]() |
![]() |
Note: By default, users with administrator role will have the same rights as a Connection owner.

Follow these steps to assign permissions from the Connections page:
- On the Connections page, click
for the required connection.
- From the menu, select Permissions.
- To assign permissions:
- In the Owners field, type the name of the user, and select from the list.
- In the Users field, type the name of the user, and select from the list.
The corresponding permissions window is displayed.
- Click Save permissions.