All Integrations
Fivetran
x

Connect Fivetran to Pigment and centralize planning data

Send planning and forecast data from Pigment to the data warehouse or data lake your team already manages with Fivetran, using Pigment’s Export API and your cloud storage. Keep planning data within your existing, governed data pipelines and give analysts access to the latest plans and forecasts directly in their BI and analytics tools.

Fivetran

Fivetran

Export Pigment planning data to cloud storage so Fivetran can load it into your Fivetran destination

Category

Middlewares

Integration method

Middleware

Best for

Data warehousing · BI reporting · Custom data pipelines

See documentation

What can you do with Fivetran and Pigment?

  • Publish the latest forecast to your warehouse. Export a dedicated forecast View from Pigment to cloud storage, and Fivetran loads it into the warehouse or lake your analysts query, so FP&A no longer emails files when reporting needs new numbers.
  • Report plan against actuals in BI. Land Pigment plan data next to the data Fivetran already moves from your other sources, then build variance reporting in your BI tool, so dashboards and plans use the same figures.
  • Share planning drivers with data teams. Export the Lists and Metrics behind your plan so data teams can use them in analytics, operations, and AI work.
  • Refresh downstream data on your cadence. Schedule exports with your cloud provider’s tools, such as an AWS Lambda function triggered by Amazon EventBridge, so new plan data reaches your destination on a regular schedule.

How the Fivetran integration works

The integration has two steps and runs through cloud storage rather than a direct connection between Pigment and Fivetran. First, Pigment’s REST export API sends a View, List, Metric, or Table as a CSV file to Amazon S3, Google Cloud Storage, or Microsoft Azure. Each export call authenticates with a Pigment export API key sent as a bearer token. Next, Fivetran picks up the files from that cloud storage and loads them into your Fivetran destination, using Fivetran’s setup guide for your storage provider. Data flows one way, out of Pigment.

Key capabilities

  • Export exactly the data you need. Target a View, List, Metric, or Table by its ID, and use a dedicated View for API export to control what leaves Pigment.
  • Use the cloud storage you already run. Stage exports in Amazon S3, Google Cloud Storage, or Microsoft Azure, so Pigment fits into the storage your data team already manages.
  • Limit who can grant export access. Only Workspace Admins and Security Admins can manage API keys in Pigment, so export access stays with named administrators.
  • Load files your pipeline can parse. Exports arrive as flattened, unformatted CSV, so downstream tools receive raw values instead of formatted reports.
  • Know which Scenario you're sending. Exports return the default Scenario unless you change the default items, so downstream reports reflect the version you expect.

Frequently Asked Questions

What Pigment data can I export to Fivetran?

You can export Views, Lists, Metrics, and Tables, using the ID of each item you want to send. Pigment recommends a dedicated View for API exports.

How is the connection authenticated, and who can set it up?

Each export call uses a Pigment export API key, sent as a bearer token. In Pigment, only a Workspace Admin or Security Admin can manage API keys, and you'll also need access to a Fivetran account. Check with your Fivetran admin about the permissions your setup requires.

Is there a limit on how often I can export data?

Yes. Pigment’s export API allows 500 requests per 5-minute window per IP address, so plan the frequency of scheduled exports around that limit.

Can Fivetran bring data into Pigment?

Not directly. Fivetran can load data from sources such as SAP into a warehouse like Google BigQuery, AWS Redshift, or Azure SQL, and Pigment imports it from there through its native connectors.

See Pigment in action

The fastest way to understand Pigment is to see it in action. Sign up today and explore how agentic AI can transform the way you plan.

Three colleagues focused on an iMac screen in a bright office with plants and modern artwork.

From 8 days to 4 min

Update P&L actuals & financial forecasting

80%

Time cut on data aggregation

12 hours

Saved per month on executive reporting

6 days faster

For scenarios creation and analysis