Abstracts APEX World 2017

Michael Hichwa

Oracle US

VP Software Development

ENG


Keynote 1, Thursday March 30, 09:30 - 10:30

Oracle APEX Past, Present, and Future

Revisit the early days of Oracle APEX and learn the principals that drove the initial development and continues to drive APEX development 17 years on. Mike will cover declarative development, database centric application development, opportunistic development and the agile process. See how the Oracle APEX engine delivers modern user experience by transparently leveraging advanced JavaScript, HTML, CSS and AJAX. Review how the Oracle APEX platform uniquely allows applications written years ago to be infused with new technology without disruptive rewrites. Review new APEX productivity apps and recommended design principals. Also get Mike’s vision and wish list for future Application Express releases.


Keynote 3, Friday March 31, 09:00 - 10:00

RAD Challenge: Build a Real World Application in 60 Minutes

Your primary users have just defined a brand new business requirement they want to prototype! See how in the space of 60 minutes you can go from napkin design to working prototype.

Starting with Quick SQL, a new Packaged App introduced in APEX 5.1, Mike will build out the required tables and even populate them with some sample data. Then using a new extension framework he will build out the initial application, complete with some primary components needed to deliver a fully featured prototype application.


 


Hilary Farrell

Oracle US

Consulting Member of Technical Staff

ENG

 

Advanced Charts in APEX 5.1 and Beyond...

Oracle Application Express 5.1 introduced a new charting engine based on the Data Visualization components of Oracle JavaScript Extension Toolkit (Oracle JET). This JavaScript charting solution is highly customizable, accessible, interactive, and incorporates automatic responsive design support. In this session we’ll explore how you can take full advantage of the built-in capabilities, how you can link up your charts with dynamic actions to create a truly interactive experience for your users and how you can utilize the JavaScript APIs to further customize your charts, to make your charts fly with Oracle JET. We'll also take a peek at what's to come in APEX 5.2 in the area of charting.


 



Shakeeb Rahman

Oracle US

UI Architect

ENG


Keynote 4, Friday March 31, 16.00 - 17.00 The Center of Universal Theme
The Universal Theme empowered developers to build beautiful, responsive, accessible apps without becoming experts in HTML, CSS or JavaScript. This session will introduce you to improvements and updates to Universal Theme in Application Express 5.1, and how to take full advantage of all that it has to offer. Learn directly from the creator of the Universal Theme as we discuss new features, best practices, and advanced techniques. Together, we'll journey to the center of the Universal Theme and discover how to take our apps to the next level.


 


Geertjan Wielenga

Oracle

Principal Product Manager

English

Level: Beginner


Finally, JavaScript Is Easy, with Oracle JET!

Oracle JET (oralejet.org) is Oracle's JavaScript toolkit, including data visualizations, architectures, templates, components, and a range of enterprise solutions, such as modularity, internationalization, and accessibility. It is the platform used by Oracle itself for the creation of user interfaces that interact with Oracle Cloud services. It is open sourced on GitHub.

In this session, you'll be introduced to Oracle JET and you'll learn about the latest new features and the direction in which Oracle JET is going.


Speaker/Bio

Geertjan Wielenga is an Oracle product manager for Oracle JET (oraclejet.org).


 


Moritz Klein

MT AG

Senior Consultant

English

Level: Expert


APEX Generator - The Clone Wars

A recent project included about 60 master data tables in the data model, not counting the additional tables for all those with translations. It was also known upfront that the number would increase even more and those tables could also change often during the project. Some objects will get translations added, others get new attributes and so on, whatever change you can think of.

So it was immediately clear from the start that we wouldn't be able to focus on any business functions if we needed to constantly adapt and create master data pages by hand.

Laying out our options we had the idea of letting the database create those pages. If we wouldn't have to worry about changes on master data pages and testing those every time it would free a lot of time to focus on business functions.

At this point the idea of the APEX Generator was born.

By using the Data Dictionary to get available objects and their definition and fetching additional meta data from the APEX dictionary we were able to generate fully functional pages for those objects.

Just imagine regenerating an application with 120 pages within seconds.

The attendees will be shown the wealth of information they already have in APEX and the database and how to exploit this information for their own projects.

Some Live-Runs of the "APEX Generator" will also be included.


Speaker/Bio

Moritz Klein has been working with Oracle technology since early 2001.

He started using Oracle Application Express with it's first public release which was called HTMLDB in 2004.

Moritz shares his knowledge through his blog, on Twitter and by speaking at national and international conferences like the DOAG Annual Conference, APEX Connect and APEX World.

After 6 years working for Ericsson as Data Warehouse Specialist, he joined MT AG as Senior Consultant in November 2015.

His main areas are Data Modeling, PL/SQL and Oracle APEX.


 

Bart Peeters

iAdvise

Senior Oracle Consultant

NL

Level: Beginner


Wit-Gele Kruis en Oracle APEX, een match met zorg gekozen

