thank DanGuzman, shell and cron, so far, we have no business case identified without those two
Mostly will be self contained cloud solutions for WP, Joomla, Drupal and similar (for the scenario A, public), the other bizCase is a self develop Ubuntu installation by client already deployed over 3000~4000 instances and with a daily refresh of about 50 of them.
On both cases bash, cron and ftp access is an standard, on first scenario most of cloud providers WILL NOT install any dependency, but you can run anything you upload trough ftp. On second scenatrion, having to install new packages is simple a PITA very unlikely.
Indeed deployment of teh script and prograimg it via cron (or self executed) can be see as an installation process, but one that is possible and allowed to be done ;-)
Calling a REST API via curl will probably have the broadest coverage in the wild with already-installed packages.
That will be awesome GREAT "!!
But I am almost sure it can not be used "directly" onto Azure DBs...
(Mr. Nadella, please, I know it is too late for Saint Claus :-)
[remember: each user/client has its own, as in it is own premises/cloud, database, neither the database must be centralized]
So far, a pilot, includes a "middleware" server which is called by curl, so script generate the "instruction" code in BASE64, calls the middleware, this decode the BASE64 and calls the AzureSQL using sqlcmd, and returns to the client-script.
This middleware seems pretty unnecessary if you obey the logic of its work, but needed as a glue. That is what we try to get rid of.
Could a C++ program using the ODBC driver be compiled as a self executable distributable via ftp? (we don't have so much experience with developing that level, but looking forward the option of a external developer)