Azure PostgreSQL Database Management

Azure PostgreSQL Database Management is a management API for Azure PostgreSQL Database, which is a relational database service based on the open-source Postgres database engine. It's a fully managed database-as-a-service that can handle mission-critical workloads with predictable performance, security, high availability, and dynamic scalability. For more information on Azure PostgreSQL Database Management see the company website.

In the context of Nintex Automation Cloud, Azure PostgreSQL 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 PostgreSQL Database Management connector is used to create connections for Azure PostgreSQL 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 PostgreSQL Database Management actions to create, delete, retrieve, and update PostgreSQL databases.

Jump to:

Create an Azure PostgreSQL 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 PostgreSQL Database Management account requirements

  • The account you use to create a connection for Azure PostgreSQL Database Management is the account that has access to the Azure PostgreSQL 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.

  • 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 PostgreSQL Database Management data lookup

Use the Azure PostgreSQL Database Management data lookup to create a drop-down list in a form of available Azure PostgreSQL Database Management databases. For example, to allow users to select a specific database in a form, add a drop-down list of databases to the form using a Data lookup control A form control that allow users to select from a drop-down list that has values sourced from a third-party service.. The Data lookup control uses an Azure PostgreSQL Database Management - Get databases data lookup to list the databases available on the Azure environment.

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

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

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

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

  1. Create your Azure PostgreSQL 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 PostgreSQL Database Management data lookup fields

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