Optimale zorg bieden aan de patiënten, dat is de doelstelling van Wit-Gele Kruis. Thuisverpleegkundigen, medewerkers die gezinshulp bieden, medewerkers in de zorgcentrale…, allen dragen ze bij om onze doelstelling te realiseren.

Maar hoe maak je dit mogelijk zonder in te binden op een gedetailleerde opvolging?

De IT-afdeling van het Wit-Gele Kruis Antwerpen had jarenlange ervaring met de ontwikkeling van applicaties in Oracle Forms. Tijdens een proeftraject op zoek naar een moderne opvolger, bleek APEX een zeer goede match. Samen met iAdvise zijn we gestart aan het uitbouwen van een nieuw en modern applicatie landschap dat steunt op onze ervaring met Oracle Forms en de kennis van het werkveld.

In deze presentatie willen wij graag met u het traject bekijken dat we doorlopen hebben. We beginnen bij het eerste idee en het proeftraject. Wat heeft ons doen kiezen voor APEX? Hoe hebben we onze gebruikers overtuigd? Welke technische keuzes hebben we moeten maken? Onze doelgroep heeft zeer uiteenlopende functies en belangen, hoe zijn we hiermee omgegaan? En vooral, waar we staan vandaag? Dit succesverhaal vol functionele en technische tips & tricks wil je niet missen!


Speaker/Bio


 

Roel Hartman

APEX Consulting

Director

ACE Director

NL/ENG

Level: Intermediate


A Deep Dive into APEX JET Charts

In this session we will take a closer look on the options the new JET Charting engine brings to the APEX world. There are a quite a lot of declarative options to explore, but also the JavaScript API is worthwhile to investigate. You will learn that with just a few lines of JavaScript you can change the look and feel of a chart to your own needs.


Speaker/Bio

Roel started a long time ago using Oracle RDBMS 5, Oracle Forms 2.3, RPT/RPF and Oracle*Case 4.5. Since a few years he focuses mainly on Oracle Application Express.

Roel has been a speaker on UKOUG, OOW, Collaborate, ODTUG's KSCOPE and a number of local Oracle User Groups. Within ODTUG he acted as the APEX Content Lead for the Kscope14 and KScope15 conferences and joined the Board of Directors in March 2016.

He keeps an (APEX-related) blog on http://roelhartman.blogspot.com. In June 2009 Roel received an Oracle ACE award and in August 2010 he's appointed as Oracle ACE Director. Roel is a co-writer of the "Expert Oracle Application Express" and "Oracle Application Express for Mobile Web Applications" books.

Roel is Director at APEX Consulting in The Netherlands.


 

Craig Sykes

Explorer

Development Consultant

ENG

Level: Expert


APEX, Meet the Rest of the Web - Modern Web Technologies in Your APEX Application

"We need a Google Search" - is the kind of user request that plagues application developers. Google have spent years and millions refining their search engine technology and your end users often expect you to replicate this functionality. This presentation will discuss what we can build using the Oracle Database and Application Express to closely resemble technologies such as Google Search, Google Maps, Dropbox Uploads and IoT connections.


Speaker/Bio

Craig is a Development Consultant at Explorer. Craig has an MSc in Computing Science and is an experienced software engineer, utilising development tools such as PL/SQL and APEX to provide bespoke ERP software to both UK and international businesses. Craig has experience developing solutions to connect Oracle systems to a wide range of existing external applications within business environments.


 

Frederik Vallaeys

iAdvise

Competence Lead

NL

Level: Beginner


De Apex Challenge en Apex aan de Hogeschool Utrecht

De Hogeschool Utrecht was op zoek naar een goede tool waar studenten snel mee aan de slag konden gaan voor het maken van projecten in een complexe bedrijfsomgeving.  Zonder dat dit een lange leercurve zou inhouden.

Na het bekijken van enkele mogelijke tools kozen ze om de studenten met Oracle Apex aan de slag te laten gaan.

De keuze viel op Oracle Apex omwille van de snelle leercurve, het gebruik van enkele vaste waarden in webdevelopment(HTML, CSS, JavaScript), het belang van het datamodelling en het feit dat dit ook perfect in een grote bedrijfsomgeving kan ingezet worden.

De studenten krijgen gedurende het jaar een intensieve cursus Oracle Apex en verschillende projecten die ze tijdens het academiejaar moeten uitvoeren.

In België organiseert iAdvise ondertussen al 9 jaar de Apex Challenge.  Gezien de intensieve Oracle Apex opleiding bij Hogeschool Utrecht, besloten we samen met enkele docenten om de Apex Challenge ook aan de hogeschool Utrecht te organiseren en dit met medewerking van Oracle Academy.

Samen zorgen we door middel van de challenge en de nodige opleidingen dat de studenten op een leuke en uitdagende manier worden ge-challenged om Oracle Apex te leren kennen, nog voor ze de bedrijfswereld ingaan.

