All Integrations
Celigo
x

Connect Celigo to Pigment and automate planning data flows

Move ERP actuals, CRM data, and other operational data into Pigment through the Celigo flows your integration team already runs. Send approved plan data back out the same way. It's built for IT teams who want planning on their existing integration platform, and for Finance leaders who want current numbers without manual exports.

Celigo

Celigo

Connect Celigo to Pigment to move planning data in and out through the flows your team already manages

Category

Middlewares

Integration method

Middleware

Best for

ERP actuals · Plan write-back · Integration governance

See documentation

Why connect Celigo with Pigment?

  • Plan on your existing integration platform. Teams already running Celigo connect Pigment to the flows they manage, with no separate integration tool for planning
  • Give Finance actuals without file handoffs. If NetSuite data already moves through Celigo, actuals reach the plan through those flows instead of a downloaded CSV
  • Keep planning data under IT governance. Data enters and leaves Pigment through flows and admin-issued API keys that your IT team controls
  • Reach sources Pigment doesn't connect natively. Celigo says it offers 1,000+ prebuilt connectors and templates, giving other systems a route into the plan

What can you do with Celigo and Pigment?

  • Start variance analysis on loaded actuals. A Celigo flow sends NetSuite actuals into Pigment, so FP&A compares actuals to plan without reformatting exports
  • Plan revenue and costs together. Finance leaders combine ERP and CRM data in one Pigment model, 2 use cases on Celigo's Pigment page
  • Feed BI dashboards from the plan. A flow exports a dedicated Pigment view to your BI tool, another use case Celigo lists for Pigment

How the Celigo integration works

Finance gets source-system data in Pigment without downloading and reuploading files, and IT manages every transfer in Celigo. Pigment's documentation lists Celigo as a middleware option and doesn't document a prebuilt Pigment connector. Celigo flows connect to Pigment's import and export APIs.

For imports, a flow uses an Import API key to push a CSV or trigger a saved import configuration. For write-back, a flow uses an Export API key to pull a view or raw Block data, then hands it to the target system. Celigo controls when each flow runs and how data maps into the destination; Pigment processes each request as it arrives.

Key capabilities

  • Separate import and export access. Each API key is either Import or Export, so each flow gets only the direction it needs
  • Define destinations in Pigment. The import configuration sets whether data lands in a List, Metric, or Table, so the flow just passes its ID
  • Push files or run saved imports. A flow can send a CSV in the request body or trigger an existing import configuration
  • Export the numbers planners see. View export returns a flattened CSV of a Metric, List, or Table view, with ISO 8601 dates available
  • Pull larger datasets by Scenario. Raw Block export returns more data than view export, without calculations applied, and adds Scenario and filter options
  • Confirm each load before Finance looks. Each import returns an ID, and a status call with a detailed report shows whether it succeeded

Frequently Asked Questions

What data can Celigo import into and export from Pigment?

Imports land in a List, Metric, or Table, as set by the import configuration the flow references. Exports cover Metric, List, and Table Blocks, either as a flattened CSV of a view or as raw Block data with Scenario and filter options. View exports use the default Scenario, and Pigment recommends a dedicated view for API export.

Can Celigo write Pigment plan data back to other systems?

Pigment's export APIs support this pattern: a flow pulls approved data from Pigment and sends it to the target system.

Does Finance need to work in Celigo to use this data in Pigment?

No. Finance works in Pigment, where imported data appears in the Lists, Metrics, and Tables that each import configuration targets. Your integration or IT team builds and runs the flows in Celigo, and Celigo says business users can handle day-to-day changes while IT keeps governance.

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