Skip to Content
Dear All,

OBJECTIVE:

 

This Document explains steps how to access SUP cache database.

 

REQUIREMENT:

Tools used in developing the application are:
SUP version : 2.2, SAP CRM 7.0
Procedure:
You would have wondered how to see data in SUP CDB after MBO deployment.
Here I have used SAP as backend specifically. Device doesn’t talk to backend directly. First there is a full data subscription happens from backend to SUP and on SUP data will be stored In CDB.  (Assuming whole data load into SUP after a defined interval)
You can verify/crosscheck the data from here. You can put some object query in SQL to see the data displaying on device.
Let me go step by step.

1. You create an application named “test1” (refer below snapshot)

/wp-content/uploads/2013/04/1_200993.png

2. Then create one MBO (testMBO) using SAP backend.

/wp-content/uploads/2013/04/2_200994.png
/wp-content/uploads/2013/04/3_200995.png

3. You set its cache policy as Scheduled with some interval let’s say 10 mins.

    • (Here I am mentioning cache policy as scheduled because once you deploy your MBO to SUP server, you can see data in CDB in stipulated interval time mentioned in cache policy, if you set its cache policy as on demand then you have to wait for trigger from
      device, then only you will be able to see data in CDB.)
    • Deploy MBO to Unwired server
/wp-content/uploads/2013/04/4_200996.png

4. Once MBO has been deployed successfully to SUP unwired server, you would be able to see data in SUP local database.

5. SQL tool is available in Sybase folder,

    • Go to: C:\Sybase\UnwiredPlatform\Servers\SQLAnywhere12\BIN32
    • Then search for dbisql.exe, double click on the same
/wp-content/uploads/2013/04/5_200997.png
    • For ODBC Data Source name, click on Browse, search for cdb_32bit
    • Pass User ID: dba
    • Password: sql
    • Click on Connect

 

/wp-content/uploads/2013/04/6_200998.png

 

/wp-content/uploads/2013/04/7_200999.png

 

 

 

6. You will see screen like below:

 

/wp-content/uploads/2013/04/9_210045.png

 

 

 

7. In SUP CDB,table nomenclature is different what you have in MBO. As you have created a testMBO in your workspace, that testMBO would have some different table name in CDB. To search that

    • Go to C:\Sybase\UnwiredPlatform\Servers\UnwiredServer\deploy\sup
    • You will see below folder name. pick test one.( since our project name is test)

 

/wp-content/uploads/2013/04/9_210045.png

 

 

8. Open it, and then search for applicationContext-admin.xml file. Double click on it. It will open in a browser.

 

/wp-content/uploads/2013/04/10_201002.png

 

 

 

    • In that opened page, search for testMBO
    • You will see a ref bean associated to testMBO. Here it is d11_test1_1_0_testmbo
    • Copy it and go back to SQL tool.

 

 

 

<?xml version=”1.0″
encoding=”UTF-8″?>

 

 

-<beans xsi:schemaLocation=”http://www.springframework.org/schema/beans/spring-beans

 

 

http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-2.5.xsd
http://www.springframework.org/schema/util
http://www.springframework.org/schema/util/spring-util-2.5.xsd
xmlns:p=”http://www.springframework.org/schema/p” xmlns:util=”http://www.springframework.org/schema/util
xmlns:context=”http://www.springframework.org/schema/context
xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance
xmlns:dep=”http://www.sybase.com/sup/ds/schema/deployment” xmlns:xalan=”http://xml.apache.org/xslt
xmlns:jdbc=”http://www.sybase.com/sup/ds/schema/deployment/jdbc
xmlns:jca=”http://www.sybase.com/sup/ds/schema/deployment/jca
xmlns:sap=”http://www.sybase.com/sup/ds/schema/deployment/sap
xmlns:wssoap=”http://www.sybase.com/sup/ds/schema/deployment/wssoap
xmlns:rest=”http://www.sybase.com/sup/ds/schema/deployment/rest
xmlns:local=”http://www.sybase.com/sup/ds/schema/deployment/local
xmlns:interaction=”http://www.sybase.com/sup/ds/schema/deployment/core/interaction
xmlns=”http://www.springframework.org/schema/beans“> -<bean
id=”DSAdminPackageData” scope=”prototype”
class=”com.sybase.vader.mms.admin.DSAdminPackageData”>
-<property name=”dsAdminMBOs”> -<util:map
map-class=”java.util.LinkedHashMap”>

 

 

-<entry key=”test_MBO”>

 

 

<ref bean=”d11_test1_1_0_testmbo.DSAdminMBO”/>

 

 

 

 

 

9. For cross checking data, you may write a simple object query like

 

    • Select * from d11_test1_1_0_testmbo
    • Press F5. You will see data in below table.

 

 

/wp-content/uploads/2013/04/9_210045.png

 

/wp-content/uploads/2013/04/9_210045.png

Note: For more details check this Wiki Page.

 

I hope this would help you.

 

Regards,

Jitendra Kansal

To report this post you need to login first.

8 Comments

You must be Logged on to comment or reply to a post.

  1. Florian Kekule

    Hello Kumar,

    i´m working with SUP 2.1.3 and in my file-system the folder servers does not exist in C:\Sybase\UnwiredPlatform. Do you have any ideas how to solve this problem?

    Thanks in Advance! 😉

    Florian

    (0) 
    1. Jitendra Kansal Post author

      Hi Florian,

      if you are not able to see the desired path then SUP server is not installed on your machine..it must be on some other machine.

      Please chck.

      Regards,

      Jitendra Kansal

      (0) 

Leave a Reply