Create a SAP Business One model

Under the Apps (On-prem) section, select SAP Business One.

From the source type pop-up, click Deploy on the SAP Business One entry tagged Model.

Complete the following fields:

1. Data Gateway - Leave this item set to None unless you are using a Data Gateway.

2. Processor Architecture - Select the Processor Architecture of the SAP Business One DI API installed.

3. System Landscape Directory Server (SLD) - Location of the SAP System Landscape Directory Server (SLD). Use the server name if the SLD server is on the same network as the Data Hub server. Otherwise, a fully-qualified domain name (FQDN) is required.

4. SLD User Name - Provide a user name with access to the System Landscape Directory Server.

5. SLD Password - Provide the password for the SLD User Name.

6. Database Server Type - Select the Version of Microsoft SQL Server used for the SAP Business One Database.

7. Database Authentication - Depending on how your instance of SAP Business One is configured, authentication credentials are provided by either:

   1. SLD Authentication - Select to use SLD authentication to connect to the SAP Business One Database Server.

   2. Windows Authentication - Select to use a Windows user name and password to connect to the SAP Business One Database Server. Active Domain credentials are also accepted.

   3. SQL Server Authentication - Select to use a SQL Server user name and password to connect to the SAP Business One Database Server.

8. Database User Name - Enter the user name of a user with access to the SAP Business One instance. The user name provided may require the domain name (such as domain\user) or a User Principal Name format (user@fully-qualified_domain_name).

9. Database Password - Enter the password for the provided user name.

10. Database Server - Type the SAP Business One System database name, or select the database from the drop-down list. ZAP Data Hub automatically combines data from the SAP Business One company databases for the Configure Source and Select Data steps.

11. Caption Language - Select the language used to display user-friendly descriptions for elements stored by SAP Business One.

Click Test Connection.

Click Next.

Specify which entities to include for analysis by selecting or clearing the check box beside the entity names.

Select the Primary Company check box for the primary entity (if there is more than one entity).

Click Next.

Complete the following fields:

1. Model Name - Enter a name for the new data model.

2. Model Location - Click Browse and select a root directory for data model using the Select Folder pop-up window. New folders can be created by right-clicking on existing folders and selecting New Folder.

3. Model Server - Select an existing Model Server to use for this Data Model, or select Create new model server… to open a New Model Server tab.

4. Model Database Name - Enter a name for the data warehouse table to be stored in Microsoft SQL Server. If the Model Database Name is already in use, attempting to create the model will not proceed until the Model Database Name is changed or Ownership of the existing table is changed as described in Resolving Cube and Warehouse Usage Conflicts in the Model Wizard.

5. Deploy Analytics - When checked, analytics provided by the Solution are deployed during model creation. When cleared, analytics will not be deployed during module creation and will need to be deployed later from the model task pane.

6. Modules - Select the pre-packaged modules to be deployed for this data model.

Click Create Model.