Deze pagina in het Nederlands

Abstracts Tech Experience, June 7th & 8th 2018, De Rijtuigenloods, NL

Subject to changes

Alex Nuijten Alex Nuijten ACE director (NL) allAPEX

Parallel session 3.3 Intermediate

SQL Model Clause: A Gentle Introduction

The Model Clause adds spreadsheet-like functionality to the SQL language. Very powerful stuff, yet the syntax can be quite daunting. With the Model Clause, you define a multidimensional array from query results and then apply formulas to this array to calculate new values. This presentation will give you a gentle introduction in the complex syntax of the Model Clause and will show you some real life examples where the Model Clause was invaluable.

Bio Alex Nuijten

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.

« Back

Amit Zavery Amit Zavery

Keynote 1

Oracle Cloud Platform Strategy

This session will review the strategy and vision for Oracle Cloud Platform’s comprehensive, open, integrated, and hybrid PaaS offerings. Join Oracle Executive Vice President Amit Zavery as he discusses the journeys customers are taking to the cloud, and how Oracle Cloud Platform is enabling and simplifying the move to the cloud to drive business transformation. This session will cover some of the latest development from Oracle including autonomous PaaS, artificial intelligence, chatbots, blockchain, cloud-native application development, microservices/containers and will illustrate how the Oracle Cloud Platform can accelerate your own innovation.

Bio Amit Zavery

Amit Zavery is Oracle’s executive vice president for cloud platform and middleware products. He is responsible for product vision, strategy, development, and go-to-market initiatives for Oracle Cloud Platform and the Oracle Fusion Middleware product family. Amit and his team focus on building the most modern, open, comprehensive, and easy-to-use cloud platform that provides capabilities for cloud-native and mobile development, application integration, big data, data integration, content management, identity management and security. He is also responsible for enhancing the Oracle Cloud Platform with new and emerging technologies including Blockchain, AI/ML, and Bots. Since joining Oracle in 1995, Amit has held various positions in product development, management, strategy, and consulting. He began his career at Oracle as a software engineer on the video server product team. He then joined Oracle Consulting, implementing numerous interactive television applications, and, with the advent of the web, building internet applications for customers. Amit has worked in the Oracle Database group, where he was a member of the team responsible for planning and defining various Oracle Database releases. He was also responsible for product development and management of Oracle’s ecommerce applications and established Oracle’s CRM development center in India. Amit holds a bachelor’s degree in electrical and computer engineering, graduating with highest honors from the University of Texas at Austin. He also holds a master's degree in information networking from Carnegie Mellon University and is a graduate of the Harvard Business School’s Advanced Management Program.

« Back

Borkur Steingrimsson

Parallel session 7.4 Beginner

What a Successful OBIEE 12c Upgrade Project Looks Like: Liberty Global - Customer Case Study

OBIEE 12c is the latest generation of Oracle's Enterprise analytics and reporting tool, bringing with it many powerful new features. Many users are still on earlier releases of OBIEE 11g or even 10g, and are looking to understand how they can move to OBIEE 12c to benefit from its new capabilities. Liberty Global is a global telecommunications company, with a long history with OBIEE going back to 10g. They wanted to move to OBIEE 12c in order to use the new Advanced Analytics options, and used Rittman Mead to support them with the full scope of the upgrade. In this presentation, we will see what a highly successful OBIEE 12c migration looks like. We will cover clear details of all the steps required, and discuss some of the problems encountered. Regression testing is a crucial step in any upgrade and we will show how we did this efficiently and accurately with the provided Baseline Validation Tool. This presentation will assist all attendees who are considering, or in the process of, an OBIEE 12c upgrade.

« Back

Borkur Steingrimsson

Parallel session 9.4 Beginner

Visualising Streams

Business Analytics is undergoing a significant change: the traditional approach of batch ETL populating a pre-defined model is being challenged by streamed data, distributed file systems, and ad-hoc access. It is unlikely that either one alone will fully support the business, so understanding how these different approaches can be used together is vital. This session will present a modern Business Analytics data flow: starting from the data collection using Kafka, describing options for the transformation and enrichment, for example using Confluent's recently announced KSQL, and ending with surfacing using the latest release of Oracle's Data Visualization tool. The session will provide an excellent overview of the latest technology trends and how they can be assembled to create a state-of-the-art analytical solution.

« Back

Bruno Alves & Lykle Thijssen
Bruno Alves & Lykle Thijssen ACE associate (NL)

Parallel session 6.8 Intermediate

Continuous Delivery in the Oracle Cloud

The predominance of service offerings in the cloud is primarily derived from the prominent need to provide services in a fast way. This need also puts more emphasis on delivery methodologies that allow to maintain the speed, while also ensuring quality in the delivered software. Concepts such as DevOps and Continuous Integration are increasingly adopted and become pivotal in a software world marked by these constant demands. Cloud and hybrid application solutions are increasingly common, which puts the need for companies on the agenda to discuss how they should tailor the application promotion processes to align with the unique characteristics of developing and mantaining solutions in the cloud. In this session you will learn how to deliver high quality at high speed in the Oracle Cloud. Oracle has several interesting services for this purpose, like Developer Cloud Service and Container Native Application Development Platform, to cover your needs when it comes to continuous delivery of both Fusion Middleware and Microservices. We will explain best practices and show you how these Oracle Cloud services can help your software development lifecycle.

Bio Bruno Alves & Lykle Thijssen

Bruno Alves has worked with Oracle Fusion Middleware technologies for the last 13 years. He holds several Oracle certifications and is experienced as SOA/BPM Senior Architect, Consultant, Technical Team Leader and Presales. Currently performing the role of managing partner and Technical Director at eProseed UK, Bruno is co-author of the Oracle Fusion BPM & SOA Blog, speaker on conferences, and publisher on Oracle Technology Network (OTN) and other SOA related publications. By being at eProseed since it’s early days, Bruno, together with the team at eProseed, has received 15 Oracle Awards the last 6 years, amongst which multiple times the Oracle Middleware Partner of the Year, Industry Partner of the Year, and Oracle Fusion Middleware Global Innovation. He also recently got recognised with the Oracle ACE Associate title for his contributions to the Oracle community. Lykle Thijssen is a principal architect and Oracle ACE Associate, working for eProseed. With more than ten years of international experience, he's an expert in the field of process and integration development, as well as agile methodologies. Lykle is an independent thinker with an innovative mindset, who regularly shares his thoughts and ideas through blogs and presentations.

« Back

Bryn Llewellyn Bryn Llewellyn (US) Oracle

Parallel session 9.3 Intermediate

Guarding your data behind a hard shell PL/SQL API—the detail

I’ve taken my “Why Use PL/SQL?” talk around the conference circuit and published the companion whitepaper on the PL/SQL blog. It was a high-level account that appealed to common sense and to abstract principles of computer science. This session takes the opposite approach. It tells you in practical detail how to ensure that the hard shell of the database’s PL/SQL API is impenetrable by addressing code organization and security. It advocates a multi-schema model (for example, Data, Code, API, and Connect) using only invokers rights units together with code-based access control to honor the principle of least privilege. The approach is refined by explicit control of “inherit privileges”, the “accessible by” whitelist, and secure error handling. And scrupulous care is taken to ensure that the privileges needed for installation and patching are not available at run-time.

Bio Bryn Llewellyn

Bryn Llewellyn has worked in the software field for more than thirty-five years. He joined Oracle UK in 1990 at the European Development Center to work on the Oracle Designer team. He transferred to the Oracle Text team and then into consulting as the text specialist for Europe. He relocated to Redwood Shores in 1996 to join the Oracle Text Technical Marketing Group. He has been the product manager for PL/SQL since 2001. In 2005, he became responsible, additionally, for edition-based redefinition (EBR for short). This is the Oracle Database capability that supports online application upgrade. It’s hard for Bryn to remember his life before Oracle. He started off doing image analysis and pattern recognition at Oxford University (programming in FORTRAN) and then worked in Oslo, first at the Norwegian Computing Center and then in a startup. In Norway, Bryn programmed in Simula (its inventors were his close colleagues). This language is recognized as the first object-oriented programming language and was the inspiration for Smalltalk and C++. Bryn is an Oak Table member.

« Back

Chris Saxon Chris Saxon ACE director (UK) Oracle

Parallel session 7.3 Intermediate

Fixing the Worst Database in the World

Tables are the foundation of your database. Mistakes in their design put your whole application on a shaky footing. So it's worth spending some time to ensure you construct them well. But what if you inherit a schema riddled with bad practices? How do you go about fixing it? In this interactive session, Chris and Heli will show you how to use Oracle Data Modeler to iteratively fix a broken data model. If you're a developer or DBA who creates database tables, this session is a must for you!

Bio Chris Saxon

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.

« Back

Christian Gohmann Christian Gohmann (DE)

Parallel session 1.2 Beginner

MythBusters Globalization Support - Avoid Data Corruption

Oracle supports a huge amount of different languages and characters in its database. During database creation you have to choose between a single-byte (e.g. WE8MSWIN1252) and a multi-bytes (e.g. AL32UTF8) character set. Using a not suitable character set can lead to logical data corruption. On the other side, a wrong client configuration can lead to logical data corruption too, even when the database supports ""every"" character in the world using Unicode character set. For the case, that client and server use different character sets, a conversion must be performed. To avoid logical data corruption, the most important part is the correct setting of the NLS_LANG environment variable. The presentation starts with fundamentals about the Globalization Support of the latest Oracle 12c Release 2 database. Then it will give a overview of the correct setting and usage of the NLS_LANG and corresponding variables. Common myths in this context will be illuminated and eliminated - the effect of each misconfiguration is shown. Furthermore the correct usage of tools like SQL*Plus, Putty and the SQL Developer to avoid data corruption is part of the presentation. At the end of the presentation a short introduction on how to analyze and correct data corruption is shown.

Bio Christian Gohmann

Christian Gohmann is currently working as Senior Consultant and Instructor at Trivadis GmbH in Düsseldorf, Germany. His main focus lies on helping customers in the areas of architecture planing, implementation and migration - with a specialization on high availability solutions, like Data Guard, Oracle RAC. Since 2006, Christian Gohmann is working with Oracle and the Oracle Database and was part of a huge amount of different projects for customers in the German speaking areas. Beside his consultancy activities, he is the main developer and the reponsible person for TVD-Backup - a product distributed by Trivadis, which is reponsible for the intelligent backup and recovery of an Oracle database. In his spare time, he shares his knowledge on his blog www.christian.gohmann.de.

« Back

Daan Bakboord Daan Bakboord (NL)

Parallel session 3.4 Intermediate

Challenges and Pitfalls of Data Visualization

"A picture says more than a thousand words"". This sounds like a true statement. While it's true that it is easier to tell a story with visuals than with words, it makes a huge difference which visual you are using for which story. What is the real story behind a visual. Using the wrong visual to tell a certain story can reduce the benefit of a visual to zero. In this presentation we will go through the challenges & pitfalls of Data Visualization. Oracle Analytics tooling (Oracle Data Visualization Desktop) will be used to clarify the story.

Bio Daan Bakboord

Daan Bakboord is a Self Employed consultant who helps customers make data driven decisions using Oracle Data & Analytics. Daan has a strong focus on Oracle Business Analytics (BICS, OAC, OBIEE, Big Data, and Data Visualization). Next to that, Daan has a strong interest in (the Architecture and organization of) Business Analytics and Data Warehousing in general (TOGAF, ArchiMate, and CBIP) and Oracle Analytics Architectures in specific.

« Back

Daniel Merchan Daniel Merchan ACE (NL)

