I have a simple use case. DB (On Premise) and DB (On Cloud).
I want to use nifi to extract data from on prem DB (huge volumes) and insert into the same table structure that is hosted on cloud. I could use ExecuteSQL on both sides of the fence (to extract from on prem and insert onto cloud). What processors are needed in between (if at all)? As i am not doing any transformations at all....it is just extract and load use case