Home Contact About ODTUG
TOPICS
Application Express
Database Development
Essbase
Hyperion Applications
Hardcore Hyperion
Middle Tier and Client-Side Development
Oracle Business Intelligence, Hyperion Reporting, and Data Warehousing
SOA and BPM
MySQL NEW!
Other
Technical Sessions - The Heart of Kaleidoscope
Kaleidoscope 2010 will feature more than 170 technical sessions, providing the best information available for the developer community.

Just looking around? Check out the topic selections listed below from the main topic areas.

Application Express

Plugin Showcase - Take 5 NEW APEX Plugins Home as Souvenirs!

The new plugin architecture is probably one of the most exciting features to be announced for APEX 4.0, allowing anyone to create extensions to the core APEX framework. In this session we'll showcase 5 useful plugins that we've created from scratch, discuss the ideas behind them and how they were created. As a souvenir, you'll get to take all of them home, learn from how they were coded and use them in your 4.0 applications.


APEX Open Mic Night – Your 15 Minutes of Fame Starts NOW

Done something cool with APEX lately? Got a favorite feature that you think everyone should be using? Found a unique way to solve a problem? Well then, this is your chance to tell the world! APEX Open Mic Night will give you 15 minutes to present your ideas and discoveries to your peers without the pressure of having to produce a full conference presentation. There will be no slides allowed, and your app/demonstration must be run on APEX.ORACLE.COM from a laptop that we will provide. Other than that, there are no limitations. Think Oracle Unconference meets The Improv. Good luck and your time starts ... NOW!


Sunday Symposium - APEX A to Z

This year's Sunday APEX Symposium will take on bit of a different twist. We're going to follow the development of a single system from data model to deployment, each session focusing on a different aspect of the development process. Topics covered will include :Data Model/Foundation,
Application Development, Dynamic Actions/Plugins, Performance and Tuning , User Interface , Printing , Security, and Globalization.

Each session will use the foundation that is build by the previous ones, but will be a self contained lesson. This way you can see the things that are most important to you without the fear of missing something from a previous session. Although we hope you'll stay with us for the entire symposium.


Oracle Business Intelligence, Hyperion Reporting
and Data Warehousing

Tracy McMullen, interRel Consulting
Oracle Business Intelligence, Hyperion Reporting, and Data Warehousing

Converting from Hyperion Web Analysis to OBIEE Answers+
Hyperion Web Analysis is not Oracle's strategic direction for ad-hoc analysis (against cubes or otherwise). Oracle is going to be putting all their research and development into OBIEE Answers+. With the newest release of Answers+ (11g), you now have much better access against Essbase, so the question is: how do I migrate from Web Analysis to Answers? Well, there isn't a migration tool, but we'll show you how to recreate your core Web Analysis functionality in Answers. We'll also let you know what, at the moment, Answers still can't do that Web Analysis can. In one hour, you'll be well on your way to moving to OBIEE Answers+! This session is intended for Hyperion developers/administrators.


Francois-Xavier Nicolas, Oracle Corporation
Oracle Business Intelligence, Hyperion Reporting, and Data Warehousing

Oracle Data Integrator 11g - New Features and Directions
Oracle Data Integrator (ODI) is Oracle’s comprehensive data integration platform that covers all data integration requirements — from high-volume, high-performance batches, to event-driven, trickle-feed integration processes, to SOA-enabled data services. This session is intended to present the product directions and show the new 11gR1 features.


Mark Rittman, Rittman Mead
Oracle Business Intelligence, Hyperion Reporting, and Data Warehousing

Metadata and Infrastructure Changes in OBIEE 11g
The new 11g release of OBIEE introduces an enhanced metadata model that now incorporates key performance indicators, Web service actions, and complex hierarchies into the traditional BI Server semantic model. This new release also incorporates WebLogic into the application infrastructure with simplified clustering, SSO, and SSL support and administration performed by Fusion Middleware Application Control. This presentation looks at these new features, discusses how they affect development using OBIEE 11g, shows through demonstrations how these new features work, and discusses the implications for Oracle and Essbase developers.


Database Development

Jonathan Lewis, JL Computer Consultancy
Database Development

How to Write Efficient SQL

There is a basic strategy to writing efficient SQL, but it requires knowledge of the data, the metadata, and the intent of the query. In this presentation, Jonathan Lewis starts with the basic principle of efficient data access, then looks at ways of analyzing the data (in case you are not familiar with it already). Finally, he outlines the principle of efficient data access, using a graphical approach to model a query, and finishes with a small example from a production system.


Steven Feuerstein, Quest Software
Database Development

Guarantee Application Success

How can we break out of the vicious cycle caused by buggy software, and instead build wildly successful applications? First, we have to agree on what it means for an application to be successful. Then we need to map out the key processes and techniques that will help us guarantee that success. This presentation identifies three main criteria of success (our code must be correct, fast enough, and maintainable), and then offers ideas to automate the code testing process, optimize performance, and reduce the cost of maintenance.


Cary Millsap, Method R Corporation
Database Development

Thinking Clearly About Performance

Cary Millsap will describe the fundamentals of performance in a session designed to put DBAs and developers alike onto the right path of thinking clearly about the speed of software and how to manage it.


Hardcore Hyperion

Matt Milella, Oracle Corporation
Hardcore Hyperion

First Look - Smart View Extensions

