ODTUG OOW 2014 Sunday Symposiums

Are you a developer or architect who wants in-depth technical training at Oracle OpenWorld? 

ODTUG is proud to offer five Symposiums on Sunday, September 28, 2014 at Oracle OpenWorld in San Francisco, CA. ODTUG Symposium topic areas are: Database Development, Business Intelligence, ODTUG ADF EMG Fusion, Hyperion/EPM, and Application Express. Click one of the content areas below to view the session line up.

ODTUG Sessions at Oracle OpenWorld 2014
We have more sessions during the week, check them out here.


DATABASE DEVELOPMENT - Moscone South - 301
9:00 AM - 4:15 PM

Managing Historic Data With Flashback Data Archives
Bjoern Rost, Portrix Systems GmbH

Time: 9:00 AM – 9:45 AM
Session: UGF5801

 Learn how you can use Oracle Flashback data archives to easily access historical data in your applications. This presentation starts with a basic overview of functionalities of Oracle Flashback and how developers and ISVs can use it in their applications. The second part of the presentation focuses on the inner workings of Oracle Flashback archives and how Oracle makes use of partitioning and compression to achieve a great level of performance for these types of queries. Last, it offers best practices for dealing with Oracle Flashback-enabled tables, such as setting up test cases, exporting historical data to development databases, using data manipulation language (DML) on those tables, and other issues the speaker has come across in the past.

Scaling to Infinity: Partitioning DW on Oracle Database
Tim Gorman, Delphix

Time: 10:00 AM – 10:45 AM
Session: UGF3587

 Partitioning is known as a useful feature in very large databases, but how many people realize it is absolutely crucial to scalability and performance in data warehouses? The question, of course, is why partitioning is so crucial as well as how it facilitates scalability and performance. All the useful features for data warehousing in Oracle Database are facilitated by partitioning in a cycle described in this presentation as the virtuous cycle. The presentation is the result of 15 years of extensive data warehouse experience in numerous industries. It provides answers and guidelines so you will understand how and why to utilize partitioning. You will come away with information you can use at work immediately.

Oracle 12c For Developers
Alex Nuijten, Ordina

Time: 11:00 AM – 11:45 AM
Session: UGF3100

Do you want to get up to speed with the most current release of Oracle Database? If so, this session is for you. You will learn about the most exciting and useful new features of Oracle Database 12c that can make your work as a database developer a lot easier. There is more to Oracle Database 12c than just pluggable databases. 

Regular Expressions 101
Danny Bryant, City of Atlanta

Time: 12:00 PM – 12:45 PM
Session: UGF9128

Sometimes you have to find or replace a particular set of characters in a database column. Regular expressions are a powerful feature available in Oracle Database when it comes to pattern matching. However, implementing a regular expression in your SQL code can prove difficult. The goal of this presentation is to demystify regular expressions and provide some simple concepts to aid in understanding them. This presentation assumes you are familiar with simple pattern matching, using the LIKE statement in conjunction with wildcards such as ‘%’ and ‘_’. Sometimes, however, there is a need to match a more complex pattern that cannot rely on the all-or-nothing approach available with the LIKE statement. 

Getting Started With SQL Pattern Matching in Oracle 12c
Galo Balda,  
Texas Health & Human Services (HHSC)

Time: 1:30 PM – 2:15 PM
Session: UGF4482

Oracle Database 12c provides a completely new native SQL syntax that uses the power of regular expressions to enable inter-row pattern search capability. This session explores the new Oracle Database 12c MATCH_RECOGNIZE construct, which makes it possible to define patterns and provides the ability to search for those patterns across rows. The presentation also reviews interesting examples that previously required complex queries and how to simplify them with the new pattern matching functionality available in Oracle Database 12c. 

Just Log It
Martin D'Souza, Clarifit

Time: 2:30 PM – 3:15 PM
Session: UGF3498

