The 2022 LAOUC Community tour will be a face-to-face and online event from August 06 to 22. There will be many speakers—Oracle ACEs, Java Champions, prominent Oracle developers, and executives—engaging thousands of Latin American Oracle Users. Tracks include Database, Java, Cloud Native, Chatbots/Mobile/ Modern Development (as well as HOLs), and APEX. The tracks will be in Spanish, English, and Portuguese. Technical subjects include Oracle Autonomous Database, cloud, machine learning, artificial intelligence, operating systems, data science, microservices, containers, Kubernetes, Oracle Fn Project, and Java.

The 2022 LAOUC Community tour will be organized online from August 15th to 19th, 2022. There will be many speakers—Oracle ACEs, Java Champions, prominent Oracle developers, and executives—engaging thousands of Latin American Oracle Users. Tracks include Database, Java, Cloud Native, Chatbots/Mobile/ Modern Development (as well as HOLs), and APEX. The tracks will be in Spanish, English, and Portuguese. Technical subjects include Oracle Autonomous Database, cloud, machine learning, artificial intelligence, operating systems, data science, microservices, containers, Kubernetes, Oracle Fn Project, and Java.

LAOUC Community Tour 2022

Australia

With Oracle Database 21c, one of the long-requested features for Data Guard will become possible: Data Guard per Pluggable Database or DGPDB in short. During this technical deep-dive session, we will explore this new technology in detail and answer most of the common questions from customers: Can we use Data Guard at the PDB level? How do we do a single PDB switchover? How does it work? What will be there in this release, and what will be missing? But also: Why did it take so long to implement this feature? In this step-by-step overview, we will also cover some less known technical aspects, with a glimpse of the roadmap towards the future.

DGPDB - The long-requested Data Guard Feature is there in 21c: Data Guard per PDB

Jordan

Databases have always been a hurdle in application development. Data refreshes are time consuming and require down time and coordination. Legacy environments balance the risk of working with stale data against the effort and inconvenience of returning the database to a baseline. Even modern agile shops struggle with this task, engineering complex processes or buying hardware and software solutions to manage their test data. The difficulty lies in the way databases, configurations, and data blend together. Traditionally, navigating that complexity is left to the database administrator. Docker changes that and holds the potential to revolutionize database development. With Docker, it's no longer necessary to master database internals and commands to create, manage, or refresh databases. In this session I'll show you how to use Docker to: • Create data artifacts • Start new databases in seconds using saved baselines • Save, version, and distribute data sets in your organization • Integrate databases as full members of existing CI/CD pipelines • Test with confidence and avoid uncertainty introduced by data drift • Speed application development and reduce time spent provisioning database assets ...and all without a single database command!

Data and Database Portability in Docker

Costa Rica

This new conference first will explain about Data Compliance standards like GDPR, PCI, HIPAA, etc and Sensitive Data Protection importance, then will cover step by step on how to enable and configure DataSafe and how useful and powerful is this new tool In the past I had conference about DBSAT (still available for countries interested on it, is still a great tool), but this new conference is focussed in DataSafe, OCI basic security and also a brief basics about OCI CloudGuard which is beyond the scope of data protection. Part of this conference is based on my blog: https://blog.pythian.com/what-is-oracle-data-safe-and-why-should-you-use-it/ I will be also blogging about CloudGuard in the next couple of months. Content of the conference is going to be in English, speech can be done either in Spanish (my native language) or English. Feel free to contact me for any questions, thanks in advance.

A New Hope (for data security, how to use OCI DataSafe and CloudGuard tools)

Argentina

Oracle reagrupó los servicios de bases de datos en familias divididas por capacidades, opciones de provisionamiento y precios. En esta presentación veremos distintas opciones y como se aprovisionan con demo en vivo.

Elegir el Servicio de Base de Datos en la Nube según la Carga de Trabajo