Parallel session 1.5 Intermediate

Future of JSF and ADF

Past, present and future of JSF as MVC Framework. Enhance your Oracle ADF skills with the news of JSF 2.2 and JSF 2.3 such as CDI, WebSocket Integration etc...

Bio Daniel Merchan

Speaker at OGh NL 2017 about WebCenter Performance

« Back

Darko Vukovic Darko Vukovic (US) Oracle

Parallel session 9.5

How large enterprises are implementing hybrid API strategies

Come hear about how the world's mega companies are approaching hybrid API topologies. This session will cover different patterns of gateway deployment, administration, topologies and cross divisional relationships as well as the reasoning behind each decision. It will include a retail, banking, industrial, and oil & gas company. While this session will be very focused on APIs, the context is very much about applications in a hybrid world, which should be interesting for anyone building modern world.

Bio Darko Vukovic

Darko Vukovic has been in the API space for 7 years, currently leading Oracle API Platform Product Management. Darko previously worked at MuleSoft and has discussed API strategies with over 500 customers in his career ranging from small startups to mega conglomerates. Prior to enterprise API Management, Darko worked as a product manager in eCommerce at Barnes and Noble, and Riot Games.

« Back

David Kurtz David Kurtz ACE director (UK)

Parallel session 2.2 Intermediate

Clouds of ASH

The old mature technology still works! This is a war story of how logical standby didn't deliver a reporting solution but materialized views did. Along the way we see why it is necessary to understand the underlying technology when choosing a solution, and will look at I will look at some of the newer materialized view features added 11g and 12c and some ideas for managing the refresh processing.

Bio David Kurtz

David Kurtz has worked with the Oracle database since 1989 and with PeopleSoft ERP applications since 1996, specialising in system performance tuning. He is a regular presenter at Oracle and PeopleSoft conferences. He is the author of "PeopleSoft for the Oracle DBA" (www.psftdba.com), and blogs about PeopleSoft (blog.psftdba.com) and Oracle (blog.go-faster.co.uk). David is an Oracle ACE Director and a proud member of the Oak Table. He has worked for the Accenture Enkitec Group since 2015

« Back

Duncan Mills Duncan Mills (UK) Oracle

Parallel session 2.7 Intermediate

HTML Web Components - Building the Future

The next big thing in the HTML and JavaScript development space is the move towards the HTML Web Components standard. In this session I’ll introduce the Oracle JET Composite Component Architecture (CCA) - your gateway to quick and simple web component creation. You can use these components to customize and extend the capabilities of both your JET UIs and all the other Oracle products which are aligning with this standard. This is a great opportunity to get ahead of the development curve and learn about piece of key technology for the Oracle ecosystem which is absolutely central to all of Oracle's product development plans.

Bio Duncan Mills

Duncan Mills is senior director and architect within the Oracle Development Tools division specialising in UI technologies. He has been working with Oracle technology for almost 30 years and as a result retains a depressingly large catalogue of facts about some really obscure Oracle products. Nowadays though, Duncan helps Oracles own development groups with architecture, technology selection and troubleshooting, and can often be found holding the hand of bewildered development teams from new acquisitions.

« Back

Duncan Mills Duncan Mills (UK) Oracle

Parallel session 7.5 Beginner

Next-Generation Low-Code Development for Web And Mobile

It's so secret I shouldn't really be saying anything about it yet!

Bio Duncan Mills

Duncan Mills is a senior director and architect within the Oracle Development Tools division specialising in UI technology . He has been working with Oracle technology for almost 30 years and as a result retains a depressingly large catalogue of facts about some really obscure Oracle products. Nowadays though, Duncan helps Oracles own development groups with architecture, technology selection and troubleshooting, and can often be found holding the hand of bewildered development teams from new acquisitions.

« Back

Frank Nimphius Frank Nimphius (US) Oracle

Parallel session 3.8 Beginner

From Zero to Bot in under 60 Minutes

2017 was the year of the bot, 2018 is the year of the bot and 2019 will be the year of the bot. Notice the pattern? Chatbot heralds the dawn of a new era in which artificial intelligence (AI) and machine learning (ML) become the new normal. AI and ML everywhere is expected to have an impact comparable to cars replacing horse-drawn carriages in the 1920-1940. There is no time for sit and wait, so how can you become part of this new era in IT and build your own intelligent bots at scale? As you guessed it, Oracle can help! This zero-slide session shows what it takes to build a bot with Oracle Intelligent Bots from start-to-end. This session provides valuable insights to chatbot development and is well suited for all developer types, including non-believers.

Bio Frank Nimphius

Frank Nimphius is a Speaker, Author, Blogger, YouTuber, Developer, Trainer and Product Manager in the Oracle Mobile Platform team with a current focus set on Oracle Mobile Cloud and Chatbots

« Back

Frank van der Borden Frank van der Borden OracleOracle

Parallel session 6.10 [Workshop / Handson Lab / BYOD!]

Oracle Management Cloud

Management Cloud: From end user experience to root cause analytics using your operational data from heterogeneous (on-premises and cloud) environments.

Bio Frank van der Borden

Frank is Sales Engineer at Oracle for the technology line of business. One of his areas of expertise is Oracle Management Cloud. Frank has been working at Oracle since 1995 where he started as support engineer and later joined the sales organization as Sales Engineer for various Oracle solutions such as Identy and Access Management, Database Security and manageability.

« Back

Frits Hoogland Frits Hoogland ACE director (NL)

Parallel session 7.1 Intermediate

All about linux memory usage by the Oracle database

Memory usage of a virtual memory operating system like Linux always has been shrouded in mystery, with admins setting parameters by best practice rather than based on measurable facts specific for that machine. This presentation explains memory and hardware, then moves into how Linux uses memory, and how this can be measured, and them moves to the Oracle database. At the end some Oracle database memory use cases are executed and shown how this impacts operating system memory.

Bio Frits Hoogland

Frits Hoogland is an IT professional specialising in Oracle database performance and internals. Frits frequently presents on Oracle technical topics at conferences around the world. Frits is an ACE Director and a member of the Oaktable Network.

« Back

Frits Hoogland Frits Hoogland ACE director (NL)

Parallel session 9.1 Intermediate

Provisioning the Oracle database

This presentation provides a walkthrough on provisioning a full Oracle database software install via Ansible. The presentation also touches local virtual machine provisioning for test and development. Full not only means it is showing how to get it installed, but also fully patched to a PSU. The actual core of the presentation is walking through the Ansible scripts showing their readability and simplicity whilst the scripts are actually performing their task in the background. It goes beyond concepts and shows actual execution of deployment, step by step, via live demo’s. This is a must see session for anyone who is serious about provisioning!

Bio Frits Hoogland

Frits Hoogland is an IT professional specialising in Oracle database performance and internals. Frits frequently presents on Oracle technical topics at conferences around the world. Frits is an ACE Director and a member of the Oaktable Network.

« Back

Geertjan Wielinga (NL) Oracle

Parallel session 4.5 Beginner

Oracle JET — No Slides, Just Code!

What's Oracle JET? JET is the JavaScript Extension Toolkit, which is Oracle's official enterprise JavaScript solution. It is used throughout Oracle as the frontend user interface technology for all modern Cloud products, while it is also Oracle's strategy for extending Oracle products, such as Oracle Sales Cloud, Oracle HCM Cloud, and more. In this session, see how everything fits together, without any slides, just code! And if you have already been introduced to the concepts of Oracle JET, you might want to see how a real application can be developed from scratch — that is what this session is all about!

Bio Geertjan Wielinga

Geertjan Wielenga is an Oracle Senior Principal Product Manager focused on Oracle JET.

« Back

Gerben Vermoen Gerben Vermoen (NL)

Parallel session 4.6 Intermediate

API Integration Testing with Karate

Cloud or not, SOAP or REST, APIs are everywhere. But how can we test them in a way that is effective, efficient, and descriptive? In this session we will use Kotlin and Spring Boot 5 to quickly build a reactive REST API based on the widely known Oracle HR schema. We will then write and run Integration Tests using a brand new, kick-ass testing framework called Karate. Join this session to learn why Integration Tests are so important and how you can easily write Behaviour Driven Development (BDD) style Integration Tests that are simple, descriptive and maintainable. Expect only a few slides and much live-coding in this fast-paced development session, and learn some things new about the latest trends and hottest technologies in Oracle's Java ecosystem.

Bio Gerben Vermoen

Gerben Vermoen is an independent Oracle and Java consultant who wrote his first Java class in 2001 and has been writing code ever since. He loves building innovative software and has a passion for clean, elegant solutions. Because he can't make a choice between frontends and backends he does both of them while having a lot of fun playing with the latest technologies in the wonderful world of software development.

« Back

Gertjan van het Hof Gertjan van het Hof (NL)

Parallel session 2.6

Practical case of IoT using the Oracle IoT Cloud

In this session we share our field experience with IoT by demonstrating a practical demo: The People Counter. This demo uses sophisticated image recognition software to count the number of people in front of our AMIS conference stand and send this calculated value to the Oracle IoT Cloud. In there we have configured business rules in a way that an alarm should be raised when it becomes too crowded at our stand. Visit our conference stand to get a live demonstration!

Bio Gertjan van het Hof

Gertjan van het Hof is a Solution Architect and very passionate about IoT. With 20 years’ experience in different IT sectors and consulting companies he brings in a lot of experience. He currently is an IoT Tech Lead at Conclusion and is working on 2 different (I)IoT projects.

« Back

Gianni Ceresa Gianni Ceresa ACE (CH)

Parallel session 1.4 Beginner

Graph Databases: The Next Frontier

Graph Databases and Graph Analysis are the new boundaries of the Business Analytics world. After the classical DWH and big data, graphs provides new perspectives and insights, but are still kind of mysterious and with a steep learning curve. Newness make it difficult to find simple approaches on where to start and how to add graphs to your analytics toolbox. This session will take you over this step: introducing graphs databases and to enable them. Not another theoretical talk but more down to earth supported by a sample dataset all over the process. Practical hints on how to get started with graphs.

Bio Gianni Ceresa

An OBIEE enthusiast more widely interested in BA/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 10 years of experience in multiple project roles like architect, analyst, team lead and developer, bridging together the business and the technical side of the BA world. His other activities include OBIEE/OAC training delivery, R&D, blogging and supporting the Oracle community on the ODC forums.

« Back

Greg Stachnick Greg Stachnick (US) Oracle

Parallel session 8.3 Beginner

DevOps and Agile Methodology for Oracle Database Projects

Learn best practices for efficient cloud-based agile and DevOps platform to speed up product delivery. Bringing together the worlds of agile development methodology and DevOps process automation helped us deliver better software faster. Get a glimpse at the flow of a typical work day, from the perspective of developers and managers, and how our teams collaborate on issues tracking, development sprints, code test and review cycles and continuous integration and delivery.

Bio Greg Stachnick

Greg Stachnick is a Senior Principle Product Manager in the Oracle Development Tools group. He currently manages Oracle Developer Cloud Service and Oracle Enterprise Pack for Eclipse. Greg is also a contributor to the open source Hudson project for the Eclipse Foundation. Greg joined Oracle in 2008 and has been working in the developer productivity space since 2000. He is a frequent speaker at conferences on Eclipse, Java and JavaEE, Cloud, and Continuous Delivery topics.

« Back

Guido Schmutz Guido Schmutz ACE director (CH)

Parallel session 1.7 Beginner

Building event-driven (Micro)Services with Apache Kafka / Oracle Event Hub CS

