Is it possible to merge a virtual table to a view via SDA Virtual Connection

[former_member404189]

1) In HANA system A and HANA system B created a view.

2) In HANA system B created a virtual connection to system A

3) In HANA system B created a virtual table to consume a view from HANA system A

Is it possible to merge the view from HANA system B and the virtual table (created from view) in HANA system B.

[former_member240828 · Accepted solution]

Hello,

you should be able to create another view or calculation view on top of those two objects in your Hana system B.
When querying agains this new view and hitting the virtual table it will then push down some parts of the statement to Hana system A if possible.

Kind regards,

Timo Wagner

[former_member404189 · Accepted solution]

Can you please elaborate on the above point??

[former_member240828 · Accepted solution]

Sure. Let's say we have two views:

Hana A View1:

Country | Customer
US | 5
CA | 23

Hana B View2:

Country | Customer
IT | 21
NZ | 21

On system B we create a remote source pointing to system A and import the View1 as VT_View1 into system B.

No we can create a new view (View_ALL) that is a union of View2 and VT_VIEW1.

The view sql could be something like SELECT "Country", "Customer" from "View2" UNION SELECT "Country", "Customer" from "VT_View1".

This view contains now the merged data of both initial views.

Country | Customer
US | 5
CA | 23
IT | 21
NZ | 21

Is this the scenario you had in mind?

Kind Regards,

Timo Wagner

[former_member404189 · Accepted solution]

Hi,

Yeah,this is what I had in mind.Thanks for your help!!:)