Amazon Redshift

Amazon Redshift is a cloud-based data warehouse product from Amazon that stores and analyzes large volumes of data.

Integrations and Connectors

AgilePoint NX integrates in these ways with Amazon Redshift:

  • Activities in Process Builder
  • Access tokens

Activities in Process Builder

You can use out-of-the-box activities for Amazon Redshift 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 Amazon Redshift

Process Activities for Amazon Redshift

The following activities are available for Amazon Redshift:

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

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

Access Tokens

You can create access tokens for Amazon Redshift.

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 tokens for Amazon Redshift.

Figure: Amazon Redshift Access Token Configuration screen

Amazon Redshift Access Token Configuration screen

Related Topics

Amazon Redshift Documentation

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

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

Amazon Redshift, Amazon Web Services, AWS, data warehouse, data warehousing, database