ODTUG OOW 2016 Sunday Sessions
All sessions should be posted soon to the OpenWorld Content Catalogue.
EPM
UGF6169: Swipe Your Way to Better Analytics on the Cloud with Senior Lifestyle
Sarah Katz, Huron Consulting
Day: Sunday, September 18, 2016
Time: 8:00 - 8:45 am
Room: Moscone South Room 303
This session will focus on Senior Lifestyle's integrated solution with Oracle's BI Foundation Suite (BIFS) and Planning Budgeting Cloud Service (PBCS) to provide a best-in-class budgeting, forecasting, and reporting solution.
UGF6308: Hyperion Planning Interface: Simplified!
Cindy Eichner, Finit Solutions
Day: Sunday, September 18, 2016
Time: 9:15 - 10:00 am
Room: Moscone South Room 303
Learn how to implement Hyperion Planning’s Simplified Interface. Enhance and simplify the user experience with demonstrations of customization techniques and tips for guiding the user through the planning process. See examples of existing applications that were converted from the classic interface to the simplified interface. Leave this session knowing how to implement the simplified interface.
UGF6421: Why Finance and IT Love Hyperion in the Cloud
Alex Leung, The Goal Getters
Day: Sunday, September 18, 2016
Time: 10:30 - 11:15 am
Room: Moscone South Room 303
Join us to hear firsthand from an Oracle customer why their finance and IT teams love Hyperion in the Cloud. Learn about how they decided between on-premise/in-house managed, traditional hosting/application managed services, Oracle Cloud (PBCS), and cloud hosting/application managed services. We will also provide a glimpse of what is happening behind the scenes for Hyperion in the Cloud as well as share the user experience over a year after go-live.
UGF7494: Implementing the World's Largest Exalytics Program
Gary Crisci, General Electric
Day: Sunday, September 18, 2016
Time: 11:45 - 12:30 pm
Room: Moscone South Room 303
This session walks you through an overview of General Electric’s Oracle Exalytics program. The session discusses the business case for Oracle Exalytics and the infrastructure, which comprises 19 Oracle Exalytics servers (T5 and X4). It then goes on to discuss the tech stack installed on the platform, how GE is managing the infrastructure, and how GE is consolidating multiple enterprise performance management environments to this new shared service. The session wraps up with success stories and performance scorecards showing the gains GE is obtaining from the Oracle Exalytics platform.
UGF7495: Introduction to Oracle Essbase Hybrid Aggregation Mode
Jake Turrell, Turrell Consulting
Day: Sunday, September 18, 2016
Time: 1:00 - 1:45 pm
Room: Moscone South Room 303
The new Essbase Hybrid Aggregation Mode is generating a lot of excitement in the EPM Community. However, few practitioners have worked with Hybrid, and successful implementations require advanced Essbase skills. This session will provide an end-to-end tutorial on implementing Essbase Hybrid Aggregation Mode, including live demos. Attendees will leave with a meaningful understanding of the benefits, limitations, and pitfalls associated with this new calculation engine, as well as a structured implementation approach.
UGF2782: Oracle Hyperion 11.1.2.4 Architecture Live Demo
Nicholas King, Google
Day: Sunday, September 18, 2016
Time: 2:15 - 3:00 pm
Room: Moscone South Room 303
The best way to learn is to jump in. This live demo will explore infrastructure topics using a 11.1.2.4 virtual enviroment. Dive right into general EPM architecture including the new 11.1.2.4 HFM architecture, explanation of Web components and WebLogic, triaging issues in the environment, and tuning tips. This session is a great way to go beyond the slide decks and see the system first hand.
UGF5520: Cloud Atlas: Navigating the Ever Expanding Oracle EPM Cloud Landscape
Edward Roske, interRel Consulting
Day: Sunday, September 18, 2016
Time: 2:15 - 3:00 pm
Room: Moscone South Room 104
Companies around the world are embracing the cloud. Oracle is investing millions of dollars of research and development into the most complete EPM cloud offering in the world. Whether it's Hyperion Planning in the cloud (PBCS), Business Intelligence in the cloud (BICS and the new Essbase in the Cloud), Financial Consolidations in the cloud (FCCS), or more, Oracle now has a strategy and a product for every EPM need. Where should you begin? What products are ready now? How quickly will I need to move our products to the cloud? All this and more will be revealed by an Oracle ACE Director whose head is not in the clouds but can see through the clouds. If you want to be at the forefront of navigating the cloud landscape, this is the session for you.
UGF4215: Financial Close Manager Implementation and Integration with SAP: A Case Study
Katherine Ritsema, KPMG
Day: Sunday, September 18, 2016
Time: 3:30 - 4:15 pm
Room: Moscone South Room 303
Join this session to learn more about a large-scale implementation of Hyperion Financial Close Manager, integrated with SAP. The client, a $16 billion organization, managed the close process using various Excel-based checklists. There was little visibility of the progress of the close processes and the process that was very employee-/role-centric at a global scale. The client partnered with KPMG to implement Hyperion Financial Close Manager in one of the largest FCM implementations to date using a phased, by-region approach. The client achieved multiple benefits from the FCM implementation, including an integrated close solution process with the ability to actively monitor the process and key tasks via FCM’s dashboard functionality.
UGF5347: Data and Metadata Integration for Cloud and Hybrid Environments
Jon Harvey, eCapital Advisors
Day: Sunday, September 18, 2016
Time: 3:30 - 4:15 pm
Room: Moscone South Room 104
Unless you’ve been living under a rock, some Oracle EPM salesperson has probably told you all about “the cloud.” If you’re anything like me, your first thought was, “How do I integrate the cloud with my upstream systems?” Don’t worry; Oracle has a suite of tools specifically built for this purpose. In this session, we’ll walk through the tools available to you for moving data to and from your cloud instances. We’ll provide examples of design changes that will reduce your data integration headaches and answer questions such as, "How do I get my HR data from on-prem Workday into PBCS?" and "How do I get my nightly backups!?" Join us as we turn the death of remote desktop access into a celebration of life in the cloud!
BUSINESS INTELLIGENCE
UGF6075: Data Wrangling, Blending and Mash-ups
Wayne Van Sluys, interRel Consulting
Day: Sunday, September 18, 2016
Time: 8:00 - 8:45 am
Room: Moscone South Room 301
With the release of Oracle BI Cloud Service (BICS) and OBIEE 12c, the ability for users to include External Subject Areas (XSAs) with curated models has introduced many new terms to the lexicon of Business Intelligence and data visualization. This session will break down the technical processes going on behind the scenes when using data wrangling, data blending, and data mashups with XSAs and the functional use of each.
UGF6160: Introduction to Kafka and Real-Time Data Processing
Gwen Shapira, Confluent
Day: Sunday, September 18, 2016
Time: 9:15 - 10:00 am
Room: Moscone South Room 301
DBAs and data architects care about providing consistent performance on our OLTP databases and making sure the ETL processes will run correctly and on time. Business analysts care about getting real-time data to business dashboards and being able to run reports really fast. We also want to be able to get all the data without having to integrate with many different data stores. Apache Kafka, a distributed queue developed at LinkedIn to solve the problem of integrating databases at large scale, offers a surprising solution to all these problems, which probably explains why it has gained popularity so fast. In this session, we will explain what Apache Kafka is and why it rapidly has become the secret weapon in the fight to keep databases sane.
UGF6161: Oracle GoldenGate and Apache Kafka: A Deep Dive Into Real-Time Data Streaming
Michael Rainey, Rittman Mead
Day: Sunday, September 18, 2016
Time: 10:30 - 11:15 am
Room: Moscone South Room 301
We produce quite a lot of data! Much of the data are business transactions stored in a relational database. More frequently, the data are non-structured, high-volume, and rapidly changing datasets known in the industry as Big Data. The challenge for data integration professionals is to combine and transform the data into useful information. Not just that, but it must also be done in near real-time and using a target system such as Hadoop. The topic of this session, real-time data streaming, provides a great solution for this challenging task. By integrating GoldenGate, Oracle’s premier data replication technology, and Apache Kafka, the latest open-source streaming and messaging system, we can implement a fast, durable, and scalable solution.
UGF6163: Load Data Using Data Sync For The Oracle Business Intelligence Cloud Service
Kevin McGinley, Red Pill Analytics
Day: Sunday, September 18, 2016
Time: 11:45 - 12:30 pm
Room: Moscone South Room 301
Now that you own the Oracle Business Intelligence Cloud Service, this session will walk you through the details of how to load data into the cloud using the Data Sync tool provided by Oracle. You'll see how to get up and running with Data Sync, load data from files and databases, and manage the ongoing refresh of the data. In addition, the session will provide tips for managing your end-to-end data flow, including transformations within the included schema as a service.
UGF6162: Data Streaming and Analytic Microservices
Stewart Bryson, Red Pill Analytics
Day: Sunday, September 18, 2016
Time: 1:00 - 1:45 pm
Room: Moscone South Room 301
While traditional data warehouses excel at sourcing data from enterprise applications, they usually fail at handling the volume, velocity, and variety of new sources of information. Instead of modeling these data sources into a system that doesn't fit, let's apply a new software design patterns to analytics: microservices. Microservices are small, independent applications – building blocks that provide distinct functionality and optimized for the task at hand.
UGF5406: We Purchased BICS; Now How do I Get Started?
Mike Jelen, eCapital Advisors
Day: Sunday, September 18, 2016
Time: 2:15 - 3:00 pm
Room: Moscone South Room 301
Once you have signed the contract to purchase BI Cloud Services (BICS), there are a series of steps that you will need to walk through to get started. Come to this session to learn about the step-by-step process and walk away from this session with all of the instructions you need to start building your dashboard and data visualizations using your own data.
UGF6164: Data Visualization and Discovery
Christian Screen, Art of BI
Day: Sunday, September 18, 2016
Time: 3:30 - 4:15 pm
Room: Moscone South Room 301
For years, the ability to analyze data to discover new insights through impressive visualizations and rapid prototyping with custom, ad-hoc, or enterprise data has been out of reach for Oracle customers. Now, as part of the Oracle BIEE system, Oracle BI Visual Analyzer (VA) technology has filled the gap with an integrated solution that gives business users and developers alike the power to gain insights through visual discovery. These visual discoveries can then be carried over as production-ready reports for stunning presentations and analysis using standardized Oracle BI subject areas or data mashups with custom data with Excel spreadsheets. Attend this session to learn about Oracle Visual Analyzer and its ability to provide self-service data discovery to compete with other data visualization tools on the market today such as Tableau and how Visual Analyzer can be part of your next OBIEE implementation. Attendees will witness a demonstration of the Oracle BI Visual Analyzer solution taking a real-world business use case from end to end to learn how straightforward it is to tell a compelling story with data and prototype with greater speed of delivery, all while gaining insights to information with this new cutting-edge data visualization access.
DATABASE/ADF/MAF/CLOUD
UGF5641: SQLcl: A Modern Command Line Interface to the Oracle Database
Galo Balda, Texas Health & Human Services
Day: Sunday, September 18, 2016
Time: 8:00 - 8:45 am
Room: Moscone South Room 302
SQLcl is a new Java-based command line interface that takes advantage of SQL Developer’s scripting engine to deliver a modern command line interface that is backward compatible with SQL*Plus but also introduces new commands and features that have been missing for a long time. In this session, we will explore the new in-line editing, query history, aliasing, output formatting, DDL generation, and scripting options that set SQLcl apart from its predecessor.
UGF3572: Read, Store, and Create XML and JSON
Kim Berg Hansen, Trivadis Danmark A/S
Day: Sunday, September 18, 2016
Time: 9:15 - 10:00 am
Room: Moscone South Room 302
Oracle now supports JSON in the database similar to how XML has been supported since version 9. Both offer ways to work with data that can be more dynamic in nature than typical relational data. Both offer ways to exchange data between applications, which is highly relevant in a world mixing cloud and on-premise – typically XML for SOAP and JSON for RESTful Web Services. Each has different pros and cons that might make either XML or JSON preferable for different uses. This session will look at differences and similarities of XML and JSON in Oracle and show different ways to query and create XML and JSON, various options to store it, and methods for exchanging the XML and JSON with the outside world either incoming or outgoing.
UGF6080: Digital Transformation: Your First Steps with Oracle Mobility
Mia Urman, AuraPlayer Ltd.
Day: Sunday, September 18, 2016
Time: 10:30 - 11:15 am
Room: Moscone South Room 302
By the end of 2015, half the world’s population had a powerful computer in their pocket – their mobile phone. Studies reveal the mobile app market is now influencing more than $500 billion in sales and daring to be an even bigger revolution than the Internet. Digital leaders have quickly realized that mobile, if used effectively, can change the game in their industry. The key to success is having a comprehensive, secure, flexible, and open mobile strategy that drives mobile ROI. Mobile is the primary screen and at the core of any digital strategy. In this session, gain insights and learn how you can develop an end-to-end enterprise mobile strategy, increase your mobile ROI, and build your competitive advantage.
UGF6148: Give MAF a REST: Using REST/JSON Services in MAF
John Jay King, King Training
Day: Sunday, September 18, 2016
Time: 11:45 - 12:30 pm
Room: Moscone South Room 302
Oracle’s Mobile Application Framework (MAF) builds web applications quickly and easily that port to iOS and Android devices without target-specific customization. MAF applications may use data from POJOs, the local SQLite database, SOAP/XML Web Services, REST/XML Web Services, and REST/JSON Web Services. This presentation will show attendees how to create MAF applications based upon REST/JSON Web Services. The combination of REST and JSON has become the standard mechanism for communicating with mobile applications; MAF developers attending this session will learn how to use them.
UGF2210: A Holistic Approach to Database Security
Robert Lockard, Oracle Wizard
Day: Sunday, September 18, 2016
Time: 1:00 - 1:45 pm
Room: Moscone South Room 302
This is a discussion about defining the attack surface and what attack vectors are relevant to each node on the attack surface so the attendee understands the concept of exploiting different nodes on the system, how attack vectors change for nodes, and mitigation change for nodes. Understanding the trusted path concept, an Oracle professional can then start applying mitigation to points along the trusted path to protect data. We will present four things the DBA and developer can do now to secure the database environment right now. In closing, we will take a piece of PL/SQL that is subject to SQL injection and move through securing the code using 12C features and separating the data from the application code.
UGF6168: SQLd360, SQL Tuning Diagnostics Made Easy
Mauro Pagano, Accenture Enkitec Group
Day: Sunday, September 18, 2016
Time: 2:15 - 3:00 pm
Room: Moscone South Room 302
SQL Tuning isn't an easy task, especially when considering diagnostic collection and data analysis. SQLd360 is a new free tool built from the ground up with the idea of making diagnostics collection faster and easier without having to install anything in your database. At the same time, data analysis is made much easier with charts and graphs that help quickly answer even complex questions. This session will focus on how SQLd360 can be used to resolve real-life issues, showing how charts and graphs make SQL Tuning much easier.
UGF5049: Barriers To Oracle Database In The Cloud
Tim Gorman, Delphix
Day: Sunday, September 18, 2016
Time: 3:30 - 4:15 pm
Room: Moscone South Room 302
Cloud vendors prefer that everyone migrate to the cloud, but what often happens is that non-production migrates for cost reasons, while production stays on-premise. This phased path to the cloud can leave IT with a split personality: production on-premise on legacy proprietary UNIX platforms and non-production in the cloud on commodity Linux platforms. As the security risk in non-production is much higher than production, there is a requirement to mask personally identifiable information or confidential data before it is copied to non-production. Data as a service employs thin cloning, snapshots, and network-attached presentation, reducing cloning from hours or days to minutes. Learn how data virtualization and masking make it feasible.
APPLICATION EXPRESS
UGF6149: A Primer on RAS in APEX
Dimitri Gielis, APEX R&D
Day: Sunday, September 18, 2016
Time: 8:00 - 8:45 am
Room: Moscone South Room 304
When it comes down to securing your data, it's best to do that on the lowest level possible, meaning in the Oracle Database. Before, VPD was one of the solutions for this. In this session, I want to talk about Oracle 12c Real Application Security (RAS), the successor of VPD, and how to integrate that in APEX.
UGF6150: Strike That! Securing Data with Oracle Advanced Security & APEX
Scott Spendolini, Sumner Technologies
Day: Sunday, September 18, 2016
Time: 9:15 - 10:00 am
Room: Moscone South Room 304
There hasn't been a time in history when data security and privacy are more prominent and important than they are 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, and encryption – can help developers build secure APEX applications.
UGF6151: Affordable Workflow Options for Your APEX App
Niels de Bruijn, MT AG
Day: Sunday, September 18, 2016
Time: 10:30 - 11:15 am
Room: Moscone South Room 304
"Can I model workflows with APEX 5.x?" How do you react when you get such a requirement? If your answer is, "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.
UGF6156: Structuring an APEX Application
Alex Nuijten, allAPEX
Day: Sunday, September 18, 2016
Time: 11:45 - 12:30 pm
Room: Moscone South Room 304
Creating beautiful applications with APEX is easy. But there is more to APEX that meets the eye. There is an Oracle Database underneath it all. Building a robust database application is vital for data integrity and performance. In this session, you will learn how to set up your database application and hear suggestions for how to improve your current applications.
UGF6158: Mastering the APEX Universal Theme
Roel Hartman, APEX Consulting
Day: Sunday, September 18, 2016
Time: 1:00 - 1:45 am
Room: Moscone South Room 304
One of the most important features of Oracle Application Express 5 is the Universal Theme. This theme allows every database developer to create great-looking applications without knowing any JavaScript, HTML, or CSS. But how do you make changes to comply with your company branding in such a way that you don't break anything else? And how do you add new templates and template options? In this session, you will learn how the Universal Theme works, what the components are, and what you should and shouldn't do when you make your changes.
UGF6152: Open Source and APEX: Join the Movement
Martin D'Souza, Insum Solutions, Inc.
Day: Sunday, September 18, 2016
Time: 1:00 - 1:45 am
Room: Moscone South Room 104
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 Oracle (and APEX) development practices and integrate them in your applications. It will highlight some popular open-source projects that will help reduce your development costs and improve consistency throughout your applications.
UGF5667: APEX PI: Interfacing the Raspberry Pi with APEX
Christoph Ruepprich, Accenture Enkitec Group
Day: Sunday, September 18, 2016
Time: 2:15 - 3:00 pm
Room: Moscone South Room 304
This presentation will demonstrate how we control hardware, such as buttons and lights, attached to a Raspberry Pi from an APEX application. With the use of Node.js and some publicly available libraries, we can gain access to the Raspberry Pi’s input/output port. We can poll these ports and display their statuses in APEX, and further switch lights on and off by clicking buttons in APEX. We will also have some audience participation; we participants can connect to our application and compete in a game.
UGF5265: Designing Optimal Oracle Application Express Applications for the
Patrick Cimolini, Insum Solutions, Inc.
Day: Sunday, September 18, 2016
Time: 3:30 - 4:15 pm
Room: Moscone South Room 304
Oracle Application Express (APEX) is a mature cloud-ready web development tool. This presentation explores design decisions that must be considered before building large cloud based APEX applications. Cloud applications are often designed from within a narrow developer perspective. Developer designs are often sub-optimal when they are exposed to a wider enterprise perspective. Based on over ten years of APEX development experience, the presenter highlights key design decisions that must be optimized to satisfy the inter-related and conflicting goals of all the stakeholders who design, build, test, maintain, use, and pay for large APEX cloud applications. Careful, and sometimes painful, optimization through design leads to success.
