Is there a topic you would like covered but do not see here? We are happy to take webinar suggestions. Email us at alicia@odtug.com.

Did you miss a webinar? As an ODTUG member, you can hear all of our past webinars at any time. Just log in and you will see the link for the recorded list. Not a member? Join now for $99!

Our webinar calendar is constantly evolving! Check back frequently as more webinars will be added to the schedule.

Suggest a Topic   Past ODTUG Webinars


Thursday, September 29, 2016 12:00 PM - 1:00 PM EDT
Understanding and Using Essbase Web Services
Dayalan Punniyamoorthy, Vertical Edge

Services on cloud is the new mantra driving most of the Oracle EPM component to be accessed via the cloud. Of course, Essbase Web Services are not excluded from the list. They were introduced as a new feature in, as silent unnoticed functionality.

Essbase Web Services will expose Essbase user and administrative functionality in a services-oriented (SOA) environment via Provider Services and allow Essbase to be easily integrated with both Oracle and third-party applications.

Essbase Web Services include the following modules:

  • Datasource
  • Administration
  • Data and metadata

In this webinar, we will discuss how to get started with Essbase Web services and explore the variety of functionalities they offer us. Don’t miss this webinar if you want to learn a bit more about Essbase Web Services and how to customize them to meet your requirements.

Register Here


Tuesday, October 4, 2016 12:00 PM - 1:00 PM EDT
Scaling to Infinity: Partitioning Data Warehouses on Oracle Database 
Tim Gorman, Delphix

There is a lot of talk about big data, and it is often associated with Hadoop and other NoSQL databases. But SQL and Big Data are not mutually exclusive. There are petabyte-sized databases on Oracle Database, and this is how they happen.

This presentation is distilled from 15+ years of extensive experience implementing multi-terabyte databases to support data warehouses on the Oracle RDBMS. One of the most important technical decisions is how to implement partitioning within the Oracle RDBMS to optimize query performance for response time even as data volumes increase, and also to optimize data loading to maximize availability during data loading, eliminating downtime and minimizing impact on the system. Partitioning is also implemented to optimize storage by enabling compression and taking advantage of "tiered" storage strategies and READ ONLY tablespaces.

Partitioning is the key to unlock the full power of numerous advanced Oracle features for data warehousing in a way that is not explicitly documented by Oracle. This interlocked dependency between features is described by the presenter as the "virtuous cycle." Not starting with partitioning on a data warehouse project can lead to a deadlock of unfortunate circumstances that can doom the project to failure, which the instructor characterizes as the "death spiral." In fact, one of the most important query optimizations for data warehouses in Oracle known as "star transformations" is effectively unavailable without using properly implemented partitioning.

Register Here


Thursday, October 6, 2016 12:00 PM - 1:30 PM EDT
2016 Code Talk Series: 12 Things Developers Will Love About Oracle Database 12c Release 2 
Steven Feuerstein and Chris Saxon, Oracle Corporation

12.2 is packed full of goodies for Oracle Database developers. This 90 minute session features a conversation with the Ask Tom Answer Team (Chris Saxon and Connor McDonald), along with Keith Laker, SQL Product Manager, and Bryn Llewellyn, PL/SQL Product Manager. It will be followed by a live Q&A session with Chris Saxon and Steven Feuerstein.

Register Here

EPM.pngTuesday, October 11, 2016 12:00 PM - 1:00 PM EDT
Save Time with FDM to FDMEE Migration Utility
Bernard Ash, EPM Clarity

Do you want to upgrade to FDMEE but you’re too afraid of the large number of FDM artifacts you have in FDM (locations, data load rules, import formats, validation rules, validation entities, etc.)? It would be very time-consuming and therefore expensive and error-prone to migrate all those artifacts from FDM to FDMEE. The bad news is that artifacts such as custom reports and VBScripts will not be migrated; you will have to convert those artifacts by hand. However, the vast majority of your standard artifacts such as locations, data load rules, import formats, mappings, etc. can be migrated using Oracle’s FDM to FDMEE migration utility that Oracle released last fall. The migration utility is implemented using ODI but with a little coaching; even if you don’t know ODI, you could take what would ordinarily be a six-month migration/“upgrade” effort and condense that into a one- to two-month effort. Also, if there is enough time, we could give you an introductory tutorial on how to convert VBScript to Jython and/or how to create a custom report in FDMEE. This will be a live, hands-on demo. 

Register Here

APEX.pngBI.pngThursday, October 13, 2016 3:00 PM - 4:00 PM EDT
Using APEX to Integrate Projections into an OBIEE Financials Dashboard
Teal Sexton, UC Berkeley

