ODTUG Oracle OpenWorld 2017 Sunday Sessions                                  APEX.pngBI.pngDatabase.pngEPM.png



APEX


IoT: Oracle REST Data Service and Oracle JavaScript Extension Toolkit
Anton Nielsen, C2 Consulting, Inc.

Day: Sunday, October 1, 2017
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 Oracle Application Express
Francis Mignault, Insum Solutions

Day: Sunday, October 1, 2017
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 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

Day: Sunday, October 1, 2017
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 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

Day: Sunday, October 1, 2017
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 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.


Life After Oracle Forms: The Move to Oracle Application Express
Alex Nuijten, allAPEX

Day: Sunday, October 1, 2017
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

Day: Sunday, October 1, 2017
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.


Back to Top


Business Intelligence
 

Expanding Your Data-Driven Story: The Next Chapter
Stewart Bryson, Red Pill Analytics

Day: Sunday, October 1, 2017
Time: 9:45 - 10:30 a.m.
Location: Marriott, Salon 12

Oracle Data Visualization makes it easy to get insight from your data. This stunningly visual and intuitive product enables you to access, blend, and wrangle a variety of sources, including spreadsheets, databases, and applications, and tell the story of your data. In this session learn about the power of data storytelling and the latest capabilities of Oracle Data Visualization (including details of the product roadmap) to create compelling analytics narratives, including how you can rapidly apply advanced analytics techniques to gain insights previously only accessible to advanced users. Learn about how Oracle Data Visualization has been used in real-life scenarios to gain insight and improve business performance.


Build Your Own Infographics Using Oracle Data Visualization 
Antony Heljula, Peak Indicators Limited

Day: Sunday, October 1, 2017
Time: 10:45 - 11:30 a.m.
Location: Marriott, Salon 12

Oracle Data Visualization has already made a huge impact with its excellent visualization and storyboarding features. This session demonstrates how to take these capabilities one step further by using the Oracle Data Visualization software development kit. The SDK provides the tools for developing your own custom visuals within Oracle Data Visualization, enabling you to deliver sophisticated infographics that can tell your stories in new and exciting ways.



Finding the Forest in the Trees: Designing and Implementing an Analytics System
Mike Nader, Incorta

Day: Sunday, October 1, 2017
Time: 10:45 - 11:30 a.m.
Location: Marriott, Salon 13

Business Intelligence is about three things: analysis, access, and visibility. Increasingly, business analysts are demanding insight into ever-more-detailed data. A well-designed BI system should not just tell you what happened, but why it happened. It should help you find the needle in the haystack. This session presents both a case study and tips and tricks around implementing an analytics system and strategy. During the session participants see live demonstrations of a prototype environment as well as discuss design principles and implementation processes.


Transitioning from Oracle Business Intelligence On-Premises to the Cloud 
Peter Koutroubis, ERP Analysts

Day: Sunday, October 1, 2017
Time: 11:45 a.m. - 12:30 p.m.
Location: Marriott, Salon 12

The transition from Oracle Business Intelligence on-premise to Oracle Business Intelligence Cloud Services can be a challenging and rewarding initiative. This session provides relevant information to anyone looking to make this transition. The discussion is focused on the roles involved, including business intelligence analyst, ETL developer, and system admin/DBAs. It also covers the full-solution lifecycle of an implementation including design, fit/gap analysis, build, test, implementation, and post-go-live.


Kafka's Role in Implementing Oracle's Big Data Reference Architecture
Robin Moffatt, Confluent

Day: Sunday, October 1, 2017
Time: 1:45 - 2:30 p.m.
Location: Marriott, Salon 12

Big data... big mess? Without a flexible and proven platform design up front there is the risk of a mess of point-to-point feeds. The solution to this is Apache Kafka, which enables stream or batch consumption of the data by multiple consumers. Implemented as part of Oracle's big data architecture, it acts as a flexible and scalable data bus for the enterprise. This session introduces the concepts of Kafka and a distributed stream platform, and explains how it fits within the big data architecture. See it used with Oracle GoldenGate to stream data into the data reservoir, as well as ad hoc population of discovery lab environments, microservices, and real-time search.


Oracle Essbase Reporting With Oracle Business Intelligence, Enterprise Edition
Mike Nader, Incorta

Day: Sunday, October 1, 2017
Time: 1:45 - 2:30 p.m.
Location: Marriott, Salon 13

Oracle Business Intelligence Foundation Suite contains two world-class modeling and reporting engines: Oracle Essbase and Oracle Business Intelligence Server. Integrating the two engines has, over the years, been complex. The Oracle Essbase user community felt integration lost capabilities, but in truth Oracle Business Intelligence, Enterprise Edition provides opportunities for greater analysis. This session provides two client case studies and tips and tricks for reporting on Oracle Essbase with Oracle Business Intelligence. See live demonstrations of RPD modeling techniques for working with Oracle Essbase models, reporting tricks for dynamic filtering of Oracle Essbase reports, and ways to use advanced Oracle Business Intelligence, Enterprise Edition capabilities for asymmetric reporting.