This session will begin with a short recap of how we created systems over the past 20 years, up to the current idea of building systems, using a Microservices architecture. What is a Microservices architecture and how does it differ from a Service-Oriented Architecture? Should you use traditional REST APIs to integrate services with each eachother in a Microservcies Architecture? Or is it better to use a more loosely-coupled protocol? Answers to these and many other questions are provided. The talk will show how a distributed log (event hub) can help to create a central, persistent history of events and what benefits we achieve from doing so. Apache Kafka is a perfect match for building such an asynchronous, loosely-coupled event-driven backbone. Events trigger processing logic, which can be implemented in a more traditional as well as in a stream processing fashion. The talk shows the difference between a request-driven and event-driven communication and answers when to use which. It highlights how a modern stream processing systems can be used to hold state both internally as well as in a database and how this state can be used to further increase independence of other services, the primary goal of a Microservices architecture.

Bio Guido Schmutz

Guido Schmutz works for the Oracle Platinum Partner Trivadis. He has more than 30 years of technology experience. At Trivadis he leads the Trivadis Architecture Board. He has long-time experience as developer, coach, trainer, and architect in the area of building IT systems. In the past 4 years he mostly worked in Big Data / Fast Data projects with technologies such as Hadoop, Storm, Spark, Cassandra, Kafka as well as container technologies such as Docker and Mesos. Guido is an Oracle ACE director for Fusion Middleware and SOA and a regular speaker at international conferences.

« Back

Guido Schmutz Guido Schmutz ACE director (CH)

Parallel session 6.7 Beginner

Apache Kafka - A modern Stream Processing Platform

After a quick overview and introduction of Apache Kafka, this session cover two components which extend the core of Apache Kafka: Kafka Connect and Kafka Streams/KSQL. Kafka Connects role is to access data from the out-side-world and make it available inside Kafka by publishing it into a Kafka topic. On the other hand, Kafka Connect is also responsible to transport information from inside Kafka to the outside world, which could be a database or a file system. There are many existing connectors for different source and target systems available out-of-the-box, either provided by the community or by Confluent or other vendors. You simply configure these connectors and off you go. Kafka Streams is a light-weight component which extends Kafka with stream processing functionality. By that, Kafka can now not only reliably and scalable transport events and messages through the Kafka broker but also analyse and process these event in real-time. Interestingly Kafka Streams does not provide its own cluster infrastructure and it is also not meant to run on a Kafka cluster. The idea is to run Kafka Streams where it makes sense, which can be inside a “normal” Java application, inside a Web container or on a more modern containerized (cloud) infrastructure, such as Mesos, Kubernetes or Docker. Kafka Streams has a lot of interesting features, such as reliable state handling, queryable state and much more. KSQL is a streaming engine for Apache Kafka, providing a simple and completely interactive SQL interface for processing data in Kafka.

Bio Guido Schmutz

Guido Schmutz works for the Oracle Platinum Partner Trivadis. He has more than 30 years of technology experience. At Trivadis he leads the Trivadis Architecture Board. He has long-time experience as developer, coach, trainer, and architect in the area of building IT systems. In the past 4 years he mostly worked in Big Data / Fast Data projects with technologies such as Hadoop, Storm, Spark, Cassandra, Kafka as well as container technologies such as Docker and Mesos. Guido is an Oracle ACE director for Fusion Middleware and SOA and a regular speaker at international conferences.

« Back

Hasso Schaap Hasso Schaap (NL)

Parallel session 4.4 Beginner

Cloud Data Center, Infrastructure, Analytics and integration. Mind the gap!

This case study takes us through all the steps that we performed at a Dutch Bank that is staying compliant to the regulations, but also engaging the Finance Office with Analytics, Visualization and Process Management. The dataset used was a relational datamodel meant for credit risk reporting and data analytics. We performed data analysis in all kinds of stages using DV and used Machine Learning for base facts, the key drivers, segments and anomalies. We will show you how we used Data Visualization and where we see Data Visualization fit for purpose and where it falls short. The bank is currently using Oracle BI to support the finance transformation, but to keep up with regulations bimodal IT and bimodal analytics are a must have to perform better. Topics in this session will include using Data Source connections, Data Flows, Data Preparation, Visualization, Narration and the call to action. If time permits the Advanced Analytics features will be discussed in light of the usecase.

Bio Hasso Schaap

As the lead developer I worked on the ForceView application built on Oracle Cloud Platform. My area of expertise is in the use of Oracle Cloud Platform services and designing Analytics on cloud services. For the past 10 years I have been developing in all kinds of data and analytics projects, such as datawarehousing, business intelligence, reporting, ad-hoc and self-service analytics. Now I focus on cloud services to deliver all the new things to customers. I have been using the following: BI Cloud service, Process Cloud Service, Visual Builder Cloud Service, Integration Cloud Service, Documents Cloud Service, Big Data Preparation, Big Data Discovery, Enterprise Performance Reporting, Database Cloud Service.

« Back

Hasso Schaap Hasso Schaap (NL)

Parallel session 8.4 Intermediate

Credit Risk Analytics. A case study using Oracle Data Visualization.

There is a long list of products and services, but what do I need for Analytics? Is it just the Cloud service? Can I simply connect everything? Let's get to the bottom of this. Let’s get a holistic view on the infrastructure for hybrid cloud analytics. These topics are based on an onshore/offshore industry company moving it's analytics to the cloud, while having to deal with offshore locations as well. This session will elaborate on how Analytics Cloud, RDC, VPN, GoldenGate, Data Integrator, ETL, FastConnect, Internet Exchanges, your ISP and datacenters are related to each other. The case study is a datawarehouse and analytics platform in the Oracle Cloud connecting to on-premises sources. The analytics-to-the-cloud first approach is often a great start in the cloud, but at that time you need to think beyond running queries, offloading the ETL-load and moving BI users to the Cloud. We will mind the gap and compare the upside and downside of different infrastructural approaches.

Bio Hasso Schaap

As the lead developer I worked on the ForceView application built on Oracle Cloud Platform. My area of expertise is in the use of Oracle Cloud Platform services and designing Analytics on cloud services. For the past 10 years I have been developing in all kinds of data and analytics projects, such as datawarehousing, business intelligence, reporting, ad-hoc and self-service analytics. Now I focus on cloud services to deliver all the new things to customers. I have been using the following: BI Cloud service, Process Cloud Service, Visual Builder Cloud Service, Integration Cloud Service, Documents Cloud Service, Big Data Preparation, Big Data Discovery, Enterprise Performance Reporting, Database Cloud Service.

« Back

Ilmar Kerm
Ilmar Kerm ACE associate (SE)

Parallel session 2.1 Intermediate

Automating Oracle database administration, practical examples with Ansible

As the demand for Continuous Delivery and Cloud Computing increases, so to does the repetetive nature of DBA work. This is where automation can help you. One of the most popular Devops Tools for automation is Ansible. Ansible allows you to automate workflows using YAML an easy to use language, that can also serve as documentation. This session is a practical "minimal-slides" hacking session where the presenters will implement basic DBA workflows using Ansible automation software. The presented examples will give the audience the necessary skills to get started with Ansible so that they can implement their own custom workflows.

Bio Ilmar Kerm

Ilmar has worked with Oracle Databases since 2005, starting out with Oracle 9i. Last 10 years he has been working with one of the largest online gambling providers in Europe, Kindred/Unibet, as a Senior Database administrator, where he manages both busy transactional databases and large data warehouse daily. Previously he has been both in DBA and developer roles in medical and IT consulting industries. Although living in Stockholm, he is also the president for Oracle user Group Estonia. Ilmar has presented in Oracle User Group conferences in Norway, Sweden, Finland, Germany, Estonia, Israel, Slovenia, Croatia, Bulgaria and UK. Mikael Sandström has been working as an Oracle Database Engineer since the early 2000's. His expertise lies in the platform/infrastructure area. He is a firm believer in the concept of Infrastructure as code and thinks that there is no reason the DB couldn't be treated the same way. Currently he is (among other things) automating all the things at Kindred Group.

« Back

Iloon Ellen-Wolff Iloon Ellen-Wolff Cloud Success DirectorCloud Success Director (NL) Oracle

Parallel session 8.8 Intermediate

Lessons learned using Oracle Mobile Cloud Service in Public Transportation

Oracle Mobile Cloud Service offers a number of functionalities out of the box, in the form of Platform APIs. To offer meaningful APIs to mobile application developers, you need to build custom APIs. The custom APIs are run using node.js.

This session will discuss some lessons we learned while writing custom code.

Topics that will be addressed are:
  1. timeouts and sessions
  2. using 3rd party libraries
  3. Parsing of XML and streams
  4. Authentication and Authorization
  5. trouble shooting
Presentation summary:
The session will discuss the lessons learned when building the APIs in node.js using Oracle mobile cloud service.

Use case
Architecture
Lesson 1. Scheduling and timeouts
Lesson 2. Using 3rd party libraries
Lesson 3. arsing f XML and streams
Lesson 4. Why OAuth?
Lesson 5. Trouble shooting your code
Demo
Conclusion

Bio Iloon Ellen-Wolff

I began my Oracle career twenty eight years ago, being employed by several software houses in The Netherlands, working with Oracle Forms version 2 and Report*Writer.
Twenty years ago, I was hired to work in Oracle Support Services for the Developer competency, assisting customers with solving their software problems.
This involved supporting Application Express, Rest Data Services(APEX Listener), SQL*plus, SQL Developer and Oracle Database Service Cloud. During those years, I applied my expertise by coaching new engineers, team leading and teaching Application Express courses for Oracle University.

For the past eight years, I have been involved with the Oracle Cloud project.
I was a member of the Platform as a Service (PaaS) readiness team, who test Application Express in the cloud and in this capacity, I provide foundation training for this technology.
One of my responsibilities in Oracle Support was Global Technical Lead for Application Express.
I work closely with sustaining engineering, product development and product management from the Application Express team.

In March 2016, I moved to the job Oracle Cloud Success Director in the Platform As A Services Team. I assist customers in the complete journey to the Oracle Cloud.

Oracle’s Cloud Customer Success Organization is a focused group of Cloud Customer Success experts whose mission is to drive successful Oracle Public Cloud utilization and replenishment through the proactive management of all facets of the customer engagement life cycle.
Responsible for fusing and complementing the relationship between the Oracle Public Cloud (IaaS & PaaS) and customers core business objectives and priorities thereby driving increased business value and alignment between Oracle and its valued customer community. Assisting customers in the complete journey to the Oracle Cloud.

I am a frequent speaker for various Oracle User Groups including the UK Oracle user group, the Dutch user group, the Norwegian user group, the Bulgarian user group and OBUG, presenting about Application Express and Oracle Cloud.

Oak Table member since September 2013

Co-Authored the book Application Express Best Practices

« Back

Ivica Arsov Ivica Arsov ACE (MK)

Parallel session 7.2 Intermediate

Parallel Execution

We will first start with the parallel execution concepts, why do we need it and get understanding where we can benefit from parallel processing. Once we cover the architecture and build a solid ground we dive into more details. Some of the topics we will cover are understanding producer/consumer model, reading parallel execution plans and understanding row distribution methods. We'll mainly focus on HASH row distribution method and bloom filters. We'll see where and why performance degradation can occur. We'll also cover HYBRID HASH distribution method, Oracle's improvement for skew data handling. You'll also learn bloom filters theory, how and when they're used. We'll also cover how bloom filters help us to gain more performance from parallel execution.

Bio Ivica Arsov

