SAP Data Warehouse Cloud integrated with SAP DB-Explorer to support HANA SQL data warehousing scenarios
This Blog describes the capabilities of SAP Data Warehouse Cloud, integrated with SAP DB-Explorer to support HANA SQL data warehousing scenarios.
The SAP DB-Explorer is supporting to create and execute HANA SQL Statements, which includes SQL DDL & DML Statements and the options to create Stored Procedures, Views, Trigger, Tasks, Functions … relevant to enable SQL data warehouse systems.
The SAP DB-Explorer integrated with SAP Data Warehouse Cloud provides an offering to the SQL community to shift workload to SAP Data Warehouse Cloud by re-using existing SQL know-how – no need to be re-trained.
External Tooling, like SAP DataServices (ETL), SAP Data Intelligence, SAP Data Hub, Tooling certified to connect to HANA and HANA Cloud incl. ODBC/JDC can connect to the SAP Data Warehouse Cloud created and managed DB-Schema (“openSQL Schema”) to interact, load and process data. It’s a simple task to re-locate existing workload to the SAP Data Warehouse Cloud DB-Schema (“openSQL Schema”), no need to adjust the current ETL process configuration.
The tight integration of the DB-User openSQL Schema with the SAP Data Warehouse Cloud Space Management provides a great collaboration between IT and Business, as the SAP Data Warehouse Cloud Data-Builder (graphical) Editors can immediate access the SQL created DB artefacts + data without any data movement involved.
Nice explanation, thank you.
Can I make use of Smart Data Access, or Smart Data Integration (SDA, SDI) here with this HC instance ?
the DB-User in this case has been autom. generated by DWC, where PUBLIC Privileges + APL/PAL Privileges have been granted. The Priviliges to create Remote Sources incl. SDA/SDI capabilities haven't beeen granted.
This how to get access from DB-Explorer (in the contect of DWC) to remote Sources:
Hope this helps.