How to Read device Database?

Follow RSS feed Like

5 Likes 2,538 Views 31 Comments

Dear All,

OBJECTIVE:

This Document explains steps how to Read device/client side database.

REQUIREMENT:

SUP 2.x

Procedure:

You are wondering how to access the client side database from SUP side.

You would have checked How to access SUP CDB (Cache Database) ?

Assuming that you have created MBO(s) and deployed successfully to SUP server. then the same package has been implemented with client side (iOS native) application.

once you run the application on device, a .udb file would be created on the same.Sybase creates a .udb file on the iOS native apps to keep the data synchronised from the unwired server. Every Unwired Server setup comes with Sybase Central as db tool. For accessing client side data, Ultralite Plugin is available in this tool.

Finding Out the path for Ultralite Tool:

go to the location: C:\Sybase\UnwiredPlatform\Servers\SQLAnywhere12\Bin32

look for scjview.exe

when you open it. A screen will be prompted like below:

Open the UltraLite 12 Plugin. Click on Connect to a database

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

Once you are connected to UltraLite 12, you would be seeing the contents related to database created on iOS device.

here, you can view details in a particular table like columns details, constraints, referencing constraints, indexes, data. You can navigate to ER diagram for a table.

I hope this document will help you to read the data available at client side.

Your comments/Suggestions are most welcome.

Regards,

Jitendra Kansal

Alert Moderator

31 Comments

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

Vikas Singh

April 29, 2013 at 6:05 am

Thanks for writing this . However, wondering how can you download the .udb file from the device ?
- Like(0)
- Jitendra Kansal Post author
  
  April 29, 2013 at 6:16 am
  
  Hi Vikas,
  
  it is very simple.
  
  once you run the app lets say in iPad device, you connect device with MAC machine, then move to organizer >Devices>Applications
  
  then you will the udb file. you can download it from there.
  
  Regards,
  
  Jitendra
  - Like(0)
  - Vikas Singh
    
    April 29, 2013 at 7:26 am
    
    Thanks but wondering if you know of any mechanism by which we can analyse udb files of remote users once the app is productive. They might not be in the same location ..so we can’t connect to macbook for analysis.
    
    Thanks,
    
    Vikas
    Like(0)
    - Jitendra Kansal Post author
      
      April 29, 2013 at 10:14 am
      
      Hi Vikas,
      
      i dont think so without connecting device to MAC machine (in case of iOS platform) we can do analysis.
      
      Regards,
      
      Jitendra
      
      Like(0)
Midhun VP

April 29, 2013 at 10:12 am

Nice Blog Bro. Keep it up.
- Like(0)
- Jitendra Kansal Post author
  
  April 29, 2013 at 10:16 am
  
  thanks Midhun. 🙂
  - Like(0)
  - Rakshit Doshi
    
    June 5, 2013 at 11:26 am
    
    Bahu fine 🙂 🙂 🙂
    Like(0)
Midhun VP

April 29, 2013 at 11:50 am

Jithendra, Whether this will work only when the device is connected to SQL DB or Is it gonna with if the device is connected to SAP as backend.
- Like(0)
- Jitendra Kansal Post author
  
  April 30, 2013 at 10:57 am
  
  Hi Midhun,
  
  i am not clear with your query. please explain.
  
  Regards,
  
  Jitendra
  - Like(0)
Former Member

April 30, 2013 at 6:27 pm

When I hit Connect (in the Connect to UltraLite db view), I am getting the following error:

“Could not connect to the database.

Data source name not found and no default driver specified.”

Any kind of settings that needs to be done prior to connecting to UltraLite databases? I am running SUP 2.1.3.
- Like(0)
- Jitendra Kansal Post author
  
  May 2, 2013 at 4:00 am
  
  Hi Guven,
  
  can u put the snapshot of that error. would be helpful to trace
  
  Regards,
  
  Jitendra
  - Like(0)
  - Former Member
    
    May 22, 2013 at 5:22 pm
    
    Problem solved Jitendra. The registry update wasn’t done before and that is why I got that error. After updating the registry with regsvr32 and with the dll, it worked fine.
    
    Thanks for your help.
    Like(0)
    - Former Member
      
      July 17, 2014 at 11:52 am
      
      Hellow
      
      Im getting the same error than you did
      
      can you please Specify the solution that you have implemented?
      
      I’m not getting as it is
      
      thansk a lot
      
      Like(0)
      - Former Member
        
        July 17, 2014 at 12:01 pm
        
        Unfortunately, I can’t remember the exact steps. Sathis Kumar was having a similar problem, maybe he can point you to the right direction. It was about missing jar/dll files that wouldn’t let you connect to the DB.
        
        Like(0)
Sumeet Shahapeti

May 11, 2013 at 7:18 am