Ivica is a Senior Database Consultant at Pythian, with main focus on database performance and systems stability. His first contact with Oracle technologies was during his university studies where he graduated with a major in Information Technology. His first career years were as a web developer. Within two years he transitioned to Oracle technology as PL/SQL developer and quickly emerged into Oracle administration. In 2014, Ivica became Oracle Database 11g Certified Master, the highest Oracle certification. In 2016, he has upgraded his master certification to the latest Oracle 12c version. After several years working with Oracle and being eager to share his knowledge Ivica started submitting and presenting at Oracle user group conferences. He has spoken at numerous Oracle conferences including Oracle Open World. Mostly he can be seen at conferences within Europe. He is also maintaining his own blog where he shares his knowledge.

« Back

Jacques Kostic Jacques Kostic ACE associate (FR)

Parallel session 7.8 Intermediate

Customer case Exadata POC with OVM

With the introduction of Oracle VM under on Exadata, consolidation and licensing optimization are becoming much easier without tangible performance degradation. This presentation focus on a proof of concept for an Exadata consolidation project using OVM for a real customer that runs under AIX based infrastructure with a bunch of near “end of support” hardware. The main goal of the project is to demonstrate that the new Exadata with OVM can perfectly fit customer needs and allow future business growth.

Bio Jacques Kostic

Jacques has been working with Oracle Database since 1990 starting from version 4 on SCO Unix. Within all company he has worked in, he has always been considered a key player in Oracle Database topics by playing various roles from solution design to complete implementation and deployment of Oracle Database products. He is always open to learn and discover new technologies. In 2012, Jacques joined Trivadis AG as Senior Consultant, where he is currently a member of the Database Key Players Team, beta tester, trainer, mentor and consultant. In addition, he has recently been promoted to Principal Consultant. Fond of knowledge sharing, his activities (forums, blogs, articles, presentations), in both the French and the international Oracle community, spans the last 12 years.

« Back

Jan Willem Vermeer Jan Willem Vermeer ACE (NL)

Parallel session 2.5 Expert

How I modernized my large Forms application using PL/SQL, XML and Webservices

PLANMYSPORT is the all-in-one solution for sportscentres, sportschools and sportclubs with functionality for the administration of members, students, rental contracts, online reservations, tournaments and competitions and communication with websites, apps and mailings. PLANMYSPORT started in the year 2000 as a demonstration product for the innovative internet software of Oracle with Oracle Portal, mod_plsql and Forms/Reports (100% generated with Designer-Headstart). It was one of the first, maybe the first, Forms-applications running on the open internet! Because of problems with the Java-plugin and the oldfashioned user interface it became necessary to replace the more than 200 Forms-modules. We did this in four steps: Step 1) Requirements: most Forms-modules are master-detail or master-detail-detail screens, the more than 400 tables have meaningfull keys with 1 up to 9 columns, I am the only developer, financial means are limited and the new software needs to be modern and innovative so it will last for a long time. Step 2) Options. ADF was not an option because I have no knowledge of Java and the learning curve is too challenging. APEX was not possible because of no/limited support for master-detail screens and meaningfull keys. We use mod_plsql all the time, but it is too hard to get Forms-like functionality. After a long search I came accross TheFormspider: a framework based on PL/SQL, XML and Webservices. Step 3) Develop a small part of the application as proof of concept for TheFormspider. This was very positive: almost no learning curve, development is fast, technically modern (jquery) and user interface was highly appreciated by the users. Step 4) Develop the rest of the application: this will finish in the end of 2018. During the presentation I will show how Oracle Forms modules are being translated into TheFormspider modules. Subjects are: layout, user functions and user keys, panels based on XML and implementing the master-detail functionality.

Bio Jan Willem Vermeer

My name is Jan Willem Vermeer. Since 1985 I have been working with (almost) all Oracle products: from database version 4 with UFI/IAF/IAG up to SQL, PLSQL, Oracle Dictionary / Designer with Headstart, Forms, Reports, Discoverer, WebDB / Oracle Portal, Oracle Application Server, mod_plsql and Developer. I was beta-tester for many products, entered more than 1000 tickets in the Oracle Support system and contributed in countless discussions on the Oracle communities. After 9 years at Fokker Aircraft in Amsterdam and 7 years at Fast Lane in Maarssen, in 2001 I started my own company Farmore Automation for the realisation of PLANMYSPORT – the best all-in-one solution for the sportsworld.

« Back

José Rodrigues José Rodrigues ACE associate (PT)

Parallel session 8.5 Intermediate

Building your Agile tools with Oracle Jet in the Cloud

Oracle JET newest version opens up a world of new possibilities regarding fast, concise and enterprise grade javascript web development. Using almost no knowledge of javascript, we build a set of tools to help us on enforcing Agile Processes. In this session, we demonstrate you how someone with almost no knowledge of Javascript can build one these tools, with a step-by-step guide, from the data model in SQL Data Modeler to a live working web application, showing the common pitfalls we encountered and how we overcome them. And as a bonus, you get to take our Agile Toolkit with you, source code included :)

Bio José Rodrigues

José Rodrigues, a.k.a Maverick, is an Oracle ACE Associate and the BPM and ECM Business Manager and the BPM Practice Lead at Link Consulting. He has been involved in very large Business Process Optimization, Automation and Management projects for world top-tier companies, mostly with Oracle technology, some of which have been awarded world renowned prizes, such as the Outstanding Contribution Award given by Oracle BPM Community, and the runner-up for Oracle’s Middleware Partner of the Year Award. He’s the main responsible for the world’s largest BPM project with Oracle technology (in terms of number of instances, in 2014), and is a speaker at BPM conferences and Oracle events, both in Portugal and abroad. Recently, he has been involved in other areas such as Fast Data and Rapid Web Development, working mainly with Oracle Stream Analytics and Oracle JET. He also frequently gives trainings and classes on BPM, with strong focus on Requirements and Business Process Design Optimization. In 2014 he launched Red Mavericks, a site that focus on Oracle technology applied to Fusion Middleware and Development, that intents to make it easier for newcomers to get their ideas straight and helping them jumpstart their projects.

« Back

Klaas-jan Jongsma Klaas-jan Jongsma ACE associate (NL)

Parallel session 2.4 Intermediate

Oracle loves Kafka?

Data Integration is becoming a key element in modern data lake setups for enriching your datasets either on hadoop or sending data back from hadoop into your datatwarehouse. One of these key elements is Apache Kafka and it is becoming more popular everyday. We will investigate on how you can use Kafka to offload your Oracle datawarehouse or to enrich with data coming from the hadoop cluster. In this presentation we will talk about how to setup Kafka, different way of streaming data between Oracle and Kafka like Oracle Golden Gate.

Bio Klaas-jan Jongsma

Klaas-jan has been working in IT since the early nineties. His career started out as an system & network administrator working with a range of operation systems such as AIX, Solaris, Cisco IOS and Windows. He began to focus more and more on Oracle RAC databases and the infrastructures surrounding it, besides working with MySQL and SQL Server databases. Klaas-Jan currently works for Anchormen / VX Company in the Netherlands, as a Data Platform Engineer specialising in Big Data, Oracle and the integration of those landscapes.

« Back

Kshitij Joy Kshitij Joy (UK)

Parallel session 5.8 Expert

Exadata Patching Demystified

Kshitij Joy will be delivering a talk on Exadata Patching Demystified, starting with the history of Exadata will go into it’s Stack and then give a clear understanding around how to patch each layer of the Exadata Stack. The Exadata Cell Server Patching, Compute Nodes Patching, Infiniband and Grid Infrastructure along with DB Homes Patching will be discussed. There would also be a discussion on how he migrated their Exadata 12.1 to Exadata 12.2 which has been very recently released by Oracle.

Bio Kshitij Joy

Member of an elite group of Oracle professionals by successful completion of Oracle 11g Certified Master [11g OCM ], my profile has been published on Oracle website : http://education.oracle.com/education/otn/KJoy.htm Having 15+Years of Experience in Oracle technologies. My key responsibility areas are Exadata Architecting , Installation, Administration, Performance - Tuning, Backup – Recovery , Data Guard and Database Upgrades. I have experience with technologies like Oracle GoldenGate, Veritas Netbackup, Oracle 10g / 11g RAC with Oracle ASM, Oracle 10g /11g / 12cGrid Control.

« Back

Laura Broekstra & Jeroen Rijnboutt
Laura Broekstra & Jeroen Rijnboutt (NL)

Parallel session 3.5a Intermediate

Soaring through portals with Oracle JET / Creating, Publishing and Reusing a JET Composite Component [25 min]

A customer, keen to jump on the JET-airplane and a wish to create similar looking portals for different use cases. Only how do you match customer needs with the technical challenges of running a JET application in WebCenter Portal? This presentation will take you through several aspects of developing portals with Oracle JET. We will be dealing with integrating JET in an ADF Taskflow for use in WebCenter Portal. And supplying the application with data from Elasticsearch, calling REST API's on an Oracle database and making sure all is secure and available for external users.

Bio Laura Broekstra & Jeroen Rijnboutt

Laura Broekstra and Jeroen Rijnboutt are Oracle JET developers with a background in ADF. Both have completed the software engineering (java) retraining program at the Amsterdam University of Applied Sciences. After that they started work at AMIS, initially as ADF developers but now focusing on Oracle JET. While working on this project, experience in both technologies has been proven valuable.

« Back

Laurent Leturgez
Laurent Leturgez ACE (FR)

Parallel session 5.2 Beginner

Addressing Oracle Performance Issues: The Drill-Down Approach.

Oracle performance issues are rarely fully qualified by end-users. Usually, they come to the DBA with this fuzzy message "my application is slow, can you help me ?". So the DBAs have to determine when and how it is slowed down and to do that, they have to use the good methodology. During this session, a method will be described to identify problems from the general (It's slow!!) to the detail, for example, a PLSQL issue. To do this, two distinct parts will be shown in order to diagnose bottlenecks (and only diagnose): - First part, a technique that will help to identify hot points will be detailed. Once identified, it will be easier to point out when the problem occurs and then focus the analyze on this time period. This technique will help DBAs to guide their investigation on a CPU time reduction or on a wait time reduction. The presentation of this topic will be done with and without the help of Diagnostic pack. - Second part, an overall view of available tools will be done and how they can be used to detect bottlenecks, top sql etc. AWR/Statspack, ASH, and the PLSQL profiler are very powerful tools, and for each tool, one example from real cases will be presented. Finally, with these methods and tools, the attendees will be able to easily identify bottlenecks from the general to the detail, and then apply the fixes that will correct the performance issues

Bio Laurent Leturgez

I have been French Oracle Consultant since 2001 and have worked on critical systems for many French customers: VLDB, highly critical e-commerce websites, Engineered Systems etc. I have earned many certifications, including Oracle Certified Professional 10g and 11g, Oracle Certified expert and I'm an Oracle certified master 11g and 12c. I actually work for the company I created: Premiseo, a database oriented company. I work as a consultant and help customers build and run scalable Oracle platforms (with Appliances like Exadata or ODA). I also work on many projects to support customers to move their databases platform into the Cloud

« Back

Lonneke Dikmans Lonneke Dikmans Developer Champion (NL)

Parallel session 6.6 Intermediate

PaaS4SaaS, cloud-to-on-premise and cloud-to-cloud: Building a global HCM solution

In this session we show how we used SOA CS to build a global HCM solution for an international construction company. The global HCM solutions needed to be integrated with several on premise and cloud solutions. The session explains the different components of the solution in SOA CS, how we connected to Azure AD, Taleo Recruit, what we did to integrate safely with JD Edwards on premise and how we setup the integration with Oracle HCM cloud using the Atom feed and REST services. The different choices that were made during the project will be examined and compared with alternatives.

Bio Lonneke Dikmans

Lonneke Dikmans is Chief Product Officer at eProseed, Oracle Developer Champion and Oracle ACE Director. She has hands-on experience with process modeling, service oriented architecture and API design. She has been programing since she was twelve and is enthusiastic about new solutions and technologies like blockchain, serverless and microservices

« Back

Lonneke Dikmans Lonneke Dikmans Developer Champion (NL)

Parallel session 9.7 Beginner

Serverless and Java? Is that even possible?!?

Scalability and agility are the buzz words of modern times. This has led to new architecture concepts like microservices and functions. These architectures don’t need a complicated server backend, but can be deployed quickly and scale out easily. Often the runtime environments for these functions are Node.js, python and other scripting languages. This means, as a Java Developer, that you would have to learn a new programming language if you want to apply this concept. However, last October an open source serverless framework leveraging Java was announced: fn. It is cloud agnostic (so it runs on any cloud platform, not just AWS) and is built by the team that created IronFunctions. In this session you will learn what a serverless framework is, how you can create a function in Java using the function developer kit and how to call this function.

Bio Lonneke Dikmans

Lonneke Dikmans is partner at eProseed and head of the center of excellence. She is Oracle ACE Director for Middleware and Oracle Developer Champion. She started coding when she was 12. She has been learning new programming languages and paradigms ever since. Throughout her career, integration and software delivery quality have been a returning theme. She has worked in different industries, varying from Government and healthcare to financial services and utility companies. She is a certified Java Developer and a BPMN certified professional Lonneke is co-author of the book SOA Made Simple (Packt), publishes blogs (http://blog.vennster.nl) and articles and shares her knowledge and experience at conferences like JavaOne, Devoxx, Oracle user groups, Java user groups etc

« Back

Lucas Jellema Lucas Jellema Developer Champion (NL)

Parallel session 1.3 Intermediate

Automated testing on steroids – Trick for managing test data using Docker snapshots

Integration is a challenge that has become even more urgent with the move to the cloud that all organizations are making or are about to make. Whether SaaS applications have to be enabled (linked to other SaaS applications or to custom apps) or IoT is used to integrate the physical world into enterprise IT or whether microservices (on premises) have to collaborate with microservices (in the cloud) - integration is at the heart of enterprise IT. This presentation discusses and demonstrates the move to the cloud, a number of common integration use cases and the key components in Oracle PaaS Portfolio for tackling these challenges. These include Integration Cloud, Data Integration Cloud Platform, Event Hub, IoT Cloud, Process Cloud and API Platform.

Bio Lucas Jellema

Lucas Jellema is solution architect and CTO at AMIS, The Netherlands. The running theme through most of his activities is transfer of knowledge and enthusiasm (and live demos). Lucas is JavaOne 2015 Rockstar, Oracle Developer Champion and ACE Director and a frequent speaker at conferences such as Oracle Code, Oracle OpenWorld, JavaOne and Devoxx. He publishes techy stuff at Github, Slideshare, DZone, OTN, and the AMIS Technology Blog (technology.amis.nl). He is the author of two books on Oracle SOA Suite with Oracle Press.

« Back

Lucas Jellema Lucas Jellema Developer Champion (NL)

Parallel session 3.5b Intermediate

Creating, Publishing and Reusing a JET Composite Component [25 min]

Composite Components are a crucial element in the evolution of Oracle JET. These components allow organizations to better structure their enterprise applications built with JET and to introduce efficiency and UX consistency through reuse UI components. JET Composite Components are also shared across the boundaries of enterprises, throughout the community, to be consumed in JET applications anywhere and in Visual Builder Cloud applications. This session demonstrates how a JET Composite Component is designed and implemented. The component introduces a Geographical Map on which data bound locations (regions, countries, states and cities) can be indicated and selected. The component supports two way data binding, configuration properties and it publishes events. It leverages open source map and geocoding libraries. This session demonstrates how the component is packaged and published and how it can be reused in a JET application as well as in Visual Builder Cloud. It will allow you to start reusing, building and publishing your own JET Composite Components.

Bio Lucas Jellema

Lucas Jellema is solution architect and CTO at AMIS, The Netherlands. The running theme through most of his activities is transfer of knowledge and enthusiasm (and live demos). Lucas is JavaOne 2015 Rockstar, Oracle Developer Champion and ACE Director and a frequent speaker at conferences such as Oracle Code, Oracle OpenWorld, JavaOne and Devoxx. He publishes techy stuff at Github, Slideshare, DZone, OTN, and the AMIS Technology Blog (technology.amis.nl). He is the author of two books on Oracle SOA Suite with Oracle Press.

« Back

Lucas Jellema Lucas Jellema Developer Champion (NL)

Parallel session 4.7 Intermediate

Live Introduction to the Oracle Cloud Native Microservices Platform – open, manageable, polyglot and scalable

The microservices architecture promises flexibility, scalability and optimal use of compute resources. Through independent components with well-defined scope and responsibility, interface and ownership that are evolved and managed in an automated DevOps process, this architecture leverages current technologies and insights from SOA, containers, cloud, event bus, build and delivery automation, stateless and scalable runtime and end to end monitoring. The Oracle Microservices Platform is an open source runtime for deploying, running and managing container based microservices. This platform offers a distributed container runtime based on Kubernetes and on top of that API management, a build in event bus, a service broker to link in external services, advanced inter microservice traffic control and load balancing and extensive monitoring. It supports the pure pay-per-use and scale-on-request serverless paradigm in which functions respond to events when needed – without the need for preallocated compute resources. The platform can run anywhere: your laptop our data center, a third party cloud or as an Oracle managed cloud service. This session introduces the Oracle Microservices Platform and demonstrates how it is used to roll out and manage a set of collaborative microservices, both locally and in the cloud.

Bio Lucas Jellema

Lucas Jellema is solution architect and CTO at AMIS, The Netherlands. The running theme through most of his activities is transfer of knowledge and enthusiasm (and live demos). Lucas is JavaOne 2015 Rockstar, Oracle Developer Champion and ACE Director and a frequent speaker at conferences such as Oracle Code, Oracle OpenWorld, JavaOne and Devoxx. He publishes techy stuff at Github, Slideshare, DZone, OTN, and the AMIS Technology Blog (technology.amis.nl). He is the author of two books on Oracle SOA Suite with Oracle Press.

« Back

Lykle Thijssen Lykle Thijssen ACE associate (NL)

Parallel session 7.6 Intermediate

Say NO to Microservices!

« Back

Maarten Smeets Maarten Smeets ACE (NL)

Parallel session 2.8 Intermediate

Quickly create a development VM using Kickstart, Packer, Vagrant, Virtualbox

Using tools like Packer, Kickstart, Vagrant en Virtualbox it is suprisingly easy for any developer to quickly create a development environment from scratch. Kickstart allows the automation of installation of an OS. Packer makes it easy to automate the use of Kickstart to create images of different types. The resulting image can be used as a Vagrant base box. Vagrant makes subsequent VM configuration easy and has various provisioning options such as plain shell files or Puppet. During the presentation I will demonstrate an installation from OS to SOA Suite including database and explain the steps. It is suprisingly easy to get started. Once you have it set-up and you want to upgrade your OS, WebLogic or SOA Suite version, it is easy to recreate a new VM with new versions of software in it with minimal effort.

Bio Maarten Smeets

linkedin.com/in/smeetsm

« Back

Maarten Smeets Maarten Smeets ACE (NL)

Parallel session 5.7 Intermediate

Microservices on Application Container Cloud Service

ACCS provides the perfect cloud service to develop microservices on! In this presentation I'll demonstrate some of recent the highlights for developers such as Ruby support, integration options with the Event Hub, security options, using application caches to increase performance and support for Java EE and Java 9 applications. After this presentation you will have a better understanding of the options provided by ACCS to create microservices quick and easily.

Bio Maarten Smeets

linkedin.com/in/smeetsm

« Back

Maarten Smeets Maarten Smeets ACE (NL)

Parallel session 9.6 Intermediate

Secure your integrations

Security is a hot topic, especially with new laws concerning how to deal with personally identifiable information (PII) and the journey to the cloud many organisations are making. When implemented correctly, security measures can protect your company from people trying to spy on you or manipulate your systems. Security can be implemented at different layers. In this presentation I'll zoom in on application layer and transport layer security. Why should you implement which measure? And which are the general pitfalls? This spans area's like authentication mechanisms, keys/keystores, OWSM policy configuration (for MCS and SOA Suite), WebLogic SSL configuration and cipher suite choices. Security measures are even more relevant in cloud integration scenario's since services might not just be accessible from your internal network. After this presentation, architects and developers will have a good idea on how to quickly get started with taking security measures and which measures to implement for which purpose.

Bio Maarten Smeets

linkedin.com/in/smeetsm

« Back

Marc Kuijpers, Marcel van de Glind, Richard Olrichs Marc Kuijpers, Marcel van de Glind, Richard Olrichs ACE director (NL)

Parallel session 3.6 Intermediate

The Jarvis Pizzeria startup powered by Oracle PCS

In this session we take you along into the world of Oracle Process Cloud Service (PCS). In the last year we started a blogging journey by building the Jarvis Pizzeria use case. Get ready for a deepdive into the rich set of features PCS has to offer. Furthermore, we will discuss the shortcomings and the best practices we encountered along our way. Not only the structured processes will be discussed, we will also cover dynamic processes (case management) which is the latest addition to the PCS product.

Bio Marc Kuijpers, Marcel van de Glind, Richard Olrichs

Richard Olrichs: Oracle ACE Director Richard Olrichs is from the Netherlands, working with Java since 2002 and Oracle Fusion Middleware Technology since 2007. Over the years he developed himself to become an all round senior Fusion Middleware Developer with an interest in the Cloud. Richard runs a blog to share ideas, thoughts and findings about Oracle Fusion Middleware & the Oracle Cloud with the rest of the community. He has been a speaker at several events & companies in the Netherlands (nlOUG, MN, AMIS, The Future Group). He spoke on Tech13, Tech14 & Tech15 by the UKOUG in Manchester, Liverpool & Birmingham as well as Oracle Open World 2014, 2015 & 2017 in San Francisco. Richard has been part of the APAC tour 2017 traveling to Wellington, Auckland & Sydney to present about the Oracle Platform as a Service offerings. Richard has an enormous drive in obtaining new technologies and spends his time inside as well as outside the office to improve his knowledge of and skills in the Oracle Portfolio. Marc Kuijpers: Marc is an experienced developer who worked on a consulting basis for firms as Capgemini and Oracle at numerous clients, both public and private and both national and international. He has an extensive knowledge about the Oracle Fusion Middleware platform built up in the last 8 years and is always looking for ways to deepen that knowledge. Currently, special interest goes out to Oracle’s PaaS offerings, Oracle PCS in particular. Marcel van de Glind: Marcel van de Glind is an experienced developer with all kinds of technology ranging from the second generation language “assembly” to currently popular “Javascript” frameworks. He has always had a special interest in system integration and IT-transcending business processes. Over the last ten years he specialized in Oracle Fusion Middleware development and since three years also in the Oracle Cloud. In the summer of 2015 Marcel already started to blog about PCS. On his personal blog he writes about all kinds of Oracle Middleware and Cloud related topics. Marcel is a frequent visitor of various Oracle community meetings such as OpenWorld (2013), Summer Camps (2012, 2015, 2017) and PaaS forums (2015, 2016, 2017). He has a strong drive to gain new knowledge and to share it with others and expand it together.

« Back

Marco Klaassens Marco Klaassens (NL)

Parallel session 6.4 Intermediate

Should every project have a AI Chatbot component?

In November 2016 NetApp deployed our AI Support Chatbot in production to help customers with support issues 24*7 and to lead customers to succesful solutions. In this presentation i will discuss the intention of the project, the architecture, a demonstration of the bot, the learning model and issue with languages, training set and the outcomes of the project.

Bio Marco Klaassens

8 years Datamanagement. OBIEE certified. BICS certified. Big Data presentations at Tech17 and UK Tech17.

« Back

Markus Flechtner Markus Flechtner (DE)

Parallel session 5.1 Intermediate

Taming the PDB: Resource Manager & Lockdown Profiles

Managing a large multitenant database with many pluggable database can be a difficult task. Many PDBs fight for the server resources like I/O, CPU and memory. It can be difficult to keep the SLAs agreed with your customers. Oracle Database 12c Release 2 offers improvments in resource management for PDBs and a new feature called „Lockdown Profiles“ which helps you to limit the available features on PDB level. The talk shows the various areas of these two features in a CDB environment and shows how they will help you managing a multitenant environment. And both features can help even with a single-tenant database.

Bio Markus Flechtner

Markus Flechtner is a Principal Consultant at Trivadis/Germany. Trivadis is an Oracle Platinum Partner based in Switzerland. Markus has been working with Oracle software for more than 20 years. He started as a developer for Oracle Forms and Reports, but later became a DBA. At Trivadis he specialized on Oracle Real Application Cluster and database upgrade and migration projects. He is a teacher for the Trivadis trainings on Oracle RAC and Oracle Database 12c New Features and he is responsible for all internal projects on database topics at Trivadis. He likes sharing his experience in his blog and on national and international conferences and he is co-author of the (german) book „Der Oracle DBA“.

« Back

Martien van den Akker Martien van den Akker ACE (NL)

Parallel session 4.8 Intermediate

Master your boxes and containers with Vagrant

These days it’s all about virtualization in the form of images/boxes (VirtualBox, VMWare, etc.) and containers (Docker). Most of us have several images for different purposes. And they take a lot of space. But also as often you want to create a new one based on an older one. For instance, because of a new version of the particular software. Because you created a new version of your own application that you want to re-provision. It happens to me that I don’t need an image for a longer while. And when I need it again, I don’t know the state of the particular image. Wouldn’t it be nice if you have a tool and one or two base images and that with one simple command of the tool you can recreate and reprovision an image, based on a project and a set installers? In this presentation I introduce you: Vagrant. And show you how to manage your images with it.

Bio Martien van den Akker

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 parts of SOA Suite. Martien is an expert on the Fusion Middleware components Weblogic, Oracle Service Bus, SOA and BPM Suite and now has his focus on Oracle’s PaaS offering. Martien is employed by Darwin IT-Professionals since 2007, is a frequent speaker and trainer, and blogs enthusiastically. Since november 2017 Martien is awarded with the Oracle ACE award.

« Back

Michel Schildmeijer Michel Schildmeijer ACE (NL)

Parallel session 1.8 Intermediate

Oracle Fusion Middleware: Performance and Diagnostics solutions

Improvement and new insights on getting the best of operational performance of an Oracle Fusion Middleware platform. At customers, usually their technology stack is build on various components of Oracle, such as databases, WebLogic, Oracle Service Bus, SOA and BPM, ADF, WebCenter and so on. This can be a very complicated stack and out of the box parameters are not enough to give an overall good performance and low error rates. This presentation tells you the ins and outs on every layer regarding performance and diagnose methods and tools.

Bio Michel Schildmeijer

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,. 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. He now works mainly with Oracle WebLogic 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 - http://www.packtpub.com/oracle-weblogic-server-12c-first-look/book.

« Back

Mike Donovan Mike Donovan ACE (NZ)

Parallel session 3.7 Beginner

Kafka Connect the Dots: Building Oracle Change Data Capture (CDC) Pipelines With Kafka

The open source streaming data platform, Kafka, is taking the world by storm. In their own predictions for 2017 Oracle even asserted that “Kafka looks to be the runaway Big Data technology of 2017”. This being the case there's no better time to start learning it. So what is it? Well, technically speaking it is a ‘publish-subscribe messaging rethought as a distributed commit log.” It is designed, from the ground up, to be fast, scalable, durable and distributed. In the current business climate where data is a strategic asset Kafka's power lies in its ability to consolidate heterogenous data flows in a single platform, provide stream processing capabilities, and offer integration between a wide variety of disparate data sources and targets. As such it holds promise for Oracle database administrators looking to effectively push valuable Oracle data around their organization, for business benefit. But how do we get Oracle data into Kafka, and what options are there for delivering it on from there? In this presentation we will explore Kafka Connect, an option available in the Kafka ecosystem, described as a high level export/import tool for Kafka. The community developing around this utility offers many options for simple configuration in order to get data from, and deliver to, an array of data stores and points. We will take a look at options as to how we might get Oracle data and log file information into Kafka, and move it on beyond. In this we will also demo an Oracle change data capture process, and push this same data through to file system and Elasticsearch end points. benefits of the session: 1. Understand Kafka and Kafka Connect components and value proposition at a high level 2. Describe the change data capture (CDC) process for an RDBMS (specifically Oracle), tools for this, and its importance in the current big/fast/streaming data environment 3. Learn how to construct and deploy basic end to end data pipelines from the Oracle RDBMS to a variety of endpoints (HDFS, Elasticsearch) with Kafka Connect.

Bio Mike Donovan

Mike joined Dbvisit back in 2007 and currently serves as Chief Technology Officer (CTO). He is enthusiastic about new technologies and working with customers and partners to conceive of and build new bridges between the existing RDBMS world and the new frontiers of Big Data - for business benefit. He is motivated by championing smart, cost-effective approaches and alternatives, such as Dbvisit's products, in the marketplace. Mike has a diverse background in technology and the arts, and considerable experience in technical customer support and software development. He is passionate about Oracle database technology, having worked with it for more than a decade, spoken at numerous industry conferences including OOW, RMOUG, dbtech showcase and Collaborate, spent time as a production DBA, and gained certifications on this RDBMS platform in versions 9i through 12c. Other interests include a love of learning, reading, cooking, and various fitness pursuits, as time permits.

« Back

Milomir Vojvodic Milomir Vojvodic (UA) Oracle

Parallel session 8.6 Intermediate

GDPR - ‘once in a generation’ opportunity for transformation of data and application services governance practices

A GDPR project is a perfect catalyst toward establishing a common data model for customer data, evolving further into a broader effort on enterprise data as a service to support the speed and scale at which customer-facing functions will have to operate to be competitive. Detailed scope of GDPR and necessary preparations to be undertaken are at this moment are areas where enterprises lack knowledge, especially in area of data management, and data and application services governance. In this session we will reveal the list of such activities and projects, their order and their reference architecture : setting up dynamic platform for automatic finding, deleting or reporting GDPR records and data, creating single GDPR view of customer, Identification and management of data flows, loading into a catalog and classifying metadata about identified data elements relevant for GDPR, tracing data flows with data elements and provide answers about which exact data element are used in which business process, building glossary of sensitive data, establishing control with policies and rules, with workflow to monitor data proliferation, extend capabilities of existing applications by modeling process interactions, with other applications or user-channels. Oracle Integration platform tools such are Oracle Enterprise Metadata Manager(OEMM), Oracle Enterprise Data Quality(OEDQ), Oracle Data Integrator(ODI), Oracle Service Oriented Architecture(OSOA), Oracle API Platform(APIPCS), Oracle Business Process Management (OBPM) and their associated cloud services, can help to accelerate the GDPR’s preventive and detective controls. 3 points that the audience can expect to take away from this session 1-There is coherent & extensive list of activities & projects that can help GDPR compliance within the scope of governance of data & application services 2-Oracle Unified Integration platform includes tools which features can be efficiently used for these activities 3-GDPR is an opportunity to achieve commercial long-term benefits, if it evolves into a broader efforts. Governance, integration and data management projects are example.

Bio Milomir Vojvodic

Milomir Vojvodic is a Regional Senior Product Leader for Oracle Integration pillar across whole geography of Europe, Middle East and Africa. He is specialized in data management, data governance, integration, business and IT alignment in cross-functional IT driven programs, than business, market, and technical outbound product management, success of new products across wide geography. He is as well a PhD candidate and is researching and elaborating further in academic circles, addressing state of the art concerns in fields of data related customer centricity and compliance, data economy and data trade.

« Back

Patrick Barel Patrick Barel ACE (NL)

Parallel session 4.3 Beginner

Increase your programming confidence by using Unit Tests.

When we create our programs, just getting it to compile is not enough. We want to test if our code does what it is supposed to do. But testing over and over again is time consuming and mostly boring process. You don’t want to run the same tests over and over again. It worked before, so it will work now, or won’t it? This should be an automated process which you can start whenever you want, even when you’re not present. There are multiple unit testing frameworks and tools available to do this job for you. This session will show a couple of them and will show an in depth analysis of utPLSQL and SQL Developer. Although very different in approach then can both be useful in your development process. We’ll discuss the structure of unit testing: - Setup - Run - Validate - Teardown Then we’ll demonstrate the two products. On the one hand we will see how easy it is to setup utPLSQL and start using it, but also the technical, programmatic, approach that suites developers. On the other hand there is SQL Developer with a more declarative approach to describe and run your tests. We will also see how this can be integrated in a Continuous Delivery method with automated testing. When you are using a unit testing framework then you can be confident you are done programming and your program is working correctly.

Bio Patrick Barel

Patrick Barel is a PL/SQL Developer for AMIS Services [http://www.amis.nl/] in the Netherlands. Besides working with SQL and PL/SQL did he co-develop CodeGen and wrote different plug-ins for PL/SQL Developer. He publishes articles on the AMIS Technology blog and on his own blog . In 2015 he received the Oracle Developer Choice Award in the PL/SQL Category.

« Back

Penny Avril (US) Oracle

Parallel session 3.1

Inside the head of a database hacker

With unprotected assets in plain sight in databases, no wonder hackers seek to steal sensitive data from them. Exploiting common vulnerabilities such as unpatched systems, overprivileged accounts, insecure database configurations, stolen passwords, and unencrypted data is a quick place to start. However, knowing the mind of a hacker can better help you strategize and create a blueprint for protecting your database. This session will take you into the mind of a cybercriminal adept at exploiting vulnerabilities to access sensitive data stored in databases, and then discuss ways to stop them.

« Back

Penny Avril Penny Avril (US)

Keynote 2

Autonomous Data Management

The Cloud may be changing everything, but which cloud is right for your business? The rise of data as a form of capital, and therefore choice of enterprise database cloud, will have a direct impact on the future success of your business. This session focuses on Autonomous Data Management, a new vision for data management in the cloud that offers opportunities for DBAs and can help ensure future business success.

Bio Penny Avril

Penny Avril is a Vice President inOracle Server Technology Division, leading product management for Oracle Database. Her responsibilities include product planning, positioning, collateral, go-to-market strategy and field enablement. She works with release and development managers to take the database from design spec through development to production. Penny has been with Oracle since 1995. She holds a BA in computer science from Cambridge University.

« Back

Penny Avril & Dominic Giles (US) Oracle

Parallel session 1.1

What's New from Oracle Database Development

Oracle Database recently switched to new annual Release Model with Oracle Database 18c the first annual release in the new model. This session is a unique opportunity to get ahead of the curve and learn what's new in Oracle Database 18c directly from the Oracle Database development team. You will also get an update of other interesting tools being released from Oracle Database Development in 2018

« Back

Philippe Fierens & Pieter Van Puymbroeck Philippe Fierens & Pieter Van Puymbroeck ACE (BE) Oracle

Parallel session 4.1 Intermediate

Mirror mirror on the WaLLet: a story about wallets

Your data needs to be secure, this is something that has to be done in your own datacenter but certainly in the cloud. Oracle has lots of products that help you with that TDE SSL certificates LDAP /OUD registration password less oracle rman backups they share one common component… the wallet. The wallet can be file based or HSM based. This session will talk you through on how to set this, one wallet for everything or spread by functionality, should it be stored on a fs or on ASM, When implementing TDE: what issues can you expect and how can you solve them. How do you setup ssl… this session will be packed with info on how to make your database strong again ;)

Bio Philippe Fierens & Pieter Van Puymbroeck

Philippe is an independent oracle dba currently working for a company situated in the banking sector. As a consultant he helps his clients to find efficient, cost efficient, performing and sometimes creative solutions. The last 4 years he worked on engineered systems of the exadata family, first Super Cluster now on Exadata X2 X4 X5 X6. As a consultant he helps his clients to find efficient, cost efficient, performing and sometimes creative solutions. After finishing a migration project involving 3 M9000 s and 2 Oracle T4 Super Clusters, he now works for a customer in the banking sector on Exadata and OVM . When not working with oracle you can find him with his wife and two daughters or behind the camera taking pictures for various occasions and events and hiking with his family in the mountains.

Bio Pieter Van Puymbroek

I am an Oracle dba started in Oracle 9i. I am currently working as a Senior Oracle DBA at Exitas NV . Check their twitter handle (@Exitas_BE) some nice things are shared through there as well. Most of the time I work on short term projects which put me 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. Exadata experience starting from X2 to X7 including complete reinstallation’s and redesigns of the environment. My 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 husband and a dad for my son. The time left I like to spend with sailing and playing the double bass, bass guitar and the saxophone. You can find me on twitter: @vanpupi

« Back

Pieter Van Puymbroeck Pieter Van Puymbroeck ACE

Parallel session 6.2 Intermediate

When Your Database & Application Become 100% Available

Applications based on RAC or Dataguard are expected to deliver service continuity even in case of node crash (RAC) or database failover (Dataguard). Oracle has implemented many solutions like FCF or TAF. These usually need to instrument Java Code to manage this application Continuity. As of Oracle 12c, Oracle released Application Continuity which is a solution that simplifies the way Code has to be written. First, a short product description. Then a lots of examples. The attendee will discover how to configure the Database and how to write Java Code to implement very quickly and easily a simple Application Continuity app. Next, a presentation of Application Continuity Datasources type will be shown: UCP Pooled connection, Weblogic Active GridLink. After those two parts, various cases will be presented when using Application Continuity with RAC, Active Dataguard. Finally, no pain no gain ...overhead will be measured with jvm measurement.

Bio Pieter Van Puymbroeck

I have been French Oracle Consultant since 2001 and have worked on critical systems for many French customers: VLDB, highly critical e-commerce websites, Engineered Systems etc. I have earned many certifications, including Oracle Certified Professional 10g and 11g, Oracle Certified expert and I'm an Oracle certified master 11g and 12c. I actually work for the company I created: Premiseo, a database oriented company. I work as a consultant and help customers build and run scalable Oracle platforms (with Appliances like Exadata or ODA). I also work on many projects to support customers to move their databases platform into the Cloud

« Back

Pieter Van Puymbroeck
Pieter Van Puymbroeck ACE (JO)

Parallel session 8.2 Intermediate

Privilege elevation in the oracle cloud: more access is easier than you thought possible

We can’t continue to multiply our database storage for each preprod, test, dev, etc. environments we have to provision. We need to be agile in that provisioning. Docker. It leverages copy-on-write filesystem and linux containers to bring data containers. So why not use it for our databases?

Bio Pieter Van Puymbroeck

I am an Oracle dba started in Oracle 9i. I am currently working as a Senior Oracle DBA at Exitas NV. Check their twitter handle (@Exitas_BE) some nice things are shared through there as well. Most of the time I work on short term projects which put me 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. Exadata experience starting from X2 to X7 including complete reinstallation’s and redesigns of the environment. My 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 husband and a dad for my son. The time left I like to spend with sailing and playing the double bass, bass guitar and the saxophone. You can find me on twitter: @vanpupi

« Back

Rob Lasonder Rob Lasonder (NL)

Parallel session 3.2 Expert

Golden Gate Replication from AIX to Exadata

Er is een nieuwe Exadata omgeving voor de klant neergezet en de eerste databases zijn gemigreerd naar deze nieuwe (X6-2) Exadata omgeving, tot volle tevredenheid van de klant. Een migratie van de core legacy database van de klant staat pas gepland voor 2019. Toch wil de klant al vast aan de slag met het aabieden van Exadata data reporting services voor deze database. Om in deze behoefte te voorzien is besloten om de database via Golden Gate real time te repliceren van de bestaande (AIX) omgeving naar de nieuwe Exadata omgeving. Met Golden Gate biedt Oracle een software pakket dat bij uitstek geschikt is voor real-time data intergratie en replicatie tussen heterogene IT omgevingen. Bij deze implementatie is de meest recente functialiteit toegepast, waaronder Golden Gate 12.2 integrated extract en replicat en Golden Gate High Availability m.b.v. Oracle clusterware. De Golden Gate configuratie wordt bewaakt m.b.v. de Golden Gate Plugin voor Oracle Enterprise Manager maar ook m.b.v. maatwerk scripts en rapportages. Deze toepassing betreft zeker geen "out-of-the-box" implementatie en het project team zag zich geconfronteerd met diverse uitdagingen waarbij de grenzen van Golden Gate zijn opgezocht. Tijdens de presentatie wordt nader ingegaan op deze zaken, maar ook het implementatie proces, de gekozen architectuur en "lessons learned" komen aan bod.

Bio Rob Lasonder

2016-06-08 OUG NL Exadata DR and Exadata Snapshots 2015-06-04 OUG NL Exadata/Exalogic consolidation (keynote) 2014-06-05 OUG NL Oracle Exa Infrastructure 2013-03-26 OUG (Benelux): Oracle Exadata 2012-02-16 OUG NL: Oracle Exadata Migrations

« Back

Robert Marz Robert Marz ACE (DE)

Parallel session 1.6 Intermediate

Oracle VM Server - The Undocumentation

Oracle VM Server is a powerful virtualization environment. The daily administration tasks can be done via the OVM Manager. But the interfaces have limitations and there are occasions when one needs to look under the hood. This talk introduces features, that are not covered by the documentation: * Dealing directly with the Xen Hypervisor * Manipulating the databases of the OVM Agent * Interesting config files * How File Repositories are organized All examples shown are available for download. The presentation provides detailed live demos.

Bio Robert Marz

Robert Marz is an Oracle ACE and member of 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 German Oracle user group), he is in charge of the Cloud topics inside the database community. Robert is a member of ODTUG, IOUG and RMOUG. More than twenty years of experience in 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, virtualization and cloud technologies. 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

« Back

Robert Marz Robert Marz ACE (DE)

Parallel session 4.2 Intermediate

Automatically deploy schema changes with Ansible and Liquibase

Database schemas and application code are tightly coupled together, but often maintained and deployed separately. The opensource project Liquibase helps you manage your schema changes by writing simple JSON or YAML documents. Liquibase makes it easy to deploy to different flavors of databases and roll changes back and forward. Ansible is an opensource automation tool, that enables you to define and run tasks on a set of remote targets. Like Liquibase changelogs, Ansible playbooks are JSON or YAML documents. Both two tools together enable you to effectively version control your database schema changes and deploy them to multiple hosts at the same time. Agile and DevOps working hand in hand. This talk introduces Liquibase and ansible and demonstrates how to use them together. My session will follow this agenda: • Introduction to Liquibase. • Ansible - a short overview • YAML & JSON: two related file formats • Define changes in Liquibase • Deploy changes with Ansible • Caveats and workarounds All sources and examples will be available for download. This presentation includes live demos.

Bio Robert Marz

Robert Marz is an Oracle ACE and member of 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 German Oracle user group), he is in charge of the Cloud topics inside the database community. Robert is a member of ODTUG, IOUG and RMOUG. More than twenty years of experience in 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, virtualization and cloud technologies. 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 www.its-people.de/blog

