• 1 Minute to read
  • Dark


  • Dark

Article summary

Panoply is a cloud data platform that provides an integrated solution for data warehousing, data management, and analytics. It allows businesses to centralize their data from various sources, automate data processing, and analyze insights using popular analytics and BI tools.


  • You have created a Panoply project and a database.

Authorize Connection to Panoply

In Panoply

Get a JSON File from your Panoply account:

  1. In your Panoply account, go to the BI Connection section.
  2. Click on Send your service account JSON file to your email.
    Panoply - Get JSON file in Panoply
  3. Download the JSON file from your email.

In Dataddo

Add a new certificate and authorize your Panoply account in Dataddo.

  1. Go to the Certificates & Tokens page and click on Add Certificate.
  2. Select the Name of the certificate, choose RSA Private Key type, upload the JSON file and Save.
  3. In the Authorizers tab, click on Authorize New Service and choose Panoply.
  4. Select your certificate and Save.

Create a New Destination to Panoply

  1. Under the Destinations tab, click on the Create Destination button and select the destination from the list.
  2. Select your account from the drop-down menu.
  3. Select your Panoply project.
  4. Name your destination and click on Save to create your destination.
Need to authorize another connection?

Click on Add new Authorizer in drop-down menu during authorizer selection and follow the on-screen prompts. You can also go to the Authorizers page and click on Add New Service.

Create a Flow to Panoply

  1. Navigate to Flows and click on Create Flow.
  2. Click on Connect Your Data to add your source(s).
  3. Click on Connect Your Data Destination to add the destination.
  4. Choose the write mode and fill in the other required information.
  5. Check the Data Preview to see if your configuration is correct.
  6. Name your flow and click on Create Flow to finish the setup.

Was this article helpful?

What's Next