Connecting a Redshift Warehouse

Redshift

• Connecting Precog
• Connecting Stitch
• Connecting Fivetran

Connecting Precog

1. In the Panoply navigation menu, click BI Connection. This displays your Panoply data warehouse's connection details. 
2. Copy your database name and username.
3. Sign into your Precog account.
4. Click the Destinations.
5. Search for Panoply Redshift.
6. Click the Panoply icon.
7. Name the destination.
8. Enter your AWS S3 bucket name, access and secret keys and the bucket region
9. Enter the JDBC connection URL (replace dbname with your Panoply account name): jdbc:redshift://db.panoply.io:5439/dbname.
10. Enter the destination schema.
11. Enter your Panoply username and password.
12. Select Keys as the authorization type.
13. Re-enter your AWS access key, secret and the bucket's region.
14. Click on Add.
15. Select which tables you wish to connect to this destination.

Connecting Stitch

1. In the Panoply navigation menu, click BI Connection. This displays your Panoply data warehouse's connection details. 
2. Copy your host, port, database name, and user name.
3. Sign into your Stitch account.
4. Head to the destination tab and click the Panoply icon.
5. When prompted, enter the information you collected from the Panoply BI Connection section into the corresponding fields in Stitch:
   • Host (Endpoint): The host name you received from Panoply (db.panoply.io)
   • Port: The port number you received from Panoply (5439)
   • Username: The user name you set for your Panoply account
   • Password: The password you use to log into Panoply
   • Database: The name of the Panoply database to load data into (be sure to specify the correct database name if you have multiple databases attached to your account)

Connecting Fivetran

1. In the Panoply navigation menu, click BI Connection. This displays your Panoply data warehouse's connection details. 
2. Copy your host, database name, and user name.
3. Sign into your Fivetran account.
4. Pause all integrations in the Fivetran dashboard.
5. Login to your account page, navigate to your account and click the +WAREHOUSE button.

6. Under Select Warehouse, scroll down until you find Panoply.

7. Fivetran will automatically add Panoply's Port information, but you will need to enter Panoply's Host name (db.panoply.io), your Panoply User namme, the password associated with your Panoply account, and the Database you want to use Fivetran to load data into.

8. Click SAVE & TEST at the bottom of the screen. When the test is successful, a box at the bottom of the screen says "All connection tests passesd!"
9. Click VIEW WAREHOUSE. You should see the details of your Panoply warehouse in the next page. You can now load data into Panoply using Fivetran.