University of California, Berkeley is building an APEX form to integrate user-entered financial projections into OBIEE dashboard reports. Faculty will have up-to-date financial data including projected fund balances, particularly important for research and sponsored programs. The APEX form integrates with PeopleSoft HCM to automate the projections for employee salaries and benefits. RA’s can update, delete or add projection lines in a single form for a given faculty member’s full portfolio of funds. Upon hitting the “submit” button, the APEX application writes the projections into a staging table that triggers database updates and refreshes the OBIEE dashboard reports. Instantly, projections are factored into the calculations to give projected ending fund balances and more. The projected go-live for this functionality is March, 2016. The new functionality will efficiently provide faculty with 24/7 access to their projected ending fund balances for the first time at UC Berkeley!

Register Here

BI.pngTuesday, October 18, 2016 12:00 PM - 1:00 PM EDT
Does Your Data Have a Story? Find Out with Oracle Data Visualization
Mike Durran, Oracle Corporation

Oracle Data Visualization makes it easy to get insight from your data. This stunningly visual and intuitive application 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 capabilities of Oracle Data Visualization to create compelling analytics narratives, including how you can rapidly apply advanced analytics techniques to gain insights previously only accessible to advanced users.

Register Here

Database.pngThursday, October 20, 2016 12:00 PM - 1:00 PM EDT
Oracle SQLcl and SQL Developer Tips and Tricks
Jeff Smith, Oracle Corporation

This session has something for everyone. The DBA, the developer, the beginner, the expert – all will walk away with at least two or three new techniques in their favorite SQL-PL/SQL IDE and database GUI. I have fun doing this presentation, and I think you'll have fun participating or just soaking in some new things to try out. The presentation changes as the product updates, but the gist remains the same: Show folks the things they need to know to go from casual users to experts.

I guarantee each attendee that they will pick up two or three new things/techniques/tricks that will fundamentally change the way they use the tool. This adds up to a lot of saved time, and just as importantly, a happier end user. 

Register Here

BI.pngTuesday, October 25, 2016 3:00 PM - 4:00 PM EDT
Three Reasons Why Oracle BI Cloud Is Your Best-of-Breed Cloud BI Platform
Tom Eastlake, Vertical Edge Consulting Group 

Join us as we:

  • Explore the pillar strengths of Oracle Business Intelligence in the Cloud 
  • Compare key competitors’ features and weaknesses
  • Discuss how your organization can blend the agility and ease of analysis of Oracle BI with the unchallenged core strength of the most time-proven and capable database platform in the market

We will focus on the three key differentiators:

  • Platform stability and performance
  • Data visualization capabilities
  • Ease of integration with enterprise systems

Register now for this information-rich webinar that you don’t want to miss.

Register Here

EPM.pngWednesday, October 26, 2016 12:00 PM - 1:00 PM EDT
FDMEE Can Do That?
Tony Scalese, Edgewater Ranzal

Did you miss Tony Scalese, Oracle ACE, author of The Definitive Guide to Oracle FDMEE, and Kscope16 Data Integration and Foundations top speaker of the year at Kscope16? No worries; join him on this live webcast to learn why Oracle Financial Data Quality Management Enterprise Edition (FDMEE) and its greatly expanded capabilities are, more than ever, a viable alternative to legacy methods such as MaxL. You will learn how FDMEE can help streamline and add value to an Essbase solution as well as explore how the product has grown and continues to grow to be a vehicle for so much more than loading trial balance data to HFM.

Register Here

EPM.pngThursday, October 27, 2016 12:00 PM - 1:00 PM EDT
Metadata Management and Data Governance with EPMware  
Abhi Nerurkar, EPMware

With the world of financial applications rapidly evolving, organizations are finding it increasingly difficult to manage metadata across multiple Hyperion and non-Hyperion applications. EPMware manages ALL metadata on-premise or in the Cloud, with data governance, in a simple web-based Java application. EPMware also provides pre-built integrations to all your Hyperion applications, speeding up implementation time and eliminating errors caused by manual metadata deployments. Come join us for a live demonstration of EPMware.

Register Here

Database.pngTuesday, November 1, 2016 12:00 PM - 1:00 PM EDT
Oracle SQLcl and SQL Developer Tips and Tricks
Jeff Smith, Oracle Corporation

Why read the release notes when you can just watch the movie? In this fast paced session, the Oracle product manager will take you on a tour of all the ‘cool’ stuff the Oracle Development Tools team has cooked up in the past year.

