Skip to Content

Accessing Data from Virtual table using XSJS or XSODATA

Aug 06, 2017 at 02:46 PM


avatar image
Former Member

Hello Everyone,

I am trying to get data from MSSQL database(Onpremise) to SAP HANA Cloud Database and expose it through XSODATA for my use.

Already Done :

1) Installed Data Provisioning agent and connected to HANA

2) MSSQL LogReaderAdapter is installed and connected

3) Created a Remote Data Source and can view tables of MSSQL Database

4) Created a Virtual table from a table in Remote Data Source.


1) Not able to create XSODATA services of virtual table created as it gives error of primary keys not present.

Question :

1)Is it even possible to create Odata Services for Virtual Tables ?

2) I am also trying ti write XS JavaScript to access data from virtual table and update real table in SAP Hana Database ..Is this a good option ?

Please let me know if there is better option.

Thanks In Advance !!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers