Preparing the Amazon Redshift ODBC Environment

On Windows, the Amazon Redshift ODBC environment is set up during the installation of the Redshift ODBC driver. No additional setup steps are required.

On Linux:

After the Amazon Redshift ODBC driver is installed, make sure that path to the directory where the Redshift driver is installed is included in LD_LIBRARY_PATH (or in IBI_LIBPATH if the server is running with security on).
Note: The IBI_ variables can be set by entering the name=value pairs in the edaenv.cfg file. To edit edaenv.dfg, navigate to the Workspace page of the WebFOCUS Reporting Server browser interface, expand Configuration Files, then expand Miscellaneous, right-click Environment - edaenv.cfg, and click Edit.
For example:
```
IBI_LIBPATH=/opt/amazon/redshiftodbc/lib/64
```
Set variable AMAZONREDSHIFTODBC that points to the Linux driver manager initialization file with the setting DriverManagerEncoding=UTF-16 in it.
For example:
```
export AMAZONREDSHIFTODBC=/usr/odbc/ibiodbc/amazon.redshiftodbc.ini
```
Set IBI_LOAD_REDSHIFT_ODBC_DRIVER_FROM=path to save the DLL load path of the Redshift ODBC driver directory. For example:
```
IBI_LOAD_REDSHIFT_ODBC_DRIVER_FROM=path/amazon/redshiftodbc/lib/64
```

Did you find this helpful?

Yes No