A few weeks ago I took a stab at creating a session list for those new to APEX. Today, we’ve got something for the seasoned APEX developers among us.
The list below should keep you plenty busy. Make sure to drop by the Insum booth to let me know what you think.
Oh, and don’t forget to attend the Sunday Symposium and Thursday Deep Dive.
Open Source and APEX: Join the Movement
Martin D’Souza, Insum Solutions
When: Jun 27, 2016, Session 1, 8:30 am – 9:30 am
Topic: Application Express
Subtopic: Other Application Express
Most people don’t associate the words open source and Oracle. That time has changed as it is becoming more common for Oracle developers to publish their projects on open-source platforms such as GitHub.
This talk will focus on how you can leverage open-source projects as part of your APEX development practices and integrate them in your applications. It will highlight some popular open-source APEX projects and plugins.
Mastering APEX 5 IRs: Guts and Performance
Karen Cannell, TH Technology
When: Jun 27, 2016, Session 2, 10:15 am – 11:15 am
Topic: Application Express
Subtopic: New Release
Master APEX 5 IR by learning the essentials of IR Guts and Performance, the re-engineered CSS and jQuery that make APEX 5 IR new features possible, and how to leverage IR settings to maximize end-user performance. APEX 5 Interactive Reports has been re-engineered from the inside out. Do you know how to take advantage of the new and improved APEX 5 IR? Do you have customized APEX 4 IR to upgrade? Do your IR settings help or hinder end-user performance? Do you know how to make end-user IR searches smarter and faster?
This session details the APEX 5 IR CSS and jQuery, covering features, structure, how to upgrade, and supported (APIs and recommended solutions) and non-supported (at your own risk) options for enhancing out-of-the-box functionality. We then discuss and demonstrate how typical declarative settings influence end-user performance. How many rows are too many? When does using a select list slow response time? Why are you users not seeing all options? All of us use APEX IRs; leave this session knowing how to master them.
APEX PI: Interfacing the Raspberry Pi with APEX
Christoph Ruepprich, Accenture – Enkitec Group
When: Jun 27, 2016, Session 3, 11:30 am – 12:30 pm
Topic: Application Express
Subtopic: Integration
The Raspberry Pi is a wonderful experimentation platform. In this presentation we will see how we can interface the Raspberry Pi’s hardware with Oracle APEX. Learn how we gain access to the GPIO (General Input/Output) ports, and control attached hardware. This knowledge can be used to build home automation/control systems and much more.
Hands-On Training: Build Something! IOT = Internet + Oracle + Things
Anton Nielsen, C2 Consulting, Inc.
When: Jun 27, 2016, Traditional HOT 3, 2:00 pm – 4:15 pm
Topic: Application Express
Subtopic: Other Application Express
This hands-on lab will introduce you to the the Internet of Things by allowing you to build your own thing and connect it to an Oracle APEX application. You will select a circuit board, wires, capacitors, a WiFi device, LEDs, and a sensor. Then you get to wire them together into a real THING, connect to the Internet, and start communicating with an Oracle Database. Finally, you will build an APEX application to control your thing and report on its data. Please note there are two scheduled times to see this session.
Dynamic Actions to Create Dynamic Applications
Timothy St. Hilaire , Oracle
When: Jun 27, 2016, Session 6, 4:30 pm – 5:30 pm
Topic: Application Express
Subtopic: Detail Plunge
Dynamic Actions are the declarative way for developers to add usability and features to an application. In this session, we will introduce Dynamic Actions by evaluating requirement scenarios that developers may encounter during the usability testing phase of an application. We will discuss options for improving usability and discuss capabilities of the Dynamic Action features to improve APEX applications.
Avoid Network Issues and Polling with WebSockets!
Kai Donato, MT AG
When: Jun 28, 2016, Session 7, 8:30 am – 9:30 am
Topic: Application Express
Subtopic: Integration
A common solution for “almost” real-time web applications was to use all kinds of polling. Did you benchmark an application that utilizes polling with more than 1,200 clients? I did! You should take a look at the result and see how to avoid all those bottlenecks using WebSocket technologies. See how you can utilize WebSockets to send messages to all your clients without wasting your network and database resources. I will guide you step by step through the implementation of WebSockets using NodeJS and HTML5. You might think this can’t be the solution to your highly frequented web application. Allow me to prove it! A performance test will amaze you! The Oracle Application Express interacting with WebSockets will take your application to a whole new level.
APEX Real Life Stories
Christian Larocque, Insum Solutions
When: Jun 28, 2016, Session 8, 9:45 am – 10:45 am
Topic: Application Express
Subtopic: Real World
Oracle Application Express is widely used and gaining more and more traction in the marketplace. Most IT organizations have heard of APEX, quite a few are using it for departmental applications, but still very few leverage it as their core platform for enterprise wide critical applications, to simplify E-Business Suite, for e-commerce or mobile applications. Come listen to executives and developers from Fortune 500 companies, leading national& universities and successful start-ups who have done it with APEX. They will share their real life experience modernizing critical business systems with APEX, extending EBS and deploying customer facing e-commerce applications. In this session Insum and its clients will tell their stories, how they leverage APEX, how they overcame challenges and provide useful insight to help you be successful with APEX. It is a unique opportunity for you to learn from their experience and ask questions in an open panel format.
Oracle APEX Scripting 101: The Command Line Is Your Friend
Dietmar Aust, Opal-Consulting
When: Jun 28, 2016, Session 9, 11:15 am – 12:15 pm
Topic: Application Express
Subtopic: Real World
Although Oracle APEX is relying heavily on its GUI functionalities to provide a highly productive developer experience, we frequently find ourselves using the command line to complement that.
In this presentation we will showcase the typical use cases where we use the command line in our applications.
The APEXExport and APEXExportSplitter tools enable us to programmatically export everything from our APEX workspaces on the command line.
This comes in handy for automatic daily backups, automated deployments, and source-code control.
We are using the script-based approach with the apex_application_install interface in all of our projects, which increased the reliability of the overall deployment process significantly.
Making use of the available apis (e.g. apex_instance_admin, apex_util, apex_lang) you can create workspaces, users, deploy applications, and translate applications, and control all instance settings, just using the command line. This is convenient in many cases, but mandatory when using the runtime-only environment.
APEX Security: Discussing Real-World Security Risks
Tim Austwick, Recx
When: Jun 28, 2016, Session 10, 2:00 pm – 3:00 pm
Topic: Application Express
Subtopic: Real World
This review of the past year’s consulting will cover a range of security risks observed in APEX applications and architectures, such as SQL Injection, Cross-Site Scripting, and Access Control.
Productive JavaScript Development: Oracle JavaScript Extension Toolkit
Dan McGhan, Oracle
When: Jun 28, 2016, Traditional HOT 8, 3:30 pm – 5:45 pm
Topic: Application Express
Subtopic: Other Application Express
JavaScript-based, single-page applications (SPAs) are incredibly popular these days – and for good reason! This style of application provides developers with a great deal of flexibility and control, and end users enjoy the responsiveness and speed that comes with fewer full-page reloads. To empower developers working on SPAs, Oracle developed the JavaScript Extension Toolkit (JET), a collection of open-source JavaScript libraries along with a set of Oracle-contributed JavaScript libraries that make it as simple and efficient as possible to build applications that consume and interact with Oracle products and services, especially Oracle Cloud services.
In this Hands-On Lab, attendees will learn how to get started building applications with Oracle JET. We’ll jumpstart a new application with the QuickStart template and then extend it out with a few of the components that Oracle JET provides, including a data visualization component.
Technical Deep Dive: Single Sign-On for Your APEX Apps
Niels de Bruijn, MT AG
When: Jun 29, 2016, Session 13, 8:30 am – 9:30 am
Topic: Application Express
Subtopic: Real World
What does it take to get Single Sign-On working for your APEX apps, thereby utilizing the secure Kerberos protocol that is also used by Windows? We will go through the configuration step by step and talk about all the environment-specific details. Before we go in depth, we will also talk about SSO in general. Why should you consider it and when? Is it really secure? No question around this topic will be unanswered in this presentation.
Shaping Up Theme Roller Beyond Universal Theme
Vincent Morneau, Insum Solutions
When: Jun 29, 2016, Session 14, 10:15 am – 11:15 am
Topic: Application Express
Subtopic: Detail Plunge
You’re probably using Theme Roller along with Universal Theme lately. While being awesome, Universal Theme can’t always be used on customer projects because of branding. Did you know you can bring Theme Roller to absolutely any other APEX theme? Theme Roller’s attributes are 100% customizable.
This session is intended for intermediate to advanced developers with an interest in UI. It will demonstrate how the APEX engine parses a LESS file to compile CSS on the fly and how it interacts with you. You’ll be able to build more reusable themes by creating your own theme styles from the ground up.
If you have multiple customers running the same application or simply want to parametrize your styling, this is what you need to increase design productivity.
Merging the Great Divide: Bridging Desktop and Web Applications
Martin D’Souza, Insum Solutions
When: Jun 29, 2016, Session 15a, 12:45 pm – 1:45 pm
Topic: Application Express
Subtopic: Other Application Express
Ever needed to extend your (APEX) application back into the desktop? It’s not easy to do without supporting many different languages and operating systems.
This presentation will cover how to build native desktop applications using Node.js and Electron, which can then easily be deployed to multiple desktop environments. This can also greatly enhance an existing APEX application with native functionality.
Strike That! Securing Data with Oracle Advanced Security & APEX
Scott Spendolini, Sumner Technologies
When: Jun 29, 2016, Session 16, 2:00 pm – 3:00 pm
Topic: Application Express
Subtopic: Real World
There hasn’t been a time in history where data security and privacy is more prominent and important than it is today. With data breaches occurring almost weekly and high profile news stories dominating the mainstream media, organizations are scrambling to make sure that their infrastructures – both on premise and in the cloud – are as secure as they can be.
Fortunately, this task is not as daunting as it seems – when you use the proper tools. This session will highlight how using features of the Oracle Advanced Security option – particularly Redaction, VPD & encryption – can help developers build secure APEX applications.
APEX 5.1 New Features: Part 1
Marc Sewtz, Oracle
When: Jun 29, 2016, Session 17, 3:15 pm – 4:15 pm
Topic: Application Express
Subtopic: New Release
While APEX 5.0 was primarily focused on developer productivity and creating modern user interfaces, APEX 5.1 will be a huge leap in end user productivity. See how the Interactive Grid will bring dynamic, rich-client reporting and multi-row editing capabilities to your APEX applications and how the new, powerful charting engine – based on Oracle’s own JavaScript Extension Toolkit (Oracle JET) – will enable your users to visualize and interact with their data like never before. We’ll also take an in-depth look at numerous other enhancements, such as the new Live Template Options, support for Right-To-Left languages and the future of Page Designer with the integrated Component View. This is part one of a two-hour in-depth session and live demonstration of the new features introduced with APEX 5.1.
APEX 5.1 New Features: Part 2
Marc Sewtz, Oracle
When: Jun 29, 2016, Session 18, 4:30 pm – 5:30 pm
Topic: Application Express
Subtopic: New Release
While APEX 5.0 was primarily focused on developer productivity and creating modern user interfaces, APEX 5.1 will be a huge leap in end user productivity. See how the Interactive Grid will bring dynamic, rich-client reporting and multi-row editing capabilities to your APEX applications and how the new, powerful charting engine – based on Oracle’s own JavaScript Extension Toolkit (Oracle JET) – will enable your users to visualize and interact with their data like never before. We’ll also take an in-depth look at numerous other enhancements, such as the new Live Template Options, support for Right-To-Left languages and the future of Page Designer with the integrated Component View. This is part two of a two-hour in-depth session and live demonstration of the new features introduced with APEX 5.1.
That’s it for today. In a future post we’ll assemble a session list comprised entirely of Insum speakers.