This session will be interactive and the audience is invited to ask questions and share feedback on our current direction and future plans.

Register Here

EPM.pngTuesday, November 8, 2016 12:00 PM - 1:00 PM EST
FDMEE Smart Replace for HFM
Bernard Ash, EPM Clarity

While HFM clears the entities in your current load file, it will not clear entities that were loaded previously. A clear of entities from a previous load could be required if someone books some transactions incorrectly (for example, to the wrong entities) and they flow through to HFM. Smart Replace will catch and clear ALL entities (even from previous loads) and by doing so will save customers from many hours of digging to find out why their data doesn't tie. Many thanks to Tony Scalese for writing the first generation of this Smart Replace module in VBScript, but this demo and code are by EPM Clarity in Jython for FDMEE compatibility. It is in production at Chevron. 

Register Here

BI.pngThursday, November 10, 2016 12:00 PM - 1:00 PM EST
Agile Data Warehousing: Using Oracle Data Modeler (SDDM) to Build a Virtualized ODS
Kent Graziano, Snowflake Computing
At a past client, in order to meet timelines to fulfill urgent, unmet reporting needs, I found it necessary to build a virtualized Operational Data Store as the first phase of a new Data Vault 2.0 project. This allowed me to deliver new objects, quickly and incrementally to the report developer so we could quickly show the business users their data. In order to limit the need for refactoring in later stages of the data warehouse development, I chose to build this virtualization layer on top of a Type 2 persistent staging layer. All of this was done using Oracle SQL Developer Data Modeler (SDDM) against (gasp!) a MS SQL Server Database. In this talk I will show you the architecture for this approach, the rationale, and then the tricks I used in SDDM to build all the stage tables and views very quickly. In the end you will see actual SQL code for a virtual ODS that can easily be translated to an Oracle database.

  • Learn a data warehouse architecture that can be implemented incrementally and in layers 
  • Learn what is a Virtual ODS and how it can help you be Agile 
  • How to quickly build pattern based stage tables in SDDM 
  • How to build complex, pattern based views in SDDM 
  • Tips on how to use analytic functions to create virtual columns 
  • See examples of how to embed change data capture into a view-based loading architecture  

Register Here

EPM.pngTuesday, November 15, 2016 12:00 PM - 1:00 PM EST
Automating Routine HFM tasks with the HFM Java API 
Deven Shah, EPMware

Learn how to use the new HFM Java API. Start with learning how to prepare a java Development environment, and run HFM automation tasks like loading and extracting metadata, rules, member lists, and security to ease the burden of recurring tasks on your HFM administrator. You don't need to be a Java pro to get started, allow us to help you get ramped up and begin building your automations. Come join us for a demo on a live environment!    

Register Here

EPM.pngThursday, November 17, 2016 3:00 PM - 4:00 PM EST
Face Your Budgeting Fears: Indirect Budgeting
Matt Gualtieri, Shreeram Sharma, and Shreyas Krishna, Saturn Infotech

How efficient is your business’ budgeting process? Indirect budgeting can be unclear, especially when it comes to understanding how to allocate costs to departments. Without an accurate budget that correctly predicts costs and profits, meeting fiscal obligations and keeping your business compliant become a challenge. In this webinar, Saturn Infotech’s technical and functional experts will demonstrate how to streamline your planning and budgeting process with Oracle PBCS. You will learn how PBCS provides more comprehensive reporting options and simplifies companywide hiring and budgeting, making headcount management a breeze!

Learn how to:

  • Make smarter budgeting decisions with the proper allocation of costs
  • Allocate indirect cost to departments
  • Simplify headcount input for users
  • Avoid common budget mistakes
  • Understand the difference between centralized drivers and local drivers
  • Customize the application according to your business process needs
  • Determine headcount cost reporting by department
  • Perform data integration with a feeder system (ADP, HR.1, etc.)
  • Improve data security
  • Manage workflow in a corporate hierarchy

Register Here

BI.pngThursday, December 1, 2016 12:00 PM - 1:00 PM EST
Data Warehousing in the Real World
Kent Graziano, Snowflake Computing

At a former health-care client, we were not able to implement a pure Data Vault 2.0 architecture. Instead, we had to evolve a hybrid solution that uses Type 2 persistent stage tables we tie together using standard Hub and Link structures along with a Key Map table. While we have been able to utilize DV 2.0 concepts such as MD5 hash keys, in order to avoid joins in loading the stage tables we had to come up with a way to resolve the business keys further into the process. We will show you our solution and discuss the pros and cons of our approach. 

Register Here