Maria Colgan

Oracle Server Techonologies

Mater Product Manager

ENG

Level: Intermediate


Keynote: Oracle Database 12c and DevOps
For decades developers and DBAs have battled over who controls the world. With each new development paradigm the battle flares again as developers push DBAs to adopt and support new data structures (JSON), new APIs (REST services), new technologies (In-Memory) and new platforms (Cloud). Oracle Database 12c is the ultimate peacekeeper, offers both developers and DBAs everything they need to happily co-exist and successfully embrace the latest technology trends, without exposing the business to painful availability or security vulnerabilities.




Duncan Mills
Oracle

Senior Director

ENG



Keynote: How I learned to stop worrying and love the Cloud
A ramble through the worlds of DevOps, Agile and Modern development for the Oracle platform. Can the vision match your reality?



De abstracts van Tech Experience 2017 staan per onderwerp gerangschikt.


Klik op een van onderstaande SIGs of onderwerpen om naar de betreffende serie abstracts te gaan:
 


BIWA (Business Intelligence en Data Warehousing)

Brendan Tierney

Oralytics

Principal Consultant

ACE Director

ENG

Level: Intermediate


Is Oracle the best language for Statistics

Did you know that Oracle comes with over 280+ statistical functions? and that these statistical functions are available in all version of the Database? Most people do not seem to know this. When we hear about people performing statistical analytics we can hear them talking about Excel and R. But what if we could do statistical analysis in the database, without having to extract any data onto client machines. That would be really good and just think of the possible data security issues with using Excel, R and other tools. This presentation will explore the various statistical areas available in SQL and I will give a number of demonstrations on some of the more commonly used statistical techniques. With the introduction of Big Data SQL we can now use these same 280+ Oracle statistical functions on all our data including Hadoop and NoSQL. We can also greatly expand our statistical capabilities by using Oracle R Enterprise using the embedded capabilities in SQL.

Speaker/bio

Brendan Tierney, Oracle ACE Director, is an independent consultant (Oralytics) and lectures on data science, databases, and Big Data at the Dublin Institute of Technology/Dublin Technological University. He has 24+ years of experience working in the areas of data mining, data science, Big Data, and data warehousing. Brendan is a recognized data science and Big Data expert and has worked on projects in Ireland, the UK, Belgium, Holland, Norway, Spain, Canada, and the U.S. Brendan is active in the Oracle User Group community, where he is one of the leaders for the OUG in Ireland. Brendan has also been editor of the UKOUG Oracle Scene magazine and is a regular speaker at conferences around the world. He is an active blogger and also writes articles for OTN, Oracle Scene, IOUG SELECT Journal, ODTUG Technical Journal, and ToadWorld. He is also on the board of directors for DAMA in Ireland. Brendan has published three books with Oracle Press (Predictive Analytics Using Oracle Data Miner, Oracle R Enterprise: Harnessing the Power of R in Oracle Database, and Real World SQL and PL/SQL: Advice from the Experts). These books are available on Amazon.

Web and blog: www.oralytics.com

Twitter: @brendantierney


Gianni Ceresa

DATAlysis GmbH

Managing Director

ENG

Level: Intermediate


OBIEE DevOps with Containers: How and Why

Nowadays BI development processes have adopted a more flexible and agile approach. With this major change some activities become more and more important like quickly provisioning a sandbox environment for developers right after their kick off of a new project or in a later stage being able to execute a full regression testing suite and implement continuous integration to merge the various parallel development into your OBIEE server.

At the same time the infrastructure of these enterprise tools isn’t anymore a bunch of physical servers, organizations try to increase flexibility while lowering costs adopting virtual machine or, more recently, moving into containers solutions.

Containers are the “next step” after standardized virtual machines where the virtualization software runs as an application within the operating system instead of duplicating a full OS. As they are running within the OS they require less resources, RAM as well as storage and increase flexibility.

In this session you will first be introduced to the concept of containers (Docker) and, more specifically, how to run OBIEE inside a container. You will then see how this solution can help you make various DevOps activities simpler while gaining in agility.

Do you need a fresh sandbox for a new resource joining your team? A container running OBIEE can be deployed in just few commands within minutes.

What about continuous integration and regression testing? Instead of having a dedicated “test server” able to run these tests in a serial mode you can execute them in parallel using container: fire up a fresh container right after a new commit in your versioning system is detected. Run regression testing. Once done the container disappears like it was never there - thus freeing up resources - and you have the regression test output to analyze.

And last but not least: all of it automated! You will see an example of an automation use case with triggers running a regression test using the Baseline Validation Tool when a new commit in Git is detected.

Forget what a nightmare it normally is when applying a bundle patch or doing an upgrade: requiring systems running in parallel and using extra hardware resources you have to pay for. With containers it’s as simple as executing a command to run both versions in parallel and do the full regression testing needed to update/upgrade your prod environment without being scared.

Provisioning developers’ sandboxes or regression testings and continuous integration in OBIEE, some common DevOps tasks which often take time and resources. Containers technology provides a quick and flexible answer to these growing needs and as opposed to virtual machines require less resources (storage and memory). You will learn about containers (Docker) and how OBIEE can fit into it and be managed easily to fulfil these common tasks. Having nightmares thinking at your next upgrade or patch? OBIEE in a container can be a solution for having sweet dreams every night. Works both on prem and cloud (OCCS or others).


Speaker/bio

An OBIEE enthusiast more widely interested in BI/DW/EPM solutions with a special focus on Oracle products and solutions. Owner of DATAlysis GmbH, a consulting company in Switzerland, he has more than 8 years of experience in multiple project roles like architect, analyst, team lead and developer, bridging together the business and the technical side of the BI world. His other activities include OBIEE training delivery, R&D, blogging and supporting the Oracle community on the OTN forums.



Brendan Tierney

Oralytics

Principal Consultant

ACE Director

ENG

Level: Intermediate

 
Running R in your Oracle Database using Oracle R Enterprise

R is a very powerful programming language that allows use to perform all sorts of statistical and advanced analytics on your data. But can we use R in the Database? How can we do this? How is it different to the Advanced Analytics Option? Can we combine the power of R and the in-database Data Mining feature? This presentation will look at each of these questions and will give a live demonstrations to illustrate the answers. At the end of the presentation you will know how to use R on your data, how to integrate R with your Data Mining processes, how to embed R in your database and how to use the embedded R to perform advanced analytics on your data. The presentation will conclude with example of how to include in-database R code in OBIEE.


Speaker/bio

Brendan Tierney, Oracle ACE Director, is an independent consultant (Oralytics) and lectures on data science, databases, and Big Data at the Dublin Institute of Technology/Dublin Technological University. He has 24+ years of experience working in the areas of data mining, data science, Big Data, and data warehousing. Brendan is a recognized data science and Big Data expert and has worked on projects in Ireland, the UK, Belgium, Holland, Norway, Spain, Canada, and the U.S. Brendan is active in the Oracle User Group community, where he is one of the leaders for the OUG in Ireland. Brendan has also been editor of the UKOUG Oracle Scene magazine and is a regular speaker at conferences around the world. He is an active blogger and also writes articles for OTN, Oracle Scene, IOUG SELECT Journal, ODTUG Technical Journal, and ToadWorld. He is also on the board of directors for DAMA in Ireland. Brendan has published three books with Oracle Press (Predictive Analytics Using Oracle Data Miner, Oracle R Enterprise: Harnessing the Power of R in Oracle Database, and Real World SQL and PL/SQL: Advice from the Experts). These books are available on Amazon.

Web and blog: www.oralytics.com

Twitter: @brendantierney


Hasso Schaap

Qualogy & ForceView

Business Intelligence Consultant

ENG

Level: Intermediate


Data Modeling, BI Modeling and-or Data Blending & Wrangling

What For users of corporate data in a bimodal IT environment it is somehow confusing that there are several tools available for combining data in BI tools these days. Users are faced with corporate governed data models and have been using them for several years within their BI tools. They may not be aware of how data is stored or structured and expect the easiest access to more datasets and want to combine them.

While modern analytics tools could recommend how to combine data, how do users make such a decision? It is valuable to understand the underlying principles of BI models, data models and schema’s to be able to define new sets that are of value.

In this session we explain the different modeling abstraction levels, the different modeling tools and how you can enable end-users to do just that necessary thing within the modern BI tools, such as Oracle Business Intelligence and Oracle Data Visualization.

When users leave this session they understand when to use which data modeling or blending tool within the Oracle Analytics portfolio and are able to figure out how to handle their data based on their goals. They will learn the importance of for instance referential integrity, data quality, aggregation and calculation rules, normalization and many other topics.

People attending this session learn the differences between Oracle SQL Developer Data Modeler, Oracle BI Cloud Data Modeler, BI Admin Tool and Data Preparation, Blending and Mashup and when to use each.

Collaboration on analytics in the Oracle Business Intelligence and Data Visualization Cloud Service

This presentation is showing tools for how to bridge the gap between Business and IT. Using two dashboards, called Data Management and Information Management, attendees get an idea of how you can create a collaborative environment for business users. Everything within the Oracle Business Intelligence Cloud Service and Data Visualization. No more questions about data definitions and lineage, put all your work into a visible library and share how dashboards are built. The OBICS Collaboration Pack builds on the 4 categories of collaboration: Data, Code, Visual and Insight.

After having announced the release of the OBICS Collaboration Pack in 2016, we are now getting ready for the 2nd release, available for free, building on the latest features of Oracle Data Visualization and Oracle Business Intelligence.

The OBICS Collaboration Pack also builds on the integrated Application Express Packaged Apps that are available for free. Integrate context sensitive Comments, Surveys, Bugs, Incidents, Feature Request and others into a collaborative BI environment, and you don’t have to switch applications to find your documentation or other collateral.

Some new features that will be shown from the collaborative Oracle Data Visualization products. With these new features there is a choice: collaborate Bimodal; collaboration for Business Users and collaborate with IT. Do all your collaboration in one Project package or integrate in the IT managed environment.


Gurcan Orhan

Metric Analytics Consultancy
Senior Solutions Architect

ACE Director

ENG

Level: Beginner


EDQ, OGG and ODI over Exadata in the Cloud for Perfection
Oracle Golden Gate (OGG) Cloud Service handles extraction phase for operational reporting, Enterprise Data Quality (EDQ) leverage source system based data quality problems in the cloud (misspells/duplications in defined or undefined conditions) and Oracle Data Integrator (ODI) Cloud Service handles and controls both of those tools and moreover loading your data into data warehouse which is in the cloud.
These 3 tools are integrated to work together while you have control of OGG and EDQ via ODI over Exadata machine in a faster manner with minimum effort of development and tools already exist in ODI.
At the same time use Exadata's extensive features to decrease ETL jobs' duration and obtain high availibility.
In this session, hear how this 3 tools are merged to be used together in the Cloud.

Migration steps from OWB to ODI
It is the fact that Oracle Warehouse Builder (OWB) released the latest major version and final state. But business requirements are rapidly increasing. New applications are implemented in source systems and as a result new reports and new subject areas are needed urgently. It is needed to implement new features for growing business needs into our data warehouses. Resources are limited and conversion should be done as soon as possible.
In this session, hear the most convenient methods to migrate from Oracle Warehouse Builder to Oracle Data Integrator with agile methodology without interrupting on going daily jobs as well as understanding of Oracle's OWB2ODI migration utility.

Speaker/bio
Working as Senior Solution Architect at Metric Analytics Consultancy. Awarded Oracle Excellence Awards, Technologist of the Year 2011 : Enterprise Architect as well as ACE Director for Business Intelligence expertise. Experienced mostly on data warehouse architecture and ETL/ELT development. He has been working with database systems since 1994 and developed his first data warehouse in 2003 with Oracle 6i. He has used almost well known DBMS systems, modelling, ETL and BI tools, but experienced mainly on Oracle Data Integrator as a data integration tool. He's one of the board member of TROUG (Turkish Oracle User Group) and Chairman of BI&DWH SIG as well as having membership in various Oracle User Groups worldwide.


Marco Klaassens, co-speaker Daan Bakboord

NetApp 

Senior Business Intelligence Analyst

ENG

Level: Beginner


Introduction in Big Data Cloud Service & Use case

In this presentation we will focus on the Oracle Big Data Cloud Service, its main functionality, how it fits in the architecture for on-premise/cloud data sources and we will present a real use case around Marketing Campaigns.


Speaker/bio Marco Klaassens

More than 8 years experience with Oracle. OBIEE certified. BI Cloud certified.

Speaker/bio Daan Bakboord

Daan Bakboord is Delivery Manager for the Business Analytics & Big Data Practice for Quistor in the Netherlands. Daan's mission is helping customers make data driven decisions using Oracle Business Analytics. Daan is an all-round Oracle Business Analytics consultant with a broad international experience in the deployment of Oracle Business Analytics tooling in general and its application in (Oracle) ERP environments in particular.



Christian Berg

Dimensionality

Managing Director

ACE 

ENG

Level: Intermediate


A Day in the Life of an Oracle Analytics Query

Cloud, on-prem or now even on-desktop - Oracle Analytics has been in use for years, gone through many iterations, and is widespread across projects around the globe. Millions of analyses have been created, deployed, and run billions of times. The actual lifecycle of an Oracle Analytics - and hence OBI - query from its inception through to the effective delivery of results may therefore be regarded as a given commodity not requiring a closer look. Few people have regarded an OBI query from this point of view: "How does it get constructed? How does it get translated between the different architectural components and the RPD layers? How, through what, and where does its lifecycle get influenced? Where can we as users/developers/administrators actively intervene with its makeup and structure? Why do we genuinely have to have an understanding of the subtleties of the lifecycle to create successful BI solutions?"

Even for the Cloud solutions this is crucial know-how.

The purpose of this presentation is to serve as an introductory session for beginners while at the same serving as a reflective discussion of a topic regarded as "god-given / it just IS" by the wider population of users (including intermediates). Theoretical examination of the possible steps and paths the query lifecycle can take is depicted with simple but speaking examples. The impact of factors like basic analysis construction in Answers, advanced SQL clauses, caching, business model peculiarities like multi-star queries, snowflaking and LTS modelling as well as physical layer settings like call interfaces, data source parametrization or inclusion of hints in the RPD are to be showcased.


Speaker/bio

Working with Oracle's Analytics solutions since the day of nQuire's acquisition by Siebel Systems in 2001, Christian Berg has more than 15 years of business analytics project work in all industries. His architect work spans the value chain of business analytics from source systems through ETL, logical modelling, and graphical representation, as well as infrastructure/environment work and dev-ops. Areas of predilection include physical and logical modeling. Christian also teaches OBI for Oracle University and other integrators and end clients.



CAF (Cloud Application Foundation)

Osama Mustafa

Gurus Soltions

Chief Technology Officer

ACE Director

ENG

Level: Intermediate


Weblogic 101 for DBA

Like it or not, knowledge of WebLogic is now part of the DBA role. You don’t have to know a great deal to be useful with basic WebLogic setups, but the whole Fusion Middleware stack is big and complicated. Once you step beyond the basics, Learn WebLogic Architecture and Components, Installing WLS & Configuring a Domain, Oracle Enterprise Manager 12c, Managing WebLogic.



Weblogic & Dockers

Docker containers wrap up a piece of software in a complete filesystem that contains everything it needs to run: code, runtime, system tools, and system libraries – anything you can install on a server. This guarantees that it will always run the same, regardless of the environment it is running in. Oracle WebLogic Server is now certified to run on Docker containers.


Speaker/bio

Osama Mustafa is Founder of Gurus Solutions Company, Oracle ACE Director , Creator/Director of Jordan Amman Oracle User Group the first Group in Jordan related to oracle technology,Author of the book Oracle Penetration Testing, Osama has been working on project and customer support in EMEA Region, Providing Database Implementation Solutions, his specialties Fusion middleware, In memory database Timesten, Exalytics and Exalogic machine, Include to this Osama Is frequently Speaker in Oracle User Groups around the world and one of RAC ATTACK event organizer, Fusion middleware ATTACK Organizer as well, he published articles in Oracle Magazine, OTECH magazine and UKOUG Oracle Scene magazine, Also he is Blogger and Certified Oracle Database and Fusion middleware, he assists with sharing his knowledge at conferences, webinars, white papers ,slide share and blog posts to the Oracle community, Simply he is Oracle passionate, International Speaker in Oracle user group.



Michel Schildmeijer

Qualogy

Solutions Architect Oracle Fusion Middleware

ACE

ENG

Level: Intermediate


WebLogic new MultiTenancy features

Within the newest releases from WebLogic terms such as "Elasticity" and " Multitenancy" are key features that will lift the tradional WebLogic Server Platform to a new era of microcontaining

Do all these new terms dazzle you a bit? Come and listen to this session which gives you an introduction of

- Microcontainers/Partitions

- Multitenancy features

- Continuous availability

- Isolation & pluggable partitions

- JVM & Resource isolation


Speaker/bio

Started in pharmacy, Michel made the change to IT in 1996, on a UNIX TTY terminal based computer and the MUMPS language. These days he is an Oracle Fusion Middleware Architect at Qualogy, as member of the Exalogic Squad team, with focus on technical infrastructure, Serverside solutions, installing, administering, configuring the Oracle Fusion Middleware stack. He started in 2000 as a support analyst for a big bank with BEA Tuxedo 6.5 and WebLogic 6. His experience is from integrations at telco´s to financial institutes. He now works mainly with Oracle Fusion Middleware 11g and 12c, plus releases with practically all Oracle products running on top of it. In 2012 he became an Oracle ACE and wrote 2 books about WebLogic: http://www.packtpub.com/oracle-weblogic-server-11gr2-administration-essentials/book which was launched at October 2011 worldwide during Oracle OpenWorld 2011. Very short after that he released the follow up http://www.packtpub.com/oracle-weblogic-server-12c-first-look/book.

Furthermore, he is a well-known expert in the Oracle Partner community and speaks regular on big events in the EMEA region and worldwide, such as Oracle OpenWorld, OBUG, OUGN and OGH

Read more at: https://community.oracle.com/blogs/mnemonichttp://www.qualogy.nl/techblog/author/michel-schildmeijer


Martien van den Akker & Rob de Gouw

Darwin IT/Professionals B.V.

Integration Architect

NL

Level: Expert


Why you should install your FMW environments using scripts and how to do that

Since 11g the installation of Fusion Middleware (FMW), including the Repository Creation is made possible using the Oracle Universal Installer. Although this is very convenient for ad-hoc installations, we experience this as error-prone and labor-intensive. In our presentation we will describe the installation topology for FMW on OSB, SOA Suite and BPM Suite, and showcase how to perform this installation using (Bash) scripts. Then we show how to create a domain using Weblogic Scripting Tool (WLST) scripts. Also artefacts like users, queues, datasources etc. are created automatically using these WLST scripts.

As a demo, we will deliver a FMW installation from scratch. Although there are a number of alternatives for this method of installation / configuration, we feel the scripted install is best for educational purposes while at the same time offering an efficient and well documented process. Ofcourse we leave ample room for discussing other alternatives.


Speaker/bio

Martien van den Akker started in IT in 1994. In 1998 he joined Oracle as development specialist on Oracle Designer, Forms, Reports and Pl/Sql. With Oracle Streams/AQ, Workflow and InterConnect the focus turned to integration. Martien was one of the first to become an expert on BPEL Process Manager, after the introduction by Oracle. He was also one of the first to implement Oracle Integration B2B in the Netherlands. Both products are now integral part of SOA Suite. Martien is an expert on the Fusion Middleware components Weblogic, Oracle Service Bus, BPM Suite and has now the PaaS offering of Oracle in focus.

Martien is employed by Darwin IT-Professionals since 2007.

Since 1995 Rob de Gouw is an ambitious and dedicated Oracle IT-professional. He worked for Oracle Netherlands Consulting for 13 years. First in Forms/Designer, then he specialized in Oracle Portal, Unified Content Management, ADF and WebCenter. He has extensive knowledge of the Oracle

Database and Weblogic Server. At Darwin he is regulary asked for as troubleshooter and ad-hoc problem solver. Rob is leading the OGh WebCenter Special Interest Group.


Cloud



Oracle ACE Team


Soaring through the Clouds –Live Demo of Setting a World Record in Integrating Oracle Public Cloud Services
You probably have seen demonstrations of Oracle Cloud Services. You may have seen demos with several cloud offerings working together. You may even have seen one of the three previous soaring through the cloud performances of the Oracle ACE Team with up to 10 cloud services in one integrated demo. In this session, we will go beyond of all that. No fewer than 17 Oracle Cloud Services will be shown in an integrated live demo, that spans data centers, continents and a wide range of platform features.

The functional story for this demo is that you – the audience – will propose artists to perform at the annual concert that concludes Oracle OpenWorld, by tweeting your favorite acts. IoT CS monitors Twitter, detects proposals and triggers a workflow that involves ICS, PCS, Document Cloud, Sites CS and Social Network. Through SOA CS, JCS and Application Container Cloud, the artist proposals are recorded – along with enriched artist and albums data - in DBaaS. Business APIs – implemented with SOA CS and published through the API Platform CS - expose the data. Through MCS, mobile APIs are created as well as a mobile application (with MAX) and a ChatBot. A rich Oracle JET web application runs from ACCS and consumes these mobile APIs. Oracle Management Cloud is used for live monitoring of the end user experience. Guest appearances are expected from Oracle Self Service Automation, Container Cloud Service and Data Visualization Cloud. Based on audience requests, we will make some functional enhancements. DevCS is used to apply and rollout the change.

Our exact flight plan depends a little bit on the weather forecast: we do need a cloudy sky to realize our full potential. The team of Oracle ACEs will explain the role of each cloud service, perform some live hacking in the various cloud services to complete and tweak the end-to-end flow. We will divulge some of the behind-the-scenes challenges and our findings beyond slideware and C-level promises. The audience kick off our demo - so please be there to lend a hand.




Jurgen de Leijer & Daniel Schrijver

Oracle

ENG


Oracle Management Cloud: Unified Platform and Machine Learning Drives New Insights
Oracle Management Cloud is a suite of next-generation integrated monitoring, management and analytics cloud services that leverage machine learning and big data techniques against the full breadth of your operational data. Oracle Management Cloud’s unified platform helps you to:, improve IT efficiency, prevent application outages, increase DevOps agility, protect against security threats



Oracle Management Cloud: Drive faster, better Software Delivery with Performance Monitoring and DevOps

As continuous delivery pushes the pace of development and deployment ever faster, IT organizations are faced with an increasing need to move quickly and shorten the gap between developers and operators. The time when different component owners hoarded operational data and sought only to exonerate themselves from blame has passed. Incorporating management telemetry early and continuously in the delivery pipeline builds the knowledge and discipline necessary to ensure high performing releases and prevent production problems. We will cover methods to incorporate instrumentation and telemetry into continuous delivery, with concrete examples of implementation and benefits. 


