nl.OUG Tech Experience 16 June 2017

Today the second day of the nl.OUG Tech Experience took place in ‘De Rijtuigenloods’. After a really interesting first day it was a real challenge to be at least as good as the day before on day 2. Also for this day the Dutch Oracle User Group has prepared an interesting and varied program. It is nice to see that there was a mix of people which represented the Oracle Community. There where ACE’s and non-ACE’s, men and also women, veteran speakers and relatively newbies (including myself), young and old, Dutchies and foreigners. All in all a great mixture of people with all the same goal; exchanging knowledge, meeting (new) people and having a lot of fun.

Duncan Mills (Oracle) kicked off the day explaining how he loves instead of fears the (Oracle) Cloud.

 

One of the things Duncan has learned in his long impressive career is to be pragmatic. You should make your life as easy as possible. The Cloud offers various tools to support this. In the end the Cloud is a ‘Force Multiplier’ for developers

After the keynote the Experience continued with the different parallel sessions. Also today, one of the SIG-Leads of the nl.OUG, I had the privilege to be part of the BIWA-track (Business Analytics & Data Integration). Today we had four different parallel tracks.

“Migration steps from OWB to ODI” – Gurcan Orhan

Oracle Data Integrator (ODI) is Oracle’s flagship product when it comes to Data Integration (ETL / E-LT). Officials Oracle Warehouse Builder (OWB) does not exist anymore. Still lot’s of company’s are using OWB. Migrating from OWB to ODI is not that easy by default. Gurcan explained which migration steps could make this process a bit easier.

“Introduction in Big Data Cloud Service and Use case” – Marco Klaassens & Daan Bakboord

When you talk about Big Data and the Cloud, Oracle might not be the first supplier people think about. Still Oracle is making serious progression when it comes to the various Cloud products. With an introduction into the Oracle Big Data Cloud Services, all the products could be placed into the context of the Oracle Information Management Reference Architecture. These architectures always make more sense when explained by a real use case.

“Oracle BI is just Lego for adults”

“A Day in the Life of an Oracle Analytics Query” – Christian Berg

When Christian Berg takes the stand you always know his message is supported by sarcasm, fun and beer. It does not matter which product you use in the Oracle Analytics stack, they are all based on the same core. With Oracle Analytics you don’t write a query (just use Oracle SQL Developer for that. Easier and cheaper). Oracle Analytics generates a query based on the metadata you provide. Therefore it is essential to understand how a query is constructed.

Of course Christian had one of the best one-liners of the day; “Oracle BI is just Lego for adults”. Different components fit together to make e.g. the perfect query. If one component does not fit, you don’t get a saw to make the component fit, you try another one which is made to fit in that place.

“Collaboration on analystics in the Oracle Business Intelligence and Data Visualization Cloud Service” – Hasso Schaap

There are several reasons to collaborate on Analytics. Sharing Insights and Story telling are just two examples. Oracle Analytics offers various options to collaborate. Hasso made some reusables. Get into contact with him and start collaborating.

At the end of two really great days, Lucas Jellema wrapped up the experience. With a few salutes, to the board of the nl.OUG for being so brave to host this event, to the audience for joining the conference and to the speakers who were well prepared and willing to share their experiences.

Special thanks to the sponsors.

 

It was a really great event. I enjoyed it a lot. It’s great meeting ‘old’ friends and meeting new ones. The bar is set high for next years experience. Already looking forward!

Download presentations from #OGhTech17 from https://www.nloug.nl/handouts.aspx – only a few slidedecks available, more to follow soon.

See you all next year.

Originally written for LinkedIn

nl.OUG Tech Experience 15 June 2017

Today the first day of the nl-OUG Tech Experience took place in ‘De Rijtuigenloods’. De Dutch Oracle User Group has prepared an interesting and varied program with different speakers from various countries covering almost the complete Oracle RedStack.

 

But first Chairman Robin Buitenhuis kicked of the #OGhTech17 and announced the name change of the OGh. From now on it will be nl.OUG!

Sesame Street SQL

After Robin’s introduction, Maria Colgan from Oracle took the stand. She covered the struggle between developers & dba’s while developing applications. With the (new) Oracle 12c database there is less reason to argue. Here presentation covered subjects like JSON, REST and Docker. In the end Maria could conclude that the Oracle 12c database is the ‘Universal Peace Maker’. Check some more here, to get an impression about some of things Maria showed.