Habilitando un futuro de manejo de datos Cuando nos imaginábamos que almacenar y administrar datos en una base de datos convergente sería más eficiente y productivo que dividirlos en varios motores de uso específico.? Una base de datos convergente es una base de datos multi-modelo, multi-tenant, y multi-workload. Oracle soporta ahora, varios modelos de datos y métodos de acceso, simplificando la consolidación al tiempo que garantiza el aislamiento y destaca en los casos de uso típicos de cargas de trabajo de bases de datos, tanto operativos como analíticos.

Oracle Database 21c, es un paso real a una base de datos convergente o simplemente una falsa promesa.?

En esta sesión vamos a repasar las mejoras realizadas en el año actual a Oracle Autonomous Database, la base de datos autónoma en la nube de Oracle.

Mejoras y Nuevas Características de Oracle Autonomous Database en 2022

Brazil

Have you ever wondered why it takes so long until you receive a bug fix? Or why your highly important bug fix isn't in the next Release Update? How does the Oracle Database development works? And how can you speed up an SR? And why is Windows so different? All this and much more will be part of this talk changing your life as a DBA or manager. This is the talk you must visit when you deal with Oracle databases.

From SR to Patch - Secret insights into the Oracle Database development

Join this session to get a comprehensive understanding of what happens internally to your Oracle Database files and dictionary tables when you patch your database. This will be a deep and dive session, dissecting how opatch and datapath work. How does rollback happen? And in multitenant architecture, can I patch only the CDB? How to patch with zero downtime? How to protect Oracle Home files from attackers? Those are sample questions that will be answered during the session.

Database Patching Internals

Germany

After 20K+ hours oncall supporting all sort of business, like banking, retail and department store, online services and e-commerce, television, automotive industry, healthcare, timeshare, education and others, this is a summary on how to deal with the most frequent issues using the best we have.

Tips & Tricks from 20K+ hours DBA oncall

Colombia

En esta sesión, aprenderá cómo desarrollar e implementar rápida y fácilmente aplicaciones móviles utilizando Oracle APEX, la plataforma de desarrollo de aplicaciones Low Code de Oracle. Comenzaremos con un archivo que contiene datos de carreras de F1 y la convertiremos en una aplicación donde agregaremos búsqueda por facetas, informes personalizados, tableros y más. Luego, personalizaremos la interfaz de usuario y la convertiremos en una aplicación web progresiva que puede ser instalada y utilizada por cualquier persona en todo el mundo. ¡Únete a nosotros en esta aventura de Low Code!

De Idea a Realidad: Construye una app móvil en 60 minutos con Oracle APEX!

Você deseja modernizar seus aplicativos Oracle Forms, criando apps de negócios rápidos, intuitivos e seguros, reutilizando a lógica de negócios e sem custos de licenciamento? Se sim, esta sessão é para você! Saiba por que o Oracle APEX é a ferramenta ideal para modernizar aplicativos desenvolvidos em Oracle Forms.

Benefícios de modernizar seus aplicativos Oracle Forms com o Oracle APEX

This session will present how can the developer validate input data from the user. This presentation will be in Portuguese.

Data validations in Oracle APEX

This session will demonstrate some funcionalities we can build using the Dynamic Action Component from APEX

Creating dynamic action in APEX

Aprenderemos como implementar AJAX de manera eficiente para traer datos en tiempo real desde Oracle APEX. -Procesos AJAX Callback -Documentación apex.oracle.com/jsapi -Envío de parámetros -Llamada de procesos -Procesamiento de data vía json

Implementando AJAX en las solicitudes de Oracle APEX

REST Enabled SQL permite el acceso a bases de datos remotas de manera sencilla y sin tener que definir "database links". En esta sesión, el asistente podrá conocer de primera mano lo sencillo que es habilitar REST Enabled SQL y cómo de manera más sencilla Oracle Application Express hace uso de esta funcionalidad para generar aplicaciones de manera aún más sencilla.

Adiós database link, hola REST Enabled SQL

Peru

Successful Projects with APEX in Finance and Cooperatives

Successful Projects with APEX in Finance and Cooperatives

United States of America

