The Max Out of APEX! Lessons from a large APEX project Spreker(s) : Jacob Beeuwkes & Wesley Lems Datum : 07-03-2016 E-mail : [email protected] WWW.TRANSFER-SOLUTIONS.COM Who is who? ■ Jacob Beeuwkes ■ Wesley Lems © WWW.TRANSFER-SOLUTIONS.COM 2 Transfer Solutions ■ Dutch IT Service company ■ Training ■ Design ■ Development ■ Implementation ■ Management (24*7) ■ 140 employees ■ Enthousiastic, co-creating, experts © WWW.TRANSFER-SOLUTIONS.COM 3 The Max Out Of APEX! Lessons from a large APEX project © WWW.TRANSFER-SOLUTIONS.COM 4 Outline ■ Introduction Vopak Agencies ■ The PortView project ■ 7 Lessons learned © WWW.TRANSFER-SOLUTIONS.COM 5 Introduction Vopak Agencies © WWW.TRANSFER-SOLUTIONS.COM 6 The PortView project © WWW.TRANSFER-SOLUTIONS.COM 7 The project ■ Agile approach, 3 wk sprints ■ Team ■ 4 APEX developers ■ 1 datamodeller ■ 1 tester ■ 1 team leader ■ Vopak staff (3) ■ >1 Year development ■ 1-3 deployments per sprint ■ Upgrade APEX 4.2 5.0 ■ Go live Spring 2016 © WWW.TRANSFER-SOLUTIONS.COM 8 The PortView application in a nutshell ■ Oracle 12c ■ One APEX 5 instance, multiple offices ■ Google OAuth2 authentication ■ Mail client (Google) ■ REST webservices integration ■ Jasper Reports © WWW.TRANSFER-SOLUTIONS.COM 9 Some figures… ■ 3 APEX applications ■ 7 schema’s ■ 170 tables ■ 160 pages ■ 450 packages ■ 6 offices ■ multiple timezones ■ 100 users ■ >8000 hours of development © WWW.TRANSFER-SOLUTIONS.COM 10
Description: