Add Source: New OData connection.
Properties: Maintain OData connection.
Refresh: Update source OData metadata.
Alias. The name for the source object shown on the Source Objects panel. Unless customized the name will be automatically generated based on OData feed(URL).
Schema: Controls the schema name assigned to the target tables in the Target Object panel.
When dimmed or unchecked, the SQL schema name is the EntityID. (The EntityID shown on the example above is
When checked, the schema name is based on the Alias.
Odata feed(URL). URL to the OData source system.
User and Password: Credentials with reading rights from OData.
Auth Scheme: Select the Basic option.
Extraction pages. Number of rows extracted in one page or block. The default is 5,000.
Pause. Length of pause in milliseconds between pages. The default is 500.
Back. Leave the page without saving or attempting to connect.
Connect. Connect to the Odata source. Same function as Refresh.
Save. Save the configuration without attempting to connect.
Change DataSource. Only shown when opened by Properties.
How to Add OData Connections
Select Add Source > OData.
For more about preparing to connect to a OData source system see:
How to Maintain OData Connections
Select Properties > OData
Related Pages about Acumatica (OData)
ETL+ for Acumatica Cloud (OData) – – a tutorial on extracting Acumatica tables with the OData driver into a data warehouse.
OData URL from an Acumatica Instance – How to construct the Odata Feed(URL).