Skip to Content
Technical Articles
Author's profile photo Former Member

Interested in news about database support for the service layer?

Dear all,

Since its introduction in SAP Business One there has been discussions about the missing official support of the service layer for Microsoft SQL Server.

Now there are important news, read Andreas Wolfinger’s comment on this improvement request on customer influence platform (anyone with an s-user can be active there).

<update on Dec 18 2019> Even though it is not yet available with version 10 PL00, it is planned as described in our updated product road map. Please pay attention to further communication on upcoming patches.

Best regards, Peter

Assigned Tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Manuel Dias
      Manuel Dias

      Hi Peter,

      Service Layer availability for MS SQL is important to support organizations that rely on MS SQL data eco-systems, to support both SAP B1 and other LB solutions that integrate with B1.

      Do you have any date when first SL version will be released for MS SQL?

      Thanks

       

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Dear Manuel, this is planned very soon, unfortunately we are not allowed to make a clear or binding statement here.
      I personally assume the GA (general availability) version of Business One 10 should be very interesting.
      Best, Peter

      Author's profile photo Paolo Fornari
      Paolo Fornari

      Hi,
      I took it for granted SL support for SQL Server on B1 10.

      I've just installed B1 10 PL01 and tryed a login using Postman, here is the response:

      {
         "odata.metadata": "https://server-doc:50000/b1s/v1/$metadata#B1Sessions/@Element",
         "SessionId": "212d4e66-48cd-11ea-8071-005056875584",
         "Version": "1000110",
         "SessionTimeout": 30
      }

      So... seems to work, tried also an oData Get on a BP and it's working.

      Please, let me understand state of art and if support is official or not.

      Thank you

      Paolo

       

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      As above, indeed it's supported and official.

      Author's profile photo Miguel Adauto
      Miguel Adauto
      I have this problem with the SL for SQL Server on B1.
      
      
      
      {
         "error": {
            "code": -311,
            "message": {
               "lang": "en-us",
               "value": "Fail to get the bound database instance from SLD."
            }
         }
      }
      
      
       
      Author's profile photo Bilal Sultan
      Bilal Sultan

      Paolo Fornari

      Have you configured anything?
      i can’t access service layer through https://Server:50000

      is there any configuration i have to do?
      or is there a specific installation i have to install?

      I'm running SAP Business One 10 PL01

      Please Help.

       

      Best Regards,

       

      Author's profile photo Paolo Fornari
      Paolo Fornari

      Bilal Sultan

      You need to separately install it.

      You can find the setup under the Packages.x64\ComponentsWizard folder.

      Paolo

      Author's profile photo dhana sekar
      dhana sekar

      Hi ,

      How to fix following error "SERVICE LAYER NOT FOUND FOR THIS DATABASE SERVER"  in SAP BUSINESS ONE 10 PL02 SQL

      Please help me to sort out this issues

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Dear all, I'm pleased to clarify that Service Layer service is enabled for Microsoft SQL Server wince Version 10 PL01, see SAP Note 2875568

      Best regards, Peter

      Author's profile photo Darren Grayson
      Darren Grayson

      When used on Microsoft SQL, is there anything missing from Service Layer? Such as the JS script engine (https://blogs.sap.com/2017/09/01/implementing-service-layers-script-engine/)?

      Author's profile photo Thiago de Castro Mendes
      Thiago de Castro Mendes

      Hi Darren,

      You can find here the documentation with features and scope of the Service Layer for both MS SQL Server and SAP HANA.

      Please refer to page 51 where we state Semantic Layer through SL is obviously only available for SAP HANA, or to page 120 explaining the same for the parameter isCaseInsensitive.

      Hope it helps,
      Thiago Mendes.