Articles & Content

Henrik Loeser: Thoughts on IT, Life, DB2, and More

IT Professional (IBM), Information Management Architect / DB2 pureXML / Database Kernel Developer, spent 7 years living in California (Bay Area), now back in Germany, living in a passive house in Friedrichshafen

Note: The content of this blog is the opinion and thoughts of the blogger and does not necessarily represent the opinions of IDUG.

 

 
DeDUG-Treffen in Ehningen / Db2 User Group meeting near StuttgartDb2 User Group MeetingRemember the last German Db2 User Group (DeDUG) meetings at IBM in Munich (April) and at Fiducia GAD in Karlsruhe (January)? Or not? Anyway, get ready for an educative meeting with great networking. The next Db2 meeting is coming up this June 29th. IBM is going to host the user…
Use BotKit Middleware to create Watson-powered database interfaceChatbot anyone?Few months back, I introduced you to a tutorial for a database-drive Slackbot. In the tutorial I used the Conversation connector to hook up IBM Watson Assistant to Slack as a chatbot. Did you know that you can reuse the code and utilize BotKit and IBM Watson BotKit Middleware to imple…
Securing your Python app with OpenID Connect (OIDC)Authorized access only using OpenID ConnectSome weeks back I introduced to a tutorial on how to analyse GitHub traffic. The tutorial combines serverless technology and Cloud Foundry to automatically retrieve statistics and store them in Db2. The data can then be accessed and analyzed using a Python …
June 2018 Edition: Latest IBM Cloud news and links (Db2 included)IBM Cloud newsIt's been a while since my last news compilation. Here is a collection of news interesting links related to IBM Cloud from the past few weeks:I always recommend to regularly go over the "What's new in IBM Cloud" page in the IBM Cloud docs.Something announced this week is a major expans…
Tutorial: Analyze and visualize open data with Apache SparkLife Expectancy MapMany government agencies and public administrations offer access to data, contributing to open data. Using IBM Watson Studio with Jupyter Notebooks and Apache Spark it is simple to retrieve, combine and analyze data from different sources. The result can be easily visualized. Lear…
How to pack serverless Python actionsServerless access to Db2 and GitHubFor my tutorial on automated data retrieval and analytics, I use IBM Cloud Functions to automatically fetch GitHub traffic statistics once a day. It is implemented as a serverless Python action. Because some Python packages are needed, the question was how to pack …
Db2: CTE and CONNECT BY - two kinds of recursionWriting recursive SQLRecently, I gave a talk on SQL Recursion. One of the cool features in Db2 that I (re-)discovered for that presentation is that there are two different forms of syntax for recursive queries. One is the Common Table Expression (CTE), another the CONNECT BY syntax. Let me introduce…
Automated, regular database jobs with IBM Cloud Functions (and Db2)IBM Cloud Functions and Db2Yesterday, I blogged about the latest tutorial I wrote. The tutorial discusses how to combine serverless and Cloud Foundry for data retrieval and analytics. That scenario came up when I looked into regularly downloading GitHub traffic statistics for improved usage insights…
Use Db2 and IBM Cloud to analyze GitHub traffic data (tutorial)Architecture: GitHub Traffic AnalyticsIn a new solution tutorial, I show you how to automatically retrieve and store GitHub traffic data the serverless way with IBM Cloud Functions and Db2. The data can then be analyzed via a Web app deployed to Cloud Foundry on IBM Cloud. The app is secured with Ap…
IBM Cloud and Watson security questionnairesIf you are reading my blog regularly, you are aware of the entries on cloud security. Today, I want to point you to some newer reading material at the Cloud Security Alliance. They now have up-to-date self-assessment security questionnaires for the IBM Cloud.The three available security documents co…