Question Re: Connect SQL Anywhere to MS Dataverse in Technology Q&A

Connect SQL Anywhere to MS Dataverse

former_SQLA_member1694914 — Mon, 11 Apr 2022 02:06:46 GMT

Hello, we have SQL Anywhere 17 and would like to do integration with MS Dataverse. We would send some data to Dataverse tables and request some data from dataverse. Did anyone do something like this? How do you connect to Dataverse?

Thank you for your help

Tomaz

Re: Connect SQL Anywhere to MS Dataverse

Breck_Carter — Mon, 11 Apr 2022 09:33:47 GMT

If I had to guess (well, actually I do have to guess), I'd start with

   CREATE SERVER CLASS 'MSSODBC' ...

just because "it's Microsoft and everything looks like SQL Server when you're Microsoft"...

Then, if that doesn't work, try

   CREATE SERVER CLASS 'ODBC' ...

See CREATE SERVER

Re: Connect SQL Anywhere to MS Dataverse

former_SQLA_member1694914 — Mon, 11 Apr 2022 10:05:11 GMT

Hi Breck, That would be easy part if MS would have ODBC driver for Dataverse. Regards Tomaz

Re: Connect SQL Anywhere to MS Dataverse

Breck_Carter — Mon, 11 Apr 2022 14:44:04 GMT

...oh, money, that stuff 🙂

https://www.cdata.com/drivers/dataverse/order/odbc/