Amazon Redshift Bedienungsanleitung PDF herunterladen (Seite 8)

Page 8

Connecting QlikView and Redshift

For demonstration purposes, and for the sake of brevity, the paper covers the ODBC connectors to access Redshift.

Nevertheless, the JDBC connection process is very similar.

Which drivers?

AWS recommends Postgres SQL drivers. Full installation instructions for these drivers are in the AWS Redshift

documentation. Both the ANSI and Unicode drivers have been tested to work with QlikView.

Amazon Documentation:

• Redshift Drivers

• ODBC Driver: Postgres ODBC Download

Configuring the connector

Start the “Data Sources (ODBC)” program in Windows (notice that both 32bit and 64bit have been tested but this

paper only covers steps for 64bit architecture, the 32bit are similar).

The following window should appear:

Highlight the PostgresSQL ANSI-Redshift data source and click on “Configure”.

1 2 3 4 5 6 7 8 9 10 11

Keine Kommentare

Amazon Redshift Bedienungsanleitung Seite 8