cancel
Showing results for 
Search instead for 
Did you mean: 

sap cloud analytics - model based on SQL server Stored procedure

mvontik
Discoverer
0 Kudos

Can we create model based on SQL server Stored procedure in Cloud Analytics?.

Accepted Solutions (0)

Answers (2)

Answers (2)

mvontik
Discoverer
0 Kudos

Thanks Henry. Yes I was able to create model based on the "Free hand SQL" but I am wondering instead can I create model on Stored Procedure.

Thanks

Madhavi

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

i haven't personally tried it, so can't really comment.

However, SAC offers both a 'freehand SQL statement editor' or a 'visual query builder' (the latter, i think, is solely a table browser) so you might have more luck with the first option

Looking at the help pages, the system requirements for 'import data from..' workflow for MS SQL server is JDBC to versions 2008, 2012, 2014

https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/11b4e5ff76eb4747bc255d7037be...


regards, H