Amazon Redshift is a hosted data warehouse product, which is part of the larger cloud computing platform Amazon Web Services. It is built on top of technology from the massive parallel processing (MPP) data warehouse ParAccel by Actian. Redshift differs from Amazon's other hosted database offering Amazon RDS by being able to handle analytics workloads on large scale datasets stored by a column-oriented DBMS principle. To be able to handle large scale datasets Amazon is making use of massive parallel processing.
In principle Amazon Redshift is able to handle all connections from other applications based upon ODBC and JDBC connections. Amazon has listed a number of business intelligence tools as partners and tested tools.
- Actuate Corporation
- ClearStory Data
- Dundas Data Visualization
- Logi Analytics
- Looker (Software)
- Redrock BI
- SAS (software)
- Tableau Software
Not included in the list, though capable of connecting to Amazon Redshift, is Oracle Business Intelligence Suite Enterprise Edition and numerous other solutions that are capable of connecting to a database by making use of JDBC or ODBC
Data integration tools
An initial preview beta was released on November 2012 and a full release was made available on February 15, 2013.
- "Amazon Redshift: ParAccel in, costly appliances out". ZDNet. Retrieved 8 July 2013.
- Amazon Redshift cloud based data warehouse service, Johan Louwers.
- AWS Partner Network - Amazon Redshift Partners, Amazon.
- Using Non-Oracle, and Cloud-Hosted Databases with OBIEE 11g, Mark Rittman.
- "AWS Partner Network - Amazon Redshift Partners", Amazon.
- "Amazon Debuts Low-Cost, Big Data Warehousing". Information Week. Retrieved 8 July 2013.