Location Connection for Greenplum
This section describes the connection details required for creating Greenplum location in Fivetran HVR. For information about the pre-requisites, access privileges, and other configuration requirements for creating Greenplum location, see Greenplum Requirements.
If the managed secrets feature is enabled, option USE TOKEN INSTEAD is displayed in the fields designated for entering secrets.
| Field | Description | Equivalent Location Property |
|---|---|---|
| HOST | Hostname or IP-address of the server on which the Greenplum database is running. Example: gp430 | Database_Host |
| PORT | Port number on which the Greenplum server is expecting connections. Example: 5432 | Database_Port |
| DATABASE | Name of the Greenplum database. Example: sfdec02 | Database_Name |
| USER | Username for connecting HVR to the Greenplum database. Example: hvruser | Database_User |
| PASSWORD | Password for the USER. | Database_Password |
Advanced Settings
| Field | Description | Equivalent Location Property |
|---|---|---|
| LINUX / UNIX ODBC DRIVER MANAGER LIBRARY PATH | Directory path where the ODBC Driver Manager Library is installed. This field is applicable only for Linux/Unix operating system. For a default installation, the ODBC Driver Manager Library is available at /usr/lib64 and does not need to be specified. However, when UnixODBC is installed in for example /opt/unixodbc the value for this field would be /opt/unixodbc/lib. | ODBC_DM_Lib_Path |
| LINUX / UNIX ODBCINST | Directory path where the odbcinst.ini file is located. This field is applicable only for Linux/Unix operating system. Example: /opt/Progress/DataDirect/Connect64_for_ODBC_71/odbcinst.ini | ODBC_Inst |
| ODBC DRIVER | Name of the user defined (installed) ODBC driver used for connecting HVR to the Greenplum database. | ODBC_Driver |
Staging
HVR supports staging for Greenplum location. For information about the location properties for staging, see Staging for Greenplum.