Knime + Node-RED locally in production

Have anyone here been successful in using node-red + Knime for data analytics in production?

I am struggeling finding out if it's possible to have these platforms running together locally, as none seem to have any common ways of interfacing, which also is simple and reliable. SQL and Rest APIS only as far as i know, but im not experienced in either. Knime do not provide much information either how to run a production workflow locally.

I know and prescient can provide some low code data analysis solutions with but they are Saas solutions which require subscription. My application is way to small for them to ever consider, and it would be way to expensive.