Thanks.
- Like(0)
Former Member

June 5, 2013 at 6:55 am

Hi Jitendra,

when i want to connect to the udb file it says wrong or not existing encryption key. Any idea?

Thanks!
- Like(0)
- Jitendra Kansal Post author
  
  June 5, 2013 at 8:03 am
  
  Hi Florian,
  
  actually it should work without encrption key.
  
  is it possible you to share the steps you are following with.
  
  Regards,
  
  Jitendra
  - Like(0)
  - Former Member
    
    June 5, 2013 at 9:25 am
    
    Of Course,
    
    i run the app –> open organizer –> download udb-file –> put it from Mac to Win-Machine –> open Sybase Central 6.1.0 (the win machine isn´t the machine where the SUP runs, so it´s i had to download sybase central to use ultraLite12) –> open UltraLite 12 –> Connect with a database –> user “dba” password “sql” –> select Database file and click connect.
    
    Then i get the error: “Connection with database no possible. Wrong or missing encryption key”
    
    Thanks for your fast reply!
    
    Regards,
    
    Florian
    Like(0)
  - Former Member
    
    June 5, 2013 at 2:14 pm
    Hi Jitendra,
    
    i did it like you explained:
    
    Run iPad-App
    
    start Sync
    
    in Xcode–>Organizer download udb-File
    
    copied file from mac to win-machine
    
    opened Sybase Central 6.1.0 (the sup doesn´t run on this win machine so i had to install sybase central by myself)
    
    opened UltraLite12
    
    User: dba; pass: sql
    
    selected previously to win pc copied udb-file
    
    clicked Connect
    
    Got error: “Wrong or missing encryption key”
    
    Thank you!
    
    Regards,
    
    Florian
    Like(0)
    - Jitendra Kansal Post author
      
      June 6, 2013 at 4:44 am
      
      Hi Florian,
      
      it should not ask for any type of encryption key.
      
      i am wondering since you are running ultraLite on a machine where SUP is not installed.
      
      btw: how did you install sybase central on different machine? did u download it from somewhere? wont it possible for you to run sybase central on same machine where SUP has been installed.
      
      Regards,
      
      Jitendra
      
      Like(0)
      - Former Member
        
        June 18, 2013 at 8:04 am
        
        Hi Jitendra,
        
        sorry for my late reply. I downloaded it from Sybase but i can´t find the link anymore! The problem is that i don´t have access on the machine where SUP is installed!
        
        Regards,
        
        Florian
        
        Like(0)
- Former Member
  
  June 6, 2013 at 2:11 pm
  
  Hello Florian,
  
  I remember that SUP APIs provide a way to encrypt the database. Can you check your client side code to see if you are encrypting the database? The encryption is done via the [setEncryptionKey:] method, more details are in the link below:
  
  http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc01217.0212/doc/html/apr1272289920141.html
  
  If you are encrypting the database, then you will probably need that encryption key to be able to connect to the database.
  - Like(0)
  - Former Member
    
    June 7, 2013 at 7:46 am
    
    I didn´t thought about this although it´s pretty obvious! Of course this works 🙂
    
    Thank you very much!
    Like(0)
Former Member

June 10, 2013 at 10:04 am

Hi Jitendra,

I am getting this error while connecting the database

“Could not connect to the database.

Data source name not found and no default driver specified.” Can you please tell me why am getting this error.

Thanks in advance!

Sathis
- Like(0)
- Jitendra Kansal Post author
  
  June 10, 2013 at 2:00 pm
  
  Hi Sathish,
  
  can you please share snapshot of that error?
  
  Regards,
  
  Jitendra
  - Like(0)
  - Former Member
    
    June 17, 2013 at 7:12 am
    
    Hi Jitendra,
    
    Any luck to resolve the issue..? Please do let me know if there is clue.
    
    Thanks
    Like(0)
    - Jitendra Kansal Post author
      
      June 18, 2013 at 5:34 am
      
      Hi Sathis,
      
      this issue is related to some missing jar files. but i am unable to find where exactly the required jar files has to be pasted. i ll try once and let u know if i find something useful.
      
      Regards,
      
      Jitendra
      
      Like(0)
      - Former Member
        
        June 18, 2013 at 10:17 am
        
        Thanks Jitendra,
        
        Please do revert back to me if you find anything interesting.
        
        Like(0)
      - Former Member
        
        July 17, 2014 at 12:24 pm
        
        Hellow Sathis Kumar,
        
        How did you solve this issue?
        
        Cheers
        
        Like(0)
Former Member

June 11, 2013 at 7:04 am

Hi Jitendra,

PF the SS.
- Like(0)
/
Sergio Mauricio Mesa Londoño

June 11, 2013 at 3:06 pm

Great!, thanks Jitendra.
- Like(0)