ETL+ Deployment for Acumatica Cloud (OData)

Owned by Cortlandt _
Dec 19, 2023
3 min read

Deploying ETL+ to connect with Acumatica with OData.

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 https://dataself.atlassian.net/wiki/spaces/DS/pages/1570013215

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 https://dataself.atlassian.net/wiki/spaces/DS/pages/1639940097

  • 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.