low code ‘data first’ development › bizzabo.users.files › 130770...• model over code...

Copyright © 2017 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential: Internal Use Only

Low Code ‘Data First’ Development

RMOUG

[email protected]

Senior Principal Product ManagerServer TechnologiesOracle America, Inc. February, 2018

mailto:[email protected]


David PeakeSenior Principal Product Manager, Application Express

• With Oracle since 1993

• Started in Oracle Consulting in Australia, New Zealand and USA.

• Responsible for APEX Product Management since 2006

• Based in Denver, Colorado

• @orcl_dpeake


Safe Harbor Statement

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.


• Most of IT Budget spent developing, maintaining, enhancing core company-wide applications– Very little remaining budget / resources for new initiatives

• Spreadsheets used for making major business decisions– Insecure, non-scalable, multiple sources of the truth

• Departments need apps to compete and stay competitive in a very rapidly evolvingmarketplace– Can’t wait for IT to develop apps for them

• IT see Departments as renegades– Do not follow IT standards or procedures

• Departments see IT as a roadblock– Frustrated that requests for help from IT are ignored or put into large backlog

Big Problems Facing ITDepartments are very needy!


• Introduce “Bi-Modal IT”– One IT group concentrates on core systems

– Other IT group builds new apps as quickly as possible

• Use Low-Code Frameworks to improve ROI with limited budget / resources

• IT Professionals can build using low-code to greatly increase speed and agility

• Citizen Developers can also build using low-code– Non-IT professionals = Don’t have Computer Science or related degree

– Best if some coding experience = Spreadsheet macros / Desktop tools

– Don’t work within the IT Department

• IT should be advocates / mentors for Citizen Developers as needed– Improving apps with JS, HTML, CSS

– Help model data; Access existing data sets

– Encourage adoption of standards and proper processes

The SolutionUtilizing Low-Code Frameworks


• Departments form Shadow IT when IT not meeting requirements

• Problems being solved at the source

• Meets critical requirements faster than waiting for IT

• No adherence to standards, company practices, consistency

• Poor integration

• Duplication of apps and data

• Often developed by contractors / interns on short-term assignments

• Once apps get too large / unmanageable thrown over to IT to resolve

The Alternative = Shadow ITThe good, the bad, and the ugly


• Low barrier of entry – Easy to learn (Not overly complex)

– Fast to develop applications

– Simple to deploy

• High Productivity– Drag and Drop

– Feature functions

– Consistency

– High fidelity

• Concentrate on business requirements not low-level coding

• Automate / improve poor business practices

• IT Professionals can extend using JavaScript, HTML, CSS

Why Low-Code Frameworks?Not just a buzz phrase


• Increased number of developers – More hands on deck

• Empowers employees and their department

• Boosts productivity – Great ROI

• Greatly enhances requirements gathering

• Decentralizes application development

• Fosters collaboration, not confrontation, between departments and IT

• Improved engagement / shared ownership

• Can free up IT professionals for higher-order problems

• The apps they build will be easier to maintain / enhance

Why Work with Citizen Developers?Your new best friend


Low Code Tools

Oracle Application

Express


11

Copyright © 2017 Oracle and/or its affiliates. All rights reserved.

Application Development Complexity

Control

Productivity

NoCodeCitizenDeveloper

LowCodeDepartmentalIT

FullControlCorporateIT


12


Gradual Transition of Complexity Example


13




Application Development Productivity

Control

Pro

du

ctiv

ity




No CodeHigh ProductivityBusiness Users4GL Meta Data Properties

ProgrammaticHigh Control

IT Professional3GL Procedural Code / Libraries

User Interface

Browser Client Interaction

Business Logic

Oracle APEXHigh productivity AppDev components on the no code to highly programmatic spectrum

Components & Data Access

Navigation & Page Flow

Access Control &Session Management

Low CodeMore ControlCitizen DeveloperSnippets and plugins

Copyright © 2017 Oracle and/or its affiliates. All rights reserved. |

DemonstrationLow Code Challenge

Copyright © 2017 Oracle and/or its affiliates. All rights reserved. |

More InformationOracle Application Express (APEX)


High Productivity Rapid App Dev for Oracle• Model over code – Easy development of reports, charts, forms, editable grids, and all classes of data visualization

• Low Code Support – Declarative support for business logic, UI, dynamic client interactions

• One-button application deployment – Easy export and import of application definition, both from command line and Web UI

• One-button revision control – Granular application definition export for integration into source code management systems

• Live prototyping – Immediate results, no intermediate deployment steps.

• Multiple runtime platforms – Runs on premises in any Oracle DB, Oracle Cloud, other clouds

• Support SOA – Consume both REST and SOAP Web services. Create REST Services

• Smart Application Connectors – Programmatic integration with Oracle eBusiness Suite, Oracle SaaS.

