Skip to Content
Author's profile photo Jitendra Kansal

How to access SUP CDB (Cache Database) ?

Dear All,



This Document explains steps how to access SUP cache database.



Tools used in developing the application are:
SUP version : 2.2, SAP CRM 7.0
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″



-<beans xsi:schemaLocation=”
xmlns:p=”” xmlns:util=”
xmlns:dep=”” xmlns:xalan=”
xmlns=”“> -<bean
id=”DSAdminPackageData” scope=”prototype”
-<property name=”dsAdminMBOs”> -<util:map



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



Jitendra Kansal

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Midhun VP
      Midhun VP


      Good work.

      But I found the same post in a different date from you at

      I think you did a mistake.

      Author's profile photo Jitendra Kansal
      Jitendra Kansal
      Blog Post Author

      Thanks Midhun.

      by mistake that blog has added twice. removed from that link.



      Author's profile photo Sumeet Shahapeti
      Sumeet Shahapeti

      Thanks Jitendra

      Great work.

      Author's profile photo David Clavey
      David Clavey

      Nice share, thanks 🙂

      Author's profile photo Former Member
      Former Member

      Great one Jitendra 🙂

      Author's profile photo Former Member
      Former Member

      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! 😉


      Author's profile photo Jitendra Kansal
      Jitendra Kansal
      Blog Post Author

      Hi Florian,

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

      Please chck.


      Jitendra Kansal

      Author's profile photo Former Member
      Former Member

      Hey nice one Jitendra!!!

      Kind Regards,