Vooraf krijgen ze vanuit de hogeschool een opleiding over Oracle Apex en zijn ze ook bezig om het nodige voorbereidende werk te doen voor de opdracht die ze voor de challenge moeten uitvoeren.  Daarnaast hebben we dit jaar ook samen de HU Tech Day georganiseerd bij Oracle, waar een presentatie over Oracle Apex werd gegeven.

Voor de officiële start van de challenge krijgen de studenten nog een presentatie van een iAdvise expert met een heel aantal tips en tricks die handig zijn om tijdens de ontwikkeling te gebruiken van hun applicatie.

In de periode(3 weken) tussen de tips en tricks en de uitreiking, zijn er 2 dagen voorzien waar de studenten met hun vragen op consultancy kunnen komen bij enkele iAdvise experten .

In deze korte periode gaan de studenten aan het werk als junior apex ontwikkelaars en komen ze in de praktijk te weten wat de sterke kanten zijn van Apex. Als afsluiter is er uiteraard ook een prijs uitreiking waar we de winnaars in de bloemetjes zetten. Tijdens de presentatie zullen we ook een student aan het woord laten om zijn ervaring te delen met het publiek.


Speaker/Bio

Frederik Vallaeys is Competence Lead @iAdvise Groep and has been working with all kinds of Oracle products since 2001

Rik Boss is a teacher and researcher @University of Utrecht and has been working before as an Oracle E-Business Suite consultant and trainer.


 

Alex Nuijten

allAPEX

Director

ACE Director

NL/ENG

Level: Beginner


Jet Charts in the world of APEX

Compared to all previous charting solutions that were included in APEX, Jet Charts have a lot more to offer. Jet Charts are included in Oracle APEX 5.1. In this session we will explore several charting visualizations, migration from previous charts to Jet Charts, as well as customization of Jet Charts.


Speaker/Bio

Alex Nuijten is an independent consultant (allAPEX), specializing in Oracle database development with PL/SQL and Oracle Application Express (APEX) and member of the Smart4APEX Guild.

Besides his consultancy work, he conducts training classes, mainly in APEX, SQL and PL/SQL. Alex has been a speaker at numerous international conferences, such as ODTUG, Oracle Open World, UKOUG, IOUG, OUGF, BGOUG, OGH APEX World and OBUG. For his presentations, Alex received several Best Speaker awards.

He wrote many articles in Oracle related magazines, and at regular intervals he writes about Oracle Application Express and Oracle database development on his blog "Notes on Oracle" (nuijten.blogspot.com). Alex is co-author of the following books “Oracle APEX Best Practices” (published by Packt Publishers) and  “Real World SQL and PL/SQL” (published by Oracle Press).

Because of his contributions to the Oracle community, Alex was awarded the Oracle ACE Director membership in August 2010.


 


Niels de Bruijn

MT AG

Business Unit Manager

ACE Director

ENG

Level: Beginner


Affordable Workflow Options for your APEX App

"Can I model workflows with APEX 5.x?" How do you react when you get such a requirement? If your answer is like, "Well, I'm not sure...," then this presentation is for you. We will go through all the (affordable) options in this area and demonstrate a use case. After this presentation you will be confident how to answer the stated question.


Speaker/Bio

Niels de Bruijn works for MT AG, a mid-size vendor-independent IT-consultancy company based in Germany. As a business unit manager, he is responsible for a group of APEX experts and all APEX activity in the company. Niels shares his extensive knowledge through the website apex.mt-ag.com and by speaking at events such as DOAG Conference, APEX Connect (initiated and led by Niels), APEX World and ODTUG Kscope. His activity in the APEX community and engagement with product management, led him to his Oracle ACE Director title.


 

Dietmar Gabauer

FOEX GmbH.

Technical Pre-Sales Consultant

ENG

Level: Beginner


From 0 to APEX - A guide to successful APEXify new employees

Experienced APEX developers are rare to hire - let's educate a newbie!

This presentation gives a guideline for a successful integration of a new employee into your team.

What is APEX? How do I guide someone into the world of APEX?

What's needed in addition? SQL, PL/SQL, HTML, CSS, JavaScript......what else?

How can this be trained time and cost efficient?

How do I phase-in a new, basic trained employees into running project work?

Answers to these questions are out of our experience in phasing in new employees at FOEX GmbH.


Speaker/Bio

47 Years, 2 children, living in Austria

Working with Oracle Forms since 1998, started with APEX in 2007, since 2015 working for FOEX GmbH.


 

Iloon Ellen-Wolff

Oracle

Cloud Success Director

ENG

Level: Intermediate


New Developments in the Oracle Cloud

The services available in the Oracle Cloud are growing very fast. What kind of cloud services are available and what is the best choice to make. This presentation will highlight the new Cloud services in the Platform As A Service area (PaaS).


Speaker/Bio