The Data Chain: Oracle's Data Infrastructure as the Basis for Data Warehousing
Rene Kuipers, SLTN

Day: Sunday, October 1, 2017
Time: 2:45 - 3:30 p.m.
Location: Marriott, Salon 12

From Oracle Database 12<i>c</i> (with or without the in-memory option) all the way up to the Exalytics machine and Oracle Business Intelligence, Enterprise Edition 12<i>c</i> and Oracle Business Intelligence Cloud Service, every component in the data chain has its function and role. And sometimes it's hard to decide where to put certain elements of your data chain from storage perspective, but also from transformation perspective. In this session learn how one data infrastructure has improved business processes and cut costs.

High-Availability Oracle Data Integration Without the Need for J2EE
Holger Friedrich, sumIT AG

Day: Sunday, October 1, 2017
Time: 3:45 - 4:30 p.m.
Location: Marriott, Salon 12

The Internet of Things (IoT), cloud-based products, or real-time data warehousing—almost every state-of-the-art data integration (DI) application requires high-availability (HA). In this session learn how Oracle Data Integration provides different installation alternatives offering different degrees of HA. Moreover, different platforms such as Exadata allow only certain DI installation types. Learn the different HA and installation types available from Oracle, with a special focus on how to achieve HA without having to pay for J2EE licenses. See how HA can be achieved easily with little implementation effort on non-J2EE installations.


Back to Top


Database

Leveraging Oracle Database SQL and PL/SQL to Simplify User Interface App Dev
Peter Koletzke, Quovera

Day: Sunday, October 1, 2017
Time: 10:45 - 11:30 a.m.
Location: Marriott, Salon 10/11

If you develop applications for an Oracle Database, the development framework approach known as "thick database" can provide benefits. This approach to development evolved from discussions in ODTUG channels more than 10 years ago. The thick database approach consists of centralizing most application logic in the database. It also shields the application from UI technology changes, so if an application framework needs to be changed, the amount of code to rewrite is much less. This session explains the benefits for using this approach. It also describes different levels at which you can use the thick database principles and how to decide which level to use. It also discusses how business rules logic can be centralized and standardized.


My Favorite Oracle Database 12c R2 New Features
Galo Balda, State of Texas

Day: Sunday, October 1, 2017
Time: 12:45 - 1:30 p.m.
Location: Marriott, Salon 10/11

In this session learn about the new Oracle Database 12c R2 features that Galo Balda finds the most exciting and that can help you build more robust database applications. Key points covered include PL/scope reports on static SQL statements, enhanced CAST function with error handling, new SQL and PL/SQL function VALIDATE_CONVERSION, enhanced LISTAGG functionality, long identifiers, online conversion of a nonpartitioned table to a partitioned table, and online table move.


Alexa, How Do You Work With Oracle REST Data Services?
Jonathan Dixon, JMJ Cloud

Day: Sunday, October 1, 2017
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!


Back to Top


EPM


Jumpstart Cost Allocations: Oracle Profitability and Cost Management Cloud Service
Joe Aultman, interRel Consulting

Day: Sunday, October 1, 2017
Time: 9:45 - 10:30 a.m.
Location: Marriott, Salon 1-3

In this session learn how Oracle Profitability and Cost Management Cloud Service provides a complete graphical interface to simplify the build and execution of complicated allocation rules in Oracle EPM Cloud, with no scripting required. Some beloved Oracle Hyperion Profitability and Cost Management features are included, such as the traceability interface and rules balancing report, along with new prebuilt dashboards. Oracle Profitability and Cost Management Cloud Service sits entirely on top of Essbase and supports any costing methodology. Discover how Oracle Profitability and Cost Management Cloud Service allows users to get an inside look at the drivers of costs as they audit the profitability of their organization. 


Backstage Pass: Lesser-Known Features of Oracle Hyperion Financial Management
Christopher Barbieri, Finit Solutions

Day: Sunday, October 1, 2017
Time: 9:45 - 10:30 a.m.
Location: Marriott, Salon 10/11

Oracle ACE Chris Barbieri takes you backstage to work with some lesser-known Oracle Hyperion Financial Management administrator features. In this session learn about the Insights module, review common system messages, and make use of the admin mode while performing application updates. Discover a few Oracle Hyperion Financial Management system settings to control behavior and explore module configuration. The session also covers shared services logs and the data audit log for tracking user activity and data changes. Please note that although some of these features are specific to Release 11.1.2.4, many of them apply to earlier releases as well.


Oracle Essbase Cloud Service Is Here: Now What?
Tim German, Qubix

Day: Sunday, October 1, 2017
Time: 10:45 - 11:30 a.m.
Location: Marriott, Salon 1-3

Oracle Essbase Cloud Service is finally among us. But what does that really mean? How does it fit into our existing EPM environments? What does Oracle Essbase Cloud Service actually do that's better than before? What paths are not taken? In short, does Oracle Essbase Cloud Service live up to its promise? In this session join Tim German as he explores and explains Oracle Essbase Cloud Service's architecture, functionality, use cases, cost, and performance. This comprehensive review of the essence of Oracle Essbase in the cloud gives you the answers and direction you need to go forward with Oracle Essbase now and in the future.


