Skip to Content

Changing SDA virtual table structure

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Feb 06, 2017 at 05:48 PM

    Any inputs?

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 07, 2017 at 04:39 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 08, 2017 at 02:02 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • May 21, 2017 at 01:42 PM

    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

    Add comment
    10|10000 characters needed characters exceeded