Amazon Redshift

Amazon Redshift is a data warehouse that analyzes the customer data using standard SQL and other existing Business Intelligence (BI) tools. For more information, click here.

Ensure that you have downloaded the drivers to use the application in Adeptia Connect.

Field (Account) Information

While configuring the Source or Destination of a Template or Transaction, you find an Account option to connect Amazon Redshift with Adeptia Connect. Using Account configuration, you specify the location from where the data is to be accessed. In this process, enter the details of the application account to grant permission for data access.

Specify the following information for Amazon Redshift:

Field Name	Description
Account Name	A short, descriptive name that helps you re-use this account in future.
User and Password	User name and Password of the user.
Database	Name of Database from Redshift cluster where user needs to login
Server	The host name or IP Address of the Redshift cluster hosting the database
Port	The port on which Amazon Redshift is running.

Triggers

A Trigger specifies when a particular Transaction will start executing. While configuring the Source of a Template, you find a Trigger drop-down list.

Following triggers are available for Active Directory at Source.

Trigger Name	Description
On Records Added	Triggers when the new records are added.
On Records Added or Updated	Triggers when the new records are added or existing records are updated.
All Records	Extracts all records starting from the beginning.

Actions

An Action specifies how the data will be transferred at the destination location. While configuring the Destination (Target) of a Template, you find an Action drop-down list.

Following actions are available for Apache Cassandra at Destination.

Action Name	Description
Add Records	Adds the new records in the account.
Update Existing Records	Updates existing records in the account.
Add Records or Update Existing Records	Adds the new records or updates existing records in the account.