I began my Oracle career twenty six years ago, being employed by several software houses in The Netherlands, working with Oracle Forms version 2 and Report*Writer.
Eighteen years ago, I was hired to work in Oracle Support Services for the Developer competency, assisting customers with solving their software problems.
This involved supporting Application Express, Rest Data Services(APEX Listener), SQL*plus, SQL Developer and Oracle Database Service Cloud. During those years, I applied my expertise by coaching new engineers, team leading and teaching Application Express courses for Oracle University.
For the past six years, I have been involved with the Oracle Cloud project.
I was a member of the Platform as a Service (PaaS) readiness team, who test Application Express in the cloud and in this capacity, I provide foundation training for this technology.
One of my responsibilities in Oracle Support was Global Technical Lead for Application Express.
I work closely with sustaining engineering, product development and product management from the Application Express team.
In March 2016, I moved to the job Oracle Cloud Success Director in the Platform As A Services Team.
I assist customers in the complete journey to the Oracle Cloud.
I am a frequent speaker for various Oracle User Groups including the UK Oracle user group, the Dutch user group, the Norwegian user group, the Bulgarian user group and OBUG, presenting about Application Express and Oracle Cloud.
Oak Table member since September 2013
 
 


Matt Nolan

FOEX GmbH

CTO

ENG

Level: Intermediate


Unlocking the power of the APEX plugin architecture

This session is to promote the APEX plugin architecture. We will walk through the structure of region plugins using an existing real world example which has a focus on techniques to maximize performance. We will walk through from requirements analysis to plugin release & usage.

This example will show an image list view based on thousands of images stored in the database which has the following requirements:

- the image list view will need to be responsive since it will be viewed on different device types, phones, tablets, desktop

- the image list view will need to load more images on scroll

- the image list view will need to have several different viewing styles to switch between

- the image list view will need to support thousands of users

The solution uses the universal theme for responsive design and client side templating with 2-way data binding using Ractive.js (Mustache Templating) and APEX_JSON, infinite scrolling, drag & Drop re-ordering, lazy fetching of data, and lazy loading images. A complex set of requirements that can be solved using a single easy to configure region plugin with minimal coding requirements thanks to the integration of open source javascript libraries and using APEX PLSQL and Javascript API's.

We will also explore the best practices of plugin design, emphasise the importance of events and their usage, how to best manage and centralize the development and maintenance of plugins.


Speaker/Bio

Matt is the co-founder & CTO of FOEX GmbH, which specializes in APEX plugin development. Matt has 16 years of experience working exclusively with the Oracle database and has been developing commercial Oracle APEX applications since 2008 for companies in the US, UK, Europe, and Australia.


 

Dedmer Sipma

iAdvise

Oracle Consultant

NL

Level: Intermediate


Customer Case - Unpack me in the Oracle Cloud

Customer Case  - Unpack me in the Oracle Cloud

Improve a packaged application into a full research application in the Oracle Cloud

Onze klanten zijn gecertificeerde arbodiensten en bedrijfsartsenorganisaties die zich richten op verzuimbegeleiding. iAdvise ontwikkelt een volledig verzuimsysteem, waarbij nieuwe functionaliteit in iteraties wordt opgeleverd naar het technisch Compasity platform in de Oracle Database Cloud Service.

In deze customer case belichten wij samen met de klant de geïmplementeerde APEX functionaliteit; een verslagleggingstool die als module verslagen en onderzoeken verwerkt omtrent verzuimconsulten. Deze tool is gebaseerd op de packaged application ‘Survey Builder’.

Eerst zal één van onze klanten toelichten hoe zij onze software gebruiken. De klant geeft een korte uitleg over het verzuimtraject, wat daar allemaal bij komt kijken, aan welke eisen een verzuimdossier moet voldoen en hoe de verslaglegginstool daarbij helpt.   

Daarna zal de ontwikkelaar vertellen hoe een Oracle Packaged Application is gebruikt, hoe deze is uitgebreid en verbeterd om tot de functionaliteit te komen. De tool draait volledig op de ‘Survey Builder’ programmatuur maar is op modulaire wijze omgebouwd naar een verslaglegginstool die voor verschillende doeleinden kan worden gebruikt. Denk aan het tussentijds opslaan van verslagen, het invullen van vooraf bekende gegevens, autorisatie op wie de vragenlijsten mag invullen en een volledig nieuwe UX-laag. Dit terwijl er bijna niet in de oorspronkelijke code van de Packaged Application is geprogrammeerd.

Daarnaast zal er ook nog aandacht gegeven worden aan de migratie naar de Oracle Database Cloud Service die is uitgevoerd. Het Compasity platform draaide op verschillende on-premise omgevingen, welke inmiddels allemaal in de Oracle Cloud draaien. Wat op voorhand een grote stap leek, bleek achteraf  mee te vallen.

Doel van de presentatie is om programmeurs te inspireren, te laten zoeken naar ‘hidden gems’, in plaats van het wiel opnieuw uit te vinden. Ook zal er veel aandacht besteed worden aan modulair programmeren en modelleren zodat er gemakkelijk één functionaliteit voor meerdere doeleinden gebruikt kan worden. Tot slot hopen we dat het deel over de Cloud migratie de drempel verlaagt voor de aanwezigen om hetzelfde te doen, want wij zijn in de wolken met de Oracle Database Cloud Service.