No matter how much you prepare, all systems will fail at some point. And, the more complex and distributed the system, the higher the likelihood that one of your many moving parts will stumble and fall in a way that is likely to impact both your users and your business. With a microservices-based architecture, system failure comes in many forms: a service outage, worker node failure, network issues, or any number of unexpected issues, adding complexity to an already-convoluted investigative process. So, how do you move away from the traditional model of “after the fact” troubleshooting? You architect for Observability from the get-go. This session provides best practices into making your system more observable, and consequently more insightful and actionable. Using a Kubernetes, Prometheus, Jaeger, and Grafana environment, we will cover: •	Investing in a proactive data collection strategy •	How monitoring != observability •	Moving quickly from data to insight to action Using these guidelines, organizations of all shapes and sizes can quickly get started understanding and addressing the issues encountered by their systems -- and, most importantly, resolve IT mysteries before they happen. Benefits to the Ecosystem In a fun and light-hearted presentation as solving an IT murder mystery, Erin and Sherwood will guide the attendee through: •	How and what information to capture for a proactive data collection strategy so they can connect the dots leading up to – and after – a system failure. •	How to set up monitoring using Prometheus to provide insight into the overall health of your systems and observability using Prometheus, Jaeger, and Grafana to provide deeper context into a system’s inner workings. No one-size-fits-all approach, but there are a number of best practices the attendee can take with them and use in their environment. •	How to turn monitoring data into insights and, ultimately, action. Bringing together your observability information with your knowledge of the “usual suspects” in your systems will enable you to rapidly move from data → insight → action, while also improving the overall health of your IT portfolio.

Observability: Solving IT Murder Mysteries Before They Happen

Portugal

When dealing with application scalability, it is common to deal with topics such as microservices, cache, and NoSQL, among other buzzwords in the software engineering area. However, particular needs are often overlooked, such as: ensuring that the organization's point of failure is not IT. But instead the human factor. One of the biggest challenges in software engineering today is ensuring that the technology park grows and innovates while being stable and resilient. Delivering innovation with stability, despite sounding utopian, is possible through well-orchestrated work. This talk will teach practices that lead to a well-documented, multiplier architecture.

Architectural practices for greater scalability and innovation

Aprenderemos cómo puede crear rápidamente un servicio backend Kotlin utilizando Spring Boot, y utilizar Spring Cloud GCP para aprovechar muchos de los servicios útiles de Google Cloud para la base de datos, el almacenamiento y la observabilidad en cuestión de minutos. Estos servicios están totalmente gestionados, por lo que no es necesario dedicar tiempo a la configuración y gestión de la nueva infraestructura. En su lugar, puedes centrarte en el código. Cuando el backend esté listo, lo desplegaremos en nuestra plataforma sin servidor, donde tu servicio de backend puede escalar automáticamente el número de instancias en función de la carga, pero también puede reducirse a cero instancias cuando nadie lo esté utilizando.

Construir un backends con Kotlin y Spring Boot

Observability is today central for a reliable architecture and Grafana is the best-in-class choice to offer a Single-pane of Glass for Cloud Native environments. Converged Oracle Database could be out of this scenario thus in this workshop, we will have our journey to monitor Oracle Database using the start of the current APM solution - Prometheus + Grafana stack.

Unified Observability in Grafana with Converged Oracle Database

Les voy a presentar la consola de seguridad que ofrece Oracle en forma nativa en OCI. Veremos todas las ventajas y validaciones que podemos automatizar con esta herramienta gratuita que tenemos dentro de nuestra subscripción

OCI – Oracle Cloud Guard

Uruguay

Terraform is a popular tool to handle your infrastructure as code. It is really simple to use and there are plenty of examples and tutorials. What about when you need to use it for several months on a daily basis? In this session I share my learnings after using it for almost a year to maintain databases in the cloud (OCI and AWS), highlighting the concepts and issues you need to get familiar with in order to speed up the learning curve, become more productive, and avoid common mistakes.

Terraform tips and tricks

France