Code instrumentation is critical in helping developers debug applications. This session covers Logger, an open source PL/SQL logging tool used in many organizations. The presentation discusses the latest features of Logger, along with integration into Oracle Application Express and how to take proactive approaches to error handling in your applications.

Dev Ops, Databases and The Phoenix Project
Kyle Hailey, Delphix

Time: 3:30 PM – 4:15 PM
Session: UGF4042  

This session explores one of the major bottlenecks in database application development: the movement of data, from production databases and development to QA, user acceptance testing, and test—including building and managing development and QA environments. The presentation discusses what the impact is, how to solve these bottlenecks, and what metrics to track to validate the solution.  

Back to Top


9:00 AM - 4:15 PM

Building a BI Competency Center 
Mike Jellen, eCapital Advisors

Time: 9:00 AM – 9:45 AM
Session: UGF9143

Building a Business Intelligence Competency Center (BICC) is a joint business & IT team that focuses on implementing their company's information strategy. This competency center is a key pillar of success to any organizations BI Program. There are many components in the why, how and when companies implement a BICC. If you're an Executive, BI Program Lead or any part of BI within your organization, come learn the building blocks of a BI Competency Center.

Engaging Oracle BI Users Through Collaborative and Embedded BI
Christian Screen Analytic Vision

Time: 10:00 AM – 10:45 AM
Session: UGF9142

Oracle Oracle BI and EPM customers and practitioners attending this session will be introduced to the value-add principles of Collaborative Business Intelligence in any BI program. This emerging concept of collective intelligence explores how to engage users at all parts of the Oracle BI implementation life-cycle. It's not just about leaving comments on dashboards and providing a collaborative approach to decision making; although that is part of the feedback equation this session will highlight. Providing access to Oracle BI data outside of the standard Oracle BI portal to integrate with Oracle BI mobile and third-party portals such as SharePoint and Oracle WebCenter will also be explored. This session will introduce the audience to social integration and meaningful interactions wherein Collaborative BI and Embedded BI can create new metrics for user participation that drive better business usecases, analytical decision making, and provide new ROI metrics for just about any Oracle BI implementation.

The Value In Adopting Agile and CI for OBI Development
Kevin McGinley, Red Pill Analytics

Time: 11:00 AM – 11:45 AM
Session: UGF9126

As organizations ponder how they can get the most value from their Oracle Business Intelligence platform, the dominating thought tends to be to invest in the next implementation. But just as important as WHAT you're going deliver is HOW. Traditional approaches create headaches over time, as delivering new content across multiple work streams takes longer and is more complicated. This session will demonstrate why you should adopt an Agile approach and support that methologolgy with Continuous Integration, which will simplify your multi-user development and automate key tasks.

Oracle Business Intelligence Development in the Cloud
Stewart Bryson, Red Pill Analytics

Time: 12:00 PM – 12:45 PM
Session: UGF6324

Managing parallel streams of development with Oracle Business Intelligence (OBIEE) is difficult when developers share a common development environment. Providing isolated sandboxes for OBIEE developers is one solution, but it comes at a cost. Development sandboxes are hard to come by, and they introduce a new requirement: an automated process for assembling the final production release. Maybe the Cloud can help? In this presentation, we'll explore the use of Cloud-based development combined with build automation and continuous integration techniques for testing and deploying metadata and web catalog releases for OBIEE. And the best part: it makes no difference whether these releases are deployed on-premise or in the cloud.

No Silver Bullets: OBIEE Performance in the Real World
Robin Moffett, Rittman Mead

Time: 1:30 PM – 2:15 PM
Session: UGF9095

Are you involved in the design and development of OBIEE systems and want to know the best way to go about ensuring good performance? Maybe you've an existing OBIEE system with performance "challenges" that you need to diagnose? This presentation looks at the practical elements of diagnosing the causes of performance issues in OBIEE, and discusses good practices to observe when developing new systems.

Neo's Voyage in OBIEE
Christian Berg, Dimensionality GmbH

