Move Picqer data anywhere it matters.

Load Picqer customers, products and products stock into the warehouse or AI app you already run.

Sync Picqer free Read the docs

Source

Picqer

Snowflake
BigQuery
Postgres
Databricks
Claude

Streams: 15
Incremental streams: 6
Destinations: 50+
Standard support: 0.0.72

Overview

What is the Airbyte Picqer connector?

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

01
Sync to your warehouse
Land 15 Picqer 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 Picqer once and Airbyte keeps every scheduled sync running on it.
04
Cloud or self-hosted
Run the Picqer connector on Cloud, OSS, Hybrid.

15 streams

Every table you can sync from Picqer

customers
Primary key idcustomer
Pagination DefaultPaginator
Sync modes FullIncr.
productsIncremental
Primary key idproduct
Pagination DefaultPaginator
Sync modes FullIncr.
products_stock
Pagination DefaultPaginator
Sync modes FullIncr.
ordersIncremental
Primary key idorder
Pagination DefaultPaginator
Sync modes FullIncr.
backordersIncremental
Primary key idbackorder
Pagination DefaultPaginator
Sync modes FullIncr.
returnsIncremental
Primary key idreturn
Pagination DefaultPaginator
Sync modes FullIncr.

customers
Primary key	idcustomer
Pagination	DefaultPaginator
Sync modes	FullIncr.

productsIncremental
Primary key	idproduct
Pagination	DefaultPaginator
Sync modes	FullIncr.

products_stock
Pagination	DefaultPaginator
Sync modes	FullIncr.

ordersIncremental
Primary key	idorder
Pagination	DefaultPaginator
Sync modes	FullIncr.

backordersIncremental
Primary key	idbackorder
Pagination	DefaultPaginator
Sync modes	FullIncr.

returnsIncremental
Primary key	idreturn
Pagination	DefaultPaginator
Sync modes	FullIncr.

Setup

Live in three steps

Get your Picqer 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

Picqer configuration fields
Field	Type	Description
organization_name*	string	The organization name which is used to login to picqer
start_date*	string	Not documented.
username*	string	Not documented.
password	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

Picqer connector questions

What data can I sync from Picqer with Airbyte?

15 streams, including customers, products, products stock, orders, backorders, returns, purchaseorders, locations and more.

Does the Picqer connector support incremental sync?

Yes. products, orders, backorders, returns and others support incremental sync, and every documented stream supports full refresh.

Where can I run the Picqer connector?

Run the Picqer 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