Technical Articles
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
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
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
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:
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
As above, indeed it's supported and official.
I have this problem with the SL for SQL Server on B1.
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,
Bilal Sultan
You need to separately install it.
You can find the setup under the Packages.x64\ComponentsWizard folder.
Paolo
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
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
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/)?
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.