I am a fan of open source software. I am also a fan of getting things done. So if Google works nicely, I might use it if there is no other solution.
Since Google sheets turned out to have it’s own limitations in regard to my project (apart from the usual concerns regarding using Google products), I opted to use static images for now.
I am using an SSH connector to write all images directly to the webserver.
By using a SFTP chroot setup I am lowering the risk of saving user+password in the KNIME flow.
Writing the visualized data came with it’s own challenges (e.g., JavaScript Views seem to be broken in batch mode ), but I found a solution for it as well.
I don’t have interactive graphs, but a static website with graphs that update every day is good enough for this project.
Only caveat at the moment is the DB connection. Since the DB is only accessible through an SSH tunnel, I need to have a batch file which first starts the tunnel, runs KNIME and then stops the tunnel again. It would be really nice if KNIME had SSH tunneling built into the DB connectors.