This is an old revision of the document!
Step-by-step implementation guides
Table of Contents
The steps you need to follow for implementing COBI.wms depend on the type of your SAP Business One installation. Follow the steps under the section that describes your environment.
On-premises or private cloud, MS SQL Server, SBO 9.3 or earlier
If you have an on-premises or private cloud installation of SAP Business One Version 9.3 or older, based on Microsoft SQL Server then please refer to the following steps. Note that the Integration Framework must be installed already.
- Import the Integration Framework Scenario Package
- Afterwards, copy the Trigger URL as described in the linked page and temporarily save it somewhere
- Follow all the steps of the following section (on-prem with Service Layer), with the following differences:
- Use the Trigger URL for the
APIURL
field of the SAP Business One company connection added to the Management Database - Make sure that TCP Port 8080 for Integration Framework is opened on the server
On-premises or private cloud, with Service Layer
If you have an on-premises or private cloud installation of SAP Business One with Service Layer available (which means it is either based on SAP HANA, or the version of SAP Business One is 10.0 or newer) then follow these steps:
- Create the Management Database
- Create the database itself by copy-pasting the correct creation script into SQL Server Management Studio or HANA Studio
- Import licenses by using the appropriate
INSERT
statement from the Management Database documentation - Add SAP Business One connections by using the appropriate
INSERT
statement from the Management Database documentation
- (For HANA: Install and start the HANA Proxy)
- Install COBI.wms from the Google Play Store on an Android device that can access the SAP Business One server
- Make sure that the TCP ports for direct DB queries and Service Layer are not blocked
- MS SQL Server: 1433
- HANA Proxy: 30075
- Service Layer: 50000 (https) or 50001 (http)
- (optional) Use cobiwms-config.html to generate a Settings QR Code
- Open COBI.wms on the Android device and scan the Settings QR Code (or enter the settings manually)
- Click Connect and take note of the device ID on the right side of the screen below the Login button
- Assign a license to that device ID (see Management Database documentation again)
- Log in to COBI.wms with an empty username/password and make a test booking
- (optional) Create COBI.wms users in the Management Database
- (optional) Disable all modules for all devices and enable them for users instead to force user login
Public cloud
Prerequisites
If you are using SAP Business One from a public cloud (SAP-hosted or partner-hosted) then first of all, your cloud provider must make Service Layer accessible. Talk to your provider for details about this.
Configuring the app
To configure the connection of the app to your SAP Business One cloud account, open cobiwms-config.html in a new tab of your browser, and follow these steps:
- Choose “Companies (public cloud)” at the top of the page
- Click on “New” to start creating a new Company connection
- Enter the connection settings as instructed
- (If you want to add further company connections, like for a testing database, repeat steps 2 and 3)
- Click on “Generate QR Code” to display a QR Code containing the entered company connections
- Open the Settings screen in COBI.wms if not already opened
- Scan the QR Code, either by clicking on the barcode icon at the top right to open the device's camera, or by using a built-in hardware scanner (usually triggered with a special hardware button)
Creating SQL Queries
When connecting to a cloud deployment of SAP Business One, COBI.wms cannot establish a direct database connection and instead has to request all data over Service Layer. To improve the functionality and performance of these data requests, the app can create a number of SQL Queries while logging in to a company database.
This is done by checking “Update SQL queries” in the login screen, above the login button. (It will create them if they were not created yet, otherwise update them to the newest version.)
For this SQL Query creation/update to work correctly, the SAP user you've entered for the connection settings in step 3 in the previous section has to be either a superuser, or have the permission “Modify SQL Queries in Service Layer” under the “General” category. This permission is only available since SAP Business One Version 10 FP2108. In older versions, you must use a superuser.
All types of installation
There are some steps you might need to take which are independent of the SAP Business One installation:
- DataWedge Settings: If you have a Zebra scanner, see this page.
- Barcode scanning via Bluetooth: See here for special instructions regarding Bluetooth-based barcode scanners.
- App Options: COBI.wms has many options to customize the app for your needs.
- Print Settings: See here for connecting to ZPL-based label printers.
- Label Templates: See here for a guide on designing COBI.wms label templates.