CONNECT TO AMAZON REDSHIFT

Upon successful logon you’ll be prompted to upload your AtScale license key. The URL to request a License key is http://info.atscale.com/request-license-product.

Next, it is an industry best practice to change your default password upon your first login. In this step you are prompted to change the admin account password.

Select Amazon Redshift for your Data Warehouse type.

Before you begin this section ensure that you have created a schema in your Redshift cluster. AtScale requires a schema to create and store aggregates tables. To distinguish between Data Warehouses, a unique name must be provided, then scroll down the page.

In the Host field, Specify your Redshift cluster endpoint for the Amazon Redshift cluster. You can find the endpoint displayed on the overview page for the cluster in your Redshift dashboard in the AWS console.

In the Database field, specify the name of the database that appears in the Cluster Database Properties section of the overview page for the cluster.

If you are using a non-standard port number for connections to your Amazon Redshift database, specify the port number in the Port field. The port number that you are using appears in the Cluster Database Properties section of the overview page for the cluster. The default port number is 5439.

Access to Amazon Redshift requires credentials that AWS can use to authenticate your requests.

Specify a Redshift Username with the combination of Access Key and Secret Key or by specifying the password. Use the radio button to select the preference of credentials.

Optional: Click Test Connection to check whether the connection parameters that you specified are valid.

The S3 Bucket Details are optional and only required if you plan on loading our sample data or use the file watcher feature.

Optional: Click Test Connection to check whether the connection parameters that you specified are valid

This Name of the environment specified will be displayed in the AtScale Design Center.

Specify Redshift for the data warehouse type.

Specify a port number. This port will be used in connections from SQL (ODBC /JDBC) clients only.

You must specify a port within the range allowed by the Security Group described in section AWS Marketplace 1-Click Launch settings.

Click Finish to complete the Initial Environment Set-up.