Connection to MS Dynamics 365

Hello,

I am looking for solution to connect from SQL Anywhere 17 to MS Dynamics 365 Online. We need to read some data from their tables. Did anyone already do something like that or have any suggestions?

Thanks for any tips

Regards

Tomaž

connection integration

asked 03 Apr, 04:47

Tomaz
116●8●9●14
accept rate: 0%

edited 03 Apr, 04:47

flat view

One Answer:

active answers oldest answers newest answers popular answers

Google tells me that "MS Dynamics 365" is more of a suite of applications than a database.

I'll assume that you are asking how you would connect to the underlying database storing all the data associated with MS Dynamics 365.

Do you know what the underlying RDBMS is that is storing the data?
Are you able to create an ODBC DSN on the machine where SQL Anywhere 17 is running and do a test connection to the RDBMS that is storing the data?

If you can answer those questions, then you you should be able to use the remote data access feature to access the data in another database from SQL Anywhere 17 using proxy tables.

Reg

permanent link

answered 03 Apr, 09:12

Reg Domaratzki
7.4k●3●42●113
accept rate: 37%

edited 03 Apr, 09:15

Hello Reg, you are correct, but behind is dataverse, (Dataverse is actually built on top of Azure SQL), which could be accessible with web services API. There is also company (CDATA) who is selling ODBC driver to access this data. I need to connect to this dataverse database to query some data.

Regards Tomaž

(04 Apr, 07:37) Tomaz

Replies hidden

If the data is accessible for free with a web services API, I would consider using https://help.sap.com/docs/SAP_SQL_Anywhere/98ad9ec940e2465695685d98e308dff5/3bd7b42c6c5f1014a9cee72422d79bb6.html>SQL Anywhere as a web client.

(04 Apr, 10:05) Reg Domaratzki

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:

connection ×157
integration ×7

question asked: 03 Apr, 04:47

question was seen: 544 times

last updated: 04 Apr, 10:23

SAP SQL Anywhere

Connection to MS Dynamics 365

Follow this question

Related questions