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 Automation 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 is used to create connections for Azure SQL Database Management actions A tool for building the processes, logic, and direction within workflows.. Use Azure SQL Database Management actions to actions to create, delete, retrieve, and update SQL databases.
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.
In the Add a new connection section, complete the fields as follows:
In this field
Select or enter the following
|A name for your new connection
|The client ID generated from the Azure portal tenant settings page.
|The client secret generated from the Azure portal tenant settings page.
|The tenant ID displayed on your Azure portal tenant settings page.
Azure SQL Database Management account requirements
- 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.
Use the Azure SQL Database Management data source to create a drop-down list in a form of available Azure SQL Database Management databases.
You can create a Azure SQL Database Management data source to:
- Get databases: list all the categories for events in Azure SQL Database Management.
Each data source is configured for a specific Azure SQL Database Management connection. You can create as many data sources as you need.
To access the data source fields, in the Add data source section, select the Azure SQL Database ManagementConnector and the Operation.
Field or selection
The available Azure Active Directory connections.
|Subscription credentials which uniquely identify Microsoft Azure subscription. Select the subscription from the drop-down.
|Resource group name