Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
Showing results for 
Search instead for 
Did you mean: 
Product and Topic Expert
Product and Topic Expert
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.