Question Re: Accessing external/remote data in Technology Q&A

Accessing external/remote data

Former Member — Sat, 28 Dec 2013 17:50:43 GMT

I want to use directly within SQL Stored Procedure some data from external sources.

Types of external/remote data sources I mean:

other Sybase databases (the same SQL Anywhere engine version, but different server)
other database engines (including but not limited to MySQL, MS SQL Server)
data returned from desktop applications and scripts
data returned from URLs
data from local text files
use programming languages libraries

I'm using the Sybase SQL Anywhere 9 and 12 databases.

What from the list above is possible in them?

How to handle this?

Re: Accessing external/remote data

Breck_Carter — Sat, 28 Dec 2013 20:46:59 GMT

1, 2 and 5 can possibly be done via "remote data access" also known as proxy tables... 5 can possibly also be done via LOAD TABLE.

4 can possibly be done via web client procedures.

3 and 6 are too vague to even guess at.

Re: Accessing external/remote data

VolkerBarth — Mon, 30 Dec 2013 03:18:03 GMT

Some further hints:

4 - web client procedures require SQL Anywhere 9.0.2 and above

For 3 and 6 we would need much more information about what kind of data you are thinking of. For example, it's surely possible to import all kinds of data in binary, text, XML format, say by the OPENSTRING clause of the SELECT statement, available with v11 and above, or by the openxml() system function...