ETL+ Source Driver for OData
Creates and manages Source Objects that connect to OData files.
Add Source: New OData connection.
Properties: Maintain OData connection.
Refresh: Update source OData metadata.
Where to Find in ETL+
OData Page
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
sample_entity)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 menu
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.
 | Help |
 | Change DataSource. Only shown when opened by Properties. |
How to Add OData Connections
Open the ETL+ Extract, Transform and Load (ETL) Page for the ETL+ entity to edit.
Select Add Source > OData.
For more see the OData Page section above or ETL+ for Acumatica Cloud (OData)
For more about preparing to connect to a OData source system see:
How to Maintain OData Connections
Open the ETL+ Extract, Transform and Load (ETL) Page for the ETL+ entity to edit.
Select a OData based Source Object on the Source Objects panel.
Select Properties > OData
For more see the OData Page section above or or ETL+ for Acumatica Cloud (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).
Related ETL+ Pages
Position in the ETL+ Interface
Extract, Transform and Load (ETL) page
Add Source, Properties or Refresh buttons