How to access SUP CDB (Cache Database) ?

[Jitendra_Kansal]

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)

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

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
  
  
  
  

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
  
  
  
  

• 
  
  
  
  • For ODBC Data Source name, click on Browse, search for cdb_32bit
  
  
  • Pass User ID: dba
  
  
  • Password: sql
  
  
  • Click on Connect
  
  
  
  

 



 



 

 

 

6. You will see screen like below:

 



 

 

 

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)
  
  
  
  

 



 

 

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

 



 

 

 

• 
  
  
  
  • 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.
  
  
  
  

 

 



 



Note: For more details check this Wiki Page.

 

I hope this would help you.

 

Regards,

Jitendra Kansal