Location Connection for Redshift

This section describes the connection details required for creating Redshift location in Fivetran Local Data Processing. For information about the pre-requisites, access privileges, and other configuration requirements for creating Redshift location, see .

Field	Description	Equivalent Location Property
HOST	Hostname or IP-address of the server on which the Redshift database is running. Example: hvrcluster.ar.78ah9i45.eu-west-1.redshift.amazonaws.com
PORT	Port number on which the Redshift server is expecting connections. Example: 5439
DATABASE	Name of the Redshift database. Example: mytestdb
USER	Username for connecting Local Data Processing to the Redshift database. Example: hvruser
PASSWORD	Password for the USER.

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.
ODBCSYSINI	Directory path where the odbc.ini and odbcinst.ini files are located. This field is applicable only for Linux/Unix operating system. For a default installation, these files are available at /etc directory and do not need to be specified using this field. However, when UnixODBC is installed in for example /opt/unixodbc the value for this field would be /opt/unixodbc/etc. The odbcinst.ini file should contain information about the Amazon Redshift ODBC Driver under the heading [Amazon Redshift (x64)].
ODBC DRIVER	Name of the user defined (installed) ODBC driver used for connecting Local Data Processing to the Amazon Redshift clusters.

Staging

Local Data Processing supports staging for Redshift location. For information about the location properties for staging, see .