A build-to-order connector that publishes governed SAP Business One datasets straight into Looker Studio and Sheets, replacing hand-built CSV exports. Scoped, quoted and built for your company database. Built to order by ECOSIRE for SAP Business One (build-to-order) — indicative price from $499.00 USD; request a quote for a scoped proposal.
A build-to-order connector that publishes governed SAP Business One datasets straight into Looker Studio and Sheets, replacing hand-built CSV exports. Scoped, quoted and built for your company database.
Built to order
Somebody on your team exports a CSV from SAP Business One every Monday morning. They paste it into a spreadsheet, fix the date column, re-run a lookup against a second export, and refresh a dashboard that the leadership team looks at once. By Wednesday the numbers are stale. By the following Monday the person who built the spreadsheet is on leave and nobody else knows which query produced column K.
The deeper problem is that every consumer builds their own version of the truth. Sales pulls revenue one way, finance pulls it another, and the two never reconcile because one included credit notes and the other did not. The dashboard is only as trustworthy as an undocumented export chain, and the ERP has no record that any of it happened.
We build a connector that publishes defined SAP Business One datasets into Looker Studio and Sheets as live, refreshable data sources. Your reporting layer stops being a pile of exports and becomes a governed set of datasets that everyone reads from.
This is the important distinction. We do not expose your schema and leave analysts to guess join conditions. During scoping we agree the datasets you actually report on and build each one as a defined, documented model with named fields, correct grain and explicit business rules. Typical datasets:
Each dataset gets a data dictionary: field name, source table and column, calculation where it is derived, and grain. When two people disagree about a number, the dictionary settles it.
Looker Studio. We build a community connector so your datasets appear as native data sources: pick the dataset, pick fields, apply date ranges and filters, and build charts. Date parameters push down to the query rather than pulling everything and filtering in the browser, so a two-year dashboard does not drag your database. Aggregations and calculated fields defined in the dataset behave consistently across every report anyone builds.
Sheets. A bound add-on writes a dataset into a sheet range on demand or on a schedule, with parameters (date range, warehouse, Business Partner group) taken from named cells. Refresh replaces the range in place, so formulas, pivot tables and charts built on top of it survive. This is the honest answer for the finance analyst who genuinely needs a spreadsheet — it gives them one, fed from a governed dataset instead of a manual export.
The connector reads SAP Business One through the Service Layer (REST/OData), using the DI API where a specific object requires it. Where a dataset needs a shape the Service Layer does not express efficiently, we define it as a query or view inside your company database and expose it through the connector — read-only, parameterised, never string-concatenated from user input.
Dataset definitions, field mappings and refresh schedules live in UDTs, and a dataset registry is exposed as a UDO so adding a field or a new dataset is a configuration change your team can make and audit inside SAP Business One rather than a code deployment. UDFs you have already added to Business Partners, items or documents can be included in any dataset — a common request, since your custom fields are usually the ones the business actually reports on.
Access is scoped. A service account authenticates to SAP Business One, and the connector applies its own dataset-level and row-level rules on top: a regional manager's Looker Studio credentials can be restricted to their warehouses or their sales employee codes. Every request is logged with the requesting identity, dataset, parameters and row count, so you can see who pulled what.
The connector is read-only by design. It never writes to your company database. Where you also need a printed or e-mailed document, Crystal Reports remains the right tool and we will say so rather than pushing everything into a dashboard.
SAP Business One companies standardised on Google Workspace whose reporting currently runs on manual exports. It fits management teams who want a small number of dashboards they trust, finance analysts who need live spreadsheet data, and operations managers who want a warehouse or item view refreshed daily without asking IT.
It is not a replacement for a data warehouse if you need to blend SAP Business One with several other large source systems and keep years of history — we will tell you that during scoping rather than selling you a connector that will be outgrown. It is also not the answer if your reporting need is really a formatted, statutory document.
1. Scoping call. We work from the reports you actually use. Which questions get asked every week, which fields matter, which of your UDFs must appear, how you define a fiscal period and an ageing bucket, what your currency setup is, and whether you are on SQL Server or SAP HANA. We agree the dataset list and the grain of each.
2. Fixed quote. A written scope naming every dataset, its fields, its grain, the refresh model, the access rules, the timeline and a fixed price.
3. Build. Typical lead time is two to four weeks depending on how many datasets you take and how much derived logic they carry.
4. Install into your test company. Connector installed against a copy of your production company database. You connect from your own Looker Studio and Sheets accounts and reconcile each dataset against a report you already trust. That reconciliation is the acceptance test — a dataset is not done until its totals match a number you already believe.
5. Production install. Scheduled cutover with the service account, access scoping and refresh schedules configured. We repoint your verified dashboards at production.
6. Support window. A defect-fix window after go-live, with the length stated in your quote. Adding a field to an existing dataset afterwards is a UDT change your team can make; a genuinely new dataset is quoted as a small change.
Everything is delivered per tenant, for your company database, with source code, dataset definitions and the data dictionary handed over.
A short call to confirm the workflow, your platform version and where the integration boundaries sit.
You receive a written scope and a fixed price. Nothing is built until you approve it.
We develop against a copy of your configuration and test it there. Typically two to four weeks.
We install on your instance, hand over the source, and support it for twelve months.
Rebuilds the same export-and-paste routine every month and cannot explain to an auditor where a number came from. Gets governed datasets refreshed into a spreadsheet range with a data dictionary naming the source table and column behind every field.
Waits on IT for an inventory or open-order extract and works from figures that are days old. Gets a Looker Studio dashboard on live inventory and purchasing datasets, scoped to their own warehouses, refreshing on a schedule without raising a request.
Sees sales and finance present revenue figures that do not reconcile because each built its own export. Gets one defined sales dataset with credit notes netted and currency handling stated, so the same number appears in every dashboard.
| Criterion | ECOSIRE | Custom Build | Competitor |
|---|---|---|---|
| Governed datasets with a published data dictionary rather than raw table access | Included | Partial support | Partial support |
| Native Looker Studio data source with pushdown of date and dimension filters | Included |
From $499.00
Starting point — quoted to your scope
| Partial support |
| Scheduled Sheets refresh that preserves formulas and pivots built on the range | Included | Partial support | Partial support |
|---|
| Your existing UDFs selectable as dataset fields | Included | Included | Not included |
|---|
| Row-level access scoping enforced server-side, with a request log | Included | Not included | Partial support |
|---|
| New fields added by configuration in a UDT registry, not a code release | Included | Not included | Partial support |
|---|
| Reconciled against a report you already trust as the acceptance test | Included | Partial support | Not included |
|---|
| Fixed price agreed before build starts | Included | Not included | Partial support |
|---|
OCR capture and two- and three-way matched A/P invoice posting for SAP Business One. Built to order for your suppliers, tolerances and approval rules after a scoping call and fixed quote.
A guided month-end close and reconciliation assistant for SAP Business One, built to order for your chart of accounts, period calendar and approval rules. Nothing is pre-packaged.
A build-to-order SAP Business One add-on that scores invoice, inventory and price-list activity for anomalies — negative margin, dead stock, shrink and price drift — and routes them for review. ECOSIRE builds it for your company after a fixed quotation.
A conversational analytics layer for SAP Business One that answers plain-language questions on sales, margin and stock. Built to order for your company database, quoted after a scoping call and installed per tenant.