Is anyone using MS SQL server as a data store? I don’t think Opal can natively connect to it, but what about as a resource - has anyone done that?
I just checked: the R package DBI (used by resourcer to build the database resource connector) could use the driver odbc (which itself depends on the system lib unixodbc-dev) to manage the connection with MSSQL.
In other words, MSSQL resource is not implemented, but it could be.
Regards
Yannick
I forgot to mention that there is an alternative solution with resourcer: using PrestoDB or Trino you can connect to many data sources including MSSQL. The resourcer already wraps the RPresto package.
Cheers
Yannick
That’s cool. I’ll have a look at that. Cheers!