In this page, we will know how to set up the SDA from HANA.
Install and configure the ODBC database driver required to connect to the remote source. This process varies by driver. Refer to the specific driver section for details.
Setting Up ODBC Drivers
Create a remote source using SQL syntax or SAP HANA Studio. Again, creation varies by driver, so continue referring to the specific driver section for details.
Creating a Remote Source
Create virtual tables to access the data stored in remote tables, using SQL syntax or SAP HANA studio.
Create Virtual Tables in HANA studio / SQL command
SDA setup for MSSQL