Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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ž

asked 03 Apr '23, 04:47

Tomaz's gravatar image

Tomaz
166101220
accept rate: 0%

edited 03 Apr '23, 04:47


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.

  1. Do you know what the underlying RDBMS is that is storing the data?
  2. 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 '23, 09:12

Reg%20Domaratzki's gravatar image

Reg Domaratzki
7.7k343118
accept rate: 37%

edited 03 Apr '23, 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 '23, 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 '23, 10:05) Reg Domaratzki

As for the connection to SQL Dynamics, I can recommend dotConnect for Dynamics. You can check if it's work for you.

permanent link

answered 24 Nov '23, 08:44

TimLewisTim's gravatar image

TimLewisTim
71
accept rate: 0%

Your answer
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:

×159
×7

question asked: 03 Apr '23, 04:47

question was seen: 909 times

last updated: 24 Nov '23, 08:44