Speaker/Bio

 


Colm Divilly

Oracle

Consulting Member of Technical Staff

ENG

Level: Intermediate


Building Applications with Oracle REST Data Services & Oracle JET
This talk will demonstrate a sample web application built using Oracle JET & Oracle REST Data Services, showing how simple it is to integrate these two powerful technologies to quickly and easily build rich applications atop Oracle Database.
Speaker/Bio

Architect for Oracle REST Data Services, presented 'Design of RESTful APIs using Oracle REST Data Services' @ ApexWorld 2016.


 

Christian Rokitta

Smart4APEX

Consultant

ACE

NL/ENG

Level: Intermediate


Bootstrapify Universal Theme

Alle APEX applicaties gebouwd met Universal Theme zien er het zelfde uit!
Sinds de introductie van APEX 5 is het Universal Theme (UT) de favoriete UI voor nagenoeg alle APEX projecten, zowel voor interne als publieke applicaties. En toegegeven: UT is modern, “crisp” en met Themeroller, Themestyles en Template Options is de declaratieve filosofie van APEX op een hoger niveau gebracht.
MAAR …
Themeroller bied maar beperkte mogelijkheden tot customisatie, vooral kleurinstellingen. En omdat UT zo sterk in het APEX framework geïntegreerd is, zijn structurele veranderingen in templates lastig, sterker nog, niet aan te raden, omdat hierdoor de mogelijkheid verloren gaat om naar nieuwe versies te upgraden. Plus: maatwerk CSS voor UT is niet altijd even makkelijk te ontwikkelen.
Dus, Theme 42 (UT) is niet het antwoord op ALLE vragen.
Een compleet nieuw theme in APEX van scratch te ontwikkelen is heel veel werk. Het kost veel tijd (en dus geld) en onderhoud. Veel functionaliteiten die in UT al opgelost zijn zullen moeten herontwikkeld worden.
Als een project om een ander design vraagt, maar het budget niet toelaat dat de bestaande (UT) componenten niet hergebruikt worden, dan is er wel een alternatief:
Kant-en-klare Bootstrap themes en UT kunnen prima met elkaar overweg. Dus is het mogelijk het Universal Theme van APEX met het Design en aantal templates van een pre-build Bootstrap theme te verrijken. Op de juiste manier toegepast, resulteert dit in een uniek UI design voor de applicatie, onder behoud van de belangrijke UT componenten en functionaliteit.
Het (online) aanbod aan Bootstrap applicatie templates (Admin Themes) is groot, gratis of voor een redelijke prijs te downloaden.
In mijn presentatie laat ik, met mijn ervaring uit projecten, stap voor stap zien hoe deze methode werkt en welke technieken, mogelijkheden en beperkingen van toepassing zijn.


Speaker/Bio

Christian is zijn carrière als Oracle ontwikkelaar begonnen in 1992 bij een onderzoeksteam van de Pharma divisie van Hoechst AG in Frankfurt. In die tijd begon hij zich ook in de (nog opkomende) standaard HTML te verdiepen en werd de basis gelegd voor zijn passie; de Oracle database en het internet met elkaar integreren. In 1996 emigreerde Christian naar Nederland om als Custom Development Consultant voor Oracle Nederland te werken. Daar gebruikte hij voor het eerst de Oracle Web Toolkit, welke nu het fundament van APEX vormt. Vervolgens is hij in dienst getreden voor Scamander Solutions; een bedrijf dat zich specialiseert in de conversie en migratie van ERP systemen en Business Intelligence. Oracle EBS hierbij in het bijzonder.
Sinds 2010 werkt Christian als onafhankelijke professional en heeft hij op verschillende congressen presentaties over APEX verzorgd. Onder andere bij het OGH APEX congres (APEX World), de ODTUG KScope Conference in de VS en verschillende DOAG conferenties in Duitsland. Daarnaast ontwerpt hij, onder de naam THEMES4APEX, op maat gemaakt User Interfaces voor het APEX ontwikkelplatform.


 


Jan Karremans

JK-Consult

Consultant

ACE

NL/ENG

Level: Intermediate


Saving Lives at Sea - At an Industrial Scale Using Oracle Cloud Technology

The International Convention for the Safety of Life at Sea (SOLAS) is an international maritime treaty which requires signatory flag states to ensure that ships flagged by them comply with minimum safety standards in construction, equipment and operation.
One recent regulation states that the gross mass of any container that will be shipped across international waters must be verified.
The two presenters will combine a business insight with a technological focus to highlight all aspects of the application, leveraging Oracles most strategic technological Cloud solutions.
This presentation discusses how we are able to help safeguard human lives at Sea on an industrial scale. It demonstrates how Oracles Cloud Technology enables an entire industry to increase safety by complying with this new rule, set forward by SOLAS. In practice this means a natural person has to sign off on the weight of any individual container.
Learn how it is possible to process millions of sea-bound containers on an annual base and see how we succeeded in getting the various partners in this 24*7*365 hyper dynamic environment to work together on meeting these brand new requirements.


