I am new to SAP data services. In order to transform and load data, I am only able to connect to data stores that have already been imported into Data Services from Hana. For my situation, the tables might change in the forthcoming future so I wanted to script the transform through SQL. Is there a way, I can connect to HANA db directly instead of going through each individual data store (which have to be created with individual tables)?
I have used SSIS earlier and I know I can connect and write SQL queries to pull data from multiple tables directly only if I have connection to the database. I was expecting something similar in Data Services