Progress Rollbase for Open Edge Developers Introduction Overview

Progress Rollbase for Open. Edge Developers Introduction & Overview April 2014

Rollbase in Action 9 © 2013 Progress Software Corporation. All rights reserved.

Core Concepts: Objects, Fields, Relationships and Cardinalities § Applications are data-driven – Objects are the core business entities § Objects have properties and attributes associated with them § Objects have Fields associated with them § Object relationships and cardinalities are modeled visually § Underlying database physics are completely hidden – it‘s a. Paa. S ! 10 © 2013 Progress Software Corporation. All rights reserved.

Building the User Interface (UI) § Build UI using integrated WYSIWYG editor § UI Tabs are automatically generated for each Object § Page elements are created and edited using drag-and-drop § Changes immediately reflected in the UI 12 © 2013 Progress Software Corporation. All rights reserved.

Deploying Applications § Applications can be published and accessible via a user-facing Portal § Several Portals can be defined per Application § Fine-grained (user/role) authentication and access control fully configurable 13 © 2013 Progress Software Corporation. All rights reserved.

Rollbase with Open. Edge 24 © 2013 Progress Software Corporation. All rights reserved.

Rollbase and Open. Edge Integration Options (OE 11. 3. 2+) § Open. Edge Service Objects § Data. Direct Cloud (aka D 2 C) § External tables with auxiliary databases Open. Edge 25 © 2013 Progress Software Corporation. All rights reserved. Rollbase

Open. Edge Service Objects: The “Preferred” Approach § Rollbase Objects based on Open. Edge “Business Entities” ü OERA-certified ü Builds on Java. Script Data Object (JSDO) Catalog in Open. Edge Mobile ü First priority for Rollbase work: “Parity with native objects” § Phased implementation – current functionality: • Tenant-based identity • Single Table Pro. Data. Set • Direct CRUD support - INVOKE done in Object. Script 26 © 2013 Progress Software Corporation. All rights reserved.

Open. Edge Service Objects Rollbase Server Rollbase Objects Tomcat JSDO Catalog RB Server REST JDBC driver App. Server Business Entities HTTP/JSON RB DB RB Schema Rollbase tables 28 REST Adapter Open. Edge App. Server © 2013 Progress Software Corporation. All rights reserved. (REST) OE DB PUB Schema your tables

Data. Direct Cloud + Open. Edge RDBMS § D 2 C Server runs in Amazon cloud ü Served by Open. Edge RDBMS ü Your application's data is on your server ü Enables building new, hosted, customized Web Applications on Partner and DEU platforms ü 10. 2 B onward § Rollbase runs either hosted or on-premise • Rollbase talks to D 2 C • D 2 C talks to your server § Limitations: • Latency can be high § Access to Database, not Business Logic 29 © 2013 Progress Software Corporation. All rights reserved.

Data. Direct Cloud + Open. Edge RDBMS Rollbase Server Rollbase Objects RB Server tcp/ip JDBC driver RB DB RB Schema Rollbase tables 31 Open. Edge App. Server Data. Direct Cloud © 2013 Progress Software Corporation. All rights reserved. JDBC Driver: OEDB tcp/ip OE SQL Server JDBC Driver: … OE DB PUB Schema your tables

"External" tables – On Premise Only § Rollbase on-premise has a database • Rollbase has about 25 tables • Tables used by Rollbase are in the RB schema • Do not touch these tables § The "external" tables must be in the SAME database • In a different schema, e. g. PUB Limitations • Cannot modify schema in Rollbase • Must be in shared namespace and single database • Must have a unique numeric column or text column 32 © 2013 Progress Software Corporation. All rights reserved.

External Tables + Open. Edge RDBMS On-premise Rollbase Server Open. Edge App. Server Rollbase Objects RB Server JDBC driver tcp/ip OE SQL Server OEDB RB Schema Rollbase tables PUB Schema your tables One and only one database 33 © 2013 Progress Software Corporation. All rights reserved.

External tables with auxiliary databases § Open. Edge SQL Server process serves data from multiple databases § Main database is read-write • Contains Rollbase tables only § Auxiliary databases are read-only to Rollbase • Auxiliary db contains your application's tables • Must be on same system as main database • Property file describes auxiliary database and names the tables therein • User id for main and auxiliary db must be the same • Rollbase thinks there is just one database 34 © 2013 Progress Software Corporation. All rights reserved.

External Tables + Open. Edge RDBMS Rollbase Server Rollbase Objects Open. Edge App. Server RB Server JDBC driver tcp/ip RB DB 35 © 2013 Progress Software Corporation. All rights reserved. multidatabase property file OE SQL Server OE DB RB Schema Rollbase tables PUB Schema your tables main database auxiliary database

Documentation References Topic Rollbase Where http: //www. progress. com/docs/ebooks/Roll base_in_Action. pdf Open. Edge Service Objects Rollbase In Action, Appendix E, Creating Rollbase Objects From Open. Edge Services Open. Edge SQL Development, Performing Multidatabase Queries Multi-database connection property files Data. Direct Cloud 36 © 2013 Progress Software Corporation. All rights reserved. Rollbase In Action, Using Rollbase With Data. Direct Cloud

In Summary… § You can support separate Open. Edge and Rollbase applications • Open. Edge application is Client/Server • Can be used to provide existing app on web and mobile devices § You can create new module in Rollbase for existing Open. Edge application • Open. Edge application in n-tier • Can be launched from existing Open. Edge app If On-Premise , use… Open. Edge Service Objects - On-Premise/Private Cloud - HTTPS (moving to native) - Basic-Auth/HTTPS - Open. Edge 11. 3. 2+ 43 © 2013 Progress Software Corporation. All rights reserved. If Rollbase is hosted, use… Data. Direct Cloud - OE On-premise - Database Security/SSL - Open. Edge 10. 2 B+ Limited use for External tables - mostly read-only - don’t rely on OE triggers - one database/PUB schema - latest OE is best