Openthebox connector

Use your Openthebox data for reporting, automation and AI.

Data Panda brings Openthebox data together with the data from the rest of your stack. From one place, we turn it into dashboards, automations, AI workflows and custom apps that keep every Belgian company record current without anyone opening the KBO website.

Data Panda Reporting Automation AI Apps
Openthebox
About Openthebox

The convenience layer over Belgian open business data.

Openthebox is a Belgian company-intelligence platform that consolidates the public registers a sales, finance or risk team would otherwise hit one by one: KBO/CBE for entity status and directors, the National Bank of Belgium for annual accounts, the Belgian Official Gazette for publications, and the UBO register for ultimate beneficial owners. The platform exposes that on three million Belgian company and person profiles through a web app, an API and scheduled data feeds, with a daily refresh cadence and named features like Spiderweb for ownership graphs, Benchmark for NACE-peer comparisons, and Notifications for monitoring lists.

The reason to pull Openthebox into a warehouse is that BE company data drifts the moment you stop looking. Directors change, NACE codes get reclassified, financials are filed, addresses move, a UBO changes nationality. Doing one-off lookups at KBO direct keeps a sales rep busy and leaves the CRM stale anyway. Wired to the warehouse next to HubSpot, Salesforce, Exact Online or Business Central, Openthebox becomes the always-on enrichment of every Belgian record the rest of the company uses, with the same identifier the bookkeeping team and the credit team already trust.

Ideas

What you can automate with Openthebox.

Pair with HubSpot

Enrich HubSpot companies with live KBO and NBB data

Every BE company in HubSpot gets the current KBO status, latest NBB financials, NACE code, registered address and UBO snapshot written back on the company record. Sales reps stop alt-tabbing to KBO before a call, and dead, dissolved or renamed entities are flagged in the same view as the open opportunities.

Pair with Salesforce

Keep Salesforce accounts current against the Belgian registers

Salesforce Account records for BE entities are kept in sync with KBO and NBB, including director changes, financial-health shifts and NACE reclassifications. Account owners get a Chatter alert when a watched account's status moves, so the next renewal or expansion talk happens with the latest filing in hand.

Pair with Exact Online

Validate Exact Online customers against KBO before invoicing

BE customers in Exact Online are checked against KBO at creation and on a rolling schedule. VAT number, registered name and active status are reconciled, mismatches surface for finance to fix, and dissolved entities cannot quietly stay on the customer master with open invoices behind them.

Pair with MS Dynamics 365 Business Central

Score Business Central customers on Belgian financial health

Each BE customer in Business Central gets an Openthebox financial-health score, equity trend and last-filed-accounts date next to the open AR. Credit limits move on filed evidence rather than gut feel, and the credit manager sees degrading customers before the receivable ages.

Pair with Octopus

Pre-fill Octopus customer creation from KBO

When an accountancy office on Octopus opens a new BE client, KBO and NBB data flow straight in: legal form, registered address, VAT status, NACE, directors and the latest filed accounts. The intake form turns into a confirmation step instead of a typing exercise, with the same identifier the office uses everywhere else.

Pair with Slack

Push KBO and UBO change alerts into Slack

Watched BE entities trigger a Slack message in the right channel when a KBO status, director, NACE code, financial filing or UBO changes. Sales hears about a name change before the bounce on the next email, finance hears about a dissolution before the next dunning run, and KYC sees a UBO shift the day it lands in the register.

Data model

Tables we make available.

These are the 33 tables we currently pull from Openthebox into your warehouse. Query them directly in SQL, join them to the rest of your stack, or build reports on top.

  • Companies
  • Company Accountant Companies
  • Company Accountant Company Relationships
  • Company Administered Companies
  • Company Administered Relationships
  • Company Administrator Companies
  • Company Administrator Company Relationships
  • Company Administrator Person Relationships
  • Company Administrator Persons
  • Company Annual Account Consolidations
  • Company Annual Accounts
  • Company Annual Accounts Most Recent
  • Company Cohabiting Companies
  • Company Cohabiting Company Relationships
  • Company Cohabiting Person Relationships
  • Company Cohabiting Persons
  • Company Direct Connection Local Political Mandate Persons
  • Company Direct Connection Local Political Mandate Relationships
  • Company Direct Connection Other Mandate Persons
  • Company Direct Connection Other Mandate Relationships
  • Company Direct Connection Parent Companies
  • Company Direct Connection Parent Relationships
  • Company Direct Connection Participator Companies
  • Company Direct Connection Participator Company Relationships
  • Company Direct Connection Participator Person Relationships
  • Company Direct Connection Participator Persons
  • Company Direct Connection Subsidiary Relationships
  • Company Establishments
  • Company Financial Overview
  • Company Participation Companies
  • Company Participation Relationships
  • Company Publications
  • Company Subsidiary Companies

Missing a table you need? We can extend the sync. Tell us what is missing and we will build it for you.

Your existing tools

Your data lands in a warehouse. Your BI tools read from it.

You keep the reporting tool you already have. We connect it to the warehouse where your Openthebox data lives.

Power BI logo
Power BI Microsoft
Microsoft Fabric logo
Fabric Microsoft
Snowflake logo
Snowflake Data warehouse
Google BigQuery logo
BigQuery Google
Tableau logo
Tableau Visualisation
Microsoft Excel logo
Excel Sheets & pivots
Three steps

From Openthebox to answers in three steps.

01

Connect securely

OAuth authentication. Read-only by default. We sign a DPA and your admin keeps the keys.

02

Land in your warehouse

Data flows into your warehouse on your schedule. Near real time or nightly, your call. You own the data.

03

Reporting, automation, AI

We build the first dashboard, workflow or AI feature with you, then hand over the keys. Or we stay on for ongoing delivery.

Two ways to work with us

Pick the track that fits how you work.

Track 01

Self-serve

We set up the foundation. Your team builds on top.

  • Openthebox connector configured and running
  • Warehouse set up in your cloud account
  • Clean access for your Power BI, Fabric or Tableau team
  • Documentation on what's in the data model
  • Sync monitoring so you're warned before reports break

Best fit Teams that already have a BI analyst or data engineer and want to own the build.

Track 02

Done for you

We build the whole thing, end to end.

  • Everything in Self-serve
  • Dashboards built to the questions your team actually asks
  • Automations between your systems
  • AI workflows scoped to real tasks your team runs
  • Custom apps where a dashboard does not cut it
  • Ongoing delivery at a pace that fits your team

Best fit Teams without in-house BI or dev capacity. You tell us what you need and we deliver it.

Before you book

Frequently asked questions.

Who owns the data?

You do. It lands in your warehouse, on your cloud account. We don't resell or aggregate it. If you stop working with us, the warehouse stays yours and keeps running.

How fresh is the data?

Near real time for most operational systems. For heavier sources we schedule hourly or nightly. You pick based on what the reports need.

Do I need a warehouse already?

No. If you don't have one, we help you pick one and set it up as part of the first delivery. Common starting points are Snowflake, Microsoft Fabric, or a small Postgres start.

GDPR-compliant
Data stays in the EU
You own the warehouse

A first deliverable live in four to six weeks.

We review your Openthebox setup and the systems around it. Together we pick the first thing worth building.