Oracle Planning and Budgeting Cloud Service/Oracle Business Intelligence Cloud Service
Robert Gideon, interRel Consulting

Day: Sunday, October 1, 2017
Time: 11:45 a.m. - 12:30 p.m.
Location: Marriott, Salon 13

Oracle has powerful planning and forecasting solutions in Oracle Planning and Budgeting Cloud Service, as well as easy-to-use visualizations and dashboarding in Oracle Business Intelligence Cloud Service. Oracle Planning and Budgeting Cloud Service has its own dashboarding capabilities, but there is still a compelling use case for combining it with Oracle Business Intelligence Cloud Service into a best practice solution. In this session learn why and when it makes sense to combine the two, what stage of the implementation process to combine them, and how to actually integrate data between the two solutions. See a demo of the integrations and witness the power of Oracle Business Intelligence Cloud Service on top of Oracle Planning and Budgeting Cloud Service from an end user perspective.


Implementing Oracle Financial Consolidation and Close Cloud Service: Lessons Learned
Mike Janik, New Flyer Industries

Day: Sunday, October 1, 2017
Time: 11:45 a.m. - 12:30 p.m.
Location: Marriott, Salon 1-3

In this session, hear how one company implemented Oracle Financial Consolidation and Close Cloud Service one month after it was released. Learn about the journey moving from Oracle Hyperion Financial Management, the differences and similarities with Oracle Financial Consolidation and Close Cloud Service, and the workarounds that were devised to enable the solution to deliver what was needed. Learn from this journey of exploration (so you can be a lot smarter on your journey).


Evaluating Deployment Options: Oracle Hyperion Enterprise Performance Management
Eric Helmer, Mercury Technology Group

Day: Sunday, October 1, 2017
Time: 12:45 - 1:30 p.m.
Location: Marriott, Salon 1-3

Today, the word cloud is everywhere, and it's causing a lot of confusion. Software as a service, infrastructure as a service, and platform as a service are completely different solutions but all are considered cloud solutions. This session compares the options Oracle customers have to deploy Oracle Hyperion Enterprise Performance Management. Get detailed information about Oracle's cloud offerings, IaaS, third-party hosting, on-premises deployments including Exalytics, and hybrid approaches, and learn the differences in functionality, data integration, security, flexibility, and scalability.  If you are looking to make a decision on how best to deploy, upgrade, or outsource Oracle Hyperion Enterprise Performance Management, this is a don't-miss session.


Oracle Planning and Budgeting Cloud Service for the Merger of Citrix GoTo/LogMeIn
Matt Ward, Peloton Group

Day: Sunday, October 1, 2017
Time: 1:45 - 2:30 p.m.
Location: Marriott Salon 1-3

For many organizations, financial and business planning is a complex process facilitated by time-consuming spreadsheet activities including preparation, data input, calculations, reporting, and reviews.  For organizations going through a merger these costs are multiplied even further. But it doesn't have to be that way. In this session learn how Oracle Planning and Budgeting Cloud Service provides a path for the rapid deployment of integrated planning business processes. Using the configurable features of these out-of-the-box capabilities, organizations can reduce the effort and cycle time of planning processes,  at a lower overall cost. The session includes the customer story of the merger of Citrix's GoTo division with LogMeIn.  


I Have an MDX Script for That
Gary Crisci, General Electric

Day: Sunday, October 1, 2017
Time: 2:45 - 3:30 p.m.
Location: Marriott, Salon 1-3

With the release of Oracle Essbase 11.1.2.4.010, it is now possible to get clean MDX output from a MaxL script. This opens many doors and possibilities for developers and power users, and makes knowing how to write a solid MDX script a must-have skill for Oracle Essbase professionals. In this session learn the fundamentals of writing MDX scripts. Discover the new delimited output options and learn ways to leverage this new feature. Attendees hear how they can use their MDX scripts to create advanced reports and how to format data for ingestion to other systems. How to use the query and load (Q&L) method to leverage MDX scripts as an alternative to ASO calc scripts is also covered. Don't miss this informative session.


Elevating Your Workforce Planning Solution to the Cloud
Nicholas Blazosky, TopDown Consulting

Day: Sunday, October 1, 2017
Time: 3:45 - 4:30 p.m.
Location: Marriott, Salon 1-3

Thinking about elevating your organization's Workforce Planning Solution? Want to see a detailed demo of the capabilities of the latest version of Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS), SWP (Strategic Workforce Planning), and Workforce planning modules? What has changed since the days of deployment in on-premise, and how can you be leveraging the enhanced functionality for your organization? Learn the differences between an on-premise deployment and strategies for getting you to the cloud in no time. The demo will have a unique San Antonio twist to get you into the spirit of being in the heart of South Texas. Join seasoned WFP architects and Kscope speakers Ludovic De Paz and San Antonio native Nicholas Blazosky for this informative deep dive into the newly enhanced world of Workforce.

Back to Top