ODBC Driver for Acumatica

Build 20.0.7587

Connecting to Acumatica

Connecting to Acumatica

Log into Acumatica in a web browser, and then navigate to the 'Web Service Endpoints' screen. If necessary, navigate to this screen by editing the web browser URL and replacing ScreenId=00000000 (the homepage) with ScreenId=SM207060. If you are redirected back to the homepage, this means your user does not have the necessary permissions to access web services. Under Endpoints properties get the Endpoint Name and Endpoint Version.

Once you the requried values, set the following connection properties to connect to Acumatica:

  • User: Set this to your username.
  • Password: Set this to your password.
  • Company: Set this to your company. It is required when Schema is set to "OData".
  • Url: The base URL for the acumatica site. For example: https://domain.acumatica.com/
  • EndpointVersion: The version of the endpoint from theWeb Service Endpoints form. For example: 17.200.001
  • EndpointName: The name of the endpoint Web Service Endpoints form. For example: Default
  • Schema: There are two schemas which contains different data. The default one is REST which uses the Acumatica REST Contract Based Api and the OData which uses the Acumatica OData Api. The OData schema is used for Acumatica Generic Inquiries. Generic Inquiries need to be exposed via OData, On the Acumatica Generic Inquiries Screen check the "Expose via OData" checkbox.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587