Microsoft Business Central Connector
Microsoft Dynamics 365 Business Central is an all-in-one business management solution (ERP) designed to streamline business processes.
Microsoft Business CentralYour warehouseLive
Agent context over MCPSet up in minutes.
No code, no maintenance.
Microsoft Business Central
Data source
Microsoft Business Central in your warehouse.
Ready for your agents.
Microsoft Dynamics 365 Business Central is an all-in-one business management solution (ERP) designed to streamline business processes. Weld's Microsoft Business Central connector is fully managed: it extracts data from Microsoft Business Central, loads it into your warehouse, and keeps it in sync. The data lands in a clean, documented schema with agent context attached, so analysts can query it with SQL or dbt, and agents can query it over the Weld MCP server without guessing at tables or joins.
Microsoft Business Central data schema.
The map your agents read.
Every table, field and relationship Weld syncs from Microsoft Business Central is served to agents as context over MCP, so they pick the right tables and join on the right keys.
- tables
- 92
- fields
- 1,475
Microsoft Business Central models.
What the numbers mean.
Open-source SQL that turns the raw Microsoft Business Central tables into the reports people ask about. Deploy them in Weld and your agent queries the definitions, not guesses.
- General ledgerThe general ledger: every G/L entry with its account, category and company. Recreates the G/L Entries list (and the Detail Trial Balance report) in Business Central.grain: one row per G/L entry (company x entry number)
- Profit and loss by monthIncome statement by month, at account level with Business Central's account category (Income, Cost of Goods Sold, Expense) and subcategory alongside for roll-up in BI.grain: one row per company x month x account, income statement accounts only
- Receivables agingAccounts receivable aging at invoice level: every open posted sales invoice with a remaining amount, bucketed by days past due as of today.grain: one row per open sales invoice (company x invoice)
- Trial balance by monthTrial balance per month: for every company, account and month, the opening balance, the month's debits and credits, and the closing balance. Recreates Business Central's Trial Balance report (net change and balance at date) for each month end.grain: one row per company x month x account, from the company's first posting month to the current month (or the latest future-dated month), including months in which an account had no postings
Ask your agent.
It already knows Microsoft Business Central.
Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It reads the Microsoft Business Central context, finds the tables it needs and queries your warehouse.
- Agent contextMicrosoft Business Central tables, fields and joins
- QuerySQL against your warehouse
- OperateCheck, rerun and refresh syncs
How many customer rows do we have per tax_area? Use our Microsoft Business Central data.
Reading the Microsoft Business Central context first, so the query uses the right tables and keys.
Load Microsoft Business Central into any warehouse.
Set up in minutes, no code.
Microsoft Business Central to Amazon Redshift
Microsoft Business Central to Amazon Redshift Cluster
Microsoft Business Central to Amazon S3
Microsoft Business Central to Apache Iceberg
Microsoft Business Central to Azure SQL Database
Azure Synapse
Microsoft Business Central to ClickHouse- Microsoft Business Central to Databricks
- Microsoft Business Central to Google BigQuery
Everything you need.
To get started.
Microsoft Business Central setup guide
Step-by-step instructions to configure and start syncing.
MCP serverConnect your agents
Set up Claude, Cursor, ChatGPT or Codex against your Weld workspace.
Weld Connect APIBuild custom connectors
Use the Weld Connect API to build and publish your own connector.
FAQCommon questions
Answers to frequently asked questions about Weld connectors.
Set it up in code.
One REST API.
Use the Weld Connect REST API to create Microsoft Business Central connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.
▌Common questions.
About connectors.
Put your Microsoft Business Central data to work.
Connect Microsoft Business Central, pick a warehouse, and your agents can query it today. Free for 14 days, no credit card.
Source