Time: 2:30 PM – 3:15 PM
Session: UGF9144

"You take the blue pill and the story ends. You wake up in your bed and believe whatever you want to believe."(Morpheus) This represents sticking with documentation and the vanilla product. "You take the red pill and you stay in Wonderland and I show you how deep the rabbit-hole goes. Remember -- all I am offering is the truth, nothing more." (Morpheus) A "Matrix" style voyage into a little known area of OBIEE will take you into the bowels of OBI.

Deep Dive Into Big Data Using ODI12c and Oracle Big Data Connectors
Mark Rittman, Rittman Mead

Time: 3:30 PM – 4:15 PM
Session: UGF9481

Much of the time required to work with big data sources is spent in the data aquisition, preparation and transformation stages of a project, before your data is a state suitable for analysis by your users. Oracle Data Integrator, together with Oracle Big Data Connectors, provides a means to efficiently load and unload data from Oracle database into a Hadoop cluster, and perform transformations on the data either in raw form or technologies such as Apache Hive or R. In this presentation, we will look at how ODI can form the centrepiece of your big data ETL strategy, either within a custom-built big data environment or one based on Oracle Big Data Appliance.


Back to Top


ADF - Moscone South - 270
8:00 AM - 4:15 PM

Customer Stories - From Oracle Forms to Oracle ADF and Mobile
Marcus Lohn, essentri & Martin Disterheft, PITSS

Time: 8:00 AM – 8:45 AM
Session: UGF9224

Looking to transition your Oracle Forms applications to newer technologies and channels? In this session, learn some best practices from two projects: (1) Oracle Forms to Oracle Mobile and (2) Oracle Forms to Oracle Application Development Framework/SOA. This presentation shares the why, how, and what to watch for when doing modernization projects, offering experience-based insight into the process.

ADF Essentials - Tips and Tricks
Alexis Lopez, Oratechla

Time: 9:00 AM – 9:45 AM
Session: UGF9377

Oracle Application Development Framework Essentials, a subset of Oracle Application Development Framework (Oracle ADF), enables you to create enterprise web applications using Java. When combined with Oracle GlassFish Server and MySQL Database, you get a platform that is free to develop and free to deploy, even on production environments. However, some features might not work out of the box, and you will find yourself looking for workarounds. Attend this presentation to learn common workarounds that have been used on projects to deliver enterprise web applications using Oracle ADF Essentials. The workarounds include configuring MySQL for Oracle ADF, using MySQL AI columns, working with history columns, and managing Oracle GlassFish Server from inside Oracle JDeveloper.

Mastering Oracle ADF Bindings: Advanced Techniques 
Sten Vesterli, Scott/Tiger

Time: 10:00 AM – 10:45 AM
Session: UGF3484

This session focuses on the heart of Oracle Application Development Framework (Oracle ADF) and takes a deep dive into Oracle ADF bindings. Understand the life cycle of the binding context and the binding container. See what happens behind the scenes when a data-bound page is requested. Hear how to create and manipulate the binding objects at runtime programmatically. See how to define a complete binding container on the fly, and learn advanced techniques for dynamically creating bindings such as iterators, attribute values, tree bindings, list-of-values bindings, Boolean bindings, and method actions. Also learn how to use an Oracle ADF binding framework in a common Java EE web application.

Web & Mobile Oriented Architecture (WOA& MOA) With Fusion Middleware and Cloud
Lucas Jellema, AMIS

Time: 11:00 AM – 11:45 AM
Session: UGF9524

Mobile applications as well as a large class of modern HTML5 web applications are built on top of an architecture with special provisions, such as RESTful services; the personal cloud, to provide a cross-device experience; push; cache; localization; scalability; and secure interaction with the enterprise back end. Gartner refers to this as the web-oriented architecture. Oracle Fusion Middleware offers key products (Oracle SOA Suite, Oracle Identity Management, and Oracle API Gateway) to implement this architecture, possibly in combination with cloud services such as Oracle Mobile Cloud Service, Oracle Messaging Cloud Service, and Oracle Storage Cloud Service. This session discusses the architecture itself and what it entails.

