Accessing external/remote data

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?

asked 28 Dec '13, 17:50

BlueMark
316●13●18●27
accept rate: 66%

flat view

One Answer:

active answers oldest answers newest answers popular answers

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.

permanent link

answered 28 Dec '13, 20:46

Breck Carter
32.5k●541●726●1050
accept rate: 20%

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...

(30 Dec '13, 03:18) Volker Barth

flat view

Your answer

toggle preview

community wiki:

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

learn more about Markdown

Question tags:

sa-12 ×438
stored-procedure ×125
asa-9 ×108
remote-data-access ×31
external-environment ×24

question asked: 28 Dec '13, 17:50

question was seen: 2,206 times

last updated: 30 Dec '13, 03:23

SAP SQL Anywhere

Accessing external/remote data

Follow this question

Related questions