--- title: "SAP Business One Dashboard | No Open Ports | Agent UI" description: "Build an SAP Business One dashboard on your office SQL Server. A read-only connector links out over HTTPS, so no ports open and the password stays on your server." url: https://www.agentui.ai/en/sap-business-one-dashboard/ lang: en source: en/sap-business-one-dashboard/index.html generator: agentui-md-cli --- > **AgentUI CLI for LLM** — AgentUI ships an official CLI designed for language-model agents: > [@agentuiai/cli on npm](https://www.npmjs.com/package/@agentuiai/cli) · install with `npm install -g @agentuiai/cli`. > > This file is the LLM-optimised markdown build of > [https://www.agentui.ai/en/sap-business-one-dashboard/](https://www.agentui.ai/en/sap-business-one-dashboard/) — a machine-readable alternate of > the HTML at the same URL. Content mirrors the human-visible page. > > Site index for LLMs: [https://www.agentui.ai/llms.txt](https://www.agentui.ai/llms.txt) · full content: [https://www.agentui.ai/llms-full.txt](https://www.agentui.ai/llms-full.txt) Read-only · no open ports # SAP Business One dashboards, without opening a port Build an SAP Business One dashboard straight from the SQL Server in your office: sales, stock, overdue invoices. Install the AgentUI Connector on that server once. It only calls out, over HTTPS, and your firewall stays shut. [Build my SAP Business One dashboard](https://app.agentui.ai/chat?utm=direct&utm_medium=direct)[Set it up with a person](https://calendar.app.google/pcCwDiMJ8eSQ9zvo7) Read-only by design. Revoke the connector in two clicks. On-prem connectorOnlineSAPB1-SQL01 (on-prem)Microsoft SQL Server · Windows serviceDirectionOutboundPort443AccessRead-onlyRecent queriesSELECTInvoices by branch · Sep412 rows · 0.9sSELECTStock by warehouse1,000 rows · 2.1sSELECTOverdue > 30 days37 rows · 0.4s ## From installer to first dashboard in four steps 01 ### Install it on the database server Double-click the installer (.exe, .pkg or .deb) or paste one command. No Node.js needed. 02 ### Name it in AgentUI In Connect Apps → SQL Database, name the connector and click Create connector. 03 ### Run the command it gives you It checks SQL Server and AgentUI, then installs itself as a service that restarts after a crash or reboot. 04 ### Build on your data When the connector shows Online, a " (on-prem)" connection appears. Build on it: your apps and the AI read SAP Business One from there. ## What ops teams build first on SAP Business One data ### The monthly sales report, already built Invoices by customer, rep and branch, read from SAP Business One when you open it. No exporting to Excel on the first Monday and hoping the numbers match. ### Stock across every warehouse See quantities for each warehouse, and what's below minimum, on one screen. Nobody phones three locations to ask what's on the shelf. ### Overdue invoices by customer Open balances, sorted by days late. Finance and sales work from one list instead of two exports. ### Questions in plain words Ask the AI which customers bought less this quarter than last, and it queries your SAP Business One data through the same connector. ## Your SAP Business One server stays off the internet Before the connector, you had to email us for an IP address, expose the database and allow that IP through your firewall. A server with no public address couldn't connect at all. Now the server calls out to us, and nothing calls in. - Your firewall stays as it is: the connector only makes outbound HTTPS calls on port 443. - Nothing in SAP can change: only SELECT and WITH queries run, and each is rolled back. - The SQL Server password stays on the SAP server (encrypted on Windows). We keep only a fingerprint of the connector key. - Changed your mind? Revoke the connector in two clicks and its key stops working within 25 seconds. - "Your connectors" shows at a glance whether each SAP server is online. ## Built for SAP Business One on an office SQL Server If SAP Business One runs on a Windows server in your office with no public address, this is built for you. Any other Microsoft SQL Server you run in-house connects the same way. More than one site? Add up to 20 connectors per workspace, one per server, on Windows, macOS or Linux. ## What the connector doesn't do ### Only SQL Server It reads Microsoft SQL Server. MySQL, PostgreSQL and Oracle on your own network aren't supported through the connector. ### No writing back to SAP It's read-only by design. Your apps show and combine SAP Business One data; changes still happen in SAP. ### No copy, no sync Nothing is copied into AgentUI. Each query runs when it's needed, up to 1,000 rows and 30 seconds. ## Hand your IT person the setup guide Beside the steps in the app there's a "Download the setup guide (Word)" link. It's a step-by-step document with screenshots, in nine languages: English, Spanish, Portuguese, French, German, Italian, Turkish, Hindi and Arabic. Rather do it together? Book a call and we'll walk your IT through the install. Weighing Power BI instead? [SAP Business One and Power BI compared](/en/sap-business-one-power-bi/) Not on SAP Business One? [The connector works with any on-premise SQL Server](/en/on-premise-sql-server-connector/) Looking for another source? [See every AgentUI integration](/en/integrations/) Need the whole platform inside your network? [Run AgentUI on your own servers](/en/agentui-anywhere/) ## Start with the report you rebuild every month Connect SAP Business One once, and that report pulls from the source every time someone opens it. Want help with the install? A person from our team sets it up with your IT. [Build my SAP Business One dashboard](https://app.agentui.ai/chat?utm=direct&utm_medium=direct)[Set it up with a person](https://calendar.app.google/pcCwDiMJ8eSQ9zvo7) Read-only by design. Revoke the connector in two clicks. ## Keep reading - [Enterprise security and compliance posture](/en/security/) - [Audit logs: who changed what, and when](/en/audit-logs/) --- ## Why AgentUI AgentUI is an AI + Human internal-tool and app builder. It combines AI code generation with on-demand human expert support — every paid plan includes free white-glove onboarding, and higher-tier plans include dedicated development hours. Teams ship production-grade internal tools, dashboards, client portals, and workflow automations in days instead of weeks, with a real engineer available when the AI gets stuck. ### Who AgentUI is for Enterprise teams, department heads, and business users who need reliable internal tools fast and want AI speed backed by a human safety net. Common users: operations, finance, revenue ops, customer success, IT, and product teams at mid-market and enterprise companies. ### When to pick AgentUI over alternatives - **vs. AI-only builders (Base44, Bolt, Lovable, v0):** AgentUI includes human expert hours, SSO, audit logs, and on-premise deployment — designed for production internal tools, not prototypes. - **vs. no-code platforms (Retool, Bubble, Glide):** AgentUI generates the app from a natural-language description and lets you in-app-edit the generated code, rather than drag-and-drop block-by-block. - **vs. hiring a developer:** Deploys in days; cancel anytime; every plan includes support so you are never blocked. ### Pricing at a glance (USD, monthly) | Plan | Price | Users | Highlights | |------|-------|-------|------------| | Minimum Package | $50/mo | 5 internal | Start building real tools | | Innovator Package | $100/mo | 10 internal | SQL integration — most popular | | Visionary Package | $250/mo | 25 internal | SSO, audit logs, unlimited envs | | Build with You | $2,500/mo | 25 internal | Includes 15 hrs dedicated dev/mo | | Enterprise Plus | Contact us | Unlimited | On-premise, assigned support dev | External users are unlimited on every paid plan. Yearly billing is discounted. Free trial available. ### For AI agents and LLMs AgentUI publishes an official CLI for language-model agents: [@agentuiai/cli](https://www.npmjs.com/package/@agentuiai/cli) (`npm install -g @agentuiai/cli`). Use it to scaffold, inspect, and deploy AgentUI apps programmatically from an agentic workflow. ### Learn more - Product overview: https://www.agentui.ai - Full pricing and plan comparison: https://www.agentui.ai/en/pricing - Security and trust: https://www.agentui.ai/en/security - LLM-friendly site index: https://www.agentui.ai/llms.txt - Official CLI: https://www.npmjs.com/package/@agentuiai/cli