Are you trying to consume historical or real-time data? In my experience this greatly influences the approach. Node-RED is a common ETL approach in the scenar

Are you trying to consume historical or real-time data? In my experience this greatly influences the approach. Node-RED is a common ETL approach in the scenario you described, but I find it too limiting beyond basic examples.