5.1.6.11. RedShift Setup

<< Click to Display Table of Contents >>

Navigation:  5. Detailed description of the Actions > 5.1. General Parameters used in many actions > 5.1.6. ODBC Connections >

5.1.6.11. RedShift Setup

 
The official link to download the Redshift ODBC drivers is here:

https://docs.aws.amazon.com/redshift/latest/mgmt/configure-odbc-connection.html#install-odbc-driver-windows

 

For your convenience, a copy of the ODBC drivers is here:

http://download.timi.eu/ODBC/ODBC_drivers_Redshift/

 

The Redshift ODBC driver can execute “Select” SQL statement but not “Insert” or “update” statements. If you need to “insert” rows inside a RedShift database, you should use the special Action named “RedShift Bulk Upload” described in section 5.24.2.

 

By default, you can only access a Redshift database from a limited set of machines hosted inside the AWS network. You will need to manually configure Redshift to be able to access it from a machine located outside AWS. This manual configuration is in two steps:
 

 

1.Make Redshift Publicly accessible:

 

1.1. Open the Amazon console: https://console.aws.amazon.com and login into AWS.

 

1.2. Type “redshift” inside the search bar number1 and click on “Redshift” in the results number2:

 

clip2032

 

 

1.3.Click on “View all Clusters”:

 

clip2033

 
 

1.4.Check the “checkbox” in front of the redshift instance that you want to access with Anatella number1, then click on the “Actions” button number2, then click on the “Modify publicly accessible setting” option number3. In the screenshot below this option is grayed-out. This is because the creation of the redshift-cluster is not complete.

 

clip2034

 

 

1.5.Wait until your redshift-cluster is with the “available” status. This can take up to half an hour. When the status of your redshift-cluster is marked as “available”, you should be able to see the “Actions” menu that is not grayed-out. If that’s not the case (i.e. the “Actions” menu is still grayed out), you just need to wait a little bit more (up to half an hour! Regularly press F5 to refresh the page). Inside the “Actions” menu, select the “Modify publicly accessible setting” option.

 

clip2035

 
 

1.6.Select “Enable” number1 and click on the “Save Changes” button at the bottom number2 :

 

clip2036
 

1.7.You should now see the “Global dashboard” related to your Redshift instance.
 

 

2.Open the firewall to access Redshift

 

2.1.Open the “Global dashboard” related to your Redshift instance (this should already be visible if you followed the previous steps) and click on the “Properties” tab:

 

clip2037

 
 

2.2.Scroll down to the “Network and security settings” section. Here, you should see that your Redshift is “Publicly accessible” (if that’s not the case, wait a little and refresh the webpage – press F5) : Check here: number1
 

Click on the link inside the “VPC security group” number2:

 

clip2038

 

 

2.3.Click on the “Inbound Rules” panel number1 and click on the “Edit Inbound Rules” button number2:

 

clip2039

 
 

2.4.Click on the “Add Rule” button number1: For the “Type” field, select “Redshift” number2 and for the “Source” Field, select “Anywhere-IPv4” number3. Click the “Save Rules” button at the bottom number4.

 

clip2040

 

 

2.5.You can now connect to Redshift wih Anatella from any machine.