How to use ChatGPT with SAP Business ByDesign
Short answer
You can use ChatGPT with ByDesign in two ways: paste or upload exported reports for analysis, or give a custom GPT an action that calls a read-only custom OData service. The second needs an internet-reachable, authenticated endpoint, so most regulated teams front it with a gateway or choose a private model.
Many ByDesign users already have ChatGPT open in another tab. They export a sales report to Excel, paste it in, and ask for a summary or an explanation of a variance. It works, and for non-sensitive data it is a perfectly sensible start.
The harder question is the next step: can ChatGPT answer from live ByDesign data without anyone exporting anything? It can, if you publish a narrow read-only API for it, but that decision moves you from a personal convenience to a data governance topic with a named owner.
This page walks through the three levels, spreadsheet analysis, a custom GPT with an action, and a governed gateway, and explains where each one stops being a good idea.
What teams use it for
Explain a margin or cost variance
Export a product profitability or cost center report and ask ChatGPT to rank drivers and draft the commentary a controller would write.
Draft supplier and customer replies
Give it the facts of an overdue delivery or a disputed invoice and have it write a polite, precise message for a person to send.
Turn a business question into a report spec
Describe what you want to see and let it propose the data source, filters and columns to build in the Business Analytics work center.
Order status lookup via a custom GPT action
A sales coordinator asks about a customer order and the GPT calls a read-only endpoint that returns status, dates and delivery lines.
Excel formula and cleanup help
Use it for data prep when working with the ByDesign Excel add-in or when cleaning a migration file before upload.
SAP Business ByDesign integration surface
- Report exports from the Business Analytics work center to Excel or CSV. Quickest path, manual, and a snapshot only.
- Custom OData services created from analytics data sources, which return filtered JSON that a GPT action can describe in an OpenAPI schema.
- SOAP web services through communication arrangements. ChatGPT actions expect REST and OpenAPI, so SOAP needs a small translation layer.
- The SAP ByDesign add-in for Microsoft Excel for pulling data into a workbook you then share deliberately.
- Authentication options on the tenant side: basic authentication for a technical user or certificates. Custom GPT actions typically use API key or OAuth, so an intermediary usually holds the ByDesign credential.
How it works
- 1
Decide the data classification first
List which ByDesign data may leave your environment: pricing, customer names, employee data. This decides whether any hosted model is allowed.
- 2
Start with exported snapshots
Use ChatGPT Enterprise, Team or an API workspace where your organisation has agreed data-use terms. Avoid personal accounts for business data.
- 3
Build one read-only custom OData service
Define a data source with only the fields needed, for example order header, status, requested date and ship-to. Test it with a technical user in a browser or a REST client.
- 4
Put a thin gateway in front
The gateway holds the ByDesign credential, accepts a ChatGPT-side key, enforces rate limits and rejects any non-GET call.
- 5
Describe the endpoint as an OpenAPI action
Write short, unambiguous descriptions of each parameter so the model calls it correctly, and give it the instruction to quote the document ID in every answer.
- 6
Pilot with a small group and review logs
Look at what people actually ask. Tighten fields and add a second endpoint only for demonstrated needs.
Example flows
Variance commentary from an export
Trigger: A controller finishes a month-end cost report.
- Export the report with masked cost center names if required.
- Upload it to an approved ChatGPT workspace.
- Ask for the three largest variances and likely drivers.
- Edit the draft and paste into the management pack.
Result: Commentary that took an hour takes a few minutes, with the controller still owning the conclusion.
Customer order lookup through a custom GPT
Trigger: A salesperson asks, 'Where is order 10045 for this customer?'
- The GPT calls the gateway action with the order number.
- The gateway queries the custom OData service with the technical user.
- It returns status, confirmed date and delivery status only.
- The GPT replies in plain language and cites the order ID.
Result: A status answer without opening the ERP, and an access log of who asked what.
Keeping data on-prem
ChatGPT is a hosted service, so a fully on-prem posture means not sending ByDesign records to it. Teams with that requirement keep ChatGPT for non-sensitive drafting and use a private open-weight model for anything that touches order, price, supplier or employee data. ByDesign is cloud-hosted by SAP, so the private model runs in your network or sovereign cloud and calls the same custom OData services outbound. The gateway pattern stays the same, only the model endpoint changes, which makes it easy to start with ChatGPT and move later.
Security checklist
- Use an enterprise workspace with contractual data-use terms, not personal accounts.
- Expose only the fields the question needs; never an unrestricted data source.
- Keep the ByDesign credential in the gateway, never in the GPT configuration or instructions.
- Make the gateway read-only and log every call with the end user's identity.
- Review your tenant's data protection agreement with SAP and your provider's terms before connecting.
Ways to get it done
Manual export and upload
Effort: Minutes to start, no engineering.
Good for analysis and drafting on low-sensitivity data with a handful of users.
Custom GPT with a gateway you build
Effort: Days to a couple of weeks including security review.
Fits teams with a developer and a clear read-only use case.
Private model with the same gateway through Netray
Effort: A scoped pilot of a few weeks.
Fits regulated or defense-adjacent teams, or any who cannot send ERP data to a hosted model.
Pitfalls
- !Pasting full exports with personal or pricing data into a personal account.
- !Pointing the action straight at a SOAP service and expecting the model to handle envelopes.
- !Letting the GPT answer from memory when the action fails. Instruct it to say it cannot retrieve the data.
- !Over-broad data sources that return whole customer records when status was all that was needed.
- !Forgetting that a snapshot export is stale the moment it is made; label the extraction time in the prompt.
Frequently asked questions
Is there an official ChatGPT connector for SAP Business ByDesign?
I am not aware of an official one, and availability changes quickly, so check the current connector listings. The dependable route is a custom GPT action calling a read-only custom OData service through your own gateway.
Can ChatGPT write orders into ByDesign?
It could be wired to, but that is rarely wise. Keep the model read-only and, if you need writes, have it produce a draft that a person approves and a separate service posts.
Is it safe to upload a ByDesign export to ChatGPT?
That depends on your agreement with the provider and your own data policy. Business and enterprise plans typically offer stronger data controls than personal ones. Strip personal and pricing data if you are unsure.
Why not just use ChatGPT for everything?
For general drafting it is excellent. For regulated or contractually restricted data, you may be unable to send records to a hosted service at all, which is where a private model on your own infrastructure is the cleaner answer.
What does the gateway add?
It holds the ByDesign credential, restricts calls to read-only, applies rate limits and records who asked what. It also lets you swap ChatGPT for another model later without touching ByDesign.
More for SAP Business ByDesign
Want ChatGPT working on your SAP Business ByDesign?
A free 30 minute assessment: we map the integration path for your version and setup, and where it should run.
Get a free assessment