Speaker/bio

Jan started his IT career in a medical facility of the Royal Dutch Army in 1992 as an administrator on a Datapoint Mainframe, coding in RMS. In 1994 the medical facility switched to using Oracle 7.1 on a Micro VAX 3100, which kicked of his career in Oracle.
In 1998 Jan joined VIR e-Care Solutions, where he supported the development of Ecaris. Ecaris is a support system for healthcare administration within multi-disciplinary working organizations.
Over the years Ecaris evolved from a host-based system, through a Forms & Reports application in a client-server architecture to a fully web-based solution. The architecture for the web-based solutions is of a Pre-APEX form, based on mod-pl/sql.
In recent years Jan came in contact with Dbvisit of New Zealand. In 2011 he started working as a Business Development Manager for Dbvisit, successfully creating brand-awareness and recognition for the company. Jan founded #RepAttack as a new form to introduce commercial products to a technical community, an idea which was quickly adopted by other vendors.
Starting January 2016 Jan is a member of the Portrix Group based in Hamburg Germany. In his role as Director Operations Jan is working both to expand the Portrix Systems company, delivering highly specialized projects with the center of excellence in Oracle, Linux and Cisco.
Also Jan made his appearance as a regular speaker at Oracle User Groups around the world, with a debut at UKOUG_Tech13. Since that time, the Oracle community virus has taken a hold with Jan, resulting in various initiatives within this community.  In 2015 Jan was awarded the Oracle ACE recognition for these community initiatives.
In his scarce free time Jan enjoys traveling the country-side with his charming wife, preferably in a good size RV or ride his bright red Honda VF700C Super Magna into the sunset.


 

Dick Dral

Detora

Consultant / Developer

NL/ENG

Level: Intermediate


Battle of the tools: Apex vs. JET - A hands-on comparison
A comparison between Apex and JET is made by redeveloping two Apex applications with JET. The experiences to build these applications with JET compared to the effort needed in Apex clearly shows the strong areas of both tools.
The applications I redeveloped were my entry for the Apex Dashboard competition, with a lot of charts and fancy stuff, without data manipulation. The other one is a small mobile data entry application that is used in tomato greenhouses to register the growth of the plants.
As a bonus the mobile application will be converted to a mobile app using Phonegap with offline capabilities.
The findings of this investigation can help you choose which tool is most suited for your needs.


Speaker/Bio

Dick Dral has been an enthusiastic Oracle Developer since 1988. In 2006, he first discovered the magic of Application Express, and he has been an addict since. He likes challenges and discovering new possibilities in development. He likes both database development in SQL and PL/SQL and front-end development. Dick has worked for a number of major companies and government agencies in developing Oracle applications.

He has been a presenter at a number of events, including Oracle World 2001 in Berlin, APEX World 2013, 2015 and 2016 in the Netherlands, Apex Connect 2016, ODTUG 2015 and DOAG 2015. His current favorite subject is mobile development with Apex, ranging from Single Page Applications to speech input.


 

Roel Hartman

APEX Consulting

Director

ACE Director

ENG

Level: Beginner


Docker for Dummies

You might (or might not) have heard of Docker. But you have no idea what it is and why you should care. But if you are a database or APEX developer and still work with Virtual Machines, it is about time to broaden your horizon.

In this session you'll learn what Docker is and how you can benefit from it in your daily work.


Speaker/Bio

Roel started a long time ago using Oracle RDBMS 5, Oracle Forms 2.3, RPT/RPF and Oracle*Case 4.5. Since a few years he focuses mainly on Oracle Application Express.
Roel has been a speaker on UKOUG, OOW, Collaborate, ODTUG's KSCOPE and a number of local Oracle User Groups. Within ODTUG he acted as the APEX Content Lead for the Kscope14 and KScope15 conferences and joined the Board of Directors in March 2016.
He keeps an (APEX-related) blog on http://roelhartman.blogspot.com. In June 2009 Roel received an Oracle ACE award and in August 2010 he's appointed as Oracle ACE Director. Roel is a co-writer of the "Expert Oracle Application Express" and "Oracle Application Express for Mobile Web Applications" books.
Roel is Director at APEX Consulting in The Netherlands.


 

Oliver Lemm

MT AG

Competence Center Leader

ENG

Level: Intermediate


Mastering Universal Theme with Corporate Design from Union Investment

