Amazon Redshift

Visier can retrieve data through this connector if the following requirements are met.

Prerequisites

  • Create an integration user in Amazon Redshift.
  • Add Visier IP addresses to your Amazon Redshift allowlist.

Integration user

Create an integration user in your source system and assign it the appropriate security access so that Visier can retrieve your source data through this user.

Access

Description

SELECT access

Assign SELECT access to the tables you want Visier to retrieve.

Connector credentials

You need to provide the following credentials to Visier so that we can retrieve data from your source system. To provide your credentials in Visier, see Set Up Data Connectors.

Credential

Description

Example

Endpoint

The URL associated with the Amazon Redshift database.

redshift.myURL.io

Port

The Amazon Redshift port number.

5439

Database

The name of the Amazon Redshift database.

mydatabase

Schema

The schema in the database to retrieve database objects from.

schema_1

Username

The integration user’s username.

IntegrationUser

Password

The integration user’s password.

Password1234

IP addresses

Add the following IP addresses to your Redshift allowlist based on your jurisdiction.

US

  • 3.209.36.139
  • 18.215.76.61
  • 54.156.247.194
  • 35.169.9.177

Canada

  • 52.60.179.226
  • 99.79.133.101
  • 52.60.89.120
  • 35.182.193.120

Europe

  • 3.65.101.208
  • 18.192.64.158
  • 18.195.228.12
  • 18.196.36.112

Asia Pacific

  • 13.213.108.107
  • 13.251.18.199
  • 13.251.171.117
  • 3.1.9.34

Data files

The Amazon Redshift data connector only retrieves data stored in Redshift for use in Visier.

For other data, you must provide that data through alternative methods such as SFTP or Visier’s other data connectors. For more information about sending data to Visier, see File Upload.

How the connector loads data

Initially, data connectors retrieve a full history for each subject to generate an initial history of events. In each subsequent data retrieval, each connector handles the data load differently.

  • Full load: All data from the source system is loaded into Visier.
  • Delta load: Only changed data is loaded into Visier. A delta load may take either the entire history or a specific number of years of history for each changed record.
  • Snapshot load: All data at a particular point in time. A snapshot load does not contain historical records or show changes over time.
  • Partial load: A subset of data is loaded into Visier.

After the initial load, this connector only retrieves data for changed records.