Maria must have had the best term of the day by using; ‘Sesame Street SQL’ which refers to some easy lines of SQL code.

The Experience continued with the different parallel sessions. As one of the SIG-Leads of the OGh I had the privilege to be part of the BIWA-track (Business Analytics & Data Integration). Today there were five different parallel tracks.

“Is Oracle the best Language for Statistics.” – Brendan Tierney

Oracle comes with over 300+ statistical functions. These statistical functions are available in all version of the Database. When people are performing statistical analytics it’s always about Excel and R. When doing statistical analysis in the database, there is no need to extract any data onto client machines. It would also eliminate the possible data security issues with using Excel, R or any other tools.

“OBIEE DevOps with Containers: How and Why?” – Gianni Ceresa

Business Analytics development processes should be flexible and agile. Oracle BI is not that flexible and agile by default. A DevOps strategy can be implemented with the help of Docker containers, version control software (e.g. Git) and continuous integration (GitLab) tooling.

“Running R in your Oracle Database using Oracle R Entreprise” – Brendan Tierney

After Brendan’s first presentation one could think there is no need using R. One can do it all with Oracle Database statistical functions. In this presentation we got an introduction into Oracle R Enterprise. Combining the power of R with the in-database Data Mining / Advanced Analytics capabilities.

“Data Modeling, BI Modeling and-or Data Blending & Wrangling. What should I do?” – Hasso Schaap

In Analytics it’s all about data. There are various ways to use this data. If you choose to use it directly you can just blend and wrangle the data in your self-service tool. In some cases it might be better to prepare, govern and secure the data. There will be a need to model the data, either upfront (Conceptual, Logical and Physical) or in the Business Analytics Tool.

“EDQ, OGG and ODI over Exadata in the Cloud for Perfection” – Gurcan Orhan

The BIWA track concluded this day with a taste of pizza as a metaphor of the various Oracle Data Integration tools (EDQ – Enterprise Data Quality, OGG – Oracle Golden Gate and ODI – Oracle Data Integrator) assembled on the Oracle Exadata Machine. Hardware and Software integrated together both On-Premise as well as in the Cloud.

All in all a very interesting day and (hopefully) a start of a new tradition in Oracle Redstack knowledge exchange in the Netherlands.

Originally written for LinkedIn.

BIWA sessions OGh Tech Experience 2017

Thursday 15 juni

10:20 – 11:05
Brendan Tierney
Is Oracle the best Language for Statistics.

11:30 – 12:15
Gianni Ceresa
OBIEE DevOps with Containers: How and Why?

13:30 – 14:15
Brendan Tierney
Running R in your Oracle Database using Oracle R Entreprise

14:30 – 15:15
Hasso Schaap 
Data Modeling, BI Modeling and-or Data Blending & Wrangling. What should I do?

16:00 – 16:45
Gurcan Orhan
EDQ, OGG and ODI over Exadata in the Cloud for Perfection

Friday 16 juni

10:15 – 11:00
Gurcan Orhan
Migration steps from OWB to ODI

11:15 – 12:00
Marco Klaassens & Daan Bakboord
Introduction in Big Data Cloud Service and Use case

13:30 – 14:15
Christian Berg
A Day in the Life of an Oracle Analytics Query

14:30 – 15:15
Hasso Schaap
Collaboration on analystics in the Oracle Business Intelligence and Data Visualization Cloud Service

Tech Experience 2017 – An inspiring source of Oracle knowledge

On June 15th & 16th the Dutch Oracle Usergroup will organise its first “Tech Experience”, a full stack Oracle Technology Conference, covering everything from EngSys and DBA to Development and BI.

English version below

OGh_logo_op_witOp 15 en 16 juni organiseert de OGh haar eerste “Tech Experience”, een tweedaags event dat de complete Oracle Technology Stack zal bedienen: van EngSys en DBA tot Development en BI. Heeft u uw toegangspas al bemachtigd?

Keynote sprekers zijn Maria Colgan (Oracle), Duncan Mills (Oracle) en Lucas Jellema (AMIS). Met meer dan 50 sprekers, waaronder Tim Hall, Christian Berg, Chris Saxon, Toon Koppelaars, Geertjan Wielenga, Grant Ronald, Ralf Muller, Frank Nimphius en Steven Davelaar verdeeld over 9 parallel sessies, kijken we uit naar een veelbelovend en leerzaam programma!