DBA (Database Administration)

Gerwin Hendriksen

Axis into ICT

Principal Consultant

NL/ENG

Level: Intermediate


Tuning op basis van Wall Clock tijd i.p.v. Elapsed time in databases

In Oracle land wordt bij tuning van SQL gekeken naar elapsed time terwijl een eind gebruiker geïnteresseerd is in de tijd dat hij of zij echt moet wachten voor hij antwoord krijgt. Het blijkt in praktijk dat soms meer elapsed time wordt gemeten en uiteindelijk de eindgebruiker korter wacht, in AWR rapportages is dit niet te zien en wordt op onjuiste manier getuned.


Speaker/bio

Gerwin werkt al meer dan twintig jaar met Oracle technologie. Hij is begonnen als DBA bij een consultancy bedrijf, hierna werkte hij vijf jaar bij Oracle in de rol van Advanced Resolution Engineer. In deze rol specialiseerde hij zich in performance en hoge beschikbaarheid voor Oracle Databases en E-Business Suite. In de tijd dat hij werkte voor Oracle gaf hij verschillende training in binnen- en buitenland. Later werkte Gerwin voor IBM als technisch consultant voor verschillend projecten in verschillende landen. Hij gaf hiernaast trainingen in het IBM JSC in Montpellier en bij verschillende klanten. In de loop van zijn carriere ontwikkelde Gerwin een eigen performance methodologie genaamd "Method-GAPP". Hierover heeft hij meerdere keren gesproken bij Hotsos in Dallas (2008, 2009, 2011 en 2013), bij Oracle Open World in 2008, bij de UKOUG in 2011 en bij verschillend nederlandse conferenties. Op dit moment is Gerwin werkzaam bij Axis into ICT als principal Consultant.


Toon Koppelaars

Oracle

Consulting Member of Technical Staff

NL

Level: Intermediate

Investigating the performance of a statement via the SQL Monitor report

If you investigate the performance of SQL statements regularly, you really should be using SQL Monitor reports as a means to get great detailed information on how a statement was executed and where time was spent. In this session we'll introduce you to SQL Monitor reports and describe the anatomy of such a report. We'll then do a couple of hands-on performance investigations using real-world examples.

Speaker/bio

Toon has been part of the Oracle eco-system since 1987. He is currently a member of Oracle's Real World Performance team. The RWP-team troubleshoots application performance issues in and around the DBMS. The way applications currently use (or rather, abuse) the DBMS, is often at the root of these performance issues. Prior to joining the RWP team, Toon has been mainly involved in database application development. His special interests are: architecting applications for performance and scalability, database design, and business rules / constraints modelling. He is a long-time champion of the Thick Database paradigm.


Lothar Flatz

Diso AG

Senior Principal Consultant

ACE

ENG

Level: Intermediate


Raiders of the Data Dictionary I: Indexing for the Workload

Have you ever wondered about the quality of the index design in one of your applications? After all, quite often the index design is done by developers who never see the database in action. How about not just fitting one index into existing complex indexes but create a complete new index design where everything fits together optimized as a whole. Would that not be very risky? How do you control the risk? How would you form your team? Where will you get the relevant information to do this? What tools would you use?


SQLTuning Mystery: Anatomy of a SQL Statement

Sir Arthur Conan Doyle's role model for Sherlock Holmes was his former Professor Dr. Joseph Bell. He wrote about his motivation, that he wanted to write a detective story "in which the hero would treat crime as Dr. Bell treated disease and where science would take the place of chance." As we all know, when watching series like CSI, Conan Doyle’s opinion is widely accepted nowadays.

Can we learn from Sherlock Holmes’s way of deductions to improve our own daily work?

Following a real case, we will see how step by step fact based deduction will lead to success. Please, join in, contribute and have fun.


Speaker/bio

Lothar Flatz started working with Oracle Database in 1989, in the days of Version 5. He worked for Oracle Corporation for 15 years and was a member of the Real-World Performance Group for two years. He is a member of the OakTable Network of Oracle scientists and specializes in performance tuning.


Maria Colgan

Oracle Server Techonologies

Mater Product Manager

ENG

Level: Intermediate


Explaining the Explain Plan- Interpreting Execution Plans for SQL Statements

 

The execution plan for a SQL statement can often seem complicated and hard to understand. Determining if the execution plan you are looking at is the best plan you could get or attempting to improve a poorly performing execution plan can be a daunting task even for the most experienced DBA or developer. This session examines the different aspects of an execution plan, from selectivity to parallel execution and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan.



Oracle Database In-Memory: A Deep Dive into the Next Generation

Oracle Database In-Memory is the industry leading in-memory database technology, seamlessly accelerating analytics as well as improving mixed workload enterprise OLTP applications, on databases of any size. In the two years since it was launched, Database In-Memory has been successfully adopted by a wide variety of customers across many industries, making it one of the fastest growing technology offerings from Oracle. This session provides a detailed explanation of what you can expect from the next generation of Oracle Database In-Memory and how it interacts with other aspects of the Oracle Database like RAC, Multitenant and the optimizer.


Speaker/bio

Maria Colgan is a master product manager at Oracle Corporation and has been with the company since version 7.3 was released in 1996. Maria is responsible for evangelizing new database functionality and getting feedback from customers and partners incorporated into future releases of the product. Prior to this role, she was the product manager for Oracle Database In-Memory and the query optimizer. Based on Maria’s extensive experience in Oracle’s Server Technology Performance Group – where she conducted competitive customer benchmarks and tuning sessions – she develops and delivers material on the Oracle Database and the best practices for incorporating it into your environments. She is also the author of the SQLMaria blog https://sqlmaria.com.


Jakub Sejba

DBvisit

Development & Software

ENG

Moving Oracle data in real-time - The 3 fundamental principles of Oracle replication
Moving Oracle data in real-time using logical replication based on redo log mining is used by many tools such as Golden Gate, Streams and others. There are 3 fundamental principles that govern how all these replication solutions work. The 3 principles are around conversion, identification and conflicts of the replicated data.This session explains what the 3 principles are, how they work and provides demos as proof. Other topics addressed are managing conflicts, commit strategies, sequences, updating primary keys and the difference between logical and physical replication.This information is good grounding for DBAs, architects or developers that require replication from one database to another for reporting, data-warehousing, migrations, CDC, streaming, workflow, or relocating data to the cloud.

Speaker/bio

Jakub is an IT professional with 12 years of experience in Oracle world. Before joining Dbvisit he worked as developer, DBA and BI specialist for Energy Sector and Bank Industry in Prague, Czech Republic. Over the last years Jakub is focused on database physical and logical replication working for one of the Replication industry leaders.



Mike Donovan

Dbvisit Software

Chief Technological Officer

ENG

Level: Beginner


Oracle Database Event Streaming 101 - Unlock the Value of Your Data

Open source applications such as Apache's Kafka and NiFi are rapidly transforming the collection, integration and re-distribution of enterprise operational data, making this available as a continuous, real-time data stream for consumption by enterprise users. But alongside this a wealth of data remains hidden in our Oracle databases. So how can we turn the database inside out to make its valuable data readily available for consumption along with the other data sources in our enterprise? The key is the change data capture process, and using logical replication to generate a continuous stream of database events. In this presentation we will discuss these concepts, introduce Kafka/NiFi (with demo), show solutions and outline various use cases.


Speaker/bio

Mike joined Dbvisit back in 2007 and currently serves as their Chief Technology Officer. He is enthusiastic about new technologies and working with organisations to build new bridges between the existing RDBMS world and the new frontiers of Big Data. He is motivated by championing smart, cost-effective approaches and alternatives. He has a diverse background in technology and the arts, and considerable experience in technical customer support and software development. He is particularly passionate about Oracle database technology, having worked with it for more than a decade, spoken at numerous industry conferences, and spent time as a production DBA.


Jan Karremans

JK-Consult

Managing Consultant

ACE

ENG

Level: Intermediate


Migrating your Oracle database with almost zero downtime

In this presentation I will talk about why you would like to do a database migration, why the trouble to go through such a process. Based on this starting point is a definition of the migration objectives and why logical based replication is the way to go about such a project.

On-line database migration based on Dbvisit Replicate is a valid choice for many organizations. I will give an overview of the tool and the underlaying architecture. This will be complete by a demo of a logical replication case and some things to consider when you are working on this.


Speaker/bio

Jan started his IT career in a medical facility of the Royal Dutch Army in 1992 as an administrator on a Datapoint Mainframe. In 1994 the medical facility switched to using Oracle 7.1 on a Micro VAX 3100, which kicked of his career in Oracle. From 1998 Jan supported the development of a system for healthcare administration. Over the years Ecaris evolved to an APEX based solution.

In recent years Jan came in contact with Dbvisit from New Zealand. In 2011 he started working as a Business Development Manager for Dbvisit. Most recently Jan joined the German based company of Portrix as Director Operations ai. responsible for reorganizing the operations department.

Also Jan made his appearance as a regular speaker at Oracle User Groups around the world, with a debut at UKOUG_Tech13, including DOAG14 and OOW14. His work for the Oracle User Community was recently recognized with an Oracle ACE Associate award.


Kyle Hailey

Amazon

Product Manager

ACE Director

ENG

Level: Intermediate


Monitoring Database Performance in the Cloud

Monitoring database performance in the cloud poses unique challenges such as not only monitoring the database and host but also monitoring the hypervisor as well. The challenges are further complicated by the fact that Oracle DBAs are more and more expected to take on monitoring databases such as MySQL and Postgres. The presentation will go over an easy, automated way to monitor databases with a standard interface across Oracle, MySQL and Posgres in the cloud.


Speaker/bio

Kyle Hailey was the designer of Embarcadero Technology's DB Optimizer and a principal designer for the Oracle Enterprise Manager performance pages. He is a member of Oracle Oak Table, Oracle Ace Director, co-author of Oracle Insights: Tales of the Oak Table, and he was a technical editor of Oracle Wait Interface. He holds a patent in the area of database performance diagnosis and has been a speaker at Hotsos, NOCOUG, RMOUG, NYCOUG, and Oracle World; he also organizes Oaktable World during OOW. Kyle teaches classes around the world on Oracle performance tuning. Currently Kyle works on database performance monitoring at Amazon.


Robert Marz

Its-people GmbH

Technical Architect

ENG

Level: Intermediate


Taking Batch Scripting to the Next Level with SQLcl

SQLcl is ready to replace the reliable but somewhat outdated SQL*Plus as the new command line interface of the database pushing its capabilities to the state of the art.

The most exciting new feature of SQLcl is scripting: batch scripts can now be written in languages like JavaScript, Python or Perl.


 
Rest-db-links - access Oracle Databases in the Cloud using ORDS, REST & JSON

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 an process the JSON-Documents, finally a View and is built that can be used by the application developers.

A generator that produces all necessary objects will be shown. The generator can integrated into SQLDeveloper.

The presentation includes a live demo.

My session will follow this agenda:

• Advantages of stateless coupled systems via http.

• Introduction to REST, JSON and the standards for query and modifying data defined by oracle and other players.

• Accessing databases in the cloud using utl_http from PL/SQL

• The magic of the SQL json_table operator

• Hiding the complexity from developers with updateable views, table-functions and instead-of-triggers

