0

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.

Sandra Rossi
  • 11,934
  • 5
  • 22
  • 48
PGK
  • 141
  • 3
  • 12
  • 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

0 Answers0