Follow our setup guide to connect Periscope to Fivetran.
Prerequisiteslink
To connect Periscope to Fivetran, you need the following:
- A Periscope account
- Permission to connect as an Admin user
- Fivetran role with the Create Destinations or Manage Destinations permissions
Setup instructionslink
Find standard JDBC connection detailslink
-
Log in to your Periscope warehouse.
-
Click Settings, then select Cluster Info.
-
In the Cluster Details section, find your connection details. Make a note of the details. You will need them to configure Fivetran.
Complete Fivetran configurationlink
- Log in to your Fivetran account.
- Go to the Manage Account page.
- In the Destinations tab, click +Destination.
- On the Add Destination To Fivetran page, enter a Destination Name of your choice.
- Click Add Destination.
- Select Periscope as the destination type.
- In the destination setup form, enter the Host name you found in Step 1.
- Enter the Port number you found in Step 1.
- Enter the User name you found in Step 1.
- Enter your Password.
- Enter the Database name you found in Step 1.
- Choose the Data processing location. Depending on the plan you are on and your selected cloud service provider, you may also need to choose a Cloud service provider and AWS region as described in our Destinations documentation.
- Choose your Timezone.
- Click Save & Test.
Fivetran tests and validates the Periscope connection. On successful completion of the setup tests, you can sync your data using Fivetran connectors to the Periscope destination.
Setup testslink
Fivetran performs the following Periscope connection tests:
- The Database Host Connection Test validates the database credentials you provided in the setup form. The test verifies that the host is not private and then checks the connectivity to the host.
- The Connection Test connects to your database instance and executes queries to check if we have the permissions to access the
information_schema
andpg_catalog
schemas.
NOTE: The tests may take a couple of minutes to finish running.
Related Contentlink
description Destination Overview
settings API Destination Configuration