Skip to Content
avatar image
Former Member

Accessing Data from Virtual table using XSJS or XSODATA

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.

Problem:

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 !!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers