UKOUG Tech17 is a wrap

Last week I have attended the UKOUG Tech Conference at the ICC in Birmingham. This conference is a combined conference with APPS-, TECH- and JDE-related content. Quistor was present with a stand at the JDE-conference. For me, these kinds of events are a way of exchanging knowledge and meeting old and new friends.

I have been given the privilege to speak. My first presentation was about ‘Becoming Insight Driven With Big Data’. This was basically an overview of Oracle’s answer to the changing needs in the Data and Analytics atmosphere. The second presentation tried to answer the question; ‘Is Data Warehousing Dead’. During this presentation, I discovered that preparing for two presentations at one conference (which I have never done before) is more work than I had expected. It took me too much effort to get the story across. This is a lesson for next time so I will be better prepared.

For those interested, I uploaded my slides to Speaker Deck.

Becoming Insight Driven with Big Data – https://speakerdeck.com/daanalytics/becoming-insight-driven-with-big-data …

Is Data Warehousing dead? – https://speakerdeck.com/daanalytics/is-data-warehousing-dead …

In the Christmas edition of Quistor’s QPulse there are two articles from my hand with some more insight of my visit to Birmingham. I have attended several presentations. If I may highlight a few, I would first like to mention Robin Moffat, because he is so passionate about his topic; Kafka. Rob Cowell showed excellent skills explaining Oracle Big Data SQL. Last but not least Mike Vickers managed to get his story about Oracle BI Publisher across in a very structured manner. If I compare their performance to mine, there is some room for improvement 😊.

Still for me personally, it was great to meet ‘old’ and new friends. There was also an offline presence of the #obihackers IRC channel. Finally, a chance to meet people in real-life instead of from behind the keyboard.

Thanks, UKOUG, for the organization and for giving me the opportunity to be part of your conference. I had a great time and I hope to be back next year in Liverpool.

Don’t forget to submit your paper for Tech Experience on the 7th & 8th of June 2018! Submit your paper on http://www.tech18.nl. More info here.

 

Originally written for LinkedIn.

Call for Papers nlOUG Tech Experience 2018

#nlOUGTech18 | Vanwege groot succes kondigt de nlOUG graag aan dat de Tech Experience in 2018 wederom zal plaatsvinden! | Due to great success, the Dutch Oracle User Group (nlOUG) is very happy to announce that the Tech Experience will again take place in 2018!

English version below

Vanwege groot succes kondigt de nlOUG graag aan dat de Tech Experience in 2018 wederom zal plaatsvinden!

Het concept blijft hetzelfde, verspreid over twee dagen zullen er presentaties gegeven worden die de complete Oracle Technology Stack bedienen. Het congres zal net als vorig jaar plaatsvinden in De Rijtuigenloods in Amersfoort (onder voorbehoud). Noteert u de datum alvast in uw agenda!

Datum: 7 en 8 juni 2018. 

De nlOUG wil haar leden en andere geïnteresseerden vragen een bijdrage te leveren aan het programma. We zijn dan ook op zoek naar aansprekende klant- 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 24 december 2017 uw abstract in via http://www.tech18.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 met het secretariaat via: secretariaat@nloug.nl

Due to great success, the Dutch Oracle User Group (nlOUG) is very happy to announce that Tech Experience will again take place in 2018!

The concept will remain the same. During a two-day programme there will be presentations that serve the complete Oracle Technology Stack. The venue will again be the Rijtuigenloods (with reservation).

Date: June 7th & 8th 2018. 

The nlOUG 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.tech18.nl/ before the 24th of December. 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 nlOUG: secretariaat@nloug.nl

Please check out some impressions from the last event.

I hope to see you all next year.

Originally published for LinkedIn.

Check out the 2017 UKOUG Conference agendas.

Last week I announced that I will be speaking at the UKOUG Tech17. Today I can announce that the 2017 UKOUG Conference Agendas are now live! Check out the agendas for the co-located UKOUG conferences for Apps17JDE17 and Tech17.

I will be part of the Business Analytics track. For me personally it is a great honour to be part of this track.

I will be presenting on Monday 4 December at 09:00-09:50 and Wednesday 6 December at 12:25-13:15.

Check out the complete line up here.

Also special attention for other Quistor activities at the UKOUG 2017 Conference. Quistor is one of the sponsors of the UKOUG JD Edwards Conference & Exhibition 2017. My colleague Jack van den Brink will be hosting three sessions:

It will be a challenge to pick and choose. See you all next December 2017.

Originally written for LinkedIn.

I am speaking at UKOUG Tech17

Last Friday I received confirmation that my papers for next UKOUG Tech17 in December are accepted. I will be talking about Oracle (Big) Data (Warehousing). The presentations will cover different aspects of the Oracle Data Management ecosystem.

Presenting at the UKOUG Tech17 will be a challenge, but I am really looking forward to it. It will give the opportunity put myself and my employer Quistor on the map. Quistor is always present at the UKOUG JD Edwards Conference & Exhibition. Next to our JD Edwards activities, Quistor is also active in the Business Analytics and Big Data market. Therefor it is great that we are offered the opportunity to be part of the UKOUG Tech17.

I am expecting a great lineup in the Business Analytics track. It will be great to meet ‘old’ and new friends. There will also be an offline presence of the #obihackers IRC channel. Finally a chance to meet people in real-life instead of from behind the keyboard.

See you all next December 2017.

Originally written for LinkedIn.

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