By using this website, you agree to our Terms of Use (click here)
Looks like Acumatica is going to retire ODBC access in their SaaS environment by March 31, 2019. Of course, you could still use ODBC in a private cloud or hosted internally, but most Acumatica customers are on the SaaS offering.
I think this will drive even more interest in OData.
Any idea if this affects mac users that rely on third party excel ODBC drivers to make ODATA work?
I wouldn't think that the client would matter (Windows or Mac) since it's being shutdown on the Server.
Here is a tool that @sqlrunner pointed out in this post which allows you to connect to OData using ODBC (I haven't tried it personally):
https://www.cdata.com/drivers/odata/odbc/
The tool works ok. If the queries start to get complex, it runs into problems. For example, last I checked, sub queries often caused problems with the result set that would not occur in a standard SQL engine. However, simple queries and joins ran fine.
Online Members
