Skip to Content
0
May 25, 2020 at 09:00 PM

sap data service to load all tables in a db

156 Views Last edit May 26, 2020 at 04:21 AM 2 rev

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