Skip to Content
0

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

Apr 26, 2017 at 08:24 AM

72

avatar image
Former Member

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.

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

1 Answer

Best Answer
Timo Wagner
Apr 28, 2017 at 11:31 AM
0

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

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Can you please elaborate on the above point??

0

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

0
Former Member
Timo Wagner

Hi,

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

0