• A Generator that produces all that stuff for you. The generator implements the oddgen-Interface and can be integrated into SQLDeveloper

• Compared with database links: pros, cons and performance

This is a real world use case for the ORDS autorest-Feature.

The source code will be released as open source and published on github.

The live demo will show the thing in action.


Speaker/bio

Robert Marz works as Senior Professional for its-people GmbH, a Germany based professional services company.

At customer sites he works as a senior technical architect with a database centric view of the world.

Robert is Portfolio Manager Database Technologies at its-people.

At DOAG (the the german oracle user group), he is in charge for the Cloud topics inside the database community.

Robert is a member of ODTUG.

More than twenty years of experience on custom development and data warehouse projects makes him a specialist in Oracle Database development and administration.

Additionally, he is skilled in the fields of scripting languages, operating systems, high availability and it-security.

Robert Marz publishes articles and papers in various publications, maintains the its-people portfolio blog and speaks frequently at mostly german conferences.

Robert.Marz@its-people.de

@RobbieDatabee

http://www.its-people.de/blog


Tim Hall

Oracle Base

DBA/Developer

ACE Director

ENG

Level: Intermediate



It's raining data! Oracle databases in the cloud

Wherever you turn someone is talking about cloud databases or database as a service (DBaaS). This presentation will show you how you can run your Oracle databases in the cloud using a variety of providers (Amazon Web Services, Microsoft Azure and Oracle Cloud) and discuss the pros and cons of these services compared to your on-premise installations.

Pluggable Databases - What they will break and why you should use them anyway!

The multitenant architecture was "the" headline feature announced in Oracle Database 12c. On the surface pluggable databases sounds great, but are they really? This presentation will explain the parts of your systems that will break if you move to pluggable databases, but why you should probably use them anyway.


Speaker/bio

Tim Hall is an Oracle DBA/Developer and well known Oracle blogger at https://oracle-base.com. If that isn't enough, he's written two books and over 700 articles, is an Oracle ACE Director, OakTable member and has presented at numerous user groups and conferences worldwide, as well as a series of 2-day presentations as part of the "Oracle University Celebrity Series".


Frits Hoogland

Accenture Enkitec Group

Principal Consultant

ACE Director

NL

Level: Expert


Drill down into the log writer inner working and communication to foreground processes

This presentation takes you along an investigation into the inner working of the logwriter. Traditionally, the log writer uses the semctl call to notify the foreground process its public log buffer contents are written. However, starting from Oracle 11.2.0.3, an alternative method exists, which is called ‘polling’. However, there is no official statement on what ‘polling’ means, and what it actually polls. This presentation is a hands-on investigation into the foreground polling mechanism, and takes the attendee through the logic steps of the investigation. A second purpose is to show alternative methods for investigating the inner working of the Oracle database.


Speaker/bio

Frits Hoogland is an IT professional specializing in Oracle database performance and internals. Frits frequently presents on Oracle technical topics at conferences around the world. In 2009 he received an Oracle ACE award from the Oracle Technology Network and a year later became an Oracle ACE Director. In 2010 he joined the OakTable Network. In addition to developing his Oracle expertise, Frits works with modern operating systems. Frits currently works at the Accenture Enkitec group.


Patrick Munne

Transfer Solutions

Oracle DBA

NL

Level: Senior

Oracle Cloud Infrastructure as a Service: Valkuilen en tips
Wie snel wil inspelen op veranderingen en kosten wil verlagen, zal overwegen om over te stappen naar de cloud. Zo’n overstap maak je niet van vandaag op morgen. Wij verwachten daarom dat veel bedrijven de komende jaren gebruik gaan maken van een hybride cloud omgeving als ‘best of both worlds’ of als onderdeel van de ‘roadmap to the future’.

Patrick Munne heeft de afgelopen periode verschillende klanten gemigreerd naar de Oracle Cloud en daarbij specifieke ervaring opgedaan met Infrastructure as a Service (IaaS). IaaS stelt u in staat om in de Oracle Cloud een virtuele server aan te maken met een operating systeem naar keuze en daar zelf op voort te bouwen.

In deze presentatie deelt hij de valkuilen en tips met u.

         · Wat zijn de manieren om een server aan te maken en waarop moet u letten?

         · Denk aan security of de manier van inrichting!

         · Wat zijn de verschillende soorten disken die gebruikt worden?

         · Wat verstaat men onder een Orchestration?

         · Wat zijn uitdagingen met firewalls en mailservers?

Patrick laat aan de hand van demo’s de verschillende werkzaamheden zien en stelt u daarmee in staat om snel met IaaS aan de slag te gaan.



Speaker/bio
Patrick Munne is ruim 10 jaar werkzaam bij Transfer Solutions als Senior Oracle DBA. Hij heeft ruime ervaring op het gebied van Oracle database 12c Release 2 en de Oracle Cloud.




Marco Gralike

eProseed

Principle Consultant

ACE Director

NL

Level: Intermediate


De Oracle 12.2 In-Memory Database en Ongestructureerde Data

De laatste Oracle 12.2 database versie is niet alleen veelzijdiger maar brengt verschillende technologien bij elkaar die het nu mogelijk maken om ook in de database effectief "big data" te bedrijven. De 12.2 In-Memory Column Store (In-Memory Expressions) in combinatie met de laatste JSON, XML of materialized view functionaliteit laat zien waarom Oracle, in mijn ogen terecht, deze betiteld als "document store".

De presentatie laat via uitgebreide voorbeelden, tips & trucks en ervaringen, zien wat er mogelijk is op basis van de 12.2 In-Memory DB functionaliteit op het gebied van database ins-and-outs, opslag, indexering, automatisering (wie is er niet lui), etc., als het gaat om het beheer en verwerking van ongestructureerde data in dit van oudsher relationele bolwerk.


Speaker/bio

Marco Gralike is een Oracle ACE Director/OakTable member, gespecialiseerd in ongestructureerde data in de database (JSON/XML) en databasebeheer / architectuur. Naast virtualisatie/cloud blijft toch vooral de nadruk op performance. Hij startte als database beheerder toen Oracle 6 nog hip was, maar ontwikkelde zich al snel door als OS admin, web server beheerder en ontwikkelaar. Naast de vele buitenlandse presentaties over de jaren, deelt hij zijn passie en kennis voor Oracle (performance) onder andere via zijn website (www.gralike.com) en via de verschillende Oracle fora.


Maja Veselica

Evoxera

Chief Technological Officer & Principal Consultant

ACE

ENG

Level: Beginner


Auditing in Oracle Database 12c R1 & R2

Unified Auditing is a new security feature in Oracle Database 12c. Its purpose is to:

• Consolidate all audit trails into single unified audit trail

• Simplify audit configuration

• Increase security of audit trail

• Improve audit performance

The aim of this presentation is to cover technical aspects of unified auditing and fine-grained auditing (FGA) in Oracle Database 12c R1 & R2.

In this session, you will learn how new audit architecture works and the following topics will be covered as well:

• Mixed auditing mode

• How to enable the unified auditing mode

• New audit roles

• Using Auditing in Multitenant environment

• Audit RMAN operations (for example: backup, restore and recover)

• Audit Oracle Data Pump operations

• Audit Oracle Database Vault violations

• Create audit policies to audit privileges, actions and roles under specified conditions

• How to disable and drop audit policies

• How to clean up audit data

• Using Fine-Grained Auditing


Speaker/bio

Maja has strong mathematical and computer science background. She has worked on various complex database environments. Areas of her expertise are security, performance/SQL tuning and high availability/disaster recovery of Oracle Database. She has been working as an instructor for Oracle University since 2010. In the last several years, she has also been working for Oracle Consulting. Recently, together with Zoran Pavlovic, she co-founded Evoxera - company that provides consulting and training services for Oracle Database technologies. Also, Maja is a co-author of Oracle Database 12c Security Cookbook, member of Organising Committee for Serbian Oracle User Group (SrOUG), Oracle ACE and has more than 20 Oracle certificates. She enjoys (beta) testing Oracle products and participating in other Oracle-related activities.


Ivica Arsov

Pythian

Senior Database Consultant

ACE Associate

ENG

Level: Intermediate


Parallel Execution in Oracle Database 12c

Many of us are facing with the problem of scanning lots of data. Daily growth of data becomes everyday problem and we are challenged to write SQL statements which need to scan millions of rows and run within minutes. This presentation will focus on parallel execution with Oracle Database 12c and how should you leverage its power. We will cover the concepts, what is parallel execution and how it works. You will learn the difference between traditional parallel execution and In-Memory parallel execution. We will cover different aspects of parallel execution, distribution methods, how to implement (monitor) parallel execution and how to effectively diagnose and trace.


Speaker/bio

Ivica is an Oracle Certified Master 12c and 11g, and a recognized member of the Oracle ACE Program as an Oracle ACE Associate. He is a blogger and active contributor to the Oracle community and presents at many technology conferences. Known for his deep Oracle expertise and ability to troubleshoot quickly and efficiently, Ivica has the skills to solve problems quickly regardless of size and complexity. He is passionate about database performance and stability.


EngSYS (Engineered Systems)

Lonneke Dikmans & Ronald van Luttikhuizen

EN


Provisioning?

Abstract appears when available.

Speaker/bio

Lonneke Dikmans is Chief Product Officer at eProseed en Oracle ACE Director op het gebied van Oracle Middleware. Ze heeft hands-on ervaring met proces modellering, web services, service oriented architecture, BPEL, IoT, mobiele applicatieontwikkeling, Oracle PaaS en domain driven design en traditionele JEE applicaties op verschillende platforms in een groot aantal verschillende branches.

Ronald van Luttikhuizen is country manager van eProseed NL en Oracle ACE Director op het gebied van Oracle Middleware. Hij heeft hands-on ervaring met integratie, web services, service oriented architecture, BPEL, Chef, Puppet, Oracle PaaS en traditionele JEE applicaties in verschillende branches.



René Kundersma

Oracle USA

Consulting Member of Technical Staff

EN

Level: intermediate


Oracle Exadata High Availability Secrets Explained: Direct from Development

In this session, you will learn how Exadata provides the highest levels of availability directly from Exadata Maximum Availability Architecture (MAA) development. Exadata high availability features will be explained, with particular emphasis on new features. The Exadata MAA best practice process will also be explained including the latest and greatest best practices and exachk improvements. After attending this session, it will be clear how this combination of world class technology and best practices supports the most stringent application service levels and data protection requirements.


Speaker/bio

René Kundersma is werkzaam als Consulting Member of Technical Staff in het MAA (Maximum Availability Architecture) team van Oracle Development (USA) waar hij werkt aan ontwikkeling, verbetering en validatie van Oracle Exadata en RDBMS software.

In 1999 studeert René af als Software Ingenieur en start later als consultant bij Oracle Consulting en is zodoende verantwoordelijk voor veel RAC implementaties in Nederland. Na de eerste implementatie van Exadata in Nederland (in 2009) gedaan te hebben stapt René over naar het Oracle development team omdat hij meer wil.

Zijn specialisme is de Oracle-infrastructuur en dan met name MAA voor de database. René is 9i, 10g en 11g Oracle Certified Master en spreekt vanuit zijn functie regelmatig op Oracle Open World.


Philippe Fierens, co-speaker Pieter van Puymbroeck

Exitas

Orcale DBA

ACE

ENG

Level: Intermediate


OVM on Exadata : Living in a virtual world

