Create Remote Source (Create by Adagio)

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

2. Enter detailed information  

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

4. Then, use SQL command to grant privilege to SAPSR3 otherwise, other developer will not possible to activate the datasource that linked to this remote source

GRANT CREATE VIRTUAL TABLE, CREATE REMOTE SUBSCRIPTION ON REMOTE SOURCE "GBQ_Predict_Credit" TO SAPSR3

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

2. Go to BW model perspective - Data Sources, right click and New Source System

3. It will go to SAP GUI, enter information name regarding to naming convention

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

2. Select source system and package in case need to install

3. Select “Proposal from SAP HANA Table or View”

4. Search on the table of the datasource

5. Identify the location of the application component and name the data source ID and text.

Also the type (Transactional data / Master)