Skip to main content

From
to

DuckDB extensions for SAP, Microsoft 365, Dynamics 365, and beyond

🏢

ERPL

On-Premise SAP

Reach SAP ECC and S/4HANA systems behind the firewall via RFC.

RFCBICSODP
terminalInstallation
INSTALL 'erpl' FROM 'http://get.erpl.io';
LOAD 'erpl';
Install ERPL
☁️

ERPL-Web

Cloud & Enterprise SaaS

One extension for SAP cloud, Microsoft 365, Dynamics 365, and Delta Sharing.

SAP CloudM365Dyn365Delta
terminalInstallation
INSTALL 'erpl_web' FROM 'http://get.erpl.io';
LOAD 'erpl_web';
Install ERPL-Web
🤖

ERPL-ADT

AI Toolkit for ABAP

A CLI and MCP server for the SAP ADT REST API — give your AI agents ABAP.

CLIMCPADT
terminalInstallation
# Try without installing
uvx erpl-adt --help

# Or install permanently
pip install erpl-adt
Meet ERPL-ADT

One DuckDB, every enterprise system

Four ecosystems, one extension family — read, write, attach, and replicate from SQL.

🏢

SAP

ECC, S/4HANA, BW, Datasphere, SAC, and ABAP

RFC (Remote Function Call)

RFC (Remote Function Call)

Read SAP tables or call any RFC function module from DuckDB SQL — KNA1, MARA, BAPI_*, custom Z-modules, everything your system exposes.

ReadDiscover
BICS (BI Consumer Services)

BICS (BI Consumer Services)

Execute SAP BW queries end-to-end: filter variables, drill characteristics, pull key figures, and trace lineage from BEx back to the source cube.

ReadDiscover
ODP — Operational Data Provisioning

ODP — Operational Data Provisioning

Delta and full extraction with native subscription management across every ODP context: BW, SAPI, ABAP CDS, and classic extractors.

ReadCDC
SAP Datasphere

SAP Datasphere

First-class Datasphere integration. OAuth2 secrets, discover spaces and assets, query both relational and analytical models with metric/dimension pushdown.

ReadDiscover
SAP Analytics Cloud

SAP Analytics Cloud

Read SAC models, stories, and planning data with full metadata. ATTACH ... TYPE sac for catalog-style access to your analytics layer.

ReadATTACH
ABAP via ERPL-ADT

ABAP via ERPL-ADT

A CLI and MCP server for the SAP ADT REST API. Search ABAP objects, read source, run unit tests, and let AI coding agents write and activate fixes back to SAP.

ReadWrite
🅼

Microsoft 365

SharePoint, Excel, Teams, Outlook, Planner, Entra ID

SharePoint Lists

SharePoint Lists

Query SharePoint lists like SQL tables — typed columns, predicate pushdown, and full create / update / delete support. ATTACH ... TYPE sharepoint_lists for catalog-style access.

ReadWriteATTACH
Excel Workbooks

Excel Workbooks

Read and write Excel tables and ranges in OneDrive / SharePoint. ATTACH a workbook by site and file name — no GUIDs needed.

ReadWriteATTACH
Microsoft Teams

Microsoft Teams

Pull team rosters, channels, and channel messages by their human-readable names. Analyze collaboration patterns without leaving SQL.

ReadDiscover
Outlook (Mail, Calendar, Contacts)

Outlook (Mail, Calendar, Contacts)

The complete Outlook trio — emails, calendar events, and contacts — with folder pagination and lazy streaming for tenant-scale reads.

Read
Microsoft Planner

Microsoft Planner

Read plans, buckets, and tasks. Bulk-create tasks with lateral joins and resolve bucket names automatically — perfect for backfilling work from a CSV.

ReadWrite
Entra ID (Azure AD)

Entra ID (Azure AD)

Query users and sign-in logs through Microsoft Graph. Audit access, build user dashboards, or join identities against your SAP master data.

Read
🧩