« Back

Robert van Mölken Robert van Mölken Developer Champion (NL)

Parallel session 5.6 Intermediate

Top tips for mastering integrations in the cloud

It has been almost two years since the initial release of Integration Cloud Service and a lot has changed since then. This has led to growing adoption of this and other cloud services in the integration space, but best practices for using and integrating them are still in development. This session explores best practices and features of Oracle Integration Cloud Service and present them as byte size tips. The best practices cover areas such as improving productivity, hybrid cloud (cloud to on-premise) integrations, building complex orchestrations, managed file transfers, and practical techniques for working with large transformation and exposing database. This session is presented by one of the authors of the recently published book “Implementing Oracle Integration Cloud Service,” Robert van Mölken.

Bio Robert van Mölken

Robert is an integration consultant at heart and one of the expertise leads on Integration, Blockchain and Cloud at AMIS. He is an respected author, 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 an member of the board of the Dutch Oracle User Group (nlOUG) and also organizes SIG meetups. In 2017, Robert was named Oracle Developer Champion, but also hold the Oracle ACE title, for his contributions to the community. He is co-author of the first Oracle PaaS book published, which was published in January 2017. Robert is one an expertise lead on Integration, Internet of Things and Cloud at AMIS. His fascination for technology had led to the research of Blockchain and is currently writing a book called Blockchain across Oracle.

