Move Pennylane data anywhere it matters.

Stream Pennylane supplier invoices, suppliers and plan items to any warehouse or AI app.

Sync Pennylane free Read the docs

Source

Pennylane

Snowflake
BigQuery
Postgres
Databricks
Claude

Streams: 9
Incremental streams: 8
Destinations: 50+
Standard support: 0.3.50

Overview

What is the Airbyte Pennylane connector?

The Airbyte Pennylane connector extracts data from Pennylane and loads it into 50+ destinations such as Snowflake, BigQuery, Databricks or Postgres, with full refresh and incremental sync. It publishes 9 streams you can select per connection.

01
Sync to your warehouse
Land 9 Pennylane tables in 50+ destinations on a schedule you control.
02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
03
One authorization
Authenticate Pennylane once and Airbyte keeps every scheduled sync running on it.
04
Cloud or self-hosted
Run the Pennylane connector on Cloud, OSS, Hybrid.

9 streams

Every table you can sync from Pennylane

supplier_invoicesIncremental
Primary key id
Pagination DefaultPaginator
Sync modes FullIncr.
suppliersIncremental
Primary key source_id
Pagination DefaultPaginator
Sync modes FullIncr.
plan_items
Primary key number
Pagination DefaultPaginator
Sync modes FullIncr.
customersIncremental
Primary key source_id
Pagination DefaultPaginator
Sync modes FullIncr.
customer_invoicesIncremental
Primary key id
Pagination DefaultPaginator
Sync modes FullIncr.
customer_estimatesIncremental
Primary key id
Pagination DefaultPaginator
Sync modes FullIncr.

supplier_invoicesIncremental
Primary key	id
Pagination	DefaultPaginator
Sync modes	FullIncr.

suppliersIncremental
Primary key	source_id
Pagination	DefaultPaginator
Sync modes	FullIncr.

plan_items
Primary key	number
Pagination	DefaultPaginator
Sync modes	FullIncr.

customersIncremental
Primary key	source_id
Pagination	DefaultPaginator
Sync modes	FullIncr.

customer_invoicesIncremental
Primary key	id
Pagination	DefaultPaginator
Sync modes	FullIncr.

customer_estimatesIncremental
Primary key	id
Pagination	DefaultPaginator
Sync modes	FullIncr.

Setup

Live in three steps

Get your Pennylane credentials from the vendor dashboard or developer settings.
Configure the source in Airbyte with the required connection fields.
Pick a destination, choose streams, set full refresh or incremental, and schedule syncs.

Configuration fields

Pennylane configuration fields
Field	Type	Description
api_key*	string	Not documented.
start_time*	string	Not documented.

Hybrid deployment

Sovereign by architecture, not by policy.

The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.

Cloud
OSS
Hybrid

Your environment

DataConnectorsCredentialsKeys

↕ metadata only

Airbyte control plane

OrchestrationMonitoringUI

FAQ

Pennylane connector questions

What data can I sync from Pennylane with Airbyte?

9 streams: supplier invoices, suppliers, plan items, customers, customer invoices, customer estimates, products, category groups, categories.

Does the Pennylane connector support incremental sync?

Yes. supplier invoices, suppliers, customers, customer invoices and others support incremental sync, and every documented stream supports full refresh.

Where can I run the Pennylane connector?

Run the Pennylane connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.

Didn't find your answer? Talk to sales