KETTLE COMMUNITY MEETING 2019

Announcing Kettle Community Meeting 2019

After #pcm14 and #pcm16, the Pentaho Community Meeting in 2014 and 2016, Antwerp will host the community for a third time with #kcm19. 

Just like the previous editions, #kcm19 will be on Nov 22-24 2019 at Hof Van Liere. See below for more details.  

 

 

 

 

 

 

 

 

 

Welcome to KCM19!

A huge THANK YOU to everyone who attended KCM19! 
This edition wouldn't have been possible without YOU! 

kcm19-crowd

(picture via Ken Wood)

We'll add updates here as the organization of the event progresses, so keep an eye on this space. 

As has been the case for over a decade now, the Kettle Community Meeting (rebranded from Pentaho Community Meeting, see below for more information) is the annual (mostly) European event for all things Kettle and Pentaho. 

Join us for a weekend of meeting fellow Kettle users, customers, developers and architects. In return for sacrificing a weekend of family time, we'll do the best we can to offer great content and lots of socializing with like-minded people. 

Friday Evening Meetup

While we are hard at work at the Deep Dive Sessions, feel free to join the KCM19 crowd at the Kelly's Antwerp Irish Pub.

Kelly's Antwerp
De Keyserlei 27
2018 Antwerp
Belgium

KCM19 Livestream

Save the date!!

KCM19 will take place on: 

  • Friday Nov 22, 2019: deep dive sessions & drinks 
  • Saturday Nov 23, 2019: KCM19 presentations!  
  • Sunday Nov 24, 2019: social activity (TBD)

Registrations

Registrations will open on Monday June 17th, 2019. Stay tuned! 

  • Friday, 22nd Nov, 2019: Deep Dive Sessions
  • Saturday, 23rd Nov, 2019: main KCM sessions: Register!
  • Saturday, 23rd Nov, 2019: KCM evening dinner and drinks (coming soon)
  • Sunday, 24th Nov, 2019: social activity (coming soon)

Agenda

KCM Friday Deep Dive Sessions

There will be 2 deep dive sessions on Friday evening. 
Registrations for these sessions are limited to 25 each, so be quick to reserve your seat. 
The sessions will end at around 9pm and will be hosted at (or very close to) the meetup place (bar), so there will be plenty of time left to join the rest of the KCM19 crowd  for a drink. 

KCM Saturday Presentations

Doors will open at 9:00, presentations will start at 9:30

Download agenda: Download KCM19 Agenda

Agenda 

The technical and business presentations have been bundled in the main room. There won't be a separate business track for KCM19.

Slot Speaker(s) Presentation
9:30-9:45 Bart Maertens Welcome + opening
09:45-10:30 Matt Casters Recent Kettle Development (at Neo4J and in general)

Download Presentation
10:30-11:10 Jens BleuelLeonardo Coelho How can a Community Member contribute to Pentaho?

Download Presentation
11:10-11:40 Coffee Break
11:40-12:20 Mark Hall, Ken Wood “Hey Ray!” and other deep learning/machine learning goodies!

Download Presentation(43MB!)
12:20-12:40 Kunal Pattni Neo4J and CTools? Yes with Kettle

We use PDI to parse shapefiles downloaded from natural earth, load transformed data as a graph into neo4j and the integrate it in a C-tools dashboard, which calls PDI transformations to run cypher queries.



Download Presentation
12:40-13:30 Lunch Break
13:30-14:10 Matt Casters Kettle Sucks (Again)
14:10-14:50 Anna Rumyantseva, Elena Salova Recommendation engine in Pentaho. What's your next step? Bayes knows!
14:50-15:10 Beppe Raymaekers Driving DI Project Success with CI

In this session I will be discussing DevOps (CI/CD) best practices and how they can be applied to your Pentaho Data Integration (PDI) project. This will include an overview of the project foundations which are required to onboard on your PDI project’s DevOps journey and I will showcase a CI solution using PDI, Jenkins and JUnit to get started with your project's automated testing.
Starting your project in the right way will greatly support your development, lifecycle management and automated testing strategies, driving your project success and productivity.



Download Presentation
15:10-15:40 Coffee Break
15:40-16:00 Tom Barber Moving from Kettle to Apache Hop - What is the Apache Software Foundation and how it can benefit the Kettle Community

Download Presentation
16:00-16:20 Guido van de Kerkhof Kettle at ABN AMRO Clearing
Video and presentation won't be distributed
16:20-16:40 Lokke Bruyndonckx A data lineage framework with Kettle and Neo4J

Download Presentation
16:40-17:00 Nelson SousaLuis Silva A general purpose ETL and testing framework using Kettle, Jenkins and Git

In one of our current projects we’re aiming to build a data warehouse using data from a collection of identical or near identical MSSQL databases. However, the source databases are missing several important bits and pieces that are usually essential to extract data: there are no update timestamps, no incremental keys, no pk-fk relationships and although some triggers allow us some form of CDC, in some cases a single user action causes dozens of consecutive updates to the data. In this talk we’ll show the base principles behind our modular Kettle framework to extract and transform these data, as well as our integration with Jenkins and git to automatically fetch new commits from feature branches, run unit tests, and promote code to the UAT branch if the tests pass.



Download Presentation
17:00-17:30 Hans Van Akelyen, Bart Maertens Introducing Project Hop - Exploring the future of data integration

Download Presentation
17:30-18:30 Closing drinks + Networking

 

Download agenda: Download KCM19 Agenda

 

KCM Saturday Evening Activity