« Back

Robert van Mölken Robert van Mölken Developer Champion (NL)

Parallel session 8.7 Beginner

Building a practical Blockchain with Oracle's Blockchain Cloud Service

During this deep-dive session you will learn how to build your own practical blockchain using the Blockchain Cloud Service, build on-top of the open-source, freely available Hyperledger Fabric. At the start of the presentation I will shortly introduce the Blockchain Cloud Service and the choice of Hyperledger Fabric in relation to other (private) blockchains. The deep-dive will go through the pre-requirements, how to run a blockchain, generating artifacts, starting and stopping the network and writing your first blockchain application. At the end of this deep-dive you know how to setup a practical blockchain and understand the concepts behind it.

Bio Robert van Mölken

Robert is an integration consultant at heart and one of the expertise leads on Integration, Blockchain and Cloud at AMIS. He is an respected author, 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 an member of the board of the Dutch Oracle User Group (nlOUG) and also organizes SIG meetups. In 2017, Robert was named Oracle Developer Champion, but also hold the Oracle ACE title, for his contributions to the community. He is co-author of the first Oracle PaaS book published, which was published in January 2017. Robert is one an expertise lead on Integration, Internet of Things and Cloud at AMIS. His fascination for technology had led to the research of Blockchain and is currently writing a book called Blockchain across Oracle.

« Back

Robin Buitenhuis Robin Buitenhuis voorzitter (NL) nlOUG

Welcome

« Back

Ron Ekins Ron Ekins ACE (UK)

Parallel session 6.1 Intermediate

DevOPS, Ansible and automation for the DBA

In this presentation I will introduce the Open Source DevOps automation tool Ansible, and share examples of how DBA actives can be automated with Ansible. Throughout the session I will provide code examples and end with a live Oracle 12c database cloning demo.

