Changing SDA virtual table structure

[kumar_lakhi]

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.

[DotEiserman]

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_Gui...

[kumar_lakhi]

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.

[former_member240828]

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

[kumar_lakhi]

Any inputs?