KNIME Pro Early access - First experiences

In this post I will be sharing my first experiences with the KNIME Pro program. 

KNIME Pro is a (affordable) paid service offered on KNIME Community Hub. With KNIME Pro you can take advantage of the full capabilities of KNIME Community Hub, including: Running workflows on KNIME Community Hub. Creating and sharing data apps. Automating the execution of workflows on KNIME Community Hub.

At the time of this writing, it is still in Early Access stage.  Here I get a 60 day free subscription, 30 GB of storage and 2000 execution credits. Quite enough for testing, but if I exceed these limits I can increase them at a cost.

What I wanted to try out is to replicate part of my Airline Data Warehouse (see here) on the hub.

The first issue I encountered was that my Data Warehouse resides in a Postgres database on my local machine, which is not accessible from outside (so, also not by the Hub). As a solution for the prototype I found a company called aiven, offering a Postgres database in the cloud (so one that CAN be accessed by the hub.

With this set up, I now have to copy the tables of my local Postgres database to the one hosted by aiven. This can be done by a very simple workflow like below (here I am doing just one table...)

Next, as a proof of concept, I have created a simple Workflow that will read some data and produce a line graph. The data don't make much sense, I just want to see it things technically work. We will make it pretty later on.

Here below are the workflow and resulting bar chart.

Ok, so this proves I can access the Postgres data hosted on aiven on my local machine. 

On the next page we will move to the KNIME Pro hub.