Virtualisation gains more a more ground. As a result of that one of our customers asked to implement of Oracle VM on Exadata. This session will discuss the project implementation, issue encountered ... It will answer following questions : What it is and what it is not? When could you use it? How does it work? How to install? How to patch? Which pitfalls and problems were encountered and how to solve them? How does it compare to other Engineered systems such as for example the Super Cluster? At the time of the conference the system we implemented will be in production for approximately 6 months, which will give us the opportunity to share a lot of information.


Speaker/bio

Philippe is an independent consultant, his client are mostly in the financial sector. The last last 4 years he has been working with engineered systems first Super Cluster then Exadata. He loves solaris. When he is not working he enjoys hiking with his family

Pieter Van Puymbroeck is an Oracle dba started in Oracle 9i. He worked mostly on short term projects which put him in touch with a lot of different aspects of the Oracle database, going from infrastructural point to complete designs and implementations, the result of this is a nice allround experience and a broad personal network. Currently the focus is on Exadata/ODA and virtualisation on exadata in a BI environment. Exadata experience starting from X2 to X5 including complete reinstallation’s and redesigns of the environment. His main focus is to help the customer to find the best solution fitting in his budget and offer the maximum out of it given restrictions. The bit of free time there is left, is mostly spent on being a dad for his son and sailing and playing the double bass, bass guitar and the saxophone. You can find him on twitter : @vanpupi”


Full Stack

Maarten Smeets, co-speaker Froukje van der Wulp

AMIS

Integration Consultant

ACE Associate

NL

Level: Beginner


Optimale Performance bij De Rechtspraak

Bij Spir-IT wordt hard gewerkt aan de digitalisering van De Rechtspraak. Hiervoor wordt onder andere Oracle Fusion Middleware (ADF, OSB, SOA, BPM) en WebCenter Content gebruikt. Het aantal zaken welke in productie draait, stijgt snel en er wordt grote groei verwacht. De performance van het systeem blijkt hierin een uitdaging. In deze presentatie zullen we vertellen over de organisatorische en technische uitdagingen die we zijn tegen gekomen en hoe we deze hebben opgelost. Dit omvat een stuk organisatie en aansturing van performancetesten, monitoren/meten van het gedrag van het systeem, analyseren van bottlenecks en deze vervolgens oppakken. Naast full stack performance verbeteringen op basis van best practices is ook op basis van gebruikersscenario’s specifiek gekeken naar waar verbetering mogelijk is. In deze presentatie zal de aanpak besproken worden en zullen de verbeteringen waar we het meest aan hebben gehad kort uiteen gezet worden. Deze presentatie is nuttig voor mensen die betrokken zijn in het optimaliseren van performance van Oracle Fusion Middleware en WebCenter, zowel op organisatorisch als technisch vlak.


Speaker/bio

Maarten Smeets is een ervaren integratie consultant van AMIS betrokken vanuit een DevOps team bij Performance verbeteringen.

Froukje van der Wulp is een ICT adviseur van Spir-it, de ICT organisatie van De Rechtspraak en betrokken bij de coördinatie van de verbeteringsacties.


IAM (Identity Access Management & Security)

Andrejs Prokopjevs

Pythian

Lead Oracle Applications Database Consultant

ENG

Level: Intermediate


Password Policies in Oracle Access Manager

This presentation is about how System Administrators and/or Oracle Apps DBAs can improve and meet user authentication security standards in Oracle E-Business Suite by using Oracle Access Manager integration and it's password policy management.

We will talk about:

- Current Oracle E-Business Suite password security limitations.

- Implementation of password policy management in Oracle Access Manager releases. Comparing the capabilities and why you should upgrade your OAM to the latest 11gR2.

- A use case example of most common configuration.

- Demo.


Oracle Unified Directory. Lessons learnt. Is it worth moving from OID?

This presentation covers a real life experience of implementing latest OUD 11gR2 integrated with Oracle E-Business Suite R12.2.5.

We will talk about:

- Introduction to OUD. What is different if we compare it with Oracle Internet Directory topology.

- Implementation process. Issues faced and what does not work out-of-the-box.

- Performance tuning considerations.


Speaker/bio

Oracle Apps DBA with a 13 years hands-on experience. Oracle Certified Professional. Joined Pythian 6 years ago and driving Oracle E-Business Suite / Fusion Middleware cluster tracks, team technical leader. Oracle technology conference public speaker.


Integration & Process

Jon Petter Hjulstad

Sysco AS

Department Manager

ACE Associate

ENG

Level: Intermediate


Experiences from SOA 12.2 implementations

This presentation will cover some of the experiences we have gotten from projects where we have migrated customers from version 11 or 12.1.3 to version 12.2 of SOA Suite / Service Bus. For many customers this is something which is on the to-do list for 2017 - and we will present our key tips we have for making the migration successful.


Speaker/bio

Jon Petter is Department Manager for Middleware at SYSCO, which has a team . of skilled Oracle Middleware experts, with a focus on Oracle SOA Suite, Weblogic, Oracle Service Bus, BPM Suite, BAM, Oracle Event Processing. He has worked with Oracle products since 1997, and has worked with some of the larger SOA customers in Norway. He is an Oracle ACE Associate.


Ralf Muller

Oracle

ENG


Case Management in Process Cloud
We briefly present the new Case Management functionality in Process Cloud followed by a demo of the Case Modeller in Composer and the Runtime and User Interface aspects of Case Management.



Robert van Mölken & Gertjan van het Hof

AMIS

ENG


Asset Monitoring in the Healthcare with Beacons and the IoT Cloud

In the Healthcare it is important to keep track of important assets like machines (Blood Pumps, AEDs, Ultrasound), commodities (wheelchairs, beds) and even high-risk patients. It's an essential enterprise task that facilitates hardware management, maintenance, regulatory compliance, and security. A asset management solution can save companies time, money, and lots of management headaches.

 


During this presentation I show the audience how we can connect the physical world to the web. Using beacons, sensors and LoRa to monitor and track assets and publish data to the Internet of Things Cloud Service. I demonstrate how, through multiple Node.js gateways, assets are registered, monitored and tracked inside and outside the hospital building.



Sandra Flores

Independent

SOA Architect

ACE Associate

ENG

Level: Intermediate


SOA, Microservices and Service Orientation: The Samurai Way

Bushido (???, "the way of the warrior") is a Japanese term for a way of life following the code of 7 principles which the Samurai were required to master in order to become a consummate diplomat.

Just as the Samurais do, we must be strongly committed with Service Orientation Principles to make our Service Oriented solutions coexist harmoniously, either SOA, Microservices or any other new way of dealing with a situation. In this session, we will go over all the surrounding concepts; What is SOA and Microservices all about? What are the Service Orientation Principles? and most importantly, how they relate to each other.

Learning objectives:

Gain insights into Service Orientation Principles that will guide you to make better decisions in your Service Oriented Solutions, understand the main differences between SOA and Microservices, and find out if your idea about Microservices faithfully follows these principles. Are you ready to be a Services Samurai?


Speakers/bio

Sandra is a SOA Architect working in México City as an independent professional. In her role, she has been mainly envolved in several SOA and Java implementations with more than 12 years of experience delivering IT projects. She is also an Oracle ACE Associate and a regular speaker at various IT conferences in different countries. Sandra is a certified trainer for Arcitura SOA School, and she also has several technical certifications in her areas of expertise. Her contribution to the community is in form of her personal blog, OTN articles in Spanish and English, webinars, videos, and as a member of ORAMEX (México Oracle Users Group) she’s envolved in the group’s events and activities.


Piet de Visser

PDVBV

DBA, Troubleshooter, Architect

ACE

ENG


Consolidation on Exadata or cloud, this time we do it Right

Management-decisions, Hardware-reality and intended cost-savings forced us to concentrate many databases on a small number of (old-ish) Exadata machines. The presentation will describe the challenges we faced during migration and in operations. We will indicate the success-factors and challenges for consolidation, and point out fixes and alternatives.

The attendee will learn how to do sensible "consolidations", and how to avoid problems.


Speaker/bio

Piet is an experienced Database Consultant and DBA specializing in Oracle databases,

High-Availability and troubleshooting.

He is in IT since 1987, works with Oracle databases since 1994.

Independent since 2013, he now looks for short-term or part-time consulting assignments.

Piet combines technical knowledge with experience in global organizations.

His energetic personality, curiosity and language-skills make him ideal for pioneering projects or troubleshooting IT problems in a multi-national environment.

Piet also invests a lot of effort in maintaining a network of Like-Minded Oracle specialists worldwide

and is a regular speaker at international user group events and symposia.

Oh, and Piet has a preference for Simple solutions.



Lonneke Dikmans & Ronald van Luttikhuizen

Architecten en integratie specialisten houden vaak verhitte debatten…

Architecten en integratie specialisten houden vaak verhitte debatten over het gebruik van de SOA Suite (BPEL) versus de Oracle Service Bus. Met de release van producten in Oracle PaaS (Integration Cloud Service, SOA Suite Cloud Service). In deze sessie worden de verschillende integratie opties (ODI, SOA Suite, OSB, ICS, SOA CS met elkaar vergeleken). Deze vergelijkingen worden geïllustreerd met voorbeelden uit de praktijk.


Speaker/bio

Lonneke Dikmans is Chief Product Officer at eProseed en Oracle ACE Director op het gebied van Oracle Middleware. Ze heeft hands-on ervaring met proces modellering, web services, service oriented architecture, BPEL, IoT, mobiele applicatieontwikkeling, Oracle PaaS en domain driven design en traditionele JEE applicaties op verschillende platforms in een groot aantal verschillende branches.

Ronald van Luttikhuizen is country manager van eProseed NL en Oracle ACE Director op het gebied van Oracle Middleware. Hij heeft hands-on ervaring met integratie, web services, service oriented architecture, BPEL, Chef, Puppet, Oracle PaaS en traditionele JEE applicaties in verschillende branches.




Mario Sosic

The Future Group

SOA/J2EE Consultant

ENG

Level: Expert


Apache Kafka based event bus solution & integration with Oracle Service Bus 12c

Business Event Bus is a middleware solution in the heart of an event driven architecture. Event-driven architecture complements Rabobank’s service-oriented architecture (SOA) because services can be activated by triggers fired on incoming events. Building applications around the Business Event Bus allows these applications to be constructed in a manner that facilitates responsiveness, because event-driven systems are, by design, capable of dealing with unpredictable and asynchronous environments.


Speakers/bio

Java developer since 2004. Oracle Fusion Middleware consultant since 2008.


 


Luc Gorissen

AMIS

Solution Architect

ENG

Level: Expert

Fault Handling in ACM/BPM implementations

Often, Fault Handling in middleware implementations is a 'last minute effort'. The implementation is designed and the implementation project is rushing towards its first go-live date. Often reinforced by a scrum approach combined with too much focus on business functionality. And consequently, too little attention for non-functionals like fault handling. As a last-minute effort, fault policies are implemented, only to discover later on that this is not sufficient.

This presentation gives a more structured approach towards implementing fault handling for ACM/BPM systems. That approach will be based on 4 ingredients:

- fault categories: what different fault types are distinguished

- organization structure: what organization parts play a role in fault handling

- application structure: what are the different parts of the ACM/BPM system

- system management tooling: what management / monitoring tooling is to be used

Based on these ingredients, a structured approach is outlined for designing and implementing Fault Handling.


Speaker/bio

