...
OData v4 can extract data directly from DAC tables.
Delta refreshes: Acumatica requires that filters for Replace and Upsert must not have NULLs and ETL+ extraction blocks must be bigger than the max number of records for each block of records with the same filter value.
When working with Replace or Upsert and using date filters, ETL+ filtering adapts to the date format of the source Acumatica.
If a table doesn’t have a native OData index, ETL+ errors out and logs “Extraction time out. Table without native OData index. Please create one via Replace or Upsert.” Set up Replace or Upsert to fix the issue.
Tables Available: When refreshing an Acumatica OData v4 source on ETL+ left panel, you’ll see the list tables available from the OData v4 metadata. Depending your Acumatica speed, it can take a minute or so to load the metadata. Open the following URL on a web browser to view the raw table list data processed by ETL+:
YourOdatav4URL/$metadata (ex.: www.myacu.com/odatav4/$metadata)
Table Columns:
When adding tables from the list of OData v4 tables from ETL+ left panel, ETL+ will create a SQL statement showing columns from the OData v4 metadata. See the prior item URL rule.
You can also use the following Statement syntax to pull all OData v4 columns:
SELECT * FROM TableName
When loading an OData v4 table, you can also extract several columns that are part of related tables. To figure out what columns are available, open on a web browser the following URL:
YourOdatav4URL/$TableName (ex.: www.myacu.com/odatav4/customer)
...
Choosing Acumatica OData Versions Overview of the differences between OData v3 and v4.
ETL+ for Acumatica Cloud (OData) Installation and deployment
...
For the installation and deployment of ETL+ and Odata see ETL+ Deployment for Acumatica Cloud (OData) .
For choosing between versions of OData see Choosing Acumatica OData Versions
For solutions for problems with OData see Acumatica OData Extraction Issues
For technical information about Acumatica see Acumatica Technical Details
...