— The Forums are now read-only —
— All new activity now takes place 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.
By using this website, you agree to our Terms of Use (click here)
