I find ton of resources how to get into HANA but no material available how to retrieve data from a SAP HANA table? I am trying to get it to my java application. So trigger can only allow me to write to a different table.
Asked
Active
Viewed 418 times
0
-
Can you describe your use case in more detail? What do you mean by "get it into my java application"? – Lars Br. Nov 30 '17 at 03:36
-
To retrieve data from a database table, you can use SELECT statements. Do you mean an other problem? – Eralper Dec 01 '17 at 06:09
-
NO. like oracle change data capture. Let say I want to get changes done to a table in SAP HANA in continuous manner. HANA writes the changes to a queue where my java program can periodically go and get them. One solution I can think of is: create a trigger on a table which inserts new row for EVERY change with a time stamp. and I use my jdbc java code to query every few seconds to get recent changes. – PGK Dec 01 '17 at 23:04