By: Monty Latiolais On: September 29, 2017 In: Insum Life Comments: 0

Simon Sez…Attend These OOW17 Sessions

Oracle OpenWorld17 is but a few days away. If you have not built your agenda by now, here are some suggestions.

My favorite day of the OpenWorld week has always been User Group Sunday. This year is no different. ODTUG and the other user groups have assembled a compelling lineup for the APEX enthusiast.


IoT: Oracle REST Data Service and Oracle JavaScript Extension Toolkit

Anton Nielsen, C2 Consulting, Inc.

Time: 9:45 – 10:30 a.m. Location: Marriott, Salon 4-6

Oracle REST Data Service, Oracle Application Express, and Oracle JavaScript Extension Toolkit have disparate, sometimes overlapping, functionality. This session reviews these products and focuses on how they complement the Internet of Things. Attendees build an IoT device that communicates with an Oracle Database via Oracle REST Data Service. Device data is displayed via Oracle JavaScript Extension Toolkit components, and the device is controlled by an Oracle Application Express application. Participants gain hands-on experience in Oracle REST Data Service, Oracle Application Express, Oracle JavaScript Extension Toolkit, and IoT hardware.

Cloudy with a Chance of APEX

Francis Mignault, Insum Solutions

Time: 10:45 – 11:30 a.m. Location: Marriott, Salon 4-6

In the past you had to buy servers and/or hosting services to manage your technology stack. Now there are numerous options that allow you to quickly and easily deploy your applications in the cloud. The tough part is deciding which cloud offering or tools to use. This OpenWorld17 session covers the different cloud options available for your Oracle Application Express applications for both Oracle Cloud and non-Oracle Cloud providers. Some of the cloud options using Oracle Application Express as an add-on, such as Oracle Business Intelligence Cloud Service, are also discussed.

Make Oracle Application Express Apps Fly: Oracle JavaScript Extension Toolkit

Roel Hartman, APEX Consulting

Time: 11:45 a.m. – 12:30 p.m. Location: Marriott, Salon 4-6

At Oracle OpenWorld 2015, Oracle introduced Oracle JavaScript Extension Toolkit. Oracle Application Express 5.1 ships with Oracle JavaScript Extension Toolkit and uses it to create the good-looking charts declaratively. But if you know Oracle JavaScript Extension Toolkit a bit better, you can tune the look and feel of the charts even more. And apart from the exposed charts, there are more components in Oracle JavaScript Extension Toolkit you can use in your Oracle Application Express applications. This Openworld17 session shows you how to do that, and walks through a way to create plugins for Oracle JavaScript Extension Toolkit components.

Web Services for Oracle Application Express Decoded

Scott Spendolini, Sumner Technologies

Time: 12:45 – 1:30 p.m. Location: Marriott, Salon 4-6

Web services in the Oracle Application Express world are becoming increasingly popular. However, there is still a lot of confusion as to what they are and how they could benefit Oracle Application Express developers. After a review of the syntax and jargon associated with web services, this Openworld17 session reviews and boils down web services to their basic components. It also demonstrates how Oracle Application Express developers can start to use these powerful components both to send and receive data from other sites.

Alexa, How Do You Work With Oracle REST Data Services?

Jonathan Dixon, JMJ Cloud

Time: 1:45 – 2:30 p.m. Location: Marriott, Salon 4-6

At first glance, artificial intelligence may seem beyond the reach of the citizen Oracle REST Data Services developer. With companies such as Amazon, Google, and Apple providing the interface (Alexa, OK Google, and Siri), however, this is no longer the case. In this session learn how you can use Oracle REST Data Services as the gateway and the Oracle Database as the engine behind Alexa skills that will impress your customers. Alexa! How many orders were placed in the past hour? Alexa! Are there any stuck transactions in Oracle ERP Cloud? Alexa! It’s time to

make Oracle REST Data Services and the Oracle Database cool!

Life After Oracle Forms: The Move to Oracle Application Express

Alex Nuijten, allAPEX

Time: 2:45 – 3:30 p.m. Location: Marriott, Salon 4-6

Companies struggle with the question of whether to move to Oracle Application Express when the time comes to let go of Oracle Forms. This session explores the story of a migration project in which the Oracle Forms application needed to be replaced with an Oracle Application Express application. What might have been done better? What were the lessons learned? What was the best choice made during this project? Learn not from the books, but from experience.|

Explore Oracle Application Express APIs

Martin D’Souza, Insum Solutions

Time: 3:45 – 4:30 p.m. Location: Marriott, Salon 4-6

