SAP Business One Reporting & Live Dashboards

No. The connection is read-only at the architecture level — the tooling issues queries and has no write path at all. Nothing is installed on the B1 server, no schema is altered, and no add-on is registered. If you removed us tomorrow, your ERP would be exactly as it is today.

It is the normal case and we build for it. The reporting layer runs inside your network, so database credentials and data never leave your premises. We do not require you to expose the ERP to the internet or copy your database to our infrastructure.

Yes, and this is usually where the value is. A single dashboard can read from SAP B1 alongside an operational MySQL or PostgreSQL database and a REST API from a third-party service. The questions that matter to a business rarely sit inside one system.

If it exposes a REST API we can issue a GET request against, or a MySQL or PostgreSQL database we can be given read-only access to, then yes. That covers most helpdesk, CRM and logistics tools, which publish REST APIs as standard. We confirm against the system's own API documentation before quoting.

Built-in reporting answers the questions the ERP anticipated. This answers yours — including the ones that need data the ERP does not hold. It is also live: dashboards read current data on every load rather than being generated and emailed on a schedule.

Not for the reporting layer. We work from a read-only connection and your team's description of what they need to see. Because nothing is installed on the ERP and nothing is modified, there is no change to validate against your SAP support arrangement.

Yours — and we would rather say so at the outset than have it surface later. SAP's licensing can cover more than the people who log into SAP directly: depending on your agreement, it may also cover people who consume SAP data through another system, which SAP refers to as indirect or digital access. A reporting layer built on your SAP Business One data can fall within that. We are not an SAP partner and cannot advise on your licence position, so please confirm with SAP or your SAP partner what your agreement permits before we connect anything. We will build to whatever answer you get, and we would rather scope the work around a clear answer than assume one.

No. AREA KPI Technology is an independent software company. We are not an SAP partner, reseller or certified implementation provider, and we neither sell nor licence nor support SAP software — if you need SAP licences or functional consulting, your SAP partner remains the right people for that. What we do is build reporting, dashboards and applications that read from the SAP Business One system you already own. SAP, SAP Business One and SAP HANA are trademarks of SAP SE, used here only to describe the systems we read from.

A read-only database user, scoped to the tables you want reported on. Nothing more. We do not ask for administrator credentials, we do not need write permissions, and we do not need access to the SAP application layer or its licensing. If your DBA prefers to restrict that user further, the reporting simply reflects whatever it can see.

Yes. There is a demo instance that runs without touching any of your data, so you can see the explorer and dashboards before any connection to your systems is discussed.