Transcription
Oracle APEXNew Features & RoadmapMarc SewtzDirector of Software DevelopmentOracle APEXmarc.sewtz@oracle.comTwitter: @msewtz #orclAPEX
What is Oracle APEX?Oracle Application Express (APEX) is a low-code development platformthat enables you to build scalable, secure enterprise apps, with world-classfeatures, that can be deployed anywhere.Using APEX, developers can quickly develop and deploy compelling appsthat solve real problems and provide immediate value.You won't need to be an expert in a vast array of technologies to deliversophisticated solutions.Focus on solving the problem and let APEX take care of the rest.3
Oracle APEX Low Code Application DevelopmentWorld’s most popularEnterprise Low Code Platform Over 140 countries across all industriesOver 2,000,000 active appsOver 3,000 apps created per dayOver 500,000 DevelopersUsed by professional, workgroup andcitizen developersActive CommunityUse Cases Opportunistic Apps Enterprise Apps Reporting and Analytics SaaS Extensions Spreadsheet Replacement Loved by enthusiastic developer community Global conferences and events Strong engagement on social media #orclapex4
Oracle APEX AvailabilityOracle CloudOn PremisesThird Party Cloud Autonomous DBServerless (ATP, ADW) Autonomous DBDedicated APEX Service Database Cloud Service(DBCS) apex.oracle.com(free schema service) Oracle Database XE(free database) Oracle Enterprise Edition(and all other editions) Oracle Exadata Amazon RDSFor Oracle Database Any third-party Cloud /Hosting provider thatsupports Oracle DBapex.oracle.com/en/learn/getting-started/5
Demo
2021 Recap& Announcements
2021 APEX RecapJanuary 2021APEX Service launches!May 2021APEX 21.1 ReleaseJuly 2021APEX ORDS under FUTC LicenseAugust 2021Launch of APEX Ideas AppSeptember 2021Low Code Reference Architecture PublishedNovember 2021APEX 21.2 Release8
Replay Flows for APEX 21.1apex.oracle.com/officehours9
Next on Oracle APEX Office HoursFebruary 17, 2022Vanity URL Extensions for APEX and ORDS on OracleAutonomous DatabaseTodd BottgerPM Director, Oracle Databaseapex.oracle.com/officehours10
Oracle APEX in 2020 & 2021 APEX 20.1 (April 23, 2020) Redwood, Friendly URLs, Lifecycle Management APEX 20.2 (October 21, 2020) Cards, Automations, REST Sync, Native PDF & Excel APEX 21.1 (May 12, 2021) Maps, App Data Loading, Native Markdown APEX 21.2 (November 24, 2021) Smart Filters, PWA, Custom Positions11
Oracle APEX GitHub RepositoryThe official APEX GitHub repository is here!You can get sample apps, starter apps, plug-ins, and more.oracle.github.io/apexSample AppsThese are apps designed to highlightspecific functionality and areintended to serve as a developerguide on how to use a particularfeature.12Starter AppsThese are functional apps that are standalone point-solutions designed to meetsimple requirements. You can use theseapps out of the box, or make changes tosuit your needs.
apex.oracle.com/ideas
3,400 31Distinct Users470 Ideas14Distinct Countries600 Comments Posted3,700 Votes Cast
Oracle APEX 21.xNew Features
APEX 21.1 New Features16Maps RegionNew Data Picker Item TypeNew Application Data LoadingSecurity ImprovementsFaceted Search EnhancementsDeveloper ExperienceUI and Theme Roller UpdatesReporting ImprovementsImprovements to REST Data SourcesAdditional FeaturesNative Markdown SupportJavaScript Library Upgrades
APEX 21.2 New FeaturesSmart Filters Custom Positions .Geocoding and Address NormalizationSAML Authentication in the BuilderFaceted Search EnhancementsInclude Images in Report PrintingStatic File EditorEmail Template for Send EmailData PackagerSQL Commands supports 32kREST Data Source CatalogsAdditional Runtime LanguagesDeclarative PWA 17
Smart Filters New search component that allows users toquickly narrow data down with filterssuggestions or search terms Features a powerful Search Bar that providesbuilt-in auto-complete for your filters, supportssearching for multiple terms, and provides easykeyboard navigation. Filters are evaluated against your data anddisplayed below the search bar as chips18
Custom Positions for Page Components Provides greater control over the positioning ofpage components (regions, items, buttons) tobuild more complex layouts. Position any page component in any position. You can now render page components incustom positions that are defined by the pageor region templates. Page or Region Templates can now specifywhich components are allowed for custompositions (only regions, only items, onlybuttons, or a combination of those three).19
Declarative Progressive Web Applications (PWA) Ability to install an APEX app as a ProgressiveWeb App (PWA) Adds PWA install-ability option to the CreateApp wizard Provides installation instructions when needed,tailored for any device and browser Serves a customizable offline page when usersare offline and can't request the network Improves page load rendering time with a newbrowser cache architecture for static files (APEXcore files and APEX app files)20
New FeaturesDemo
Oracle APEX Roadmap Extended Support for MySQL Extend support for MySQL Databases byenabling the MySQL SQL dialect to be used foradvanced capabilities of APEX. Workflow Support for integrated workflow capabilitiesthat provide human workflow with actionableemails, unified task list, and connectivity toexternal services with pre-built connectors. Dialog UX Update for IG/IR 22Improved UI and consistency of IG and IRdialogs. Visual Application Logic Provide a visual representation of application logicincluding page flow and client side interactions. SQL Workshop modernization Modern Object Browser with support for more objecttypes and better accessibility. Built-In Data Generator Intelligently generate data in CSV, JSON or SQL formats,or insert sample data directly into tables within yourschema.
Oracle APEX Roadmap Easier Sample / Starter apps installation Provide wizard-based installation experience, that downloadsand installs apps directly from GitHub. Improved printing and PDF export Expanded configuration and user interface options for reportprinting, and interface to PDF printing service with ORDS. Expanded Capabilities in APEX Service Cloud Console Improved integration of APEX within cloud service console toenable easy access to monitoring, alerts, and other commontasks. Integration with developer lifecycle services 23Improved integration with cloud-based and on-prem sourcecode control and CI/CD pipeline automation.Learn more at: apex.oracle.com/sod
Q&A24
What is Oracle APEX? 3 Oracle Application Express (APEX) is a low-code development platform that enables you to build scalable, secure enterprise apps, with world-class features, that can be deployed anywhere. Using APEX, developers can quickly develop and deploy compelling apps that solve real problems and provide immediate value.
