Question Re: SAP SQL Data Warehouse on Sap Cloud Platform in Technology Q&A

SAP SQL Data Warehouse on Sap Cloud Platform

Former Member — Sun, 04 Feb 2024 05:11:17 GMT

Sap sql data warehouse is available on Sap Cloud platform?

Re: SAP SQL Data Warehouse on Sap Cloud Platform

Sefan_Linders — Mon, 11 Feb 2019 11:08:47 GMT

SCP provides SAP HANA Service with SDI, and the Web IDE full stack can connect to SAP HANA Service. This means, for example, that you can use SDI adapters with batch, virtual, or real-time replication access. The Web IDE provides basically the same features as on premise, for example, flowgraphs and calcviews. From the DW Foundation toolset, currently the Native DSO can be used.

Re: SAP SQL Data Warehouse on Sap Cloud Platform

Former Member — Mon, 11 Feb 2019 15:35:35 GMT

Hello thank you very much
I create a model with SDI but it has many limitations as inconventientes with the amount of records when replicating and that the tasks of replications can not be programmed, must be executed manually.
Log in again to the sap cloud platform account but in the catalog I can not find where to create NDSO.
For the reason of the non-programmable tasks I am looking for how to access from SCP the tools of SQL Datawarehouse and / or BW Foudation

Re: SAP SQL Data Warehouse on Sap Cloud Platform

fernando_satorra_consulte — Wed, 20 Feb 2019 04:26:30 GMT

Hi Carlos,

You can schedule replications using tasks on flowgraphs.
Those flowgraphs can get data using SDI (bringing data form ERP and other sources).
Then you build some calculation views (your data model) from the tables you got in the previous steps.
Finally you consume those views from SAP Analytics Cloud.

That is the way we did our approach to the "SAP SQL Data Warehouse" concept and it worked.

Hope it helps.

Regards,

Fernando

Re: SAP SQL Data Warehouse on Sap Cloud Platform

Former Member — Tue, 26 Mar 2019 12:10:47 GMT

Hello thank you very much
I have tried several ways but it does not enable me the option to program the flowgraphs. attached image
and I have tried to connect the ECC with SCP but I do not have the ABAPadpter enabled by SCP. The database is environment Neo version 1.00.122.23.1548298510. How can I connect to the ECC HANA database?

Re: SAP SQL Data Warehouse on Sap Cloud Platform

Former Member — Wed, 23 Oct 2019 18:12:12 GMT

The CAL version of SAP SQL Data Warehouse (Developer Edition) seems to have a fundamental problem. Web IDE, DI Builder and DI Space Enablement just show "internal server error" after entering user (XSA_ADMIN) and password.

- used default installation out of CAL
- same problem after restarting instance
- same problem after killing and reinstalling instance
- same problem when installing to Google Cloud and to AWS

For me it looks like a bug in default configuration at CAL. How can I adress the problem to SAP?

Re: SAP SQL Data Warehouse on Sap Cloud Platform

Sefan_Linders — Thu, 07 Nov 2019 10:14:46 GMT

Hi Fabian,

Answer provided here: https://answers.sap.com/questions/12891305/cal-internal-server-error-at-webide-for-sap-sql-dq.html?childToView=12903187&answerPublished=true#answer-12903187

Thanks,
Sefan