Creating Stunning UX With ADF Faces Using SASS
Amr Gawish, Infomentum

Time: 12:00 PM – 12:45 PM
Session: UGF3777

Oracle Application Development Framework (Oracle ADF) provides developers and end users with creative functionality, but without a great user interface to show off these features, the client might be derived away from Oracle ADF applications. Come to this session to see a demonstration of how to easily create a stunning user interface with Oracle ADF skinning by using the power of SASS and Compass. You will learn how to create responsive and adaptive user interfaces.

Powerful & Easy ADF DataControl For XML and Web Services
Wilfred van der Deijl, Eurotransplant

Time: 1:30 PM – 2:15 PM
Session: UGF9378

Many organizations want to leverage their existing or newly developed web services in Oracle Application Development Framework (Oracle ADF) applications. Oracle ADF's data binding layer provides a declarative way to access different types of data controls. Several of these data controls can be used to access XML content. They tend to be either easy to implement or very powerful. As a result of the Oracle ADF community's effort, now there is a free open source XML Oracle ADF data control that is both simple and powerful. It can be used with SOAP web services, Oracle Business Process Management human tasks, or any other XML data. It is declarative, without the need for JAX-WS proxies or custom beans—although it is extensible with custom code. Come to this session to learn more.

Real World ADF Performance Tuning - Case Study
Stephen Johnson, Integretas, Inc.

Time: 2:30 PM – 3:15 PM
Session: UGF4928

Performance is always an issue. Even when your application runs well, your users may very well want it faster, and if your app has noticeable problems, you’ll never hear the end of it. Oracle Application Development Framework (Oracle ADF) is a powerful and flexible framework, but that power comes with a complexity that can lead to many performance pitfalls if you’re not careful. This presentation by Integretas and ProQuest shares some of the real-world performance and stability problems encountered—and the lessons learned—across multiple Oracle ADF applications. It discusses the tuning, tweaking, and enhancements done to the applications and application servers to meet the end users’ needs.

Real Life Oracle ADF Mobile:  Things You Don't Learn From the Developer's Guide
Luc Bors, AMIS

Time: 3:30 PM – 4:15 PM
Session: UGF4161

Oracle Mobile Application Framework, released earlier this year, is based on Oracle ADF Mobile. A great developer guide is available for creating Oracle Mobile Application Framework apps, but when you’re building your first Oracle Mobile Application Framework app, you’ll run into issues you can’t solve by reading it. Think of the performance issues of taking pictures with modern devices. Images can require up to 5 megabytes apiece. Your device won’t be able to work with them unless you come up with a solution. How can you make your application look like a native app? What can you do to create a grid-like springboard? These topics missing from the developer guide are what this session covers. You will learn solutions for these and other real-life Oracle Mobile Application Framework issues.


Back to Top


HYPERION/EPM - Moscone South - 104

9:00 AM - 4:15 PM

Why Does EPM Seem So Challenging?  A Good Practices Guide to EPM Implementations
John Rambeau, US Analytics

Time: 9:00 AM – 9:45 AM
Session: UGF9125

 After nearly 25 years as a leader and pioneer in the EPM marketplace, the session speaker has a unique 360-degree perspective as a customer, vendor, software executive, and leader of a services company. In this session, you will be shown the right way to do EPM, by satisfying both tactical and strategic needs of a company. With a sometimes humorous but always insightful and fresh perspective, the session speaker covers the recipe of how to, and how not to, implement successful EPM projects. A series of customer and real-life stories illuminate lessons learned over a quarter of a century.

The ROI of EPM As A Management Process
Ron Dimon, Checkpoint LLC

Time: 10:00 AM – 10:45 AM
Session: UGF9141

