The External SAP HANA SQL View is basically the SQL View in SAP HANA DB, Where we can directly access the data stored in ADSO or any other BW Object. Here, we can bypass the traditional SAP BW Application Layer & allows the application to query data in SAP HANA using SQL.
In order to generate External SAP HANA SQL View, we have to make sure we have sufficient authorizations for managing the ADSO’s, as well as the ADSO’s are activated and created already.
Steps to enable External HANA SQL View option:
- Go to the Modelling Section in SAP BW/HANA System. Open the ADSO for which we have to generate SQL View.
- In General Settings, enable ‘External SAP HANA SQL View’ & once done, provide technical name of the SQL View. By default, system will generate the name starting with ‘2’ (Eg: 2ZADSO**)
- Once done, ensure that ADSO has required fields & all the structures are properly defined in the settings. Activate the ADSO to confirm the changes.
- Once the SQL View option is enabled, activate the ADSO & during the activation, the system will generate the External HANA SQL View.
- You can verify your external SQL View by logging into your HANA Client & navigate the schema associated with SAP BW HANA System. This external view can be used for reporting & all other database operations.
- External SAP HANA SQL Views are read-only by design. The performance of this HANA view depends on how the ADSO is being designed and partitioned are being structured.