L2-DE - Lesson 4 (MongoDB)

Educators
1

Dear KNIMErs,

I am planning to give the last (4th) session of the L2-DE course next week Wednesday. So I tried to prepare the sessions and record a “how to do the homework video”. While doing that I found some (minor) issues with the provided learning material for that specific lesson.

  1. The workflow that I have does not contain a 2nd String Manipulation node in the metanode of activity I. This means, the StoreID is stripped off of whitespace but the Renewal Status in that exercise is not. I added one, but I would dare to say, at least the solution should have one by default
  2. I couldn’t locate any login credentials for the MongoDB Connector node. I could look into the solution and find the user name but I don’t see the password. The workflow annotations indicate that this is given in the learning material but it is actually not.

I think both of these topics could be improved as basically without number 2, learners are not able to finish the homework, which would be a pity.

image
image628×648 44.6 KB

2 Likes
2

Hi Philipp,

We have a newer version of the L2-DE exercise workflows (v5.5) that have addressed the issues you raised. You can download it from here: knime/Education – L2-DE Data Engineering with KNIME Analytics Platform - Advanced – KNIME Community Hub

Briefly,

  1. There is a third String Manipulation node in the metanode that strips white spaces from StoreID
  2. The workflow reads JSON objects that have been previously downloaded from a MongoDB database. So no MongoDB Connector is needed anymore.

Good luck with your teaching!

-Satoru

2 Likes
3

Thanks for the response @hayasaka - not having to deal with MongoDB connections and rather “simply” import the JSON is a great relief.

One side note: In the current version of the linked workflow, there is no 3rd String Manipulation node, see screenshot. For my training, I added it myself.

image
image1905×1072 228 KB