PCM17 and PCM18 were generously sponsored by Hitachi Vantara. With the switch to KCM, this is no longer the case. Without this budget, we won't be able to organize a Saturday evening event with free food and drinks.

Dinner will be on your own. There are some great places near De Keyserlei and in the areas near Groenplaats, Suikerrui, Grote Markt, Oude Koornmarkt.
After dinner (no hard time, let's say 20:30-ish), we'll gather in Den Engel and Den Bengel, two adjacent pubs on the right hand side of the town hall on Grote Markt (Great Market Square).

We'll use the Kettle Slack channel should there be any last-minute changes. Use the twitter hashtag #KCM19 to request access to the channel.

KCM Sunday Social Event

We'll do a walking tour of some of the medieval and modern highlights of Antwerp. We'll end the tour in an area where we can have a KCM19 closing lunch.
Start: Starbucks Antwerp Central Station at 10:00 am.

 

Sponsors

logo_know.bi mattcasters

 

neo4j-logo
     

Rebranding to #KCM19 instead of #PCM19

After some long and hard discussion in the community, we decided Kettle Community Meeting better reflects the purpose of the meeting. 

The main reason for this name change is that we want to acknowledge Kettle (Pentaho Data Integration) as the main topic in recent years, and move the focus accordingly.

The 'old' PCM-format will remain largely unchanged for KCM. Most talks will be about new Kettle developments or use cases, but presentations about other components in the Pentaho-platform are just as welcome as they were before. We'll also continue to work closely with our friends at Hitachi Vantara. 

Expect to meet again with friends from previous editions, meet new people, enjoy great content and don't forget to enjoy our great Belgian beer and chocolate. 

KCM19 Details

Venue

KCM19 will be hosted at the wonderful "Hof Van Liere": 

"The beautiful 16th-century Hof van Liere and the adjacent historic buildings, which were constructed by the Jesuits in the 17th century, are an oasis of calm in the bustling city centre.

The central Hof Van Liere, on the University of Antwerp’s Stadscampus, belongs to Antwerp’s cultural-historical patrimony. The regal building was built in 1516, commissioned by the Mayor of Antwerp at that time, Aert van Liere. Antwerp was on the threshold of its ‘golden’ 16th century, a fact that is evidenced by this beautiful building in the Brabant Gothic style."

 

HvL-Frederik_De_Tassiszaal

HvL-garden

Address 
Hof Van Liere
Prinsstraat 13
2000 Antwerp
Belgium 

 

Getting There

  • Flying in + by train: there are connections from Brussels Airport to Antwerp Central Station every 10 to 15 minutes
  • By train: https://www.belgiantrain.be/en
  • By car:  there are plenty of public parkings in the Antwerp city center. They may be more or less expensive (€20-€25/day), and getting there can be a challenge. 
  • Consider offsetting your carbon footprint  if you're traveling to KCM19

Agenda

The name change to #KCM19 instead of #PCM19 is the perfect opportunity to tune the #KCM agenda to better reflect how the event evolved over the years. 

Exit Hackathon, Enter Deep Dive Sessions

Some great results have been achieved over the course of the 2-hour hackathon since it was introduced at #PCM14 (the first Antwerp edition). However, 2 hours barely is enough to get started on 'real' projects, let alone deliver results that can really make a difference. 

Instead of the hackathon, KCM19 will feature 2 parallel tracks of deep dive sessions.  Pre-registration will be required, watch this space for details. If taking a deep dive into new (Kettle-related) tech after a long workweek isn't your idea of fun, we'll serve a selection of our finest Belgian beers. After all, meeting up over beers has always been an important part of PCM/KCM Friday evenings. 

 

Hotels

The hotels listed below have provided KCM group codes. Both hotels have optional reservations on these codes for 20 rooms or until mid September.  Later or additional reservations with these codes may be possible, but can't be guaranteed.

Lindner Antwerp

  • hotel website
  • cost per night (tourist tax of € 2.39 per person not included)
    • single: € 119.00
    • double: € 134.00
    • breakfast: € 23.00 per person
  • reservations via email to reservations.antwerpen@lindnerhotels.be, please specify:
    • First + Last name
    • check in, check out date
    • number of guests/rooms
    • credit card (card number + expiry date)
    • group booking number 9467182 and name 'know.bi'

Ibis Antwerpen Centrum

  • hotel website
  • cost per night (tourist tax of € 2.39 per person not included)
    • single: € 89.00
    • double: € 104.00
    • breakfast is included
  • reservations via email to h1453-sb@accor.com, please specify:
    • First + Last name
    • check in, check out date
    • number of guests/rooms
    • credit card (card number + expiry date)
    • booking reference 'KNOW - 577889'

Quality Hotel Antwerp

  • hotel website
  • cost per night: (tourist tax of € 2.39 per person not included)
    • Superior Double (1 queensize bed): € 119.00
    • breakfast is included
  • reservation via email to reception@qualityhotel-antwerp.be, please specify:
    • First + Last name
    • check in, check out date
    • number of guests/rooms
    • credit card (card number + expiry date)
    • booking reference 'know.bi'

 

PCM/KCM History

  • KCM19: Antwerp, Belgium
  • PCM18: Bologna, Italy
  • PCM17: Mainz, Germany
  • PCM16: Antwerp, Belgium
  • PCM15: London, UK
  • PCM14: Antwerp, Belgium
  • PCM13: Sintra, Portugal
  • PCM12: Amsterdam, Netherlands
  • PCM11: Rome (Frascati), Italy
  • PCM10: Cascais, Portugal
  • PCM09: Barcelona, Spain
  • PCM08: Mainz, Germany