Bio Ron Ekins

Oracle Solutions Architect with 25 years experience with Oracle technology and Applications. Oracle ACE and regular speaker at various industry events including UK OUG, Scotland OUG, Ireland OUG, Finland OUG, Oracle World, DOAG and UNIX events. Co-Chair of UK OUG Database SIG.

« Back

Ruben Rodriguez Ruben Rodriguez ACE (ES)

Parallel session 5.5 Intermediate

Best Practices Implementing Oracle Mobile Cloud Service

‘Going mobile’ means more than just creating a mobile application. Enterprises need to have a Mobile Strategy that enables them and not just to have one great app. Enterprises need a scalable, efficient and robust platform that allows them to solve common mobile challenges that any mobile project may face. Challenges like the integrating existing systems, managing push notifications, collecting analytics, mobile storage, database or securing the access to application resources and the application itself. Oracle Mobile Cloud Service (Oracle MCS) provides solutions for these common challenges as well as developer productivity tools like SDKs that allows us to easily integrate everything what Oracle MCS have to offer, and also add extensive logging and lifecycle management. In this session we will explore the motivation that drove two mobile projects as well as the problems we faced and how to solve them.

Bio Ruben Rodriguez

Rubén Rodríguez has been developing web and mobile applications using Oracle technologies since his degree in Computer Science. He now works as an Oracle ADF Technical Lead and Oracle PaaS Solution Specialist in a Spanish Platinum Partner, avanttic where he is focusing on developing solutions with Oracle PaaS and Oracle Application Development Tools and Frameworks for different customers of different sectors. Apart from his work commitments, Rubén is a regular contributor to the Oracle community, and he maintains blogs in Spanish and English. Ruben is also a speaker in different events and conferences such as Oracle OpenWorld, Oracle PaaS Community Forum, OTN Tour EMEA and UKOUG Tech.

« Back

Sabine Heimsath Sabine Heimsath ACE (DE)

Parallel session 6.3 Intermediate

"With a little help from my friends..." - How to instrument your PL/SQL code easy and effectively

Do you measure how your code is performing? Do you have the right info at hand when your program fails? Can you monitor your program while running? This session is all about instrumenting your PL/SQL code, be it inside an APEX application or in a pure PL/SQL environment. What are the alternatives to the very common hand-knitted or organically grown solutions? We are going to look at a several open-source frameworks and analyse which requirements they can cover and what you might have to add yourself. After this session, you will know what to look for when choosing the right framework to enhance your project. The frameworks are - Logger - Log4PL/SQL - PL/SQL Instrumentation Toolkit (PIT) - Instrumentation Library for Oracle (ILO/OLF) - BMC_DEBUG

Bio Sabine Heimsath

Sabine studied Information Science in Münster where she discovered her love for spreadsheets, relational databases and data modelling. After her diploma in 1999 she started her professional career with Oracle Consulting in Frankfurt. Working for several customers she developed her skills in PL/SQL, Java and WebDB. After another year doing product development she decided she wanted to be in consulting again and became a freelancer with its-people GmbH. Since then, Sabine has done many projects in different industries, which are all centered around the Oracle Database, be it Reporting, Migrations, Application Development with APEX or pure PL/SQL. SQL Developer has become one of her favourite tools. She is a blogger, trainer and speaker at different conferences like DOAG, POUG, APEX Connect, APEX World and UKOUG and organises the APEX Frankfurt Meetup. Besides, she is in charge of DB Development topics within DOAG and happens to be Germany's first female ACE. Sabine loves Lego, Aardman Animations and fantasy literature.

« Back

Sander Van Laar Sander Van Laar (NL)

Parallel session 7.7

Data storage in a blockchain: practical experiences

One of the definitions of Blockchain is: a distributed, immutable, secure and persistent storage medium. Does the rise of blockchain technologies mean the end of traditional databases? In a project with one of our customers we used blockchain to store data of ownership of physical stock. These data were generated in the process of storing and trading stock. The blockchain has advantages as well as disadvantages. In this presentation the difference between blockchain and traditional SQL or NoSQL databases are explained, based on real cases.

Bio Sander Van Laar

Sander van Laar is a former lecturer from Fontys University, where he was considered an expert in database technology and data science specialist. Currently he is working for SynTouch as a blockchain consultant. In this role he gives presentations at seminars, advises companies on their blockchain strategy and uses his hands-on experience in programming Smart Contracts.

« Back

Soham Dasgupta Soham Dasgupta (NL)

Parallel session 6.5 Beginner

Make declarative UI development with Visual Builder Cloud Service

ABCS was introduced as a tool for citizen developers, for no-coders, but with the new name and version VBCS is now a complete tool for UI development. Not only citizen developers, it provides tools and technique to build an enterprise UI in cloud. In this session we will show how to build an UI declaratively and also tips/techniques, best practices to implement complex business requirements.

Bio Soham Dasgupta

Soham Dasgupta has been working with Oracle technologies for more than 12 years. He is presently working as a Senior Consultant for Capgemini Netherlands. His primary skills include ADF, Java, NodeJS, OracleJET, Chatbots and Oracle PaaS Products. He works as UI Technical Lead for Capgemini Netherlands. Soham is a frequent blogger and speaker on various Oracle User Group Conferences across the Netherlands, Norway, and Germany. Rubén Rodríguez has been developing web and mobile applications using Oracle technologies since his degree in Computer Science. He now works as an Oracle ADF Technical Lead and Oracle PaaS Solution Specialist in a Spanish Platinum Partner, avanttic where he is focusing on developing solutions with Oracle PaaS and Oracle Application Development Tools and Frameworks for different customers of different sectors. Apart from his work commitments, Rubén is a regular contributor to the Oracle community, and he maintains blogs in Spanish and English. Ruben is also a speaker in different events and conferences such as Oracle OpenWorld, Oracle PaaS Community Forum, OTN Tour EMEA and UKOUG Tech.

« Back

Stefan Panek Stefan Panek ACE (DE) Oracle

Parallel session 9.8 Intermediate

Exadata all in (Lifecyle & Support Essentials)

First of all I will give an overview of an Exdata and how to implement such kind of Engineered System in an IT Organisation. Starting from the normal Day by Day business I describe how the Patching Process will be done including all components from Infiniband, Storage Server, DB Nodes to the Grid and RDBMS Software. This will reflect the actual Exadata Software based on Exa Software 12.2. (Exadata 18.1 was also setup by me for testing). But very important is also to understand and handle the Oracle Support Essentials to be handy with the Support Process and the very helpful Service Request Data Collection Catalog which I will show. So the Presentation is for Beginners and also for Exadata Machine Administrators or who would like to work in the Future in this area. IT Managers may also be interested to understand the Process behind an Oracle Exadata Database Machine Lifecycle.

Bio Stefan Panek

I have been French Oracle Consultant since 2001 and have worked on critical systems for many French customers: VLDB, highly critical e-commerce websites, Engineered Systems etc. I have earned many certifications, including Oracle Certified Professional 10g and 11g, Oracle Certified expert and I'm an Oracle certified master 11g and 12c. I actually work for the company I created: Premiseo, a database oriented company. I work as a consultant and help customers build and run scalable Oracle platforms (with Appliances like Exadata or ODA). I also work on many projects to support customers to move their databases platform into the Cloud.

« Back

Tim Hall Tim Hall Developer Champion (UK)

Parallel session 5.3 Intermediate

Make the RDBMS Relevant Again with RESTful Web Services and JSON.

The rise of Javascript has made JSON support an essential part of most systems. This session describes ways to add JSON support to your existing applications using a variety of tools including Oracle REST Data Services (ORDS), the APEX_JSON and APEX_WEB_SERVICE packages and the JSON support built into Oracle Database 12c.

Bio Tim Hall

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 900 articles, is an Oracle ACE Director, Oracle Developer Champion, OakTable member and has presented at numerous user groups and conferences worldwide.

« Back

Tim Hall Tim Hall Developer Champion (UK)

Parallel session 9.2 Beginner

DBA Does Docker

Since Oracle announced support for some of their products on Docker there has been a flood of posts on Oracle blogs about Docker, but very few seem to tackle the hard questions. This session takes a look at Docker from a DBA perspective, demonstrating what it does well, and more importantly what it doesn't.

Bio Tim Hall

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 900 articles, is an Oracle ACE Director, Oracle Developer Champion, OakTable member and has presented at numerous user groups and conferences worldwide.

« Back

Toon Koppelaars Toon Koppelaars (NL) Oracle

Parallel session 2.3 Intermediate

Database Design Thoughts

The foundation of every database application is its database design, a.k.a. its data model. Having a good database design is the primary driver in being able to both achieve good performance, as well as adapt to changing requirments. A good database design a) fits the business requirements, and b) follows sound relational principles. Developing a design that fits the requirements mainly involves experience and creativity. Following sound relational principles requires professionalism, i.e. understanding the roots of the relational database profession, and not shying away from learning a bit of set-theory and formal logic. During the talk we'll touch an all the major principles in this area and discuss performance and maintainability implications.

Bio Toon Koppelaars

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. 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 Smart Database paradigm.

« Back

Wouter van der Brugghen OracleOracle

Parallel session 2.10 [Workshop / Handson Lab / BYOD!]

Introduction to Data Visualisatie

Data visualization describes the presentation of abstract information in graphical form. Data visualization allows us to spot patterns, trends, and correlations that otherwise might go unnoticed in traditional reports, tables, or spreadsheets. Oracle Data Visualization is easy to use, yet powerful enough to perform advanced calculations.

This session is an introduction to Oracle Data Visualization and will cover:
  • Automatically visualize data as you drag and drop attributes, chart, and graphs
  • Blend and visually analyze both enterprise and personal data
  • Change layouts to present new insights
Install Oracle Data Visualization in advance via:
www.oracle.com/technetwork/middleware/oracle-data-visualization

Bio Wouter van der Brugghen

Wouter van der Brugghen is Pre-Sales Director for Analytics and Big Data in the Benelux. He has been working with Oracle for 20 years in the area of analytics. He often presents as key-note speaker on events. He is passionate about Data Visualization and Storytelling and helps customers to turn data into capital.

« Back

Wouter van der Brugghen OracleOracle

Parallel session 3.10 [Workshop / Handson Lab / BYOD!]

Machine Learning in the Oracle Analytics Cloud

Modern analytic platforms have machine learning embedded. Machine Learning removes human bias and imagination, considers vastly more information, is incapable of missing key signals and does everything in a fraction of the time. Sure, the machine might not provide a 100 percent complete picture, and some human interpretation may be required, however, if our objective is to become more efficient with better accuracy, then machine learning saves tons of time—and time is money.

The key is that machine learning is placed into the hands of the business professionals, the end users. There is no requirement to present the problem to a data scientist (and their team) who use extremely complex and expensive tools to power machine learning to generate results days later.

In this session will cover:
  • How a business user can ask the visualization tool to explain an attribute in context of the other attributes and metrics in the dataset
  • How a business user can apply popular R-algorithms with a right mouse-click
  • How easy it is to create a predicative models and share a model with Business Professionals.
Install Oracle Data Visualization in advance via:
www.oracle.com/technetwork/middleware/oracle-data-visualization

and install Advanced Analytics and DVML via Start->Oracle

Bio Wouter van der Brugghen

Wouter van der Brugghen is Pre-Sales Director for Analytics and Big Data in the Benelux. He has been working with Oracle for 20 years in the area of analytics. He often presents as key-note speaker on events. He is passionate about Data Visualization and Storytelling and helps customers to turn data into capital.

« Back