PostgreSQL

PostgreSQL is an open source, object-relational database system that supports SQL and JSON queries.

Integrations and Connectors

AgilePoint NX integrates in these ways with PostgreSQL:

  • Activities in Process Builder
  • Access tokens

Activities in Process Builder

You can use out-of-the-box activities for PostgreSQL to execute actions in process-based apps.

An activity is a functional unit, or task, in a process-based app. Activities that integrate with a third-party system provide access to the API functionality for that system in a simple, point-and-click, form-entry format. This means that you can easily leverage APIs without writing code.

Figure: Process Activities for PostgreSQL

Process Activities for PostgreSql

The following activities are available for PostgreSQL:

  • Delete Records
  • Insert Records
  • Query Records
  • Stored Procedure
  • Update Records

For more information, refer to the process activities for PostgreSQL in Process Builder.

Access Tokens

You can create access tokens for PostgreSQL.

An access token is a secure object that stores an endpoint (usually a URL) and authentication credentials to connect to a service or technology. Often this is an external or third-party service, like Salesforce or SharePoint, but access tokens can also connect to an AgilePoint NX enviornment, local database, or other types of technologies. Once an access token is created, app designers can simply select and reuse it, rather than entering the credentials each time they are needed.

For more information, refer to Access Token for PostgreSQL.

Figure: PostgreSQL Access Token Configuration screen

PostgreSQL Access Token Configuration screen

Related Topics

PostgreSQL Documentation

Use these links to find third-party vendor documentation for PostgreSQL:

About This Page

This page is a navigational feature that can help you find the most important information about this topic from one location. It centralizes access to information about the concept that may be found in different parts of the documentation, provides any videos that may be available for this topic, and facilitates search using synonyms or related terms. Use the links on this page to find the information that is the most relevant to your needs.

Keywords

PostgreSQL, database, cloud database, db, data store, datastore, column, storage, SqlServer, SQL Server, workflow database, workflow db