| Description |
SAPB1 Resource (Magic xpi 4.9)
This section is relevant for SAPB1 2004, SAPB1 2005, SAPB1 2007, and SAPB1 8.8.
SAPB1 resources contain the following parameters (parameters in bold are mandatory):
|
|
| |
Server
|
Enter the SAP Business One company server name. This is the name of the machine where the SAP Business One company database is physically located.
For example: Server1 or (local) or 10.1.2.3.
You can also click  to open the Environment Variables List. Here, you can select an environment variable to use as a server name.
| |
Company Database
|
Enter the SAP Business One company database name.
For example: SBODemo_US.
You can also click to open the Environment Variables List. Here, you can select an environment variable to use as a database name.
| |
User Name
|
Enter the SAP Business One login user name.
For example: manager.
You can also click to open the Environment Variables List. Here, you can select an environment variable to use as a user name.
| |
Password
|
The SAP Business One user password.
For example: manager.
You can also click to open the Environment Variables List. Here, you can select an environment variable to use as a password.
|
|
A password entered as an environment variable is masked by asterisks.
|
| |
License Server/SLD Server
|
The license server manages users and licenses for SAP Business One. Enter the SAP Business One license server machine name, followed by a colon and the port number of the sublicense server. The port number is relevant for SAPB1 2005, 2007, and 8.8 only. For example, localhost:30000. (30000 is the default port number for SAPB1 2005, 2007, and 8.8).
You can also click to open the Environment Variables List. Here, you can select an environment variable to use as a license server machine name.
| |
Language
|
Select the language used for the SAP Business One data. This field defines the character setting of the retrieved XML files.
| |
DB Server Type
|
Select one of the following database servers from the drop-down list:
-
MSSQL (default)
-
MSSQL 2005 (not available for SAPB1 2004)
-
MSSQL 2008 (not available for SAPB1 2004 or SAPB1 2005)
-
MSSQL 2012 (not available for SAPB1 2004, SAPB1 2005, or SAPB1 2007) Since version: 4.0a
-
HANA DB Since version: 4.5a
|
|
If you want to use SAP HANA triggers, you need to take the ODBC connection string, defined in the ODBC Data Source Administrator dialog box, and enter it in the Connection Properties column of the SAPB1 Multi Resources List.
|
| |
Windows Authentication
|
Define whether the SAP Business One Company object uses Windows authentication. Select one of the following from the drop-down list:
| |
DB User Name (not available if Windows Authentication is set as Yes.)
|
The user name for accessing the SAP Business One Company database.
You can either enter the user name, or click to open the Environment Variables List. Here, you can select an environment variable to use as a user name.
| |
DB Password (not available if Windows Authentication is set as Yes.)
|
The user password for accessing the SAP Business One Company database.
You can either enter the password, or click to open the Environment Variables List. Here, you can select an environment variable to use as a password.
|
|
A password entered as an environment variable is masked by asterisks.
|
| |
DI API Version
|
Magic xpi supports the use of multiple SAP Business One Data Interface API versions within a single project. For example, from the same project you can:
-
Work with the SAP Business One 8.8 DI API, located on the same machine as Magic xpi.
-
Connect to a different SAP Business One company, located on a remote server, that is running the SAP Business One 2005 DI API.
This parameter allows you to define the DI API version that you want to work with for a specific SAPB1 resource, provided that it has been installed on your machine.
For example, if you want to work with the SAP Business One 2005 DI API, you should enter 2005.0 in this parameter.
The DI values are located in the registry under the SAPbobsCOM.Company.X key, where X represents the version.
The default value for this parameter is blank. This means that the resource will use the default DI API that is defined by the SAP installation that you are using. The default DI value is located in the registry under the SAPbobsCOM.Company key.
|
|
-
You should always specify the DI version that you want to use, and not rely on the default value.
-
You should make sure that the DI API dll files match the SAP Business One version that the DI API connects to. If there is a mismatch, you can copy the DI API dll files from the remote SAP Business One server, and then use them where Magic xpi is installed.
|
|
SAPB1 resources also give you the following button:
|
|
| |
Validate
|
Click this button to verify that the connection to the SAPB1 server is valid. You will receive a message indicating that the connection is established, or an error message if the connection failed.
|
|
|
Although, theoretically, you can define as many SAP database connections as you want, in practice you are limited by the type of license that you have. This means that:
-
An error message informs you if you exceed the number of database connections permitted by your license.
-
Magic xpi uses connections sequentially, in the order that they appear in the Connections List, up to the limit specified in the license. Any connections that exceed this limit are not processed.
|
|
|
|---|