Databases have always been a hurdle in application development. Data refreshes are time consuming and require down time and coordination. Legacy environments balance the risk of working with stale data against the effort and inconvenience of returning the database to a baseline. Even modern agile shops struggle with this task, engineering complex processes or buying hardware and software solutions to manage their test data. The difficulty lies in the way databases, configurations, and data blend together. Traditionally, navigating that complexity is left to the database administrator. Docker changes that and holds the potential to revolutionize database development. With Docker, it's no longer necessary to master database internals and commands to create, manage, or refresh databases. In this session I'll show you how to use Docker to: • Create data artifacts • Start new databases in seconds using saved baselines • Save, version, and distribute data sets in your organization •&nbsp;Integrate databases as full members of existing CI/CD pipelines • Test with confidence and avoid uncertainty introduced by data drift • Speed application development and reduce time spent provisioning database assets ...and all without a single database command!

Chopping the Monolith

Smooth database operations are hindered when unexpected performance incidents occur. What if we could predict an incident was likely to occur within the next 60 seconds? By using Oracle Sysmetric data with deep learning neural networks, this can be a reality. This presentation will begin with how we recognize patterns and how artificial neural networks try to do the same. Then we’ll look at Oracle database Sysmetric data, understanding and leveraging its time-series nature. With only a few more ML specifics, you will be ready to understand why neural networks and deep learning are sought after in performance prediction. An Oracle Cloud Free Tier or Gmail account is all you need for a mind-blowing graphical demonstration of making real-time performance predictions. You can download the single file necessary to replicate my demonstration enabling you to tinker and explore! Once you get a glimpse of what is possible, a whole new world of performance monitoring and alerting will come into focus. Join me for a fascinating applied Machine Learning presentation for the Oracle professional of the future.

Average Active Session Predictions Using Deep Learning Neural Networks

Both graph analysis and machine learning are effective techniques to detect anomalies and outliers in datasets. The former is particularly useful when relationships between entities play a role, in other words, when the data represents a network of connected things. Networks of bank accounts connected by financial transactions are one obvious example. For this reason, modern fraud prevention applications use graph analytics and pattern matching on this kind of data. In addition to this approach, financial service customers are increasingly complementing graph analysis with machine learning to yield even more accurate results. In this session, we will show how the Paysafe Group, a global provider of e-payment services, uses graph analysis for fraud detection. We will look at how to prepare relational data for graph analysis and how a machine learning platform can consume the linked data without losing the characteristics of the graph. Finally, we will explain why graph analysis and machine learning yield different results on the same data and discuss how data scientists can combine these techniques.

Fraud Detection in Financial Services using Graph Analysis and Machine Learning

El top 10 de funcionalidades que se pueden encontrar solo en EPM Cloud a diferencia de On Prem. •	Navigation Flows •	Data Maps/Smart Push •	Valid Intersections •	Flex Forms •	Cell Level Security •	Groovy Scripts •	Predictive Planning / Auto Prediction •	IPM Insights (Forecast Variance and Bias Insights, Prediction Insights, Anomaly Insights) •	Migration / Backup / Cloning Environments •	Auditing

Top 10 características en EPM Cloud

Mexico

APIs are ruling the digital transformation efforts and projects. We all talk about APIs. The world is aware about the existence of the APIs. We have API Designers, API Developers and API Architects. APIs are a first class citizen in the Cloud. The Cloud itself cannot be understood without APIs. APIs are creating new business. APIs are products. API Management solutions are part of every CIO agenda. Fintechs, Mobile Virtual Operators, Mobility Applications, Food Delivery solutions, Super market solutions are just a few examples on how APIs are the enablers for doing business on a different way. If we are API consumers, we expect APIs to be designed in such a way that can be understood on a very simple manner, with no effort. We all expect well-designed APIs. If we are API designers and publishers, we better have good principles to create them. But...what happens when we need to design APIs for an event-driven architecture? What is the best option for that an why? Is it really possible to have an specification that can be used to describe events on an API fashion? Is there any value for that? This session is exactly to answer those questions. We will showcase the AsyncAPI initiative and you can apply it to your projects.

