Part 2: Creating a Oracle DB connection profile in SAP Mobile Workspace 2.3:

Part 1 gives a clear understanding of how we can install and setup a connection in Oracle DB.

Steps:

  1. Right Click Database Connection in Enterprise Explorer,

  

    • Select New> Oracle> Give some connection profile name
    • Specify required DB driver details
    • Select Oracle Thin Driver and move to Jar List option as showing in below screenshot
    • You must be seeing ojdbc14.jar file already available there, remove it
    • Click on Add JAR, look for jar file available in installed Oracle DB path (D:\app\Administrator\product\11.2.0\dbhome_1\owb\wf\lib)

                    workspace1.PNG

    • Provide required SID (Global Database name, it is same id what you would set in step 6 of Part 1.
    • Required user name and password
    • Test the connection

                    connection.PNG

2.   Once the connection is successful, you would see lots of Schemas available under newly created connection. Select any table available in any Schemas.

          EmpTable.PNG

Make sure you copy the same odjc14.jar file in below location:

C:\SAP\MobilePlatform\Servers\UnwiredServer\lib\3rdparty

C:\SAP\MobilePlatform\MobileSDK23\MobileWorkSpace\mobile\eclipse\plugins\com.sybase.uep.com.oracle_2.3.0.201301212158\lib

3. For easy understanding, i have selected EMPLOYEES table under  HR Schema. Drag and drop this to create an MBO.

                    empMBO.PNG

From this step onward, we can go with any MBO mobile application development connecting to Oracle DB.

Rgrds,

Jitendra

To report this post you need to login first.

1 Comment

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

  1. Suseelan Hari

    Hi Jitendra,

    Good Day!

    Updating new in SMP module and thanks for sharing about “Creating a Oracle DB connection profile in SAP Mobile Workspace 2.3”. It is very useful for me to discuss with our SMP team. All the best!

    Regards,

    Hari Suseelan

    (0) 

Leave a Reply