beyond
APEX 18.1
Niels de Bruijn, Business Unit Manager APEX
09 -AUG-2018
2
Facts & Figures
Independent Technology House
with Cross-Industry Expertise
Headquarter
Ratingen
(North Rhine Westphalia)
260
employed
Founded
1994
Branches
Cologne &
Frankfurt am Main
Top Company
for Trainees &
Students
Privately-
Owned
Corporation
Oracle
Platinum
Partner
28 Mio. Euro
Revenue
Beyond APEX 18.1
3
About me
Niels de Bruijn, Business Unit Manager APEX
Born in 1977, married, three daughters, living in Ratingen
Working for MT AG since DEC-2003
After working for 2 years as Oracle consultant for Oracle Nederland B.V.
Track record with APEX since its inception
Responsible for all APEX activity in the company
Knowledge Portal: apex.mt-ag.com
Presenting at Kscope, DOAG Conference, APEX Connect and APEX World amongst others
ODTUG - Part of APEX Content Committee for Kscope
DOAG Initiator & Conference Chair of DOAG APEX Connect (apex.doag.org)
Beyond APEX 18.1
! knowledgebase.mt-ag.com!
4
APEX Visualizer
APEX QA-Plugin
APEX API Generator
APEX Page Generator
XLSX & PPTX Generator
Puppeteer for APEX
MT Tools apex.mt-ag.com/tools
5
6
Beyond APEX 18.1
Beyond APEX 18.1
APEX 18.1
Single Sign-On
CSV or XLSX Import
Support for other output channels
Drilldown Reporting
Continuous Integration
Automated Testing
Enhanced Tree
Workflow
Single Page Applications
Offline Capability
WebSockets
7
Single Sign-On it is not an option!
Beyond APEX 18.1
APEX & Identity Provider in LAN?
Take a look at my SSO document:
https://www.edocr.com/v/lv1rvxvx/nielsdebruijn/Single-Sign-On-for-Oracle-Application-
Express-APEX
APEX in the cloud, but Identity Provider on-premises?
Leave the server with Apache & ORDS on-premises
Identity Provider in the cloud?
SAMLv2 Authentication with Azure AD:
https://cdn2.hubspot.net/hubfs/1918225/Blog/azure_apex_integration_guide.pdf
Remark: my own experiences with this setup will soon be published
8
CSV or XLSX Import
Beyond APEX 18.1
APEX 18.1 still supports CSV import only (Data Load" feature)
Sup