De verschillende tracks waar u aan deel kunt nemen zijn:

  • DBA
  • PL/SQL & SQL
  • BIWA
  • Web & Mobile
  • Integration & Process
  • Cloud Application Foundation (CAF)
  • EngSys
  • WebCenter

Voor het complete overzicht van alle presentaties kijkt u in het programma.

Het congres vindt plaats in de “Rijtuigenloods”, een industriële locatie vanwege haar voormalige functie waar treinwagons hersteld en geschilderd werden. De Rijtuigenloods is gevestigd in Amersfoort, direct naast het centraal station. U kunt ook gewoon met de auto komen want de Rijtuigenloods biedt meer dan genoeg gratis parkeerplekken.

De toegangspas geeft u twee dagen toegang tot het congres, bovendien hebben we op donderdag een onderhoudend avondprogramma voor u samengesteld waar u op de foodmarket van gerechten uit verschillende windstreken kunt genieten.

Inschrijven

Hotel boeken?

Tech Experience 2017 wordt mede mogelijk gemaakt door: AMIS, diamond sponsor / Conspect ICT, gold sponsor / Qualogy Consultancy, gold sponsor / SynTouch, gold sponsor / Simtech Consulting, gold sponsor / Transfer Solutions, silver sponsor / Quistor Enterprises B.V., silver sponsor / Darwin-it Professionals, bronze sponsor


On June 15th & 16th the Dutch Oracle Usergroup will organise its first “Tech Experience”, a full stack Oracle Technology Conference, covering everything from EngSys and DBA to Development and BI. Do you already have your ticket?

Keynote speakers are Maria Colgan (Oracle), Duncan Mills (Oracle) and Lucas Jellema (AMIS). With more than 50 speakers, among whom Tim Hall, Christian Berg, Chris Saxon, Toon Koppelaars, Geertjan Wielenga, Grant Ronald, Ralf Muller, Frank Nimphius and Steven Davelaar covering 9 parallel tracks we are looking forward to a very promising and educational program.

The different tracks you can participate in are in example:

  • DBA
  • PL/SQL & SQL
  • BIWA
  • Web & Mobile
  • Integration & Process
  • Cloud Application Foundation (CAF)
  • EngSys
  • WebCenter

Please consult the program for an overview of all presentations.

The conference will take place in the “Rijtuigenloods”, an industrial looking place because of its former use for railcars to be restored and painted. The Rijtuigenloods is located in Amersfoort, next to the central station, however it offers enough free parking places as well.

The entrance ticket will give you access to the two-day conference and the evening program on Thursday where you can enjoy a food market with meals from different places in the world.

Register

Looking for a hotel?

Tech Experience 2017 is sponsored by:

AMIS, diamond sponsor / Conspect ICT, gold sponsor / Qualogy Consultancy, gold sponsor / SynTouch, gold sponsor / Simtech Consulting, gold sponsor / Transfer Solutions, silver sponsor / Quistor Enterprises B.V., silver sponsor / Darwin-it Professionals, bronze sponsor

Call for Papers Tech Experience 2017 is open!

English version below

Op donderdag 15 en vrijdag 16 juni 2017 organiseert de OGh haar eerste Tech Experience 2017, dit is een samensmelting van de succesvolle OGh Fusion Middleware Experience en de DBA & SQL Celebration Day. Dit tweedaagse event zal dus de complete Oracle Stack bedienen. Het zal gehouden worden in de rijtuigenloods in Amersfoort (de locatie is nog onder voorbehoud). De OGh wil haar leden en andere geïnteresseerden vragen een bijdrage te leveren aan het programma. We zijn dan ook op zoek naar aansprekende klanten presentaties en technische presentaties.

De eisen die we stellen aan de presentaties zijn:
– Een onafhankelijk, niet-commercieel verhaal
– De business case wordt bij voorkeur door de klant zelf gepresenteerd
– De technische aspecten worden bij voorkeur door een technisch inhoudelijke expert belicht
– De betreffende case is actueel, met andere woorden, maximaal 1 jaar oud.
– De presentatie dient een uitdagend/vernieuwend karakter te hebben, liefst zodanig dat het de bezoekers aan het denken zet en discussie uitlokt.

Heeft u een aansprekende presentatie die u wilt delen met uw vakgenoten? Dien dan uiterlijk 15 januari 2017 uw abstract in via http://www.tech17.nl. Nadat we uw inzending hebben ontvangen zal het organisatiecomité deze beoordelen en u hierover informeren.

