Connect with Amazon Redshift

Last updated Mon May 23 2022

Begin your journey with Amazon Redshift, which includes:

  • Quick steps for configuring the Amazon Redshift Connector to connect to an Amazon Redshift database cluster
  • Quick steps for accessing Redshift files for Insert, Update, and Upsert operations
  • Method examples for Insert, Upsert, Delete, Update, and Unload operations

Overview:

Amazon Redshift is a popular cloud data warehouse from Amazon Web Services (AWS) designed for managing and migrating exabyte-scale data sets while running complex analytical queries in a blink of an eye. Redshift provides cloud scalability and speed without requiring customers to manage data warehouse infrastructure themselves.

Each example process in this recipe demonstrates how to modify records stored in the Redshift database table for a particular operation. 

This solution consists of five example use case processes: 

  • Insert
  • Upsert
  • Delete 
  • Update
  • Unload 

Each process connects to the Amazon Redshift database by configuring the Boomi Amazon Redshift Connector with the appropriate credentials. Operations that involve adding or updating records obtain a Disk Connector to access Redshift file paths. 

This recipe makes it easy to use Boomi to collect data in Redshift for business intelligence (BI), training models for machine learning (ML), and for sharing data across departments and divisions. Collect vast amounts of data quickly, securely, and easily with Boomi and Redshift together.

The recipe qualifies for Boomi’s Recipe Program.

Qualifying customers get access to Boomi’s Recipe Program* with the purchase of a Boomi subscription. As part of the Recipe Program you have direct access to a Boomi specialist to get you up and running with Boomi at no additional cost. Learn more

*Offer applies only to new customers and requires purchase of a qualifying Boomi subscription.

Related Solutions

Recipe

Get Started with Decision Map & Business Rules in Flow

See how to use a Decision Map element alongside business rules to incorporate logic into your flow.
Learn more

Accelerator

Oracle Cloud ERP Integration Accelerator – CRM: Customer / Account by Apps Associates

Automatically load customer accounts into Oracle Cloud ERP: CRM with Boomi.

Recipe

Get Started Displaying Charts in Flow

Present data on a page using a variety of different types of chart in Boomi Flow.
Learn more