Visual Builder

Get Involved. Join the Conversation.

Topic

    Mohammed Baig
    Best approach to expose custom database...Answered
    Topic posted October 31, 2019 by Mohammed BaigGreen Ribbon: 100+ Points, tagged Custom Code, Database, REST, Tip 
    63 Views, 4 Comments
    Title:
    Best approach to expose custom database objects/functionality as Rest service, to consume in VBCS
    Summary:
    Best approach to expose custom database objects/functionality as Rest service, to consume in VBCS
    Content:


    Experts,

    We need your help in identifying the best option to expose the custom database objects or custom functionality as a Rest service which can be consumed in VBCS application.

    1. ADF BC Rest - We don't have JCS at moment but if its best option we can get back to customer.
    2. OIC Integrations as Rest - Already subscribed along with VBCS
    3. ORDS - We have custom database of size 15gb 

    FYI, we have already developed an application which is in production now, where we used Oracle JET and ADB BC combination for another customer.

    For this new customer, we have adapted the VBCS and looking for best option to expose Rest services for custom db objects/functionality. 

    Appreciate your response with cons and pros for each of the above approaches Or any other approach apart from the above three. We don't have any skill set limitations.

    Thank you

    Best Comment

    Shay Shmeltzer

    I don't think there is a single answer here, there are various considerations you can take.

    Some things to think about:

    1. ORDS - Free with the DB, requires you to code business logic in PL/SQL, consider if/how you are going to implement role based security - VB uses IDCS to get user/roles, I don't think that ORDS has direct integration with IDCS so if you need to do something like only return specific set of records based on a user - you'll need to figure out a solution for this. 

    2. OIC - Will require you to build each operation for a DB interaction (Doesn't have an expose table operation wizard).

    3. ADF BC - require WebLogic/JCS, coding in Java, VB knows how to parse the describe document ADF BC provides and do things like sorting/pagination/query by example out of the box. While JCS has integration with IDCS - if you opt for other options such as WebLogic Cloud - you might need to figure out SSO options.

     

     

    Comment

     

    • Shay Shmeltzer

      I don't think there is a single answer here, there are various considerations you can take.

      Some things to think about:

      1. ORDS - Free with the DB, requires you to code business logic in PL/SQL, consider if/how you are going to implement role based security - VB uses IDCS to get user/roles, I don't think that ORDS has direct integration with IDCS so if you need to do something like only return specific set of records based on a user - you'll need to figure out a solution for this. 

      2. OIC - Will require you to build each operation for a DB interaction (Doesn't have an expose table operation wizard).

      3. ADF BC - require WebLogic/JCS, coding in Java, VB knows how to parse the describe document ADF BC provides and do things like sorting/pagination/query by example out of the box. While JCS has integration with IDCS - if you opt for other options such as WebLogic Cloud - you might need to figure out SSO options.