Skip to Content
0
Mar 23, 2020 at 03:47 PM

SAP Business One 10.0 multitenant installation

952 Views

Hi

We are trying to create a multitenant scenario in our test environment with SAP Business One 10.0 PL01 and HANA 2.0

Our idea is to create a multitenant scheme in which a Linux server can host different SAP database environments in “tenant” independent from each other, although logically they share the version of HANA and SAP on which they work, separating the license control from SAP users of each of the tenant.

---------------------------------------------------X SAP HANA SYSTEM---------------------------------------------------

System Tenant/MDC “A” Tenant/MDC “B”

Database Database Database

Company SAPBO A_1 Company SAPBO B_1

Company SAPBO A_2 Company SAPBO B_2

….. …..

--------------------------------------------------------------------------------------------------------------------------------------

We haven´t managed to make it work completely and correctly

We have made several attempts that I summarize below in SCENARIO 1 and SCENARIO 2 but without getting the correct installation in any of them.

Given these problems we have had, we wonder if this functionality is really available in SAP Business One.

Do you know if there is any document or guide that explains how to carry out this Multitenant installation and the configuration of all SAP services for each tenant?

We have already reviewed Administrator's Guide SAP Business One 10.0 PL01, version for SAP HANA, SAP HANA Administration Guide for SAP HANA Platform 2.0 SPS 04, SAP HANA Administration with SAP HANA Cockpit 2.0 SP 04, and other documents and notes that are referenced in these manuals. but we can't find the exact way of a good setup for SAP Business One Mutitenant

SCENARIO 1

In this scenario, if we have managed to access some of the different tenant that we have created with the SAP client program

We tried three different ways to create tenant;

1.- First we have tried it from the HANA Cookpit replicating the tenant NDB that is created when installing SAP completely. But this copy process stays several hours trying to carry out this operation or it never works (The browser in this execution stays "Copying" and if we look at the Dabase Managenent of the Cokpit, the Database is in "Replicating" state and the process never ends)

2.- Then we tried creating the tenant ourselves from the "empty" Hana Cockpit, we restored a SBOCOMMON database and created the server from the SLD in the Control Center

3.- We also tried creating a new tenant, creating the server in the SLD from the SAP installation process in Windows (registered a new server), and allowing the SBOCOMMON to create again.

To the tenant created with methods 2 and 3 if we have been able to enter with the SAP client

But the environment isn´t completely stable, it does strange things to us and we believe that they aren´t 100% well created.

For example;

- We aren´t able to configure a different license for each tenant

- We couldn´t configure the Analytics of each tenant

- The App Framework doesn't seem to work

- In the ControlCenter when selecting each server / tenant, the services of each one donn´t appear below the same

SCENARIO 2

We have deployed a fresh environment and;

  • Cloned databases from primari tenant;

CREATE DATABASE TNT ADD 'xsengine' ADD 'scriptserver' SYSTEM USER PASSWORD "PASSW0RD";
BACKUP DATA FOR NDB USING FILE ('/temp/backups/NDB/CLONED');
ALTER SYSTEM STOP DATABASE TNT;
RECOVER DATA FOR TNT USING FILE ('/temp/backups/NDB/CLONED') CLEAR LOG;
ALTER SYSTEM START DATABASE TNT;

  • Removed SLDData DB on non SLD active one
  • Rerun wizard and add tenant to SAP inventory,

But every time we try to create a company on secondary tenant we get the message log attach.

And we are unable to activate analytics on secondary tenant too, because of the lack of SLD.

Regards

Juan Ramon Dios