Hi. There is a very interesting option in the SQL Anywhere 16 ODBC driver: "Connect to a running database in the cloud". Is this meant for connecting to a SQL Anywhere OnDemand database only? That edition is cancelled as far as I know? Or can we use this option to connect to a database hosted in ie. AWS, Azure og Google Cloud? The world is moving towards cloud hosting and it would be great to test and compare performance against a on prem database. br, Bjarne - Maritech |
FWIW, that FAQ may be of help...
Thanks.
This approach would mean that you install the SA16 engine on a virtual server, start a service and open the firewalls on both ends. The best thing would be to upload the .db file and host it in a service somewhere. Too bad SAP doesn't support that - since the rest of the competitors is doing that.
Bj.
Regarding the performance comparison, I’d bet that the cloud one will be worse - slow CPUs + latency + thousands firewalls. It might be close to real HW if you application is hosted close to the DB.