Azure SQL Database Management

Important: This connector and its actions have been removed from Nintex Automation Cloud and can now be found in Nintex Gallery.

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 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.. 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. Actions are the steps the workflow performs to complete a process.. Use Azure SQL Database Management actions to actions to create, delete, retrieve, and update SQL databases.

Jump to:

Create an Azure SQL Database Management 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.

In the Add a new connection section, complete 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.

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.

Create an Azure SQL Database Management data lookup

Use the Azure SQL Database Management ddata lookup to create drop-down list in a form of available Azure SQL Database Management databases.

You can create a Azure SQL Database Management data lookup to:

  • Get databases: list all the categories for events in Azure SQL Database Management.

Each data lookup is configured for a specific Azure SQL Database Management connection. You can create as many data lookups you need.

To add an Azure SQL Database Management drop-down list to your form:

  1. Create your Azure SQL Database Management data lookup

    2. See Data lookups.

  2. Add a data lookup form control to your form and configure it to use your new data lookup

Azure SQL Database Management data lookup fields

To access the data lookup fields, in the Add data lookup section, select the Azure SQL Database ManagementConnector 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.
    		•