Create Remote

...

Source (Create by Adagio)

1. At HANA studio - HANA modeler perspective, go to provisioning > New Remote Source

...

2. Enter detailed information  

The name of remote source should starting with RS_

3. After connected, available tables will display on the remote source

4. Then, run SQL command to grant privilege to authorization team and to development role otherwise, other developer will not possible to activate the datasource that linked to this remote source in each systems (development, quality, pre-production, production systems)

• GRANT CREATE VIRTUAL TABLE, CREATE REMOTE SUBSCRIPTION, PROCESS REMOTE SUBSCRIPTION EXCEPTION, ALTER ON REMOTE SOURCE "Name of Remote source" TO SDI_ADMIN WITH GRANT OPTION;
• GRANT CREATE VIRTUAL TABLE, CREATE REMOTE SUBSCRIPTION, PROCESS REMOTE SUBSCRIPTION EXCEPTION, ALTER ON REMOTE SOURCE "Name of Remote source" TO ZSLV_SDI_DEVELOPER;

Create Source system with Big Data (Create by Adagio → we should not create a new source system anymore Use SDI instead)

1. Need to create remote source first if it is not existing

...

4. Selection connection type “SAP HANA Smart Data Access”, then enter the remote sources

5. After execute

Create Data source

1. Right click on the infoarea and choose New

...