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.