Connectivity between Connect and Amazon Redshift databases is established through the Amazon Redshift ODBC driver and, when loading, through multiple SSH connections.
Connect optimizes load performance to Amazon Redshift databases through the invocation of the Amazon Redshift COPY command.
Amazon Redshift ODBC driver installation
Windows systems
For Windows systems, ODBC driver installation includes the following:
Install and configure the Amazon Redshift ODBC 32-bit driver on Microsoft Windows operating systems.
When creating a system DSN entry for the ODBC connection, ensure the following settings on
the given dialogs:
- Amazon Redshift ODBC Driver DSN Setup dialog: Use Declare/Fetch is selected.
- Amazon Redshift Data Type Configuration dialog:
- Use Unicode is unselected.
- Show Boolean Column As String is unselected.
- Max Varchar (Default 255) is populated with the value 65530.
UNIX systems
For UNIX systems, ODBC driver installation includes the following:
- Install the Amazon Redshift ODBC 64-bit driver on Linux operating systems.
- Configure the ODBC Driver on Linux operating
systems.When using the unixODBC driver manager, override the standard threading settings in the ODBC section of odbcinst.ini as follows:
[ODBC] Threading = 1 - Update odbc.ini with the following name-value pairs:
UseDeclareFetch=1 UseUnicode=0 BoolsAsChar=0 MaxVarchar=65530