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