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 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 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.. 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 source

Use the Azure PostgreSQL Database Management data source 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 allows users to select from a drop-down list of values that have been fetched from a third-party service.. The Data lookup control uses an Azure PostgreSQL Database Management - Get databases data source to list the databases available on the Azure environment.

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

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

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

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

  1. Create your Azure PostgreSQL Database Management data source.

    2. See Data sources.

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

Azure PostgreSQL Database Management data source fields

To access the data source fields, in the Add data source 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.
    		•