Searching whitepaper about external objects in Rollbase that map to Appserver API's - Forum - Rollbase - Progress Community

Searching whitepaper about external objects in Rollbase that map to Appserver API's

 Forum

Searching whitepaper about external objects in Rollbase that map to Appserver API's

This question is answered

Last week at the Exchange we learned that Rollbase allows to create external objects, that don't map to a database table using SQL, but instead map to CRUD methods in the Appserver (via REST-server). There is a whitepaper describing how this is done.

I am now assigned to do a POC/Prototype so I am searching for this whitepaper, really need it in a hurry. But can't find it. Please can someone point me to the location of that whitepaper?

Thanks,

Jurjen.

Verified Answer
  • I do not believe the specific white paper you mention exists, but there are ones that are similar or related.  I know that at Exchange 2013, there were dozens of sessions with information on whitepapers, roadmaps, and features, so there could be some confusion.  I hope this straightens this out -- I will say that I have not been involved with every white paper, but I have been a reviewer on many of them.

    Related Whitepapers:

    • White Paper: Accessing the OpenEdge AppsServer from Rollbase using Object Script
      • see: community.progress.com/community_groups/rollbase/m/documents/1160.aspx
      • This describes invoking business logic on the AppServer from Rollbase server or client coding.  You can use this to invoke CRUD operations defined in an OpenEdge Mobile Business Entity or any RESTful interface as well as invoking generic business logic methods, but this does not automatically create Rollbase Objects.
      • This whitepaper was posted on October 18, 2013.
    • Accessing the Progress OpenEdge AppServer from Progress Rollbase Using the JSDO
      • See: www.progress.com/.../white-papers or http://businessmaking.progress.com/forms/wpr-AccessingOEAppServerfromRollbaseJSDO
      • This is a whitepaper on the main Progress site, not Community, that describes how to integrate the JSDO from OpenEdge Mobile onto your Rollbase web client application.   (As noted in the thread, this is not what is requested because it is client-side access, not binding the JSDO to Rollbase server Objects.)
      • This is an older paper that was published in July/Aug 2013and works with older Rollbase instances (but is also a good description of how to use the OpenEdge Mobile JSDO with any generic web framework)
    • Calling ABL Business Logic from Rollbase via OpenClient 
      • This shows how to take Java Proxy and other OpenClient classes and use those in Rollbase Object Script.  

    The specific question in this thread is about creating Rollbase Objects tied to OpenEdge data structures.  

    • Creating Rollbase Objects tied to OpenEdge Database Tables is possible in the October Rollbase Release (v2.0).
      • This is not a white paper -- but rather a standard feature of Rollbase (as noted above in other responses)
      • See: http://www.progress.com/~/media/Progress/Documents/Rollbase/Rollbase%20in%20Action/appendixC.pdf
    • Creating Rollbase Objects tied to OpenEdge AppServer Business Entities 
      • This was released in December (v2.1).  This is a product feature, not a white paper.
      • What was announced at Exchange 2013 was the ability to create Rollbase Objects from DataDirect Cloud datasources, such as Salesforce.com.

    (and apologies to anyone who gets this response as an unwanted mail message ;-)

