Magento Business Intelligence Help Center

Setting up prerequisites for Amazon Redshift




Before you can set up your Amazon Redshift cluster, you’ll need to complete the following:

  1. Sign up for an Amazon Web Services (AWS) account
  2. Install a compatible SQL client (optional)


To sign up for an AWS account, click here or enter this URL in your browser:

Follow the instructions on the website to complete setting up your account.

SQL Client

Most SQL client tools with Amazon Redshift JDBC or ODBC drivers can connect to Amazon Redshift. After you create and launch your cluster, you'll use an SQL client to test the connection. For this reason, we recommend that installation and setup for your SQL client are complete before beginning the cluster creation process. 

We've put together a list of some compatible SQL clients. Click here to check it out.

For information regarding JDBC and ODBC drivers, refer to Amazon’s Configuring Connections in Redshift guide.

Note that this is optional for the tutorial - for the purposes of this tutorial, the SQL client is only used to test the connection. When connecting Redshift to the Private Data Warehouse (PDW), PDW will check and monitor the connection for any potential issues. Note that to actually query your data, you will need a compatible client

After you've completed the prerequisites, you can move on to creating and launching a cluster.

Was this article helpful?
0 out of 0 found this helpful


Powered by Zendesk