This session will showcase the first of the new extensions to be delivered using the Smart View extension framework. The extensions will include some cool features for Essbase users and will showcase some options for advanced querying.


Jake Turrell, US-Analytics
Hardcore Hyperion

Five Things You Can’t Do in Hyperion Planning (and How to do Them . . . )

Every packaged application has a defined set of functionality that the product addresses, but few customers are ever satisfied with these predefined limits. Technical experts who have worked with these packaged applications over many years often develop a “bag-of-tricks”, and are able to address many of these customer requests. This presentation will cover five commonly requested features in Hyperion Planning that aren’t available out-of-the-box, and how to address them.


Edward Roske, interRel Consulting
Hardcore Hyperion

Hacking Essbase: Undocumented & Unsupported

This session goes beyond the documented side of Essbase to explore what’s going on behind the scenes. In the first “Hacking Essbase” session, we covered how to hack substitution variables, data load rules, and passwords (shockingly). In this session, Edward Roske will dive even further into the inner-workings of Essbase to teach you all of those things that Oracle doesn’t document. Warning in advance, there is usually a reason Oracle doesn’t document these things, so use the tips you learn in this session at your own peril.


Middle-Tier and Client-Side Development

Peter Koletzke, Quovera and Duncan Mills, Oracle Corporation
Middle-Tier and Client-Side Development

Just Get it Written: Deploying Applications to WebLogic Server Using JDeveloper and WLS Console
This presentation explores the process of deploying to an Oracle WebLogic Server server. It outlines JDeveloper utilities and profiles that help you create an EAR file with all required libraries. The presentation then explains how to deploy the application using JDeveloper. It also discusses the benefits of and techniques for testing deployment on a local standalone server. In addition, the presentation describes and demonstrates the deployment services of the WLS Console and why you might choose it to deploy an application instead of using JDeveloper.


Anjo Kolk, Miracle Benelux
Middle-Tier and Client-Side Development

Accessing the Oracle Database from Google (Apps, App Engine, Spreadsheets)


How great would it be to access your own data that is behind the corporate firewall in the same way? With the Google Secure Data Connector and the Google Feedserver one can now access any data in your company that is easily accessed by google gadgets, Google App Engine or Google Spreadsheets. We will show you how it is done and how you can protect your self.


SOA/BPM

Lucas Jellema, AMIS
SOA and BPM

It's Happening! On Event-Driven SOA

When should a process start or a service be activated? The trigger can be a requirement in an application, process, or service that then invokes the service or process. However, frequently the link is not that straightforward. When 'something happens' (a business event!), that should lead to the start of other actions or the continuation or redirection of running processes. However, whose responsibility is it to determine that a business event has taken place, and even more importantly, who to notify? The process instance that happens to produce an event should not bare the burden of finding out who needs to be notified—especially as the list of interested parties can be hugely dynamic. Nor should the event be presented to any service, composite application, or process to check out whether perhaps it wants to consume it.
This session discusses Event-Driven SOA—an architecture where applications, processes, and services can produce business events, and interested consumers are notified of those events—through the mediation by the SOA Suite 11g Event Delivery Network (EDN). In this session, we will see how business events are defined across the enterprise, and how an interest in specific types of business events (with specific payloads) can be registered. The session demonstrates how events can be produced, how they are processed by the EDN, and handed to the interested parties. Special attention is given to the correlation of events, ensuring that the correct composite instance is provided with the event. We will discuss how the events can not only originate within the SOA Suite, but also outside of it, through AQ, PL/SQL and Java, ADF BC, and JMS. As a last step, we will discuss Complex Event Processing (CEP) as a potential source of business events. CEP will handle large volumes of small, usually insignificant events. However, by filtering, aggregating, and analyzing for deviations and threshold transgressions, CEP will occasionally find business events that are subsequently sent to the Event Delivery Network. This session has many demonstrations (end-to-end).


Torsten Winterberg, OPITZ CONSULTING GmbH
SOA and BPM

What Makes a Service a Good Service?

Ask your team what they think what would describe a "good" service. We often here universal statements like “a service must not be too coarse grained” or “a service has to deliver business benefit.” Everything right, but how to get something concrete like a checklist out of that? This session looks at the most important aspects of services, from a business and a technical perspective. Basis of this work is an article series over one and a half years in German Javamagazin together with Hajo Normann (ACE Director), Clemens Utschig (Oracle HQ), Berthold Maier (Oracle), and Bernd Trops (Sopera). This series goes as base material to Thomas Erl's Next Generation SOA book.


Shashi Suravarapu, Exilor Inc.
SOA and BPM

Leveraging Oracle SOA Suite 11g to Integrate with Force.com Cloud Platform

Cloud computing is helping a majority of the enterprises reduce IT costs by not having to purchase physical hardware/software to support these services. And most of them see integration between their existing IT systems and cloud providers as the first step. Salesforce.com is at the forefront of the cloud computing revolution, offering Force.com, a cloud platform for building and running business applications. This session will show how to exploit the Oracle SOA Suite 11g platform capabilities when integrating with a Force.com application. Besides showcasing various facets of the SOA Suite including OSB, composites with bpel/mediator components, and fault policies, it will focus on Force.com specific usecases. It will demonstrate how to build utility services to help with session management and error handling, and how to leverage workflow/approval functionality of the Force.com platform in conjunction with the out-of-the-box Task service.