All Replies
  • Sure - have a look here businessmaking.progress.com/.../wpr-AccessingOEAppServerfromRollbaseJSDO. If you are familiar with oemobile jsdo this will be very, very easy to do.

  • Thanks John, but no that's a different whitepaper, not the one I am waiting for. The whitepaper you point at is a couple of months old and describes how to fetch data from client-side JScript (the script executes in the HTML browser). The whitepaper I am searching is about defining external objects where the CRUD actions map to appserver calls. Mike Ormerod said during the Exchange that this whitepaper is new, less than a couple of weeks old, and "somewhere on a website".

  • Hello Jurjen,

    Are you searching the Whitepaper "Accessing the Progress OpenEdge AppServer from Progress Rollbase Using the JSDO" on www.progress.com/.../white-papers

    Regards, Stefan

  • Hi Stefan, no not that whitepaper but a new one, about external objects. Thanks anyway

  • Not sure whether there is a distinct White Paper on External Tables in an OpenEdge RDBMS, however, there is Appendix C introducing the feature "external tables", see here:

    www.progress.com/.../appendixC.pdf

    Maybe that one gets you the answers?

    Regards, Stefan

  • Hi Stefan, external tables need to reside in the same database as the portal database and are not available on the hosted Rollbase.

    Jurjen asked about a WP for accessing the AppServer. To my knowledge that WP is still under review.

    Architect of the SmartComponent Library and WinKit

    Consultingwerk Ltd.

  • sorry Jurjen, I can't say I've seen the white paper you mention. "somewhere on a website" good luck finding that..... Although Mike's comments above suggest it maybe not available yet.

  • Still under review, that could be it. Thanks.

  • Hi Jurjen, you might check out that jdbc driver we've talk about last year... didn't implemented 'select over stored procedures' but added some 'view' component that works with select but delegate fetch to a business logic routine - no support for update on views just yet though :(

  • Chriselst, your response is very off-topic to this thread, you should and could have created a new question. Manage your subscriptions at page community.progress.com/.../forumsubscriptions.aspx

  • Please people, I agree that the default "you are now subscribed to everything" is annoying but please use your anger energy not for disturbing a conversation, but for finding a solution. Like, unsubscribe here: community.progress.com/.../forumsubscriptions.aspx

  • I do not believe the specific white paper you mention exists, but there are ones that are similar or related.  I know that at Exchange 2013, there were dozens of sessions with information on whitepapers, roadmaps, and features, so there could be some confusion.  I hope this straightens this out -- I will say that I have not been involved with every white paper, but I have been a reviewer on many of them.

    Related Whitepapers:

    • White Paper: Accessing the OpenEdge AppsServer from Rollbase using Object Script
      • see: community.progress.com/community_groups/rollbase/m/documents/1160.aspx
      • This describes invoking business logic on the AppServer from Rollbase server or client coding.  You can use this to invoke CRUD operations defined in an OpenEdge Mobile Business Entity or any RESTful interface as well as invoking generic business logic methods, but this does not automatically create Rollbase Objects.
      • This whitepaper was posted on October 18, 2013.
    • Accessing the Progress OpenEdge AppServer from Progress Rollbase Using the JSDO
      • See: www.progress.com/.../white-papers or http://businessmaking.progress.com/forms/wpr-AccessingOEAppServerfromRollbaseJSDO
      • This is a whitepaper on the main Progress site, not Community, that describes how to integrate the JSDO from OpenEdge Mobile onto your Rollbase web client application.   (As noted in the thread, this is not what is requested because it is client-side access, not binding the JSDO to Rollbase server Objects.)
      • This is an older paper that was published in July/Aug 2013and works with older Rollbase instances (but is also a good description of how to use the OpenEdge Mobile JSDO with any generic web framework)
    • Calling ABL Business Logic from Rollbase via OpenClient 
      • This shows how to take Java Proxy and other OpenClient classes and use those in Rollbase Object Script.  

    The specific question in this thread is about creating Rollbase Objects tied to OpenEdge data structures.  

    • Creating Rollbase Objects tied to OpenEdge Database Tables is possible in the October Rollbase Release (v2.0).
      • This is not a white paper -- but rather a standard feature of Rollbase (as noted above in other responses)
      • See: http://www.progress.com/~/media/Progress/Documents/Rollbase/Rollbase%20in%20Action/appendixC.pdf
    • Creating Rollbase Objects tied to OpenEdge AppServer Business Entities 
      • This was released in December (v2.1).  This is a product feature, not a white paper.
      • What was announced at Exchange 2013 was the ability to create Rollbase Objects from DataDirect Cloud datasources, such as Salesforce.com.

    (and apologies to anyone who gets this response as an unwanted mail message ;-)

  • Thanks for the detailed answer! I am afraid this will change our planning: wait for the December release.

    Thanks, Jurjen.

  • Hi Jurgen

    This paper should get posted in the next day or so.  I'll update the thread with the link once it's posted.

    Thanks

    Mike

  • The White Paper: Accessing the OpenEdge AppsServer from Rollbase using Object Script, has been posted (Oct 18)

    see: community.progress.com/community_groups/rollbase/m/documents/1160.aspx