SAP HANA Calculation view extract Data

talend777 — Sat, 16 Nov 2024 03:24:58 GMT

Hi gurus,

I am trying to extract data from SAP HANA calculation views, where all views have prefixes like prod.fi/view_name

e.g. prod.fi/cv_bseg, prod.md/cv_mseg etc.

SQL Query --select * from prod.fi/cv_bseg (this works great in SAP HANA so i know syntax is right)

Not sure if escape characters like "/" in the calculation view name is causing this.

SAP Connection is built successfully using tsapHANAInput and i have tested this if i query small table directly which works for statement like "select * from BSEG".

I have also tried playing around sql query tsapHANARow but no success.

(reading other topics i tried something like prod.fi//cv_bseg or prod.fi/\\cv_bseg) for escape characters but its not doing the trick.

Any recommendation will be helpful

Thank you

topic SAP HANA Calculation view extract Data in Talend Studio

SAP HANA Calculation view extract Data