The following are links to the external software, products, documentation, and datafiles discussed in various sections of the book:
Amazon Redshift documentation: http://aws.amazon.com/documentation/redshift/
Amazon Redshift partners: http://aws.amazon.com/redshift/partners/
Client JDBC drivers: http://jdbc.postgresql.org/download/postgresql-8.4-703.jdbc4.jar
For 32 bit, use http://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_08_04_0200.zip
For 64 bit, use http://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_09_00_0101-x64.zip
Cloudberry Explorer – Amazon S3 file management utility: http://www.cloudberrylab.com/free-amazon-s3-explorer-cloudfront-IAM.aspx
The EMS software (SQL Manager Lite): http://www.sqlmanager.net/products/postgresql/manager
This is my query tool of choice, as I explained in Chapter 2, Transition to Redshift
Hapyrus: http://www.hapyrus.com/
Hapyrus (http://www.pentaho.com/) developed a product called FlyData to move data to Redshift Pentaho, a type of ETL/BI software
Perl: This scripting language, often used for file manipulation, is used in examples explained in Chapter 3, Loading Your Data to Redshift (for more information, see http://www.activestate.com/activeperl)
Python: The Python (www.python.org) interpreter is needed to run the command-line interface
SQL Workbench/J: A query tool recommended by Amazon; find it at http://www.sql-workbench.net/
S3 Fox: The Amazon S3 file management utility (http://www.s3fox.net/)
United States Census Data: Contains downloads for Chapter 3, Loading Your Data to Redshift datafiles (http://quickfacts.census.gov/qfd/download_data.html)