Skip to Content
SAP Mobile Platform

SUP 2.x. Creating a MBO from an SAP Adaptive Server Enterprise.

Tags:
SUP 2.x. Creating a MBO from an SAP Adaptive Server Enterprise.
This technical document explains how to create a Mobile Business Object from an SAP Adaptive Server Enterprise.

Required Software

       1. SUP 2.x.x SDK or higher.
       2. SAP ASE or Sybase ASE.
       3. Pubs2 database installed.

Assumption

This document assumes you have a working SUP environment.
You need to have access to Adaptive Server.
You need to have pubs2 database installed.

Step 1 – connecting to Adaptive Server Enterprise

User needs to connecte and consume data from Adaptive Server.

Solution

In order to connect to ASE you need to create a connection in SUP Workspace.
1.    Start the SUP Workplace.
2.    Go to the Enterprise Explorer.
3.    Right Click on Database Connection.
4.    Select NEW.

                           
            Figure 1
5.     From the Connection Profile Type: select Sybase ASE.
6.     Under Name: Add the name you would like to use for the connection object.

         Figure 2
7.    Click Next.

    Figure 3
8.    Add your hose name or TCP/IP Address.
9.    Add the Port number the ASE is listening on.
10.  Add the default database name that you are using.
11.  Add your User name.
12.  Add your Password NULL password is not supported.
13.  Optional place a check in save password
14.  Click on the Test Connection Button.

        Figure 4
This concludes the setting up the connection for the Adaptive Server Enterprise.

Step 2 – Creating A MBO:

User needs to create a MBO from Adaptive Server Enterprise.

Solution

In order to do that, you will need to do the following steps.
1.    Start or open the SUP Workspace.
2.    Go to the Enterprise Explorer.
3.    Right click on Database Connections and select from the menu Connect.
4.    Go to the folder Mobile Servers tree open and connect to the SUP Server.
   Figure 5
5.    Go to the top left menu File and select New -> Mobile Application Project.
6.    Add your Project name: SAPASE
7.    Go to your Adaptive Server connection.
8.    Tree open Databases then pubs2 and Tables.
9.    Highlight the table authors.
10.  Click on authors and drag and drop on to Application Diagram
         Figure 6
11.  Go to Attributes and add Primary Key for au_id.
12.  Save Project.
13.  In Workspace Navigator Right click on your project.
14.  From the popup menu select deploy
15.  Follow the prompts and click OK.
        Figure 7
This Concludes creating the MBO from the SAP Adaptive Server Enterprise.

Step 3 –Veiwing and checking the MBO Deployment from SCC:

a.    Checking the status of the MBO in the SUP Server.

Solution

In order to get an idea of how the deployment works we can check in SCC.
1.    First start the Sybase Control Center.
2.    Login using supAdmin or an account assigned to you.
3.    Go to Domain.
4.    Tree open default.
5.    Tree open packages.
6.    Tree Open sapase:1.0.

      Figure 8
7.    You will see the authors table this means we are now binding the table in SUP to Adaptive server.
This concludes the creation and deploying the Mobile Business Object to the SUP server.

Summary

This document explained in details about the steps needed to create a connection to the SAP
Adaptive Server Enterprise. Create the Mobile Business Object and deploy to the SUP Server.
Confirming the deployment of the MBO to the SUP server thru Sybase Control Center.