SAP SQL Data Warehouse on Sap Cloud Platform

[former_member602779]

Sap sql data warehouse is available on Sap Cloud platform?

[Sefan_Linders]

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.

[former_member637419]

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?

[Sefan_Linders]

Hi Fabian,

Answer provided here: https://answers.sap.com/questions/12891305/cal-internal-server-error-at-webide-for-sap-sql-dq.html?c...

Thanks,
Sefan

[former_member602779]

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?

[former_member602779]

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

[fernando_satorra_consulte]

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