VOOZH about

URL: https://www.cdata.com/kb/tech/odata-odbc-asprova.rst

⇱ Connect to OData from Asprova with CData ODBC Driver for OData

Connect to OData from Asprova with CData ODBC Driver for OData

👁 Jerod Johnson
Jerod Johnson
Director, Technology Evangelism
This article shows how to connect faster to OData data from Asprova.

The CData ODBC driver for OData enables you to access OData data from Asprova. In this article, you will import OData data into item data in Asprova as an example.

About OData Data Integration

CData simplifies access and integration of live OData services data. Our customers leverage CData connectivity to:

  • Access OData versions 2.0, 3.0, and 4.0, working with legacy services and the latest features and capabilities.
  • Leverage advanced query options, including $filter, $select, and $expand, enhancing data retrieval from 3rd party tools.
  • Use Server-side execution of aggregation and grouping to minimize data transfer and boost performance.
  • Authenticate securely using a variety of schemes, including Azure AD, digest, negotiate, NTLM, OAuth, and more means secure authentication with every connection.
  • Use SQL stored procedures to manage OData service entities - listing, creating, and removing associations between entities.

Customers use CData's solutions to regularly integrate their OData services with preferred tools, such as Power BI, MicroStrategy, or Tableau, and to replicate data from OData services to their databases or data warehouses.


Getting Started


Asprova setting

  1. Click File -> Data I/O Settings.

    👁 DataIO

  2. Double click the header of Item and open the Edit I/O dialog.

    👁 DataIO

  3. Select "No" from the RDB transaction combo box and close the dialog.

    👁 DataIO

Data driver setting

  1. Select "OLE DB" from combo box in "Data source" column.

    👁 DataIO

  2. Click button in Folder/database column and open the Data Link Property dialog. Select "Microsoft OLE DB Provider for ODBC Drivers" from the list of data provider.

  3. Select the Connection tab. Check "Use data source name" and select "CData OData Source" from DSN combo box.

  4. Click the Test Connection button and make sure you see the message "Connection successful".

Schema setting

  1. Click the button in "External table name" column and open the Table List dialog. Make sure tables in OData are listed in the dialog.

    👁 DataIO

  2. Click the button in "Field mapping" column and open the Item-Field Mapping dialog.

    👁 DataIO

  3. Open the context menu in the space between tables and click Delete All. Link corresponding fields by dragging mouse.

    👁 DataIO

  4. Click File > Import and data will be imported into Asprova.

Check data

Click Table View > Item. Be sure you can see the item data stored in OData.

👁 DataIO

Ready to get started?

Download a free trial of the OData ODBC Driver to get started:

 Download Now

Learn more:

👁 OData Icon
OData ODBC Driver

The OData ODBC Driver is a powerful tool that allows you to connect with live OData Services, directly from any applications that support ODBC connectivity.

Access OData services like you would any standard database - read, write, and update etc. through a standard ODBC Driver interface.