This is not an issue. This is how DS works with SAP application and BW system from the very beginnig. Most customers don't know about it. This is why I created the KBA, so it's clear the customers. It doesn't matter if your source is SAP applications...
Please check KBA https://me.sap.com/notes/3557057. Check your datastore type is SAP Applicaiton or BW source/target. If your job is not usingt BW source/target datastore type, then it doesn't use DS RFC Server at all. Job can be successful even when ...
You can create a File Location with Azure Data Lake Storage. See details in this document Create a File Location Object(https://help.sap.com/docs/cloud-integration-for-data-services/help-center-for-sap-cloud-integration-for-data-services/create-file-...
First of all, SDI is not going to be sunset. At least not announced within SAP. In CIDS, flexible Planning area is possible for order based planing master data.