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 any time to learn more about Partner Data Sources and to get them set up in your account.

Read more about:

Connecting Stitch

  1. In the Panoply navigation menu, click BI Connection. This displays your Panoply data warehouse’s connection details. 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 you 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 Panoply navigation menu, click BI Connection. This displays your Panoply data warehouse’s connection details. 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. Go to your account page 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.
Getting started is easy! Get all your data in one place in minutes.
Try Free