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. Download and install the 64 bit Amazon Redshift ODBC driver from the official website.

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 more information, see the article abot installing an assembly into the global assembly cache
  2. Copy the Mono.Security.dll file into your Xtract Universal directory.