Going to the Universal Theme including a style guide with a customer’s corporate design is the hardest challenge of migrating to APEX 5. The FondsProfiler application created in 2011 for Union Investment based on theme 22 was developed by over 15 people. It’s an application handling funds with 100 Pages, thousands of lines custom code and adjusted templates.
A huge amount of JavaScript and CSS had to be adopted to the newest APEX version. Going to the Universal Theme with many templates you have handle the matching between old and new templates including the new template options. One big question is what effort you should spent to hold the theme subscription and stay on the original Universal Theme templates by making the UI and functional changes only by custom CSS and jQuery.
Creating a custom header with standard templates, or solving problems like the big space between elements are really interesting facts when working with the Universal Theme.
Even using custom icons and fonts is not as easy as you might think. The presentation will give a high detailed view into a migration to the Universal Theme and shows howto work with APEX on a professional way.


Speaker/bio

Working since 2007 with Oracle Application Express at the MT AG. Presented  on KScope 13,14 & 16, DOAG 2008-2016, APEX Connect 2015&2016. Holding APEX Seminars for DOAG and MT AG customers. Leading projects related to APEX at the MT AG. Being Competence Center Leader for Oracle Application Express inside the MT AG for a team of 25 People.


 

Dimitri Gielis

APEX R&D

Director

ACE Director

ENG

Level: Intermediate


Moving my APEX app to the Exadata Express Cloud. Live!

I'll show an on-premise APEX app and will move it live to the Exadata Express cloud. I'll also present why I find it the first real Oracle offer which is valid for the majority of APEX apps and how it will help you to save time and energy.


Speaker/Bio

Dimitri Gielis is a Director of APEX R&D, a company specializing in Oracle Application Express. Dimitri is a frequent presenter at all the major Oracle conferences and an Oracle ACE Director, and he was named Oracle APEX Developer of the Year in 2009 and Database Developer of the Year (ORDS) in 2015.

 

Richard Martens

Smart4Apex

Founding Partner

ACE

NL/ENG

Level: Intermediate


Bootstrapping APEX Authentication and Authorisation (A deep dive into APEX authentication)

- What is Authentication

- Session Management

- Custom Authentication Schemes

- Example: An APEX only SSO engine


Speaker/Bio

Richard Martens has been involved in information technology for more than 15 years. He started as a web developer using the Oracle database as no more than data storage. Richard has been responsible for major European multilingual websites and has been working with the Oracle database since 2000. During those years, he developed himself using a multitude of technologies and specialized in PL/SQL and Oracle APEX. With APEX, he combines the things he loves most: the Oracle database and web technologies.


 


Peter de Vaal

Northpool B.V.

IT Architect

NL/ENG

Level: Intermediate


Visualising Energy Data with an APEX Dashboard and JET Graphs

Data is a key asset in today's energy market. Due to European laws all energy producing and transporting companies are obliged to publish data about production and consumption of electricity. The published data can be used to make decisions in production and trading of energy. Renewable energy sources, such as solar and wind energy, play an important role nowadays, hence wheather data are very important as well.

We have built a system to collect data from a great number of sources, store these uniformly in an Oracle database, and present the data for end users in a dashboard built in APEX. Because both historical data and near-realtime data are important for the traders we did not choose for a traditional datawarehouse solution, but created an optimised solution using APEX and PL/SQL stored procedures. Data is presented in spreadsheet-like layouts and in Charts. For the latter we use the APEX supplied charts and D3 charts, both are currently being replaced by JET charts.


Speaker/Bio

Peter de Vaal works 25 years in Oracle technology, with expertise in database and middleware technology. He has been working as a technology consultant for Transfer Solutions in the past 19 years, and now as an IT architect at Northpool. Peter is a frequent presenter at confereneces such as ODTUG Kaleidoscope and the UKOUG Tech conference. He is lead of the OGh middleware SIG Cloud Application Foundation.


 

Maresa Bunschoten en Arjan van der Palen

Transfer Solutions

Project Manager; APEX Developer

ENG

Level: Intermediate


Cloud Veterans – Lessons learned from APEX development in the Oracle Public Cloud

APEX is a very suitable platform for the Cloud because of its architecture and browser-based development. However, the majority of APEX development is still done on premises or in hosted environments. For the Dutch Veterans Institute an Oracle PaaS Cloud solution with APEX was most appropriate. Transfer Solutions has built an APEX calendar based application in which veterans can be scheduled to give presentations on Dutch schools about their experiences in war zones.

Although development in the Oracle Cloud does not seem that complicated, we experienced some technical challenges on the road. Here, we present how we have overcome the challenges that we had during development and deployment.

Furthermore we will answer questions like: How to decide to develop on premises or in the Cloud? How does Cloud development differ from on premise? What does the Oracle Cloud APEX environment look like? What can(not) be managed? How does the pricing work?

This presentation will help you understand how to bring the benefits of APEX development in the Cloud to your customer and how to tackle challenges that come along with this step.


Speaker/Bio

Maresa Bunschoten has worked in the Oracle world for over 12 years in a variety of roles such as developer, tester and architect. Maresa first came in contact with APEX as a developer 5 years ago and currently holds the role of project manager for several APEX projects.