Luc Gorissen works in IT since 1990. He has held various positions in many areas, and works since 2006 with Oracle Middleware. He likes the challenge of introducing new technologies in large companies. In the last couple of years, Business Process Management and Case Management are his main focus areas. 

 

Xander van Rooijen

PCS Case Management
Abstract will appear when available


Léon Smiers, co-speaker Jan-Willem van Doornspeek

Capegmini

Oracle Solutions Architect

ACE

ENG

Level: Intermediate


Chatbots as a new channel in case management interactions

Case management processes, such as police investigations and insurance claim handling are driven by communication between and with all stakeholders. Even though the case is driven by formal activities, tapping information form informal communication can lead to a better outcome of the case. Oracle is bringing Chatbots as a new cloud offering to the market, and is already showing potential for improvement of case interactions. We are testing a precursor of the Oracle Chatbot cloud for the Police and investigating how the conversations can be tapped into Police investigations.


Speaker/bio

Léon Smiers works as a Solution Architect for Capgemini The Netherlands in the area of Oracle Technology and Architecture, where he is one of the leading Oracle specialists. He has done a lot of work and research in the field of Integration and new technologies and architectures, like SOA, BPM, Case Management, RFID, Cloud and chatbots, on which he wrote articles and presented on international conferences. Furthermore he successfully published ‘Oracle Case Management Solutions’ and the CORE mode - an IT Application Reference Architecture'.


Ronald van Luttikhuizen

eProseed

Country manager NL

ACE Director

NL/ENG

Level: Intermediate


Microservices and Canonical Data Models: Friends or Foes?

SOA implementations frequently relied on Canonical Data Models (CDM) to provide a standardized data and message model for all service interfaces.

With the rise of architectures based on Microservices, the general view towards CDMs has changed: hass a Canonical Data Model now become an anti-pattern instead of best-practice?

In this session we will explore the impact that microservices and REST/JSON have on CDMs, discuss meaningful patterns around (canonical) data models in Microservice- and SOA-architectures and answer the question whether a canonical data model has value in a Microservice-based architecture and how it can be implemented.

(Presentation can be in Dutch or English.)

Speaker/bio

Ronald is a consultant and managing partner at eProseed NL. He has experience in IT in various roles such as coach, architect, (lead) designer/developer, analyst, and team lead. Ronald currently focuses on information and solution architecture in SOA and BPM environments. Ronald is a frequent blogger, author and presenter at national and international conferences. Ronald is Oracle ACE Director for Middleware & SOA.


Pedro Gabriel

Link Consulting

Senior Consultant

ENG

Level: Expert


Migration from Oracle Worflow to Oracle BPM 12c

We have successfully migrated an entire Oracle Workflow solution of 900 processes to just 90 Oracle BPM 12c processes. In order to accomplish this achievement we followed quite a few important steps. First we tried to comprehend customer goals for this migration. Then we analyzed every single Oracle Workflow process to find feasible patterns among them. During this analysis we catalogued processes input parameters, processes and human tasks payloads and other relevant information for future implementation. As result a full document of their processes was built and delivered, something that did not exist before. After this preparation we jumped to architecture implementation, by defining naming conventions, common schemas, reusable processes, domain partitions to be created based on processes business areas, etc. Implementation lead us to quite a few interesting challenges since we had to integrate Oracle BPM processes with their own front-end. For instance (1) How to initiate BPM processes? (2) How to submit human tasks? (3) How to store human tasks data inside customer’s business database? (4) How to “reopen” a process? This last question proved to be of great importance for our customer since it is possible to reopen processes on Oracle Workflow but not on Oracle BPM.

Having customer involved in all migration phases was important and profitable to increase satisfaction and understanding of the challenges involved on requirements. Plan first develop after and develop once reuse often was always our motto behind of all our work.

For security reasons and secrecy we cannot reveal our customer identity but we can say that current solution is implemented and used by our customer host country.


Speaker/bio
Pedro Gabriel is an Oracle BPM and ADF Senior Consultant. He is responsible for developing and architecturing BPM and ADF solutions worldwide. He has written “ADF Runtime Interface Generator for BPM Human Tasks” OTN article as well as several other blog articles. He has spread his knowledge to other Oracle technologies and is certified in Oracle 11g and 12c.


Robert van Mölken

AMIS

Senior Integration Specialist

ACE

eng

Level: Intermediate


Blockchain on the Oracle Cloud, the next big thing

What is Blockchain? Is it ‘just another’ buzzword or is it ‘the next big thing?’ In this presentation I will discuss the world of Blockchain. What is it exactly, and how shall it change the world and what are the practical usages? During this presentation we discuss, by showing a practical demo, how an enterprise Blockchain can be used in combination with the Oracle Container Cloud. The audience will get a general picture of Blockchain and a possibility to start building their own.


Speaker/bio

Robert van Mölken is a highly experienced Senior Integration Consultant and in 2016 received the title of Oracle ACE (ACE promoted from Associate) in the field of Fusion Middleware & SOA. He has over 9 years of experience with Oracle's SOA Suite and Service Bus. His focus is on the design and construction of service-oriented business processes using SOA Suite 12c.

In recent times, his focus shifted to Cloud, he began to specialize in different Cloud services from Oracle. In the last year, Robert has broaden his knowledge on Oracle Integration Cloud Service, SOA Cloud Service, Database Cloud Service, Developer Cloud Service, Mobile Cloud Services and Application Container Cloud Service. He is an expert in Oracle Integration Cloud Service and in 2016 he wrote a book about this called "Implementing Oracle Integration Cloud Service" which is published by Packt Publishing.

In addition to Cloud, he invests his time in the developing Internet of Things solutions, where he focuses on developing standard solutions for Asset Monitoring, Track & Trace and Hospitality. These solutions mainly use open source languages such as Javascript (Node.js), Python and Java.

Robert is a speaker at international conferences and is a frequent blogger on the AMIS Technology blog, the Oracle Technology Network, and participates in OTN ArchBeat Podcasts. Robert is one of the two SOA/BPM SIG leads for the Dutch Oracle User Group (OGh) and organizes these meetups. He also works closely with the SOA Oracle Product Management team by participating in the Beta programs (e.g. SOA Suite, Integration Cloud, API Platform Cloud).


Oracle Web/Integration

Frank Nimphius

Rise of the Bots. Intelligent Chatbots for the Enterprise

GREETINGS PROFESSOR FALKEN“ is the opening in a conversation between computer “Joshua” and its inventor, Dr. Stephen Falken, in the movie “War Games”, released in 1983. In the movie, artificial intelligence is used to enable man to machine conversation. Only a bit more than 30 years later, conversational interfaces are becoming reality in mobile computing, ready to be the next big thing in consumer and enterprise mobile application development. Paired with artificial intelligence, chat bots help to simplify the mobile communication between users and services. Like in human conversation, well chosen wordings allow users to book a table in a restaurant, approve a purchase order, buy an airline ticket, transfer money from your bank - the use cases are almost limitless. And the good thing about this is that there is no need to download and install a mobile application as you can use your favourite messenger from Facebook, WeChat, Slack to name a few.
This conference session explores the enterprise use case for chat bots in mobile, looks at architecture, and explains how chat bots work.

 


Niall Commiskey


Oracle

ENG


Integration and Process automation powered by the Oracle Cloud

Cloud adoption has brought new and interesting challenges. The most important one of course is integration to existing applications and assets, which may be running on a private data center or other clouds. In a significant number of situations, there is need to extend cloud and SaaS application logic, deliver workflow automation. In this session you will learn about innovation from Oracle to deliver integration and rich process automation capabilities with API Platform Cloud Service, Integration and Process Cloud Service.


Speaker/bio

Niall Commiskey is the Director of iPaaS Product Management at Oracle EMEA.



PL/SQL & SQL

Oren Nakdimon

DB Oriented

Database Architect/Developer DBA

ACE

ENG

Level: Beginner


Write Less (Code) with More (Oracle 12c New Features)

Oracle 12c introduced many new features that allow us developers to write less code than in previous releases, and become more efficient and productive.

Some features, such as Row Limiting and Lateral Inline Views, enhance the SQL language, so SQL statements can become much shorter and more readable than before.

Other features, such as Temporal Validity and In-Database Archiving, offer built-in functionality that previously had to be implemented by the application.

Attend this session to learn about several of these new features, and see many useful examples.


Speaker/bio

