Connecting ETL Tools

Connecting ETL Tools

Panoply works with several partners to provide additional data sources beyond those built into the Panoply Platform. Panoply is compatible with any data connector or ETL tool that uses a standard ODBC/JDBC connection, Postgres connection, or AWS Redshift connection. You can find a list of many of these ETL tools in the ETL section of the Data Integration listings. You can also find on our data integrations page a list of all the Partner Data Sources that are from one of our Premier ETL Partners. Chat with us anytime to learn more about Partner Data Sources and to get them setup in your account.

Read more about:

Connecting Stitch

  1. In the left pane of your Panoply Dashboard, click connect. This will display your Panoply data warehouse’s connection details, which should look like the image below.
  2. Copy your host, port, database name and username.
  3. Sign in to 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 connect section into its corresponding field on Stitch:
    • Host (Endpoint): The host name you received from Panoply (db.panoply.io)
    • Port: The Port number you received from Panoply (5439)
    • Username: The username you set for your Panoply account
    • Password: The password you use to log into Panoply
    • Database: The name of the Panoply database you would like to load data into (be sure to specify the correct db name if you have multiple dbs attached to your account)

Connecting Fivetran

  1. In the left pane of your Panoply Dashboard, click connect. This will display your Panoply data warehouse’s connection details, which should look like the image below.
  2. Copy your host, port, database name and username.
  3. Sign in to your Fivetran account.
  4. Pause all integrations in the Fivetran dashboard.
  5. Go to your account page and click +WAREHOUSE
  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 hostname (db.panoply.io), your Panoply username, the password associated with your Panoply account, and the Database you want to use Fivetran to load data into.
  8. After you have entered your connection details, click SAVE & TEST at the bottom of the screen. If the test is successful, you should see a green box at the bottom of the screen with the message “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.
Getting started is easy! Get all your data in one place in minutes.
Try Free