Omni Loader Docs
  • OVERVIEW
    • About
    • Getting Started
    • Databases
    • Performance considerations
    • Prerequisites
  • Project Wizard
    • General
    • Database List
    • Favorites
    • Review
  • Project types
    • Full Table Copy
    • Data Compare & Sync
    • Change Data Capture
    • Overview
  • Project Options
    • General
    • Performance
    • Databases
    • Mapping
    • Logging
    • Troubleshooting
  • Table Options
    • Columns
    • WHERE clause
    • Partitioning
    • Cut-off
    • Options Override
  • Global Settings
    • Overview
  • Automations
    • Overview
    • JSON job specification
  • Connections
    • Amazon RedShift
    • Analytics Platform System
    • Synapse Dedicated Pool
    • CockroachDB
    • CSV
    • Databricks
    • DB2 iSeries
    • DB2 LUW
    • DB2 zOS
    • Greenplum
    • Google AlloyDB
    • Google BigQuery
    • MariaDB
    • MySQL
    • Netezza
    • NuoDB
    • ODBC
    • Oracle
    • Parquet
    • PostgreSQL
    • Snowflake
    • Sybase ASE
    • Sybase IQ
    • SQL Server
    • Teradata
    • Vertica ODBC
    • Fabric Lakehouse
    • Fabric Warehouse
    • Azure SQL Database
    • V-ORDER Fabric Lakehouse Optimization
Powered by GitBook
On this page
  • Connecting to RedShift
  • Server
  • Port
  • Username
  • Password
  • Database
  1. Connections

Amazon RedShift

PreviousJSON job specificationNextAnalytics Platform System

Last updated 9 months ago

Connecting to RedShift

Server

Enter the endpoint of your Amazon Redshift cluster. This information is available in the Amazon Redshift console under the ‘Cluster’ section and typically follows the format examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com.

Port

Input the port number on which your Amazon Redshift cluster is listening. The default port for Amazon Redshift is 5439, but ensure to verify this from your cluster settings.

Username

Provide the username for the Redshift login credential. This should be a user with adequate permissions to perform data read operations across the necessary tables.

Password

Enter the corresponding password for the provided username. Ensure this password is kept secure and is only entered in secure environments to maintain the integrity of your data.

Database

Specify the name of the database within your Amazon Redshift cluster that you wish to connect to. This is the database from which the data will be extracted for migration.