• Collaborative Development – Multi-user concurrent development

• Social Development – Broad support for community extensions via plug-ins

• Real-time analytics of usage – Real time performance monitoring of applications

• Desktop Web UI – Desktop UI out of the box, easily customized

• Mobile Web UI – Responsive and accessible Web UI with no additional development necessary.


Oracle APEXLow Code Application Development (http://apex.oracle.com/lowcode)


Useful Links

• APEX & Low Code http://apex.oracle.com/lowcode

• Quick SQL http://apex.oracle.com/quicksql

• APEX Community http://apex.oracle.com/community

• Free APEX Service http://apex.oracle.com

• Database Cloud Services http://cloud.oracle.com/database

Collateral, Resources and Hosted Services

http://apex.oracle.com/lowcode

http://apex.oracle.com/quicksql

http://apex.oracle.com/community

http://apex.oracle.com

http://cloud.oracle.com/database


Videos

• APEX YouTube Channel: https://www.youtube.com/channel/UCEpIXFjcQIztReQNLymvYrQ

• Sign up for APEX workspace – 1 minute: https://youtu.be/xnKpvoKnwdk

• Design Data Model – 2 minutes: https://youtu.be/BCs2jWkdVFg

• Develop Application – 1 minute: https://youtu.be/Qnxj56uqMAM

• Deploy Application – 1 minute: https://youtu.be/1Vsg6rJx4CI

https://www.youtube.com/channel/UCEpIXFjcQIztReQNLymvYrQ

https://youtu.be/xnKpvoKnwdk

https://youtu.be/BCs2jWkdVFg

https://youtu.be/Qnxj56uqMAM

https://youtu.be/1Vsg6rJx4CI


Oracle Application Express (APEX) Goals

• Enablement of Shadow IT; Citizen Developers; Business unit empowerment

• Enable gradual transition from no code to full programmatic control

• Declarative App Dev abstracted from rapidly changing JavaScript, CSS and HTML

• Stable platform with full version compatibility; run an app developed 14 years ago

• Full “platform” for full life cycle application management (deployment, testing, …)

• Browser based development with concurrent multi developer app dev

• Cloud; available for free (apex.oracle.com) and with all Oracle DB cloud services

• Identical product offering on cloud and on prem; includes self service provisioning

• Productivity Apps (pre-built Apps)

• Exploit Oracle database app dev, SQL data access, portability, and scalability


Oracle Application Express (APEX) Goals

• Native RESTful data access complementing local and remote SQL data access

• Live prototyping; immediately make and see changes

• Real time analytics of developer and end user activity, performance, and use

• Leverage metadata models to create richer components “blueprints”

• Leverage large and growing community


Use SQL and Oracle database features to develop apps

Oracle Application Express (APEX) Primary Uses Cases

Rapid application development of database centric applications from

your web browser

Visualize and maintaindatabase data for desktop

and mobile

Extending enterprise application solutions

Modernizing legacy applications


2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017

APEX History

1.5 HTML DB1.5 - First Release1.6 - Themes

3.0 Flash ChartsPDF PrintingAccess MigrationTabular Forms

4.0 WebsheetsDynamic ActionsPlug-InsTeam Development

2.0 SQL Workshop2.1 - Oracle XE2.2 - Dictionary Views

5.0 Page DesignerUniversal ThemeModal Dialogs

2011Data UploadError HandlingROWID

4.1

2009Oracle Forms to APEXConversion

3.2

2012Mobile with JQueryHTML 5Packaged Apps

4.2

2008Interactive Reports

3.1 Interactive Data Grid (IG)Jet ChartsSimplified WizardsLive Template OptionsImproved Universal ThemeFont APEXImproved Packaged Apps

5.1


Oracle Application Express (APEX) Oracle APEX is available in the following products and services

• On premises APEX is available with:– All Oracle Database releases

• 11gR2, 12cR1, 12cR2

– All Oracle Database Editions• All for-cost editions SE2, EE

• And our free edition XE

• Compatible with all database options including RAC, RAC One Node, partitioning, compression, spatial, …

– Oracle Key Vault• since 2014

– Oracle Audit Vault and Database Firewall• since 2011

• Cloud Services with APEX include:– Oracle DBaaS – full instance (since 2014)

• SE, EE, EE high performance, EE extreme performance

• APEX installed and configured by default

– Oracle Database Cloud Schema Service• S5, S20, S50 services since since 2012

• BI Cloud Service

– Oracle Exadata Service• Since 2015

– Oracle Database Exadata Express Cloud Service• Released September 2016

– apex.oracle.com• Free evaluation APEX service since 2001

• 30K active tenants, 1m+ daily page views

– Oracle Database Free Service• Coming soon: also includes Type 3 JDBC driver, SODA

low code ‘data first’ development › bizzabo.users.files › 130770...• model over code...

Documents