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

asked 04 Dec '19, 05:20

Bjarne%20Anker's gravatar image

Bjarne Anker
745323548
accept rate: 10%

1

FWIW, that FAQ may be of help...

(04 Dec '19, 06:16) Volker Barth

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.

(04 Dec '19, 06:26) Bjarne Anker

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.

(05 Dec '19, 02:20) Vlad
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×23
×13

question asked: 04 Dec '19, 05:20

question was seen: 668 times

last updated: 05 Dec '19, 02:20