SAP HANA Smart Data Acess for BW [SDA] Part -2

Please find Part -1 here .

In previous blog post (Part – 1) we had seen how to implement SDA. In this part we will see the same steps but by using SQL.

Please go through the Part – 1 of the same to refer before you start with this.

1. Creating the Remote Data Source

See SQL Syntax below:

Example SQL is shown below

Creating Virtual table

See SQL Syntax below

Example SQL is shown below

Display Data

a. Data can be visualized through Display Content or SQL from created Virtual table

b. SQL used here is highlighted below

Hope this series will be helpful.