Oren Nakdimon is an Oracle Ace with more than 20 years of extensive and continuous experience with Oracle-based systems, as a developer, DBA, manager and instructor. Oren gained lots of knowledge about databases in general, and Oracle in particular, and likes sharing it - by blogging (http://db-oriented.com), tweeting (@DBoriented), presenting in local and international conferences, and more. He believes in good collaboration between developers and DBAs, and tries to bridge the traditional gaps between these two worlds. He is also a board member of ilOUG (the Israeli Oracle User Group). Since 2012 Oren is responsible for the database development and administration in Moovit.


Erik van Roon

EvROCS

Consultant/Developer

ENG

Level: Intermediate

Handling Errors during bulk DML operations
Using bulk operations to do dml from plsql is a lot faster than processing row by row.
However, during bulk dml some or all records may not be successfully created, modified or deleted.
This presentation will be about some of the pitfalls in handling these errors using "save exception".
Why is error_index a misleading name for that column in sql%bulk_exceptions? And how do you overcome the implications?
What if a record fails halfway through multiple consecutive bulk operations on relationally dependent tables?
Can log_errors be used as an alternative to using "save exceptions"?
You will be given the answers to these and more questions and hopefully gain a better understanding of how to deal with errors in bulk operations.

Speaker/bio

Erik van Roon is an Oracle Developer who has worked with Oracle technology since 1995, specializing in, but not limiting to, SQL and PLSQL.

Since 2009 he is self-employed. His company is called EvROCS.

Prior to that he has worked for several consulting companies in the Netherlands.

He has worked on major projects for several clients in industries like entertainment, banking and energy, working with the ‘classic’ Oracle tools Designer, Forms, Reports, and off course SQL and PLSQL..

Erik has been the technical lead of multiple successful high impact data-migration projects moving and transforming large amounts of data.

Since 2012 every year Erik builds and makes available the ero$kscope_sessions package that allows you to *query* the presentations on that years KScope site

Erik has had the pleasure of being a speaker at ODTUG's KScope and the Polish conference by POUG.

In 2015 Erik was nominated and selected to be a finalist in the SQL category of OTN Developers Choice Awards.


Chris Saxon

Oracle

Developer Advocate for SQL

ENG

Level: Intermediate


SQL Magic! Tricks to Show SQL Features You've Probably Never Used

In this fun session you’ll see SQL used in new and exciting ways. Chris will perform SQL "magic tricks" including:

Sawing the Query in Half: starting with a normal query, Chris will split it into smaller and smaller chunks that somehow all give the same result!

Find the Card: After getting an audience member to choose a "card" (row) from a "deck" (table), Chris will find it by making it float to the top of the table.

The Magically Changing Data Type: watch as a number changes to a date and back again!

But unlike real magicians, he'll show you how the tricks work. This will enable you to perform your own "SQL magic” and build better Oracle Database applications.

This session is for developers and DBAs looking to expand their SQL skills. It highlights features that are new to 12c as well as little used existing options.

Speaker/bio

Chris Saxon is an Oracle Developer Advocate for SQL. His job is to help you get the best out of the Oracle Database and have fun with SQL!

To help you with this he blogs at All Things SQL. He also creates videos combining SQL and magic on YouTube at the The Magic of SQL.

If you have questions about working with Oracle Database technology, please reach out to him. You can do this via Twitter or on Ask Tom.


Alex Nuijten

AllApex

Developer

ACE Director

ENG

Level: Beginner


Regular Expressions: Say What?

It has been possible since Oracle database release 10, Regular Expression support with its own set of functions. But getting started with Regular Expressions is not easy. Most database developers would avoid them if at all possible.

With current release of the Oracle database, Regular Expression syntax becomes more important. You can use them to redact data with DBMS_REDACT and to search for patterns using the Match_Recognize clause.

This session covers the basic syntax and gives you an easy introduction with Regular Expressions with plenty of code samples.


Speaker/bio

Alex Nuijten is an independent consultant (allAPEX), specializing in Oracle database development with PL/SQL and Oracle Application Express (APEX) and member of the Smart4APEX Guild.

Besides his consultancy work, he conducts training classes, mainly in APEX, SQL and PL/SQL. Alex has been a speaker at numerous international conferences, such as ODTUG, Oracle Open World, UKOUG, IOUG, OUGF, BGOUG, OGH APEX World and OBUG. For his presentations, Alex received several Best Speaker awards.

He wrote many articles in Oracle related magazines, and at regular intervals he writes about Oracle Application Express and Oracle database development on his blog "Notes on Oracle" (nuijten.blogspot.com). Alex is co-author of the following books “Oracle APEX Best Practices” (published by Packt Publishers) and “Real World SQL and PL/SQL” (published by Oracle Press).

Because of his contributions to the Oracle community, Alex was awarded the Oracle ACE Director membership in August 2010.



Toon Koppelaars

Oracle

Consulting Member of Technical Staff

NL

Level: Intermediate


 
The Database: Processing Engine, or Persistence Layer

In this presentation we'll first go through a bit of history demonstrating how the database has been used in the past 30 years: at times it was a processing engine, and at other times it was just a persistence layer. Having witnessed many application development projects, we are convinced that the database ought to be used as a processing engine. The persistence layer approach, where all business logic is implemented outside the database has serious drawbacks in the areas of initial application development, ongoing maintenance, and most notably in the area of performance and scalability. We'll discuss these drawbacks, in particular the last one: we'll debunk once and for all that moving business logic out of the database benefits performance and scalability. Finally we'll provide an overview of how to use the database as a processing engine, rehearse the reasons for its superiority, and describe how to adopt it. We formalize a layered code classification scheme which leads to optimal understandability and maintainability of both your PL/SQL and your SQL code.


Speaker/bio

Toon has been part of the Oracle eco-system since 1987. He is currently a member of Oracle's Real World Performance team. The RWP-team troubleshoots application performance issues in and around the DBMS. The way applications currently use (or rather, abuse) the DBMS, is often at the root of these performance issues. Prior to joining the RWP team, Toon has been mainly involved in database application development. His special interests are: architecting applications for performance and scalability, database design, and business rules / constraints modelling. He is a long-time champion of the Thick Database paradigm.


Patrick Barel

AMIS

Senior Oracle Developer

ACE

ENG

Level: Beginner


Get your money’s worth out of your Database

The database is one of the most important assets to your application. Besides being one of the most important assets it is also one of the most expensive parts in your application. Most organizations don’t get the most out of their database license and treat it like a simple bit bucket. The modern Oracle database can do so much more than just store data. Features you can use ‘in the database’ include:

- Flashback queries (what did my data look like at a certain moment in time)

- Data Security (only read and write data you are authorized for)

- Performance increase (Set based operations, regular expressions, analytics)

- EBR (near zero downtime application upgrades or support for parallel database worlds)

 

- Data integrity/quality (Single Point Of Data Integrity)

- Special SQL features like paginating your result.

This presentation will show these features as well as some of the enhancements in the Oracle 12c Database including:

- Identity columns (12c)

- Invisible columns (12c)

- Whitelisting PL/SQL program units (12c)

- Improvement of execution of PL/SQL in a SQL query (12c)

- Cross session Result cache (both SQL and PL/SQL) (11g)


Speakers/bio

Patrick Barel is a PL/SQL Developer for AMIS [http://www.amis.nl/] in the Netherlands. Besides working with SQL and PL/SQL did he co-develop CodeGen [http://codegen.inside.quest.com/] and wrote different plug-ins [http://bar-solutions.com/] for PL/SQL Developer [http://www.allroundautomations.com/]. He publishes articles on the AMIS Technology blog [http://technology.amis.nl/blog] and on his own blog [http://blog.bar-solutions.com/].

In 2015 he received the Oracle Developer Choice Award in the PL/SQL Category.


Alan Arentsen

Ordina

Oracle Developer

ENG

Level: Intermediate


Deploying PL/SQL applications, building Rome in a day

All roads lead to Rome but some roads just are more comfortable than others. I found a really nice road to ride when it comes to deploying PL/SQL and APEX applications.

Windows users use an MSI-file to install their applications, Apple users use their own packages. But what do PL/SQL users do? Usually they export stuff from the database and fabricate some kind of installer procedure.

How nice would it be if you just click 'install' and your application will be deployed? Or is this too good to be true? I don't think so!

If you follow the right procedures during the development process, this installation process could be the smoothest way. In this session I will show you my way to Rome.

And... I will even let you peek inside my PL/SQL installer.


Speaker/bio

Alan Arentsen is an Oracle APEX developer with experience on a wide spectrum. He has done everything between installations and development in PL/SQL and APEX.

Alan has been developing applications in Java, C++, and various scripting tools since 1998. Since he met APEX, his enthusiasm has grown.

So far he has presented on te following conferences: DOAG2014, APEX World 2015, KScope15, SIOUG15, DOAG 2015, OpenWorld2015, APEX World 2016, OUGN16, AMIS 25 BEYOND THE HORIZON, KScope16, DOAG2016 and UKOUG Tech16.


Soham Dasgupta

Capgemini Netherlands B.V.

Senior Consultant

ENG

Level: Beginner


No-Java Enterprise Application

How we can have an enterprise level fully JavaScript based application with OracleJET and NodeJS using Oracle Cloud Services.


Considering a use case of a "Lease a Car" application, will explain how to do :

1. Build & Deploy

2. Unit testing

3. Entity definition

4. Business logic implementation

5. User authentication

6. Session Management

7. Database communication

8. etc.

Showcasing how we can use JavaScript for typical Enterprise application requirements/features for which we mostly require Java or Java based framework.

Speaker/bio

Experienced UI developer on ADF, Java and JavaScript. Working with Oracle Technologies since 2006. Worked in Accenture, Oracle and joined Capgemini Netherlands on 2014. Maintain a personal blog on my personal technolgical views (http://adfjava.blogspot.in/).

Worked with Android Studio, Ionic Framework, MAF, OracleJET, NodeJS, AngularJS,Oracle Mobile Cloud Service, Oracle Application Container Cloud Service, Oracle Database Cloud Service, Oracle Java Cloud Service.

More info on LinkedIn : https://nl.linkedin.com/in/soham-dasgupta-91b75410


Zoran Pavlovic

Evoxera

CEO & Principal Consultant

ACE

ENG

Level: Beginner


Introduction to SQL Tuning

This mini course session will explain basic techniques of SQL Tuning in Oracle Database 12c. You will learn:

* Basics of Cost-based optimizer;

* How optimizer chooses execution plan;

* Common mistakes and how to avoid them;

* Basic techniques to influence Oracle Optimizer and ways to evade degradation of performance by fixing good execution plans.


Speaker/bio

Zoran has worked on various complex database environments including RAC, ASM, Data Guard, GoldenGate, etc. He has been actively engaged in beta testing Oracle Database 12c Release 2. Zoran has been working as an Oracle Consultant for more than 10 years. He has been working mostly for major clients in financial, telecom and public sector in EMEA region. Recently, together with Maja Veselica, he co-founded Evoxera - company that provides consulting and training services for Oracle Database technologies. Areas of his expertise are security, performance/SQL tuning and high availabilty/disaster recovery of Oracle Database. Zoran has been working as an instructor for Oracle University since 2010 and during that time he has trained more than 250 students in Europe. In the last couple of years, Zoran has also been working on projects for Oracle Consulting. He is an Oracle ACE, co-author of Oracle Database 12c Security Cookbook and member of Organising Committee of Serbian Oracle user Group (SrOUG). As an active member of Oracle community, Zoran delivered more than 40 technical presentations at conferences around the world. He has been featured speaker/author at many conferences/magazines.


Web & Mobile

Eric van Mourik, co-speaker Robbert Tjoa

Darwin IT-Professionals B.V.

Senior Consultant

NL

Level: Intermediate


Ervaringen met het inpassen van Oracle's recente UI-inzichten en -principes in een Forms-to-ADF migratie-traject

Het migreren van een Forms applicatie naar ADF is niet uniek. Maar wat zijn de gevolgen als tijdens het project besloten wordt om Oracle's recente UI-inzichten en -patronen als "Alta UI", "Simplified UI" en de "Applications Cloud User Experience Rapid Development Kit" te omarmen?

Het Ministerie van Financiën heeft een Forms applicatie voor het beheer van de cijfers die jaarlijks resulteren in de Miljoenennota. Afgelopen jaar is een project gestart om deze te migreren naar ADF 12c. Hoewel het oorspronkelijke verwachtingspatroon een eenvoudige "technische" 1-op-1 migratie was, is tijdens het project besloten om de voornoemde UI-principes in te passen.

We bespreken de gevolgen van die keuze. Wat was de impact op het project? Welke (extra) eisen stelt het aan ontwerpers, ontwikkelaars en stakeholders? Zijn door Oracle gepropagandeerde patronen als "Glance, scan, commit" daadwerkelijk toepasbaar op een boekhoudkundig systeem? Hoe relevant zijn aspecten als mobility en multi-device ondersteuning in de dagelijkse praktijk? Wat betekent het gebruik van de Applications Cloud UX RDK voor de productiviteit? Welke aanpassingen hebben we op de RDK moeten doen? En - last but not least - hoe ervaren gebruikers die vele jaren met een traditionele CRUD-applicatie hebben gewerkt dit alles?

We hopen heldere, op onze praktijk-ervaringen gebaseerde antwoorden te kunnen geven op bovenstaande en andere vragen.


Speaker/bio

Eric van Mourik is een zeer ervaren Oracle-professional. Hij richt zich op ‘state-of-the-art’ systeemontwikkeling in een Oracle-setting als lead-developer en software architect. Hij is o.a. gecertificeerd als ‘Oracle Application Development Framework 12c Certified Implementation Specialist’ en ‘Oracle SOA Suite 11g Certified Implementation Specialist’.


Geertjan Wielenga

Oracle

Product Manager

ENG

Level: Intermediate


Mobile Development in JavaScript with Oracle JET

Oracle JET is a new, free, and open source toolkit by Oracle for developing JavaScript applications. Quite a lot of people have already been introduced to its features for web development. In this session, the focus will be on mobile development. You will be introduced to the full mobile development cycle, both for browser-based mobile development as well as hybrid mobile development via Cordova/Phonegap. Come and see how easily you can get started creating mobile applications supporting responsive design and single page application architectures with Alta UI and data visualization components via Oracle JET!


Speaker/bio

Geertjan is an Oracle product manager for Oracle JET.


Marcel Oldenkamp & Niels Gorter
ENG

 
Java 8 – “Streaming” into the future with “Lambda” power
The Java programming language has been around for ages, well maybe not ages but at least since 1995, and it is safe to say that it has long since evolved into a widely adopted and very powerful language. Most people (who are not us) are blissfully unaware of how java powers our day-to-day lives, from mobile phones, tablet, games, navigation systems to e-business solutions. Java is everywhere, it is the building block of many Fusion Middleware products, and mastering its skills is always an excellent thing to have on your resume.

This session is all about the latest Java release, Java 8. You will learn its exciting new features by means of practical examples and live code demonstrations. Starting with the new language addition “Lambda Expression”. Although at first glance some may find the notation ‘obscure’ or flat out unreadable, we will show its true power and shine a light on the Lambda syntax and practical applications. Then we move on to demonstrating the Streams API, where data processing gets a whole new meaning. We will show that filtering and transforming data in collections has never been this easy or this fast compared to previous Java versions. Other worthy features like “Default methods” and “compact profiles” also make an appearance.

Last but not least, we mix it up with Java8 and ADF since JDeveloper & ADF 12c (12.1.3.0.0) offers Java SE 8 support (with certain restrictions).

Although some java knowledge is preferred, anyone is invited (even encouraged) to join our session. 

Duncan Mills
Oracle

Senior Director

ENG


An Introduction to Application Builder Cloud Service

Within the Oracle Developer ecosystem there has always been room for a variety of development tools for a whole range of languages and developer types. The latest of these is the exciting new low-code solution Application Builder Cloud Service (ABCS) . ABCS is aimed squarely to meet the needs of citizen developers and business users, enabling them to either build new point solutions or extend existing SaaS products with custom functionality. In this demo lead session you’ll see how easy it is for anyone to pick up and use these cloud based tools to deliver both web and mobile UIs with zero or minimal coding.


Application Builder Cloud Service - Beyond The Basics
Application Builder Cloud Service (ABCS) is Oracles development environment aimed at Business Users and so called citizen developers. However, as a software professional, don’t be put off by its "low-code" label. Just because ABCS allows you to do so much without having to write code does not mean that you can’t use your skills to the full when working with it! In this session I’ll be looking at ABCS through the eyes of a typical JavaScript developer, showing how your existing skills can take ABCS to the next level by exploring topics such as custom component creation and custom business service integration. With these skills you can elevate ABCS to a tool that exactly fits the needs of your organization.

 




Mia Urman

Aura Player

CEO

ACE Director

ENG

Level: Beginner


Migration, Hibernation, or in the Cloud—Where to Go with your Oracle Forms

If you’re an Oracle Forms user, you must be stuck at a crossroad: Should you migrate your Oracle Forms systems to new technologies, hibernate and do nothing hoping that these systems will not fail in the future, or start thinking about the next generation of the existing system with Forms 12c, and modernize existing applications to the Cloud. In this session, Mia Urman will go over the various options, the cost and the benefits analysis of each of the options and the factors to consider for each one of them. This discussion will help Oracle Forms customers get their head around next generation challenges and plan out their future strategy. It will include a short presentation of the current options followed by questions and concerns from attendees to guide the OGH Tech 17 community on location.



Oracle Forms & Mobile? We did it...so can You!

Back-office? Is there still such a thing? Mobile isn't just a "nice to have" – it’s the expectation of a generation of employees and customers. So is your Oracle Forms system keeping up? Your legacy systems contain vital information that drives your company's business decisions making sure that information is available to the people who need it – at any location, any time and on any device. This should be IT's number one priority. In this session, we will discuss how you can modernize your existing Forms applications to mobile WITHOUT redevelopment, and without writing a single line of code.. We will then go through a customer's case study on how their Oracle Forms system was elevated to mobile whilst the existing Forms application ran in parallel completely untouched. This session is for anyone who wants to begin their mobile journey but does not know how to begin.


Speaker/bio

Mia Urman is an Oracle ACE Director and a world-renounced expert in Oracle technologies, with over 17 years’ experience presenting, supporting, training and consulting Oracle products. Most recently she won the innovation award of the Oracle developer user group for "Innovative Use of Oracle Development Tools". In her 7 years at Oracle, she was a senior support analyst and product manager of Oracle Developer Suite, Jdeveloper and IAS technologies, as well as the lead on the topics of Oracle Forms modernization and ADF/Java development.While providing consulting services to customers, Ms. Urman became intimately familiar with some of the leading challenges facing Oracle Forms/EBS clients and co-founded AuraPlayer Ltd., (formerly OraPlayer), a cutting-edge technology company offering solutions to extend and modernize Oracle Forms and EBS as Webservice to mobile/web. She currently serves as AuraPlayer's CEO.Ms. Urman is a sought after presenter on Oracle technologies at various conferences including Oracle OpenWorld, IOUG Collaborate, ODTUG Kscope, UKOUG, DOAG and keynote speaker at many local Oracle Technology events. She has also served as a director on the board of the Oracle Developer technology user group and lead their global initiatives.

 



Ronald van Luttikhuizen & Luc Bors

eProseed


 
Development with Oracle Open Source Products: Not just JET

In one of our projects we developed a multitenant solution that was completely based on Oracle open source products. In this session you will learn how, in this real life project, we used Glassfish, MySQL, EclipseLink and Oracle's JavaScript Extension Toolkit (JET) to build a multitenant application. You will not only get insight in the application architecture, but you will also learn about the tools we used. You will get valuable tips and tricks and learn about the pitfalls that we encountered during the implementation of this solution.

(Presentation can be in Dutch or English.)


Speaker/bio

Ronald is a consultant and managing partner at eProseed NL. He has experience in IT in various roles such as coach, architect, (lead) designer/developer, analyst, and team lead. Ronald currently focuses on information and solution architecture in SOA and BPM environments. Ronald is a frequent blogger, author and presenter at national and international conferences. Ronald is Oracle ACE Director for Middleware & SOA.


Grant Ronald

Oracle

Director of Product Management

ENG


Building Mobile Apps in the Cloud
Mobile applications have become a bit of buzz. Businesses want them, but someone in IT has to build them and in many cases that means new skills, multi-platform development effort and the maintenance and management headache of 3rd party platform SDKs such as Android Studio and XCode. Great if you are a code ninja, less good if the business just needs to be in the mobile ballpark. But what if mobile development was as simple as assembling data aware pages based around easily defined and managed REST services. No code, no IDE, no installation, no mobile platform skills. This presentation and demo shows how mobile development has discovered a new option: the simple way by using the cloud to build mobile applications.



Lonneke Dikmans

NL


Abstract will appear when available


Speaker/bio

Lonneke Dikmans is Chief Product Officer at eProseed en Oracle ACE Director op het gebied van Oracle Middleware. Ze heeft hands-on ervaring met proces modellering, web services, service oriented architecture, BPEL, IoT, mobiele applicatieontwikkeling, Oracle PaaS en domain driven design en traditionele JEE applicaties op verschillende platforms in een groot aantal verschillende branches.



Frank Houweling, co-speaker Richard Olrichs

AMIS

Senior Java Developer

NL

Level: Intermediate


Case Study: Instrumenting, Analyzing, & Tuning the Performance of Oracle ADF Applications

In this session a case study will be discussed and demonstrated how you can monitor the performance and resource related behavior of an ADF application by instrumentation. Instrumenting gives visibility and insight of what is happening inside the application. What ADF, SOA, Java, and database transactions are executed, when and how often? What is the health of the components of your system? What is the type/severity of errors? Are there memory, or network blockages? What is the end-user experience? This end-to-end visibility and insight is very effective in identifying and resolving performance and health problems quickly by DevOps teams. Several customer scenarios will be discussed. Learn how you can make instrumentation an integral part of your ADF development process.


Speaker/bio

Frank Houweling is an Oracle ADF and Java specialist. He focuses mainly on Oracle Fusion ADF, Java Enterprise development and performance management. During the past years he has been requested several times as troubleshooter of ADF projects with bad performance. As such he has been performing performance analysis, bottleneck detection and developing mitigating solutions based on these analysis. He is also the creator of the ADF Performance Monitor, an advanced monitor that can identify, report and help solve performance bottlenecks in ADF applications.



Soham Dasgupta

Capgemini Netherlands B.V.

Senior Consultant

ENG

Level: Beginner


No-Java Enterprise Application

How we can have an enterprise level fully JavaScript based application with OracleJET and NodeJS using Oracle Cloud Services.


Considering a use case of a "Lease a Car" application, will explain how to do :

1. Build & Deploy

2. Unit testing

3. Entity definition

4. Business logic implementation

5. User authentication

6. Session Management

7. Database communication

8. etc.

Showcasing how we can use JavaScript for typical Enterprise application requirements/features for which we mostly require Java or Java based framework.

Speaker/bio

Experienced UI developer on ADF, Java and JavaScript. Working with Oracle Technologies since 2006. Worked in Accenture, Oracle and joined Capgemini Netherlands on 2014. Maintain a personal blog on my personal technolgical views (http://adfjava.blogspot.in/).

Worked with Android Studio, Ionic Framework, MAF, OracleJET, NodeJS, AngularJS,Oracle Mobile Cloud Service, Oracle Application Container Cloud Service, Oracle Database Cloud Service, Oracle Java Cloud Service.

More info on LinkedIn : https://nl.linkedin.com/in/soham-dasgupta-91b75410


Webcenter

Daniel Merchán García

VASSIT Services LTD

Technical Leader

ACE Associate

ENG

Level: Intermediate


Learn about how to enhance the performance in a WebCenter 12c platform

This speech will cover the typical issues after delivering a WebCenter Portal project. Performance.

It will cover:

- Typical mistakes or errors when installing and bulilding Portal projects that ends in performance issues.

- Steps to follow for checking performence in a WebCenter Portal platform and identifying the bottleneck.

- How to tune WebCenter Portal - Content for obtaining the best throughput.

- Personal recommendations.


Speaker/bio

I am an Oracle ACE Associate specialized in WebCenter and co-author of Beginning Oracle WebCenter Portal 12c book.


Richard Olrichs & Ise Douwes

The Future Group & Qlouded


Developing with the Oracle Content and Experience Management Cloud


Harold Oortwijn, Jan-Jaap Aaten

& Marcel van Maaren

Rabobank

NL


Straight-Through Processing van documenten

Dagelijks worden bij de Rabobank vele documenten ontvangen van klanten. Deze documenten worden gedigitaliseerd en moeten in het Electronisch Klant Dossier worden gearchiveerd in de juiste context. Een deel van deze documenten betreft de retourzending van door Rabobank gegenereerde documenten. Voor deze documenten is een process geïmplementeerd om het handmatige werk voor deze documentstroom zoveel mogelijk te beperken en de documenten zoveel mogelijk automatisch in juiste context te archiveren. Hierbij is gebruik gemaakt van WebCenter Capture en WebCenter Content.




Lucas Jellema

AMIS

Chief Technology Officer

ACE Director

ENG



The Art of Intelligence – A Practical Introduction Machine Learning for Oracle professionals

Our technology has gotten smart and fast enough to make predictions and come up with recommendations in near real time. Machine Learning is the art of deriving models from our Big Data collections – harvesting historic patterns and trends – and applying those models to new data in order to rapidly and adequately respond to that data. This presentation will explain and demonstrate in simple, straightforward terms and using easy to understand practical examples what Machine Learning really is and how it can be useful in our world of applications, integrations and databases. Hadoop and Spark, real time and streaming analytics, Watson and Cloud Datalab, Jupyter Notebooks, Oracle Machine Learning CS and the Citizen Data Scientists will all make their appearance, as will SQL.