Most developers new to Oracle Application Express aren’t aware that it comes with a plethora of very powerful APIs for both PL/SQL and JavaScript. This session highlights some of these APIs and explains how and when to use them to speed up and simplify developing your Oracle Application Express applications. New Oracle Application Express 5.1 APIs are also discussed

OAUG Oracle Application Express SIG Meeting

Sylvain Martel, Insum Solutions

Time: 3:45 – 4:30 p.m. Location: Moscone South, Room 208

This Openworld17 session is a meeting of the OAUG Oracle Application Express in Oracle E-Business Suite special interest group, which provides a forum to promote Oracle Application Express in the context of Oracle E-Business Suite, for creating custom extensions. This session provides answers and best practices to typical questions related to the architecture and configuration of Oracle Application Express in the context of Oracle E-Business Suite. Connect with your peers; learn about new features, enhancements, and changes; and share your experiences.

Elsewhere throughout the week there are certainly some sessions worthy of your time, they’re just a bit more spread out and not as concentrated as those on User Group Sunday.


Docker for Dummies Roel Hartman, APEX Consulting

Time: 2:15 – 3:00 p.m. Location: Moscone West, Room 3005

You might (or might not) have heard of Docker. Maybe you have no idea what it is and why you should care. But if you are a database or Oracle Application Express developer and still work with virtual machines, it is about time to broaden your horizon. In this Openworld17 session you learn what Docker is and how you can benefit from it in your daily work.

Oracle Application Express 5.2 New Features

Chaitanya Koratamaddi, Oracle

Time: 4:45 – 5:30 p.m. Location: Moscone West, Room 3002

Oracle Application Express 5.2 enables declaratively integrating data sources from remote databases and extending applications running on the cloud via REST. A new Create Application wizard enables you to add components and features to new and existing applications. Upgrading to the latest Oracle JavaScript Extension Toolkit and jQuery JavaScript libraries further allow Oracle Application Express to take advantage of new and improved data visualizations and widgets. In this Openworld17 session get a preview of these new capabilities and see some of the numerous enhancements to Page Designer and the Interactive Grid.

Low-Code Rapid Application Development

Mike Hichwa, Oracle

Time: 5:45 – 6:30 p.m. Location: Moscone West, Room 3002

This session features a live demo of creating a relational data model using a SQL markdown tool (QuickSQL.oracle.com). The data model design is augmented with audience input and also generates sample data. The demo then creates a responsive web application leveraging a free public service using JSON blueprints

and Oracle Application Express, and leverages Oracle REST Data Services to create swagger-documented REST APIs on the newly created data model. The demo includes access to all scripts required to repeat from the public internet, and the software demonstrated is available both on the Oracle Cloud and on-premises.


Migrating Oracle Forms to the Cloud Using Oracle Application Express

David Peake, Oracle

Time: 4:30 – 5:15 p.m. Location: Moscone West, Room 3004

Oracle Forms is still being developed, and for those whose requirements are being fully met and are up on a supported release, there is no reason to move off Oracle Forms. However, if you are on an older release of Oracle Forms, or need to deliver modern, intuitive, self-service, or mobile applications then Oracle Application Express is an excellent option. In this Openworld17 session learn what is involved in building out using Oracle Application Express, the do’s and don’ts, how to use the Oracle Application Express Migration Project, and more.

Data Visualizations with Oracle Application Express

David Peake, Oracle

Time: 5:30 – 6:15 p.m. Location: Moscone West, Room 3004

Oracle Application Express 5.1 introduced a new charting engine based on the data visualization components of Oracle JavaScript Extension Toolkit. This JavaScript charting solution is highly customizable, accessible, interactive, and incorporates automatic responsive design support. In this session explore how you can take full advantage of the built-in capabilities, and how you can link up your charts with dynamic actions to create truly interactive experiences for your users.

Plenty to chew on there. I do want to make one additional recommendation. On Tuesday at 12:30, Insum’s own, Martin d’Souza has been invited to speak by our friends at the Oak Table Network. He’ll be discussing Open Source PL/SQL Utilities. Martin’s one of the best speakers out there, so I’m sure you’ll learn plenty that you can take back to office. Oak Table World is held at the Childrens Creativity Museum adjacent to the Moscone South. It is free to attend but seating is limited, so get there early. (http://www.oaktable.net/blog/oak-table-world-2017-oracle-open-world)

That about does it. If you see me out at OOW make sure to say “Hello”


Share this:

Leave reply:

Your email address will not be published. Required fields are marked *