Skip to Content
0

Changing SDA virtual table structure

Feb 03, 2017 at 06:35 PM

536

avatar image

Hi,

We have SDA connected to SQL DB and we replicated Virtual tables into HANA. One of the table in SQL source has been changed by adding a new column. How do we bring the structural changes into HANA using SDA? Does the structural changes replicate automatically into HANA or any manual config we need to make.

Thanks.

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

4 Answers

Ram Kasireddy Feb 06, 2017 at 05:48 PM
0

Any inputs?

Share
10 |10000 characters needed characters left characters exceeded
Timo Wagner
Feb 07, 2017 at 04:39 PM
0

Hello Ram,

you can use the Alter Virtual Table Statement to refresh the metadata of a virtual table.

I just tried that on an SP12 Hana with an SP12 DPAgent (so it is using an SDI adapter):

ALTER VIRTUAL TABLE "SYSTEM"."RemoteHana_table" REFRESH DEFINITION;

Best Regards,
Timo

Share
10 |10000 characters needed characters left characters exceeded
Ram Kasireddy Feb 08, 2017 at 02:02 AM
0

I tried the same statement and execution throws an error saying that there is syntax error at REFRESH. Not sure if this is due to the fact we are on SP12 but no SDI adapter yet.

Share
10 |10000 characters needed characters left characters exceeded
Dorothy Eiserman May 21, 2017 at 01:42 PM
0

Hi,

We logged call with SAP as we are on HANA 1.0 SP 12 and they said the ALTER command is only available from HANA 2.0 onwards. They provided the following workaround:

1. Add the column you need to the source table

2. Create a new virtual table based on this source table

3. Follow the Steps "Replace a Data Source in Calculation Views" to modify your Calculation View.

https://help.sap.com/http.svc/rc/fb8f7a9f7860468b84a07eab0a7d0a98/2.0.01/en-US/SAP_HANA_Modeling_Guide_for_SAP_HANA_Studio_en.pdf

Share
10 |10000 characters needed characters left characters exceeded