Connection to MS Dynamics 365

[former_SQLA_member1694914]

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ž

[regdomaratzki]

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

[former_SQLA_member1694914]

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ž

[regdomaratzki]

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/3bd7b42c6c5f1014a9cee724... Anywhere as a web client.