For using this destination you need a running Redshift instance and valid credentials. Furthermore your client computer has to be authorized to access the cluster.

For establishing a connection to Redshift a suitable database driver is required. Please download and install the 64 bit Amazon Redshift ODBC driver from here.

If the driver is missing the connection test will fail:

XU-fehlender-redshift-treiber

Prior to Xtract Universal version 2.102.0 you have to install the Mono.Security.dll assembly instead of above mentioned ODBC driver. You can download the complete Mono package from the official project site or from any source of your choice. Please make sure to install the Mono.Security assembly, compiled on .NET 2.0. Other versions could cause problems with the assemblies used for accessing the Redshift Database.

There are two ways for installing the assembly:

  1. Register the Mono.Security assembly in your global assembly cache (gac):
    • Open the command-line and browse to your Xtract Universal installation directory
      cd “C:\Program Files\XtractUniversal”
  • Install the Mono.Security.dll file to your global assembly cache using gacutil
    gacutil -i “C:\Program Files (x86)\Mono-2.0\lib\mono\2.0\Mono.Security.dll”

(For further information, please have a look at This article)

  1. Copy the Mono.Security.dll file into your Xtract Universal directory.