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
  • Connection Details
  • Server
  • Port
  • Username
  • Password
  • Database
  • Encryption
  1. Connections

Greenplum

PreviousDB2 zOSNextGoogle AlloyDB

Last updated 10 months ago

Connection Details

Server

Specify the hostname or IP address for the Greenplum database server. If it's running on the same machine as your client application, you can use localhost.

Port

The port number that the Greenplum service is listening on. The default port for Greenplum is 5432.

Username

The username for the database login. This should be a user that has the necessary permissions for the operations you intend to perform.

Password

Enter the password corresponding to the username provided.

Database

Use the 'Select' button to choose from a list of available databases or enter the name of the database you wish to connect to manually.

Encryption

Toggle between Not encrypted and Encrypted to determine whether the connection should use SSL. It is highly recommended to use Encrypted for transferring data securely, especially if connecting over an untrusted network.

Ensure that the users have the correct permissions to access the database and that the server information is accurate to prevent connection issues. Remind users to handle credentials securely and to use encryption whenever sensitive data is being transferred.