AsyncAPI is your options for Event-Driven Architecture

Oracle Analysis Cloud includes many out-of-the-box Ml And AI features that make the life of the business analysts easier. These are very intuitive features that bring a lot of value and reduce data cleansing and analysis time. But there is more. In the latest releases, we can find more tight integration with Oracle Machine Learning as well as with OCI AI Services.&nbsp;In this session, you will see all these features and how to integrate with ML and AI in detail and with live demos.

Oracle Analytics Cloud: ML and AI Features and Integration

In this workshop walk you through all the steps to get started using Oracle Big Data Service (BDS) using BDS and Oracle Cloud Infrastructure (OCI).

Big Data Cloud Services - Bring your Present, Build your Future

Migration of an Oracle Database is a process that takes significant planning and effort. In this session, you will learn about migration from Oracle Databases, including examples, free tools, and techniques for easy migration.

Everything you need to know when you are moving your Oracle Databases

Sri Lanka

This topic delivers about Data integration isn’t just only for large enterprises of IT industry, Every single business including Hospitality industry needs to be able to use its data to compete effectively when developing designing database. Session will cover types of data integration, how does it effect in hospitality industry, what are the challenges in integrating data in hospitality products comparing with other industries and etc

Ingesting and Integrating Data in Hospitality Products

After an assessment, our organization decided to start the cloud journey by investing in Oracle Cloud ERP for our global operations. Our implementation initially covered full operations across the USA, Canada, Mexico, Brazil, and Argentina. The globalizations -which means meeting legal and statutory requirements globally- in Cloud ERP have a significant number of technical components worth learning before planning your implementation from a budget and a resource's perspective. In this session, we will cover which aspects you'd need third party companies and how you can integrate them with Oracle Integration Cloud (OIC). Also, what patching needs to be applied in Oracle Cloud SaaS, OIC, and creating an Oracle Autonomous Database, including some developments provided out-of-the-box in Oracle Visual Builder that extend Oracle SaaS. We'll show some real-life examples for Argentina and how the architected solution will look for other LATAM countries.

Demystifying the technical complexity of covering Globalizations in Cloud ERP

Oratop is a text based user interface tool for monitoring basic database operations in real time. This presentation will go into depth on how to use the tool and some example scenarios. It can be used for both RAC as well as single-instance database and can be used in combination with top to get a more holistic view of system performance and identify any bottlenecks

Oracle Database performance tuning using oratop - tips and tricks

Oracle’s Platform as a Service (PaaS) provides two powerful capabilities to Oracle Software as a Service (SaaS) i.e., Cloud Applications users. Using PaaS4SaaS, Oracle Cloud Applications can be extended to include new functionality. PaaS4SaaS is also used to integrate Cloud Applications with other Cloud or On-premise Applications. In this presentation, Oracle ACE Director Basheer Khan will describe how to leverage platform services such as Oracle WebLogic, Integration Cloud Service, and Process Cloud Service with Oracle SaaS. Several real-life use cases of how customers are leveraging PaaS4SaaS to extend and integrate their Cloud Applications will also be presented.

LAOUC Community Tour 2022

Speakers

Francisco Munoz

Osama Mustafa

Roy Salazar

Rita Nunez

Ronald Vargas

LISANDRO FERNIGRINI

Rodrigo Jorge

Mike Dietrich

Matheus Boesing

Monica Godoy

Anderson Ferreira

Emmanuel Guzmán

Eddie Molina

Helen Trujillo

Karina RPastor

Sherwood Zern

Otavio Santana

Geovanny Mendoza

Paulo Simoes

Cristian Peque

Nelson Calero

Nicolas Fränkel

Craig Shallahamer

Hans Viehmann

juan krevisky

Rolando Carrasco

Edelweiss Kammermann

Pedro Torres

Alex Zaballa

Gohulan Somanathan

Gustavo Gonzalez

Sandesh Rao

Basheer Khan