Microsoft Dynamics 365

Business Central and Dataverse / CRM

Business Central

Business Central

ATTACH ... TYPE business_central turns a BC company into a DuckDB catalog. Companies by name, entities as tables, predicate and $expand pushdown.

ReadATTACH
Dataverse / Dynamics CRM

Dataverse / Dynamics CRM

Read accounts, contacts, opportunities, and custom entities. Full $expand support for related records and predicate pushdown for fast scans.

Read
🔗

Open Standards & Cloud

HTTP, OData, and Delta Sharing

HTTP & REST

HTTP & REST

Call any HTTP API from SQL — GET, POST, PUT, PATCH, DELETE with headers, basic/bearer auth, and automatic character-set detection.

ReadWrite
OData V2 / V4

OData V2 / V4

Universal OData reader with auto version detection, ATTACH support, and predicate pushdown on $filter / $select / $top / $skip.

ReadATTACH
Delta Sharing

Delta Sharing

Consume Delta Sharing feeds from Databricks, SAP, S3, or Azure — bearer-token profiles, schema discovery, and direct Parquet scan.

ReadDiscover

Real problems, solved across your enterprise stack

Load SAP ERP master data

Load SAP ERP master data

Pull customer master data from KNA1 and ADRC straight into DuckDB via RFC. Pair it with Google Cortex to spin up a reporting layer across many SAP tables in minutes — no staging area, no middleware.

See the example
Build a Microsoft 365 reporting layer

Build a Microsoft 365 reporting layer

ATTACH an Excel workbook by site name, read a SharePoint list of contracts, and join them against your SAP customers — all in one SQL query. Export the result to Parquet for your lakehouse.

M365 quick start
Sync Dynamics 365 Business Central

Sync Dynamics 365 Business Central

Turn a Business Central company into a DuckDB catalog with ATTACH ... TYPE business_central. Query items, vendors, and ledger entries directly — then COPY TO Parquet for downstream analytics.

Dynamics 365 docs

Built for Everyone, Supported for Enterprises

✨

ERPL Extensions are Free Forever for End Users

Use ERPL and ERPL-Web internally at any scale, for any purpose. No usage limits, no hidden fees, no vendor lock-in.

🚀

Enterprise Support & Consulting

Scale with confidence. Get expert help when you need it most.

What's Included:

  • ✓
    Architecture & Design

    Expert consultation on SAP integration patterns, data modeling, and pipeline architecture

  • ✓
    Implementation Support

    Hands-on help deploying ERPL for complex enterprise SAP landscapes

  • ✓
    Training & Enablement

    Custom workshops and training for your data engineering team

  • ✓
    Priority Support

    Direct access to engineering team with guaranteed response SLAs

Perfect for: Companies scaling ERPL in production, complex SAP architectures, mission-critical deployments
Schedule Consultation
💼

Commercial Licensing for Product Builders

Building a product on ERPL? Let's partner on your success.

Our Approach:

  • ✓
    Fair Share Model

    We believe in mutual success—get the licensing terms that work for your business

  • ✓
    Flexible Licensing

    Revenue share, per-seat, or custom arrangements—we adapt to your model

  • ✓
    Partnership Benefits

    Priority feature requests, dedicated support, and go-to-market collaboration

  • ✓
    Legal Clarity

    Clear licensing terms under BSL, with straightforward commercial agreements

Required for: SaaS products embedding ERPL, commercial products using ERPL as core infrastructure, redistributing ERPL as part of your offering
Discuss Licensing

Questions about licensing? If you're using ERPL internally (even at enterprise scale), building open source projects, or creating free tools—you don't need a commercial license. Only companies building commercial products on top of ERPL need licensing terms.

Ready to unify your enterprise data in DuckDB?

Install the extensions today and query SAP, Microsoft 365, and Dynamics 365 with one SQL engine.

Install NowSchedule a Demo
10+
Enterprise Systems
100+
Production Users
60+
SQL Functions