Skip to content

Custom systems & APIs

OData connector for Microsoft Dynamics, Business Central and custom services

OData (Open Data Protocol) is an OASIS standard for REST APIs that describe their data in a $metadata document and accept standard query options such as $filter, $select, $expand and $apply. Microsoft Dynamics 365, Business Central, Dataverse and many custom line-of-business services publish OData endpoints. This page covers those services; SAP OData services are handled separately.

OData

Available now: Nexatron answers OData questions with user-level access that inherits your existing OData permissions.

Updated

Can Claude, ChatGPT or Copilot access OData data?

Yes. To connect Claude, ChatGPT or Copilot to OData, add Nexatron from Claude’s connector directory, or by its MCP server URL in ChatGPT and Copilot. Then connect it in Nexatron. Users sign in with their own OData account (or your SSO), and Nexatron inherits their existing permissions.

What OData data a question reads

$metadata (CSDL)
The service document that lists entity types, their properties, keys and data types, and annotations such as labels, which a question has to be mapped against.
Entity sets
Queryable collections such as salesOrders, customers, items or generalLedgerEntries in Business Central, or accounts and opportunities in Dataverse.
Navigation properties
Relationships between entity types, such as a sales order’s lines or customer, followed with $expand.
Query options
$filter, $select, $orderby, $top and $skip, plus $apply for groupby and aggregate where the service supports it, and server-driven paging through @odata.nextLink.
Functions and bound actions
Service-defined operations. Read-only functions may be useful for calculations, while actions change data and are excluded.

OData questions people ask

  • What were posted sales invoice amounts by customer posting group in Business Central last quarter?
  • Which items have inventory below their reorder point in the main location?
  • How many open opportunities in Dataverse have an estimated close date in the past, by owner?
  • What is the average days between order date and shipment date on sales orders this year?
  • Which vendors had general ledger entries over 50,000 in the travel expense account last month?

Who asks OData questions

Finance and operations users of Dynamics
Ledger, sales and inventory questions from Business Central or Finance and Operations entities, without building a Power BI report first.
Integration and IT teams
Exposing a custom OData service to questions in everyday language with the $filter and $expand shown for each answer.

How Nexatron connects to OData

API and sign-in
Depends on the service. Dynamics 365, Dataverse and Business Central OData endpoints use Microsoft Entra ID OAuth 2.0 for a signed-in user. Custom OData services commonly use OAuth 2.0 or basic authentication with per-user accounts.
User-level access
Users sign in with their own OData account (or your SSO), and Nexatron inherits their existing permissions. Users only see data they are already authorized to see.
Read-only
Questions only read OData; asking a question never changes OData data.
Setup
An administrator enables OData in Nexatron. Users link their own OData account, or sign in through your SSO, the first time they ask. Queries run in OData, with no warehouse to load.

OData in Claude’s connector directory

Nexatron is listed in Claude’s MCP connector directory, so a Claude user can add it without a custom server URL. Its hosted MCP server answers OData questions for Claude, ChatGPT and Microsoft Copilot with user-level access, and the same governed answer as the Nexatron app. It is Nexatron’s own server, not one published by the vendor.

  1. Connect OData to your Nexatron workspace.
  2. In Claude, add Nexatron from Claude’s connector directory. In ChatGPT or Copilot, add a custom MCP connector with Nexatron’s server URL.
  3. Sign in with your own Nexatron identity (OAuth 2.1), then ask your OData questions.

Server URL for a custom connector: https://api.nexatron.io/api/v1/mcp

OData questions and answers

Why do Microsoft and other ERP vendors publish OData endpoints?
Exposing business data over HTTP in a predictable way, so tools like Excel, Power BI and integration platforms can query any compliant service with the same syntax. Microsoft uses it widely across Dynamics 365 and Dataverse, and SAP uses it for S/4HANA and SuccessFactors APIs.
Does OData support aggregation?
OData v4 defines $apply with groupby and aggregate in the Data Aggregation extension, but not every service implements it. Where it is missing, Nexatron pages through filtered results and totals them, which is slower for large entity sets.
Are OData v2 services covered as well as v4?
OData v4 is the main target, since it is what Dynamics 365, Business Central and most current services publish. Older v2 services, common in SAP systems, are handled by Nexatron’s SAP connectors.
How is Business Central OData different from its API pages?
Business Central exposes both published web service pages over OData and the standard API v2.0 endpoints, which are also OData v4. The standard API endpoints have stable entity names across tenants, so they are preferred where they cover the question.