Voor meer informatie en sponsorinformatie kunt u contact opnemen via: secretariaat@ogh.nl


Thursday 15th and Friday 16th of June, the Dutch Oracle Usergroup (OGh) is organising the Tech Experience 2017, last year’s Oracle Fusion Middleware Experience and DBA & SQL Celebration Day will join forces in one event, covering the full Oracle Stack in this two day event. The location (with reservation) will be rijtuigenloods in Amersfoort. The OGh wants to ask its members and other interested parties for a contribution to the program. We are therefore looking for compelling customer presentations and technical presentations.

The requirements we place on the presentations are:
– An independent, non-commercial story.
– The business case is preferably presented by the customer.
– The technical aspects are preferably illuminated by a substantive technical expert.
– The case is relevant, in other words, not more than one year old.
– The presentation must have a challenging / innovative character, preferably to let the visitors think about the topic and provoke discussion.

Do you have an inspiring presentation you want to share with your peers? Please fill in the form at http://www.tech17.nl before the 15th of January 2017. After we’ve received your form, the programme committee will judge the presentation and contact you.

For more information and sponsorship information please get in contact with OGh: secretariaat@ogh.nl

Wat hebben kippen en de Cloud met elkaar gemeen? (Dutch)

Binnen de BIWA SIG worden diverse onderwerpen en thema’s behandeld binnen de vakgebieden Business Intelligence (BI) en Data Warehousing (WA). In Oracle termen vertaalt zich dat in Business Analytics en Data Integration.

Wilt u het antwoord weten op bovenstaande vraag? Kom dan naar de eerstvolgende BIWA SIG (Special Interest Group) meeting van de OGh.

Tijdens deze avond zullen er twee producten (Oracle BI Cloud Services en Oracle Data Visualization) uit de Oracle Business Analytics Suite aan bod komen.

De volgende onderwerpen zullen behandeld worden.

Qcompany presenteert; “Chickens in the Cloud”

Oracle Business Intelligence Cloud Services werd bij 1 van de grootste fastfoodketens geïmplementeerd in minder dan 2 maanden door Qcompany B.V.

Een presentatie over hoe je succesvol een Oracle Cloud Business Intelligence Platform realiseert op miljoenen rijen data.

BI Modernization (hands-on) Workshop

Samen met Oracle NL organiseren wij een hands-on workshop over BI Modernisering. Doe mee aan deze en ervaar vanaf uw eigen laptop (liefst 8 GB geheugen of meer) met de onlangs vrijgegeven Data Visualization Desktop wat Oracle Data Visualization voor u kan betekenen!

De meeting zal gehouden worden op dinsdag 11 oktober 2016 aanstaande

Volg deze link voor meer details en inschrijving.

Daan Bakboord

BIWA SIG Bijeenkomst op donderdag 26 mei 2016

Donderdag 26 mei 2016 was er een BIWA SIG Bijeenkomst van de OGh. De onderstaande onderwerpen zijn behandeld:

Metadata Management met Oracle Enterprise Metadata Management (OEMM). Eric van Ettekoven van Oracle gaf ons een introductie van deze tool waarmee zowel Data Lineage als Impact Analyse van Informatie systemen een stuk eenvoudiger wordt.

De presentatie van Eric is hier; http://bit.ly/OGh26052016oemm te downloaden.

Robbert Naastepad van MN gaf ons een inkijk in de Informatie Architectuur op basis van Oracle Data Integrator in combinatie met de Exa-hardware (Exadata & Exalogic) van Oracle. Robbert liet zien tegen welke uitdagingen je in deze betreffende architectuur kunt aanlopen en behandelde mogelijke oplossingen.

Ook de presentatie van Robbert is te downloaden en wel hier; http://bit.ly/OGh26052016ODI_Exa.

Over een volgende BIWA SIG Bijeenkomst wordt ook al nagedacht. Deze zal waarschijnlijk ergens na de zomer gehouden worden.

Mogelijke onderwerpen:

Oracle R (klantcase)
Oracle BI Cloud Service (klantcase)
Data Virtualistie
Oracle BI and Spatial

Mochten er andere interessante onderwerpen zijn laat dan even een berichtje achter of neem contact met mij op.

Hopelijk tot een volgende keer!

Daan Bakboord