Arjan van der Palen is an app developer for Transfer Solutions with APEX as his core developing platform. Arjan is one of the prime examples of Transfer Solutions’ successful education for future Oracle experts. Arjan has two years of experience with APEX and related Oracle and web technologies and has been a developer in multiple projects, among which the project in this case study.

 

Sabine Heimsath

its-people GmbH

Senior Consultant

ACE Associate

ENG

Level: Intermediate


How to instrument your code easy and effectively

Do you measure how your code is performing? Do you have the right info at hand when your program fails? Can you monitor your program while running?

This session is all about instrumenting your PL/SQL code - be it inside an APEX application or in a pure PL/SQL environment.

What are the alternatives to the very common hand-knitted or organically grown solutions? We are going to look at a few Open Source frameworks and analyze which requirements they can cover and what you might have to add yourself.

After this session you will know what to look for when choosing the right framework to enhance your project.


Speaker/Bio

Sabine studied Information Science in Münster where she discovered her love for spreadsheets, relational databases and data modelling. After her diploma in 1999 she started her professional career with Oracle Consulting in Frankfurt. Working for several customers she developed her skills in PL/SQL, Java and WebDB. After another year doing product development she decided she wanted to be in consulting again and became a freelancer with its-people GmbH. Since then, Sabine has done many projects in different industries, which are all centered around the Oracle Database, be it Reporting, Migrations, Application Development with APEX or pure PL/SQL. SQL Developer has become one of her favourite tools.

She is a blogger, trainer and speaker at different conferences like DOAG, APEX Connect and UKOUG and organises the APEX Frankfurt Meetup. Besides, she is a member of the DOAG Development community and happens to be Germany's first female ACE Associate.

Sabine loves Lego and fantasy literature.

 

Sergei Martens

SMART4Solutions

NL/ENG


The experience from a successful Forms to APEX migration

 

The experience from a successful Forms to APEX migration

In roughly seven months Stadsbeheer B.V. with a specially composed "task force" migrated a large forms application (with more than 300 unique forms) to Apex. This new application, SBA-CS currently is being implemented at their customers.

SBA CS stands for SBA Collaboration Suite and is a system for municipalities, water boards, provinces, environmental services, etc. to support their processes for site-specific permits (incl. monitoring and enforcement). Collaboration Suite because it emphasizes the ability to collaborate with partners outside of the own organisation.

Besides the technical migration, a lot of attention has been given to "user interface design" (UI) and the "user experience" (UX). Special templates have been developed for the application and also several interesting features such as a flexible to set up dashboard based on widgets, a separate search engine that operates on a Google-like way and lots of other features.

Several interesting techniques are used throughout the application that enable the system to quickly render large amounts of complex data.

Stadsbeheer used knowledge and experience from a number of smart4unity labels, for example smart4apex, smart4branding and smart4solutions. A taskforce was set up to guarantee a successful migration.

Topics covered include:

· Short demo of the application.

· Objectives, approach and organization of the migration project

· Issues faced during Forms migration to Apex

· Critical success factors for a successful migration

· Lessons learned and recommendations for other future migrations

· Interesting technical components such as the built-in search engine.

Presenter: Bart Prinsen (Stadsbeheer, part of PinkRoccade local government)

Bart has worked at PinkRoccade Local Government as a consultant since 2006. He started implementing new SAP system loads in various municipalities. He then dealt with the development of new services and products on the SAP platform. As of 2009 Bart has been involved in implementing software for the new Law Addresses and Buildings Key (Wet Basisregistratie Adressen en Gebouwen). As of November 2016, Bart holds the position of Product Owner at Stadsbeheer. He joined Sergei’s project and has since been responsible for the delivered product.

Co-presenter: Sergei Martens (SMART4Solutions)

Sergei has worked as an Oracle professional since 1998. He started as a developer in Oracle Forms and Designer, moved to be the lead developer for a large team of developers and implemented several large IT projects. In 2005 he co-founded Stadsbeheer B.V., where he was responsible for the development of the SBA software as the companies’ CTO.

Since 2008 he worked for various clients as an independent Oracle professional in the areas of Forms, Designer, PL / SQL, APEX and is active in the Skillbuilders’ Apex development team.

He did several implementation projects for various governments. Sergei is the founder of the SMART4Unity- group, known for labels as SMART4Apex, SMART4Branding and SMART4Solutions.

 




Gianluca Ghiani
UBER
Co-Presenter: Christian Rokitta, smart4apex
ENG

Special Customer Case, Thursday March 30, 17:00 - 17:45
Using APEX to extend EBS

Everybody knows UBER. UBER is a global company, doing business in many countries, and therefor is facing the challenge of implement proper financial procedures to be compliant with every local tax authority. Another challenge: UBER is using Oracle EBS to process all financial transactions.

In order to streamline these continuous processes, integrate and extend the EBS functionality, the UBER Tax-, Compliance- and Accounting-Teams in Amsterdam uses Oracle APEX to implement a solution that is used worldwide. In this presentation, the UBER team would like to share their experience with Oracle Application Express, choices-made and lessons-learned, with you.