ETL+ Source Driver for OData

Owned by Cortlandt _
Last updated: about 3 hours ago
3 min read

Creates and manages Source Objects that connect to OData files.

Source Objects panel button toolbar. Part of the ETL page.
Source Objects panel toolbar

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

  1. Open the https://dataself.atlassian.net/wiki/spaces/DS/pages/1570013215 for the ETL+ entity to edit.

  2. Select Add Source > OData.

For more see the OData Page section above or https://dataself.atlassian.net/wiki/spaces/DS/pages/1571226038

For more about preparing to connect to a OData source system see:

How to Maintain OData Connections

  1. Open the for the ETL+ entity to edit.

  2. Select a OData based Source Object on the Source Objects panel.

  3. Select Properties > OData

For more see the OData Page section above or or

  • – – a tutorial on extracting Acumatica tables with the OData driver into a data warehouse.

  • – How to construct the Odata Feed(URL).

Position in the ETL+ Interface