The sum of enterprise performance management (EPM) is much greater than its parts. This session addresses the business benefits and ROI of EPM. It shows a framework for bringing together all your EPM processes, including starting with strategic objectives and metrics, enabling a debate about what's doable (financial modeling), committing resources to achieving results (enterprise planning), gathering data and turning it into useful management information (financial reporting), understanding results and getting new insights (financial analytics), and doing all this the “right” way (financial system governance). The session includes real-world examples of how organizations are doing this now.

Managing Your Companies' Cash: Using EPM to Capitalize on Future Growth
Scott Leshinski, Huron Consulting

Time: 11:00 AM – 11:45 AM
Session: UGF9092

Since the Great Recession, companies have a record amount of cash on their balance sheets. These companies will make some key decisions about how to best use that cash, including acquisition targets, investor relations (share buybacks/dividend issuances), tax repatriation strategies, and growth strategies, particularly in global markets. The Great Recession opened up the eyes of many companies to the importance of having the proper analytics to adequately prepare for the possibility of a down economy. Now that balance sheets are generally stronger, how can companies be prepared with the analytical tools to capitalize on future growth? This session explores that topic.

A Decade of Hits: The Evolution of Hyperion Financial Management from Consolidation Tool to Financial Close Suite
Chris Barbieri, Ranzal

Time: 12:00 PM – 12:45 PM
Session: UGF9085

In this session, an Oracle ACE reviews a decade of evolution in Oracle Hyperion Financial Management. Hyperion delivered a world-class financial consolidation tool in 2001 that brought scalability and multidimensional analysis for internal and external reporting. The session looks at major product milestones as Oracle has evolved Oracle Hyperion Financial Management into a full-featured suite. With product features such as lifecycle management, 64-bit, and configurable dimensions, Oracle Hyperion Financial Management is now the keystone of a much broader suite of products such as Oracle Hyperion Financial Close Management, Oracle Hyperion Disclosure Management, and Oracle Hyperion Tax Provision, and tight integration with Oracle Hyperion Planning and Oracle Data Relationship Management.

Oracle PBCS - Hyperion Planning in the Cloud:  It's Not So Nebulous!
Chuck Persky, Performance Arhitects

Time: 1:30 PM – 2:15 PM
Session: UGF9091

By now, you have heard of Oracle Hyperion Planning in the cloud. It is a new hosted (software as a service) offering from Oracle called Oracle Planning and Budgeting Cloud Service (Oracle PBCS). This session provides a high-level understanding of Oracle PBCS. It also details a real-life implementation and explores various use cases, explaining situations where Oracle PBCS may be a good fit for an organization, including the “rapid deployment” option. Additionally, the session covers the major similarities and differences between on-premises Oracle Hyperion Planning vs. Oracle Hyperion Planning in the cloud. So, join Chuck Persky, a veteran Oracle Enterprise Performance Management pilot, in navigating through the cloud.

OBIEE and Essbase Together
Glenn Schwartzberg, interRel Consulting

Time: 2:30 PM – 3:15 PM
Session: UGF9140

Oracle Essbase is the leading OLAP database for fast data analysis, and Oracle Business Intelligence Enterprise Edition is the industry-leading reporting and dashboard tool. Join an Oracle ACE Director in this session, and learn about the features of each of these outstanding products and how to leverage them to provide fast, seamless reporting.


How to Improve EPM With BIFS & Endeca
Dave Collins, Huron Consulting

Time: 3:30 PM – 4:15 PM
Session: UGF9124

Oracle continues to provide its customers with world-class, innovative EPM applications. Yet the real power comes via Oracle Business Intelligence Foundation Suite (Oracle BIFS) for analytics and Oracle Endeca Information Discovery. During this session, you will learn how these technologies can be exploited in support of EPM processes such as financial close, planning, and management reporting. You will see how Oracle Endeca helps users quickly discover what they might want to plan or model using Oracle BIFS, perhaps atop Oracle Business Intelligence Analytics or Oracle Hyperion financial applications. In other words, Oracle Endeca helps to establish focus, and Oracle BIFS provides analytics for a longer-term process.

