Update all changed tables in SAP BODS datastore
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. In my case 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 directly instead of going through each individual datastore (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
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
Of course, SAP Data Services allows the same. You can import single tables from database, several or the whole database into datastore. For importing all the tables double-click on Tables in the datastore, in the right panel all the tables of the HANA table will be showed, then you just right-click and select Import.
After your schema changes, you just go the same process and click Reconcile as on screenshot.
More about reconciliation process is here: Determining if a schema has changed since it was imported
If only single table has changed, you can make re-import selectively Reimporting objects
through each individual datastore (which have to be created with individual tables)?
no, once you created datastore specifying valid schema, you can import/reconcile all the tables of this schema at once.
Also, consider this al_engine utility which you can use in scripts to automate imports.
More documentation about SAP HANA specifics in Data Services:
- Elusive Error "JDBC: [339]: invalid number: SQL error" in HANA SQL
- AMDP Unable to use UNION ALL with local tables - sql syntax error: incorrect syntax near "UNION
- Performance implications of INSERT INTO...SELECT :NEW.FIELD FROM DUMMY
- Connect to a Hana database through a jar file from a php script
- Can we connect Views in SAP HANA to Tableau Desktop?
- How to prompt query selection criteria with just Year
- DELETE + INSERT vs MODIFY performance on HANA?
- How to open HANA DB report in Java?
- Formatting number in HANA
- What is the right way to run query in SAP HANA
- Read a View created from a procedure in SAP HANA from R
- SAP HANA hdblci package - get data with column names
- Update all changed tables in SAP BODS datastore
- Call to undefined function odbc_connect() message while connecting SAP HANA database
- In SQL how to validate dynamic key-value pairs against key-value columns
- Using Python How To Insert Data To Sap Hana Table
- Can not connect to SAP HANA with neo: java.lang.NoClassDefFoundError: javax/xml/bind/JAXBContext
- SQl query to join a table with Attributes in different rows and filter values
- How to pass named parameters to ST_Makevalid method in SAP Hana
- Keep only groups in a SQL view that have at least one bigger value then a certain condition
- Concatenate two columns in HANA database
- SQL command to turn 261/261/261/261/262/262 into 261/262
- Connect to HANA database from docker container
- Is there a SQL function that can help me reverse an order of a string?
- User getting deactivated due to wrong credentials
- HANA transaction log overflow?
- Partition 0CALDAY (yyyymmdd) column to year, month and day in a copy activity of Azure Data Factory
- Hana Cloud, issue with stored procedure WITH RESULT VIEW
- How to make case in HANA
- Merge two SELECTs in HANA?