---
title: "How to Connect Panoply"
slug: "panoply"
description: "Connect your data to Panoply with ELT & Dataddo. Learn how to set up a cloud data platform, create a JSON file, add a certificate & authorize a new service."
updated: 2023-10-31T09:52:43Z
published: 2023-10-31T09:52:43Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dataddo.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Panoply

**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.

## Prerequisites

          
          

- 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](https://cdn.document360.io/084ed225-3f99-4644-a2da-39ca0cd5ef45/Images/Documentation/Panoply%20-%20Get%20JSON%20file%20in%20Panoply.png)
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](https://app.dataddo.com/settings/security)** 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**](https://app.dataddo.com/service/new) 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**](https://app.dataddo.com/destinations) 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**](https://app.dataddo.com/service/new).

## Create a Flow to Panoply

1. Navigate to **Flows** and click on [**Create Flow**](https://app.dataddo.com/flow/new).
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](https://docs.dataddo.com/docs/data-storages#write-modes) 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.

---

## Related Articles

- [Data Backfilling to Storages](https://docs.dataddo.com/docs/data-backfilling-to-storages)
- [Write Modes](https://docs.dataddo.com/docs/data-storages#write-modes)
- [Implementation of Batch Ingestion to Data Warehouses](https://docs.dataddo.com/docs/ingestion-to-data-warehouses)
- [Network Access Control List (ACL) Configuration](https://docs.dataddo.com/docs/network-acl)
- [SSH Tunnelling](https://docs.dataddo.com/docs/ssh-tunnelling)
- [Data Transformations](https://docs.dataddo.com/docs/data-transformations)
- [Data Quality Firewall](https://docs.dataddo.com/docs/data-quality-firewall)