Back to Top


APPLICATION EXPRESS - Moscone South - 300
9:00 AM - 4:15 PM 

APEX and eBusiness Suite
Francis Mignault, Insum

Time: 9:00 AM – 9:45 AM
Session: UGF9099

Oracle Application Express is a rapid web application development tool that provides the qualities of an enterprise solution for security, integrity, scalability, and availability. Built for the web, it’s the ideal platform for developing extensions with Oracle E-Business Suite. Starting with Oracle E-Business Suite Release 12.1.3, integration between Oracle Application Express and Oracle E-Business Suite 12 has been improved, facilitates compliance with authentication and data security, and provides users with a seamless experience. This session reviews the technical requirements of such an integration and demonstrates a few examples of extensions organizations are able to create with Oracle Application Express.

APEX and Microsoft Sharepoint
Dimitri Gielis, APEX R & D

Time: 10:00 AM – 10:45 AM
Session: UGF9098

A lot of companies use Microsoft SharePoint as a portal for their intranet. For many people, it’s the first place they go when they start their day. To do their job, they also make use of other applications, some built in Oracle Application Express. This session shows the different options you have for integrating the worlds of SharePoint and Oracle Application Express. The integration can be both ways: in SharePoint, you can get data or screens from Oracle Application Express, and in Oracle Application Express, you can use data maintained and coming from SharePoint.

Integrating APEX and Amazon AWS S3
Scott Spendolini, Enkitec

Time: 11:00 AM – 11:45 AM
Session: UGF9129

Amazon Web Services - or AWS - offer a multitude of cloud-based services ranging from virtual on-demand servers to analytics and messaging. One specific service - S3 - provides a scalable and affordable way to store and manage large amounts of information. Using an API that is included in the popular open source Alexandria PL/SQL Library, any Oracle Application Express - or APEX - application can easily and securely be integrated with S3. This session will cover the required configuration steps on the Amazon and APEX sides in order to successfully integrate the two technologies. It will step through the Amazon registration process, the installation of the required Alexandria APIs, how to configure Oracle Wallet for secure file transfer, and best practices for integrating with APEX forms and reports.

Using Angular JS in APEX
Dan McGhan, Enkitec

Time: 1:30 PM – 2:15 PM
Session: UGF9097

When the jQuery JavaScript library was released in 2006, it dramatically changed the way developers used JavaScript. Since then, interest in JavaScript has exploded, along with its role in delivering highly interactive web applications. When these applications require a lot of JavaScript, a system of structuring the code and organizing the files becomes very important. Recently, JavaScript model-view-controller (MVC) frameworks have been growing in popularity because they promise to bring order to the chaos. AngularJS is one such framework, offering a variety of features such as two-way data binding and directives. In this session, attendees will learn the basics of AngularJS and how it can be used in Oracle Application Express applications.

Oracle APEX + Node.js: A Primer
John Scott, APEX Evangelists

Time: 2:30 PM – 3:15PM
Session: UGF5222

Although Oracle Application Express is great at doing many things, sometimes you want to step outside of the box. Node.js is a relatively new platform that is becoming increasingly popular with web developers. This session covers how you can integrate Node.js and Oracle Application Express to create some amazing features.

Panel With The Presenters - Bring Your Questions RE: "Integration" (Or Anything Else!)
Roel Hartman, APEX Consulting

Time: 3:30 PM – 4:15PM
Session: UGF9093

If you have any questions regarding the integration of Oracle Application Express with various technologies, this panel session is your chance to pose your questions to a panel of specialists. And if you have any other questions about Oracle Application Express itself, you are welcome to take advantage of this unique opportunity to pick the brains of the Oracle ACE Directors and ACEs who make up the panel.

 Back to Top