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

Did you miss a webinar? As an ODTUG member, you can view 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 Webinar

APEX.pngThursday, February 15, 2018 12:00 PM - 1:00 PM EST
apex.world On Air: What Would You Wish for in APEX 6?
 Dan McGhan, and Joel Kallman, Oracle Corporation, Juergen Schuster, IT-BeratungACE Director.jpg Martin D'Souza, Insum Solutions,
                ACE Director.jpg Scott Spendolini,
Sumner Technologies

Everybody is talking about APEX 5.2, but we can’t change the current version. Now is the right time to think about the next big APEX release. Let’s talk about what you want to see in APEX 6. Half of the time will be devoted to an open Q&A session, so prepare your questions. 

Register Here

Database.pngThursday, February 22, 2018 3:00 PM - 4:00 PM EST
Barriers to Oracle Database in IaaS Cloud
ACE Director.jpg Tim Gorman, Delphix

IaaS cloud vendors, such as AWS, prefer that everyone migrate to the cloud, but what often happens is that non-production migrates for cost reasons while production stays on-premises. This phased path to the cloud can leave IT with a split personality: production on-premises on legacy proprietary UNIX platforms, non-production in the cloud on commodity Linux platforms. 

Because the security risk on non-production systems 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 virtualization employs thin cloning, snapshots, and network-attached data presentation, reducing cloning from hours or days to minutes. But there is more: your legacy UNIX (i.e. AIX, Solaris, HP-UX) databases aren't going anywhere off-premises because the cloud is based on Intel (i.e. Linux, Windows). So what to do? 

In this session, learn how data virtualization and data masking make "split-brain IT" not just possible but desirable. 

Register Here

BI.pngTuesday, February 27, 2018 12:00 PM - 1:00 PM EST
Transitioning from OBIA On-Premise to Oracle Analytics Cloud
Peter Koutroubis and Jai Gangwani,  ERPA Group

The transition from Oracle Business Intelligence Applications On-Premise to Oracle Analytics Cloud can be a challenging and rewarding initiative.
This presentation will provide relevant information to anyone looking to transition from on-premise OBIA to OAC. The discussion will focus on the roles involved, including business intelligence analyst, ETL developer, and OBIA system admin/DBAs in the full solution lifecycle of an implementation including design, fit/gap analysis, build, test, implementation, and post go-live.
The learning objective for attendees of this session will be to: (1) take away key differences in capabilities between OBIA on-prem and OBIA on OAC (2) understand the business considerations and cost/benefit analysis between on-premise OBIA and OBIA on OAC and (3) learn what work will be required to duplicate an OBIA on-premise solution in Oracle Analytics Cloud (OAC), including fit-gap analysis, installation, training, and support.
This session will cover all the practical questions and challenges that will arise when moving to OAC, such as: What is the total cost to consider of OAC vs. BICS versus OBIEE on-prem? What size of DBaaS will I need with BICS? What level of granularity should I move from on-prem to the cloud? Which is the best tool for data migration — ODI, Data Sync, or GoldenGate? Should all users move to OAC, and will I be able to migrate my existing licenses? Will I be able to do everything in OAC that I can do on-prem? What about RPD development and synchronization? In this presentation, we will explore answers to all these questions and explain our chosen solution.
There are many important messages to be drawn from this presentation. The primary one is the business case for transitioning from a business intelligence solution built on internal infrastructure to a cloud-based solution.
The information obtained from this presentation will be immediately impactful for anyone looking to implement OAC, whether they are in an executive position, DBA/system admin, ETL developer, dashboard/report developer, or functional business user, among others.
The information presented in this session will be unique from other OAC sessions because it will focus on the implementation considerations rather than solely demonstrating the functionality in OAC and data visualization.

Register Here

BI.pngTuesday, March 13, 2018 12:00 PM - 1:00 PM EST
Saddle Up: Data Wrangling in Oracle Data Visualization (DV) Desktop
Cameron Ross and Doug Ross, Performance Architects

The era of "data modeling on demand" for analytics is a necessary skill for users of advanced visualization tools like Oracle's Data Visualization (DV) Desktop. The goal of this presentation is to teach attendees how to use the data wrangling capabilities of DV Desktop's Data Flows to combine, transform, filter, enhance, and summarize multiple data sources to create a single clean view ready for analysis. A real-world, end-to-end example of data visualization will demonstrate how to handle complex data transformations easily.

Register Here

Database.pngThursday, March 15, 2018 12:00 PM - 1:00 PM EST
Getting Started with Oracle and .NET
Christian Shay and Alex Keh, Oracle Corporation

How do you get started using Visual Studio to develop .NET web applications that leverage the power of Oracle Database 12c? This beginner-level session answers that question and introduces Oracle's offerings for .NET programmers, including Oracle Data Provider for .NET (ODP.NET), Oracle Developer Tools for Visual Studio, Oracle Providers for ASP.NET, and .NET stored procedures. Step-by-step demos show you how to get started using these free products.

Register Here

BI.pngTuesday, March 27, 2018 12:00 PM - 1:00 PM EST
Property Graphs 101: How to Get Started with Property Graphs on the Oracle Database
Arthur Dayton, Vlamis Software Solutions, Inc.

Oracle Database 12c now includes property graphs—a powerful feature that goes beyond relational to analyze relationships in big data, such as finding the most influential people in a social network, discovering patterns of fraud within financial transaction data, or recommending products based on what similar customers are buying.

Don’t have the slightest clue on how to get started with and use property graphs? Good news! In this fast-paced webinar, Arthur Dayton, from Vlamis Software Solutions, will show you exactly how to create, load, and use property graphs on the Oracle Database. We will cover how to create a property graph using Java or PLSQL, how to load data into a property graph from existing database tables, how to create an in-memory instance of a property graph, how to run algorithms such as page rank against a property graph, how to use PGQL (an sql-like language for property graphs) to query a graph, and ways to visualize graph data.

Register Here

Database.pngThursday, April 19, 2018 12:00 PM - 1:00 PM EST
PL/SQL Programming for .NET Developers: Tips, Tricks, and Debugging
Christian ShayOracle Corporation

.NET and Oracle programmers frequently work with PL/SQL, whether that means setting up a call to a stored procedure from a .NET program, executing a PL/SQL anonymous block, or writing and debugging PL/SQL stored procedure code. This session looks at leveraging PL/SQL from the point of view of a .NET developer and provides in-depth tips about how to configure and use the tightly integrated PL/SQL debugger in Visual Studio.

Register Here

BI.pngTuesday, May 1, 2018 12:00 PM - 1:00 PM EST
Creating Custom Visualization with Oracle Data Visualization SDK 
Arthur Dayton, Vlamis Software Solutions, Inc.

One of the great new features of the Data Visualization option with Oracle Analytics is the ability to create your own custom visualizations with an SDK provided by Oracle. In the past, with the Answers interface, we had to inject custom code into OBI using narrative views. Getting custom visualizations to interact with the delivered ones, or print, was nearly impossible. Now, with the SDK, we can easily create custom visualizations that participate as first-class citizens in the UI and can interact with native visualizations and controls as well as print and export. In this webinar, Arthur Dayton, from Vlamis Software Solutions, will show attendees what’s possible with the new SDK and give tips and best practices for getting started with your own custom visualizations.

Register Here

BI.pngWednesday, May 16, 2018 12:00 PM - 1:00 PM EST
Discover Why Essbase in Oracle's Analytic Cloud (OAC) is a True Holistic Analytic Solution
Catherine Summers and Sheetal Kotian, Vertical Edge Consulting Group

Essbase Cloud is now a part of Oracle’s Analytic Cloud (OAC) Suite  This new suite of applications enables analytics and data insights which were not possible in previous versions. Join us as we tour the new Essbase Cloud offering and demonstrate the ease of building a cube from an ERP extract and then visualize the data in Essbase for a true holistic analytic solution.

This easy to follow webinar will give you a good insight into OAC while highlighting the benefits and ease of its functionality. 

Register Here

Database.pngThursday, May 17, 2018 12:00 PM - 1:00 PM EST
CodeTalk 2018 - REST Database Links: Access Oracle Databases in The Cloud Using ORDS, REST, and JSON
Chris SaxonOracle Corporation and Robert Marz, its-people

The 2018 CodeTalk Series webinars are co-sponsored by ODTUG and IOUG.

This talk covers a real-world solution that recreates database links using ORDS, REST, and JSON. It breaks the limits of database links by loosely coupling two databases. The complexity is completely hidden from users and developers. Modern technologies such as REST and JSON offer elegant ways to couple databases without fixed dependencies. The protocol http(s) is able to surmount the corporate firewall and query databases in the cloud. A transparent layer made of table functions, views, and instead-of triggers can be placed over the connection.

This talk introduces REST, JSON, and ORDS very briefly. After the stage is set, we explore how to query auto-rest enabled tables from PL/SQL and process the JSON documents. Finally a view with an instead-of trigger is built that can be used by the application developers. A generator that produces all necessary objects will be shown. The generator can integrate into SQL Developer.

The presentation includes a live demo.

Register Here