Configure in Redshift

1. For Simon Data to integrate with Amazon Redshift, create a user and password via the CREATE USER command in Amazon Redshift that Simon Data can use to connect:

   create user simondata password '<password here>'

2. Grant Simon select privileges on the appropriate table, schema, or database that we will need to extract from:

   grant select on <table/schema/db> <name of table/schema/db> to simondata

Configure in Simon

1. As an admin, expand Admin Center then click Integrations.
2. Scroll down to Redshift.
3. Click Add.
4. Enter your host, port, database, user (the username you created specific to Simon in Redshift itself), and password.
5. Click Save Changes

Successful connections display Connected in Green.

Allow list

Allow Simon Data's public IP addresses in any firewalls or systems that may block our access. See the complete list at Simon Data Public IP Addresses.

US East

18.211.16.116
35.173.87.106
52.7.12.28
54.152.155.89
54.165.60.44
54.165.74.55
54.174.71.70

EU West

34.253.138.241
54.76.115.255
54.77.27.229
54.228.48.108

Troubleshooting