SAP B1 Connector

The SAP B1 Connector is a lightweight Windows service that securely connects your SAP Business One database to SAP B1 AI. Your data stays within your network and is only queried when needed.

System Requirements

Component	Requirement
Operating System	Windows 10/11 or Windows Server 2016+
Runtime	.NET Framework 4.7.2 or later
Memory	Minimum 512 MB available RAM
Network	Access to SAP B1 database (SQL Server or HANA)
Firewall	Outbound HTTPS (443) to *.sapb1.ai

Installation

Step 1: Download the Connector

Download the connector installer from your SAP B1 AI dashboard:

Log in to sapb1.ai/dashboard
Go to Settings → Downloads
Click Download SAP B1 Connector

Note: The installer is pre-configured with your organization's connection details. Each organization has a unique installer.

Step 2: Run the Installer

Right-click the downloaded sapb1-connector-setup.exe file
Select Run as administrator
Follow the installation wizard

Step 3: Configure Database Connection

The configuration wizard will ask for your SAP B1 database details:

Field	Description
Server	Your SQL Server hostname (e.g., `sap-db-server\MSSQLSERVER`)
Database	SAP B1 company database name
Username	SQL Server login with read access
Password	SQL Server password (stored encrypted)

Best Practice: Create a dedicated SQL user with read-only permissions on your SAP B1 database. This follows the principle of least privilege.

Step 4: Test Connection

Click Test Connection to verify the connector can reach your database. You should see a success message with your SAP B1 company name.

Step 5: Complete Setup

Click Finish to complete the installation. The connector will:

Install as a Windows service (auto-starts with Windows)
Register with SAP B1 AI cloud services
Begin listening for queries

Verify Installation

To confirm the connector is working:

Go to your SAP B1 AI dashboard
Navigate to Settings → Connection Status
You should see Connected status

Try asking a simple question in the AI assistant, such as "How many customers do I have?" If you get a response with data from your SAP B1 system, the connection is working.

Troubleshooting

Connector shows "Disconnected"

Check that the Windows service "SAP B1 Connector" is running
Verify outbound HTTPS traffic to *.sapb1.ai is allowed
Review logs in C:\ProgramData\SAPB1Connector\logs

Database connection fails

Verify SQL Server credentials are correct
Check that SQL Server allows network connections
Ensure the connector machine can reach the database server

Queries timeout

Large databases may need index optimization
Check network latency between connector and database
Contact support if issues persist

Security

The SAP B1 Connector is designed with security in mind:

Data stays local: Your database data never leaves your network. Only query results are transmitted.
Encrypted credentials: Database passwords are encrypted using Windows DPAPI.
TLS encryption: All communication uses TLS 1.2+.
Read-only: The connector only reads data; it cannot modify your SAP B1 database.
Audit logging: All queries are logged for compliance.

Updates

The connector automatically checks for updates and will prompt you when a new version is available. You can also manually check for updates:

Open the SAP B1 Connector configuration utility
Click Check for Updates
Follow the prompts to install updates

Uninstallation

To remove the connector:

Open Windows Settings → Apps
Find "SAP B1 Connector" in the list
Click Uninstall

Note: After uninstalling, SAP B1 AI will no longer be able to query your database. Your automations will show errors until you reinstall the connector.