We have an external database table in a local server. Can we access that database in the H5 SDK using SQL Stored procedure?
No, since the H5 SDK application is a web application where you only write script (on client) you should not access SQL server, since that means that you would expose the information needed to connect to everyone with some basic technical knowledge. That is a big, big, no, no. You will have to create a backend service that access that data that you can call and that has authentication of the user as well. You used to be able to do this in a web service tool, LWS where you could build web services for M3 and also against stored procedures, but I don't think that is supported anymore. Perhaps Mongoose would have a way to build an API and expost it.
Thanks Karin, do you mean Mongoose is the only option to call the external database?
Hello,
as reported by Karin you should build a backend service and expose a webservice.
Since I understood that H5 SDK application are developed in Angular, basically with it you can't connect directly to database but you can call REST API.
So for example, you can build a .NET Core API application in charge of create connection to database and call your procedure and expose the REST service for H5 SDK client application.
I hope this help you.
Got it, thanks Karin and Gioacchino.
* Mongoose.
or
* Web Services - HTTPS always