Skip to main content
Skip table of contents

ETL+ for Acumatica Cloud (OData)

Connecting ETL+ to Acumatica and OData.

DataSelf has been working with Acumatica Inc. to certify and optimize the OData extraction to be fast and cause minimal performance impact in your Acumatica ERP.

ETL+ Deployment for Acumatica Cloud

Steps 1 and 2 can be covered under 30 minutes.

  1. Click here to fill out the DataSelf Analytics for Acumatica Deployment Form.

  2. User Access: Click here for instructions to grant DataSelf data extract access to your Acumatica data source.

  3. Wait for a DataSelf email notifying you that your DataSelf deployment has been completed.

Level 1 Testing (optional)

The optional Level 1 Testing checks if the data extraction process finished successfully and if the overall row count per extracted table matches Acumatica’s replicated table row counts.

  1. If you haven’t installed ETL+ on your Windows computer yet: ETL+ Deployment Instructions.

  2. Login to ETL+ (help here).

  3. Click Log on the ETL+ Extract, Transform and Load (ETL) Page

For more about the Log page click here.

  1. Scroll down the log page and double-check that no table load failed and that the row count matches the source tables in Acumatica.

Example highlighting two tables and their loaded row count.

In most cases, the out-of-the-box DataSelf solution is all set once this test is successful.

Troubleshooting – see Acumatica OData Extraction Issues

Popular ETL+ Tasks

  • To add a new Acumatica table into DataSelf’s data warehouse: On the ETL main page, Source Objects panel, expand the Acumatica header, right-click the table → Add Table.

  • To refresh a table (load its data) into DataSelf: On the ETL main page, Target Objects panel, right-click the table → Load Now.

  • To refresh the whole DataSelf solution: On the ETL main page, click the Job icon on the Target Objects panel, right-click a Job (usually Job #1) → Run Job.

  • To change the schedule of a DataSelf Job: On the ETL main page, click the Job icon on the Target Objects panel, right-click a Job (usually Job #1) → Properties → change the settings → Save.

ETL+ OData Maintenance

The following is to update the OData settings, such as credentials or OData URL.

  1. Login to ETL+ (help here).

  2. Right-click Acumatica > Properties on the Source Objects pane

  3. Alias is automatically populated, but you can customize it.

  4. Odata feed (URL). Enter the Acumatica OData URL. Click here for instructions.

  5. User and Password. Enter the username and password to Acumatica. Click here for instructions.

  6. Authentication. Set it to Basic.

  7. Extraction blocks: By default, leave it at 5000 records.

  8. Pause: By default, leave it at 500ms.

g.Click Connect.

  1. You’ll get back to the ETL page and see tables under the Acumatica source on the left panel.

Related Pages

Pages in this section

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.