Going APEX 5: A Real Life Adventure

61 Pages·2015·2.72 MB·English

Going APEX 5: A Real Life Adventure
Dr. Eckhart Guthöhrlein, Dr. Alex Kohn
pRED Informatics, Roche Diagnostics GmbH
Features: Most Wanted
APEX at Roche
Migration Strategy
Developer’s Cut
Lessons Learnt
Features: Most Wanted
APEX at Roche
Migration Strategy
Developer’s Cut
Lessons Learnt
APEX 5: MOST WANTED FEATURES
What‘s New in APEX 5?
• Page Designer • Interactive Reports
– Cohesive User Experience – Multiple Reports on a Page
– Better Visual Representation – Pivot
– Drag and Drop – Fixed Headers
– Enhanced Code Editor
• Modal Dialogs
• Universal Theme
• LDAP Integration for App
– Theme Roller
Builder
– Template Options
– Responsive Design
• New HTML5 charts
Features: Most Wanted
APEX at Roche
Migration Strategy
Developer’s Cut
Lessons Learnt
APEX AT ROCHE
The Roche Group
• Founded 1896 in Basel, Switzerland
• Employing > 82000 people
• Clear focus on healthcare

• Roche Innovation Center Penzberg
• Pharma Research and Early
Development (pRED) Informatics
• Provide informatics and bioinformatics
services and tools to researchers
Roche Innovation Center Penzberg
pRED Informatics

Located between Munich and the Alps in Southern Bavaria
APEX at Roche Pharma Research
• over 2000 employees at seven sites around the world
• >100 APEX applications
– Data visualization, Reporting, Process analysis and optimization
– Inventories, Request Handling, Project Management
– Masterdata and controlled vocabulary
– Platform administration for APEX and DWH (security, monitoring)
– many ad-hoc solutions for services and projects
What Does Our pREDi APEX Platform Offer
Beyond the Standard?
ASMA
• Central place for the
security management
of all APEX
applications
• PL/SQL package for
querying the Roche
LDAP
• Integrated into APEX
Alex Kohn, APEX: Zentrale Rechteverwaltung aller Applikationen leicht
Application Builder
gemacht, DOAG 2014.
What Does Our pREDi APEX Platform Offer
Beyond the Standard?
ASMA
Single Sign
On
Automatic Sign-On using
Windows Credentials