Microsoft Dynamics 365 Business Central

Connect Microsoft Dynamics 365 Business Central to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.

Sync your Business Central customers, vendors, items, documents and general ledger entries into the PostHog Data warehouse.

Register an app in Microsoft Entra ID and grant it the API.ReadWrite.All application permission with admin consent, then add it as a Business Central user in the environment you want to sync. Enter that app's client ID and secret below, along with your Entra tenant ID and the environment name (usually production).

Every table except companies is synced for all companies in the environment, with the company ID kept on each row.

Configuration

Option	Type	Required
Microsoft Entra tenant ID	text	Yes
Environment name	text	Yes
Application (client) ID	text	Yes
Client secret	password	Yes

Linking Microsoft Dynamics 365 Business Central to PostHog

1. Go to the Data pipeline page in PostHog
2. Click New source and select Microsoft Dynamics 365 Business Central
3. Fill in the required configuration fields
4. Click Next, select the tables you want to sync, and then press Import