Acumatica
Acumatica
Setup Guide
Follow these steps to connect Acumatica to your CData Connect account:
-
Open the Connections page of the CData Connect dashboard.
-
Click + Add Connection in the upper-right corner.
-
Type Acumatica into the search field, then click the data source name.
-
On the Basic Settings tab of the new connection, enter a connection name or keep the default name.
-
Enter the base URL of your Acumatica site.
-
Select the Authentication method, then proceed to the relevant section and follow those instructions.
Authentication Methods
Basic
-
Enter the Acumatica username for authentication in the User field.
-
In the Password field, enter the user password.
-
Select a Schema. By default, this is set to
REST
Contract-Based API. You can also selectOData
to use the OData API for Acumatica Generic Inquiries. See the OData page for more information. -
If using the
REST
API, enter your Endpoint Name and Endpoint Version. These values can be found under Endpoint Properties in the Web Services Endpoint form of your Acumatica ERP. -
If using the
Odata
API, enter your Company Name. -
At the top of the CData Connect Add Acumatica Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
OAuth
-
Enter the OAuth Client Id assigned when you registered your Acumatica account.
-
Enter the OAuth Client Secret for your Acumatica account.
-
Select a Schema. By default, this is set to
REST
Contract-Based API. You can also selectOData
to use the OData API for Acumatica Generic Inquiries. -
If using the
REST
API, enter your Endpoint Name and Endpoint Version. These values can be found under Endpoint Properties in the Web Services Endpoint form of your Acumatica ERP. -
If using the
Odata
API, enter your Company Name. -
Click Sign in to connect securely through OAuth. This action opens the Acumatica sign-in page in a new tab.
-
Log into your Acumatica account and provide the requested permissions (if applicable).
-
At the top of the CData Connect Add Acumatica Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
More Information
For more information about interactions between CData Connect and Acumatica, see this information page.