Drivetrain Integration Guide
  • INTEGRATION GUIDE
    • Integrate with Drivetrain
      • Accounting & ERP
        • Integrating with Certinia
        • Integrating with NetSuite
        • Integrating with QuickBooks
        • Integrating with Rillet
        • Integrating with Sage Intacct
        • Integrating with Tally
        • Integrating with Xero
        • Integrating with Zoho Books
      • BI
        • Integrating with Looker
        • Integrating with Tableau
      • Billing & Invoicing
        • Integrating with Chargebee
        • Integrating with Invoiced
        • Integrating with Maxio Chargify
        • Integrating with Maxio SaaSOptics
        • Integrating with Recurly
        • Integrating with Stripe
        • Integrating with Subscript
      • CRM
        • Integrating with Active Campaign
        • Integrating with HubSpot
        • Integrating with LeadSquared
        • Integrating with Outreach
        • Integrating with Pipedrive
        • Integrating with Salesforce
      • Customer Success
        • Integrating with ChurnZero
        • Integrating with Freshdesk
        • Integrating with Planhat
        • Integrating with Zendesk
      • Databases and Warehouses
        • Integrating with Azure SQL Server
        • Integrating with BigQuery
        • Integrating with Databricks
        • Integrating with Redshift
        • Integrating with S3
        • Integrating with Snowflake
        • Integrating with Snowflake (Small Datasets)
        • Integrating with Google Cloud Storage
        • Integrating with Postgres
      • HRIS & ATS
        • Integrating with ADP
        • Integrating with ADP Workforce Now (SFTP)
        • Integrating with Ashby
        • Integrating with BambooHR
        • Integrating with Darwinbox
        • Integrating with Deel
        • Integrating with Greenhouse
        • Integrating with Gusto
        • Integrating with HiBob
        • Integrating with Justworks
        • Integrating with Lever
        • Integrating with Namely
        • Integrating with Paylocity
        • Integrating with Personio
        • Integrating with Sapling
        • Integrating with UKG Pro
        • Integrating with Zenefits
      • Spreadsheets
        • Integrating with Airtable
        • Integrating with Google Drive
        • Integrating with Google Sheets
        • Integrating with Microsoft OneDrive
      • Others
        • Integrating with Brex
        • Integrating with Clari
        • Integrating with NetSuite (Role Based Access)
        • Integrating with Shopify
        • Integrating with Twilio
        • Integrating with Officevibe
        • Integrating with SFTP
        • Integrating with Drivetrain's SFTP
        • Setting up SSO
Powered by GitBook
On this page
  • Prerequisites
  • Setup Instructions
  • Step 1: Choose connection method
  • Step 2: Complete Drivetrain configuration
  • Appendix: Firewall Settings/IP Whitelisting

Was this helpful?

  1. INTEGRATION GUIDE
  2. Integrate with Drivetrain
  3. Databases and Warehouses

Integrating with Redshift

PreviousIntegrating with DatabricksNextIntegrating with S3

Last updated 2 months ago

Was this helpful?

Prerequisites

To connect Redshift to Drivetrain, you need the following:

  • Access to the AWS console

  • A Redshift cluster

  • SELECT access granted for the following tables:

    • PG_CLASS

    • PG_NAMESPACE

    • PG_DATABASE

    • STV_TBL_PERM

Setup Instructions

Step 1: Choose connection method

Connect directly

If you connect directly, create a rule in a security group that allows access to your Redshift instance and port from the IPs listed in the table below.

Connect using private networking

Configure your firewall and/or other access control systems to allow incoming connections to your host and port from IPs for your region (IPs listed below).

Step 2: Complete Drivetrain configuration

In Drivetrain, go to Data > New Data Source > Redshift > Connect and:

  1. Enter the Redshift cluster Host name.

  2. In the Port field, enter the port number for the corresponding host name.

  3. Enter the corresponding Database name.

  4. Enter the User name for the Redshift cluster.

  5. Enter the Password.

  6. Choose a Connection method: DIRECTLY or PRIVATE NETWORKING.

  7. Click Save and Test. Your Redshift connector is now connected!

Appendix: Firewall Settings/IP Whitelisting

Drivetrain uses Fivetran for the Redshift connection. Please configure your firewall and/or other access control systems to allow incoming connections to your host and port from these IPs for your region:

Geography
Region
IP Address (CIDR)
IP Addresses (Range)

US

us-east-1 (N. Virginia)

Default region

3.239.194.48/29

3.239.194.48 - 3.239.194.55

US

us-east-2 (Ohio)

3.145.219.16/29

3.145.219.16 - 3.145.219.23

US

us-west-2 (Oregon)

35.80.36.104/29

35.80.36.104 - 35.80.36.111

US

us-gov-west-1 (GovCloud US West)

3.30.186.152/29

3.30.186.152 - 3.30.186.159

Canada

ca-central-1 (Montréal)

Default region

3.99.193.224/29

3.99.193.224 - 3.99.193.231

EU

eu-west-1 (Dublin)

3.251.214.192/29

3.251.214.192 - 3.251.214.199

EU

eu-central-1 (Frankfurt)

Default region

3.67.81.32/29

3.67.81.32 - 3.67.81.39

Australia

ap-southeast-2 (Sydney)

Default region

3.26.88.224/29

3.26.88.224 - 3.26.88.231

UK

eu-west-2 (London)

Default region

18.168.224.40/29

18.168.224.40 - 18.168.224.47

India

ap-south-1 (Mumbai)

Default region

3.111.138.160/29

3.111.138.160 - 3.111.138.167

Singapore

ap-southeast-1 (Singapore)

Default region

18.143.203.104/29

18.143.203.104 - 18.143.203.111

Japan

ap-northeast-1 (Tokyo)

Default region

43.207.101.168/29

43.207.101.168 - 43.207.101.175

That’s it! Inform your Drivetrain customer success manager so that they can get started!

AWS PrivateLink allows VPCs and AWS-hosted or on-premises services to communicate with one another without exposing traffic to the public internet. PrivateLink is the most secure connection method. Learn more in .

AWS’ PrivateLink documentation
Prequisites
Setup Instructions
Step 1: Choose connection method
Step 2: Complete Drivetrain configuration
Appendix: Firewall Settings/IP Whitelisting
Page cover image