What's the difference between ULDB and CBD ?

[Former Member]

Dear Experts,

I am trying to find answer which elaborate the device database and its working details.

By reading available materials on SUP , there are many things which are not explained properly or i m new to this subject and finding difficult to understand small things.if SUP claims its working offline means data must have somewhere in device.

What's the difference between ULDB and CBD ? and  unable to understand how ULBD and CDB really work in SUP Environment ?

Reg

Navin

[david_brandow · Accepted solution]

ULDB is the UltraLite DB, in other words the database that sits on the device.

CDB is the consolidated DB that sits in the SUP server that the client databases, and the backend EIS, synchronize to.

[Former Member · Accepted solution]

Dear David

thanks for quick response.

Now , my next question is where it resides in device ?

and how to access device db ( UltraLite DB ) ?

Reg

Navin

[david_brandow · Accepted solution]

I'm afraid I'm not that familiar with native app development in SUP, but I'd be fairly surprised if you were able to access the device-side database directly, I imagine the intention is that you access it only via the generated Object API.

[Jitendra_Kansal · Accepted solution]

Navin,

fyi..

http://scn.sap.com/community/developer-center/mobility-platform/blog/2013/04/29/how-to-accessread-de...

http://scn.sap.com/community/developer-center/mobility-platform/blog/2013/04/03/how-to-access-sup-cd...

Regards,

Jitendra

[Jitendra_Kansal · Accepted solution]

Hi David,

for iOS native app, you can access device data (udb file) from SUP CDB.

you just need to get the udb file for that.

Regards,

Jitendra

[Former Member · Accepted solution]

Dear Jitendra,

I have read this document ( as again mentioned in this mail's link ) earlier .

Pls. see the line where u mentioned the following

• Download the .udb file from device on the SUP server. Pass dba as user ID, sql as password.
• Browse the database file (.udb file)

My Question is where is the .udb file in device ?

Reg

Navin

[Jitendra_Kansal · Accepted solution]

HI Navin,

e.g.

if your app is based on iOS platform.

then you need to conenct your device with mac machine and have to get the udb file.

Regards,

Jitendra

[Former Member · Accepted solution]

Dear Jitender,

I really appreciate your help !

First of all, for your better understand the situation...i am doing development in android .

And i understand from you reply is that .....

First i have to create .udb ( Ultra Lite) database file [ which i can create using sybase central ]

then create the table structure / using sync profile upload table structure..

then i have to upload this file into device.

and then i have to use scripting to use this file to update data , sync data ..... and so on.....

if i only have to do all these things then what SAP Mobile Platform is offering ?

I hope is am wrong and there should be some better way to use Device Database what SAP Mobile Platform is offering !

I hope i m making clear what i want / looking for !

Reg

Navin

[Jitendra_Kansal · Accepted solution]

Dear Navin,

when you access/subcribe data from device(first time) that time only data will get stored in some file( unfortunately i am not aware the exact name of file for android, but for iOS there is one .udb file).

UltraLite is a tool by which you can read client based data/client local database.

.....
First i have to create .udb ( Ultra Lite) database file [ which i can create using sybase central ]
then create the table structure / using sync profile upload table structure..
then i have to upload this file into device.
and then i have to use scripting to use this file to update data , sync data ..... and so on.....
if i only have to do all these things then what SAP Mobile Platform is offering ?
I hope is am wrong and there should be some better way to use Device Database what SAP Mobile Platform is offering !
I

there is no way you can create udb file UltraLite tool.

i hope you have got better understanding now.

Regards,

Jitendra

[Former Member · Accepted solution]

Dear Jitendra,

thanks again for reply.

One point is clear now , .udb file generated/created in IOS development not with Android !

I am sure a lot of people doing SUP & Android Application development and can help me to get the file/approach to read device DB file name, how its created and how to access.

Once i get the help to locate device side db file , will find some way to access the same.

Please. help me to understand and locate device db file .

Reg

Navin