Skip to Content
avatar image
Former Member

Required SQL Licenses

I have developed a external program that reads data from SAP B1 tables and writes calculations and totals to another database belonging to the same sql instance of B1 database. Do I have to buy an additional sql license? And if this program is launched from multiple locations, do I have to buy as many licenses as there are locations?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 14, 2018 at 08:17 AM

    Hi Emanuela,

    Usually a SAP Business One installation includes the necessary MS SQL licenses needed by SAP Business One to allow usage of MS SQL Server by the given number of licensed SAP Business One users.

    That means that, officially*, all data stemming from external applications (addons) should be stored in the company database. The system offers User Defined Tables and Fields for his purpose. Officially*, accessing this data should happen using the DI API, which has the recordset object for general query purposes. When you use the DI API, you will per definition use a licensed user to open the connection, and thus you will be covered.

    To allow for scenarios with an unknown number of connections (for example a web based application like a web shop), SAP provides the DI Server (free). The DI Server is basically a web service, that will use a single B1 license to connect to the company database.

    To allow for integration scenarios (connecting business partners' systems with yours), SAP provides B1if (free), which uses a single B1 license to connect to the company database.

    Alternatively the MS SQL Server license(s) can be purchased separately, in which case it all depends on the chosen licensing model: seat or CPU. With the seat model the rules are pretty much the same, with the more expensive CPU model, you are free as a bird, as long as the databases involved are on the same instance / server.

    External access, as you have described, can be had as long as the total number of simultaneous connections to MS SQL Server does not exceed the number of B1 licenses. Simultaneous connections means the combined number of connected B1 clients and connections made by your application(s).



    *) ;-)

    Add comment
    10|10000 characters needed characters exceeded