You can transfer data from your Pigment Views, Lists, Metrics, and Tables to Fivetran with our REST API.
First, you export your data from Pigment to your cloud server, for example Google Cloud Storage, Microsoft Azure, or Amazon Web Services. Next, you export your data from your selected cloud server to your Fivetran destination.
Recommended reading
In case you need it, we’ve compiled some useful background information for you:
Before you begin
Before you start your export, we recommend that you complete the following tasks in Fivetran and Pigment.
FiveTran
- Verify access to your Fivetran account
- Consult with your Fivetran admin
You may need to obtain permissions and information to successfully complete your export.
Pigment
Only Pigment members with the account type Workspace Admin or Security Admin can access the Access API key management page and manage API keys.
- Obtain your export API key. This is explained in Manage API Keys.
- Obtain your View ID. This is explained in How to export data from Pigment with APIs.
- Obtain your List, Metric, or Table IDs. This is explained in Export raw data from a Pigment Block.
Export Pigment data to your cloud platform
To export your Pigment data to your required cloud platform, take a look at the information below:
- Export Pigment data to Amazon S3
- Export Pigment data to Google Cloud Storage
- Export Pigment data to Microsoft Azure
Export Pigment data from your cloud platform to Fivetran
To export your Pigment data from your cloud platform to Fivetran, take a look at the information below:
- Create a destination for your data.
For more information, check out the Fivetran documentation here.
Select your data’s destination - Select your required cloud platform.
Select your cloud platform - Complete your setup.
This is described in the Fivetran documentation below: