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

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)

  • No labels