OData

OData Integration

Integrate OData with cloud applications and relational databases via Skyvia. Import OData objects directly to/from major cloud and on-premise data sources or perform OData sync in both directions.

Powerful mapping settings allow you to load and synchronize OData data with sources having different data structure. You can schedule your OData integration operations, like OData import or OData export, etc., to execute it automatically.

OData — On-Premises Integration

Skyvia provides the agent application that serves as a secure tunnel for connecting to on-premise databases without the need to expose them to the Internet directly and setting up port-forwarding. Skyvia Agent makes OData — on-premise integration easy, secure, and convenient.

Import and Export CSV Files

Import CSV files to OData endpoints and export data from OData-enabled sources to CSV files. Skyvia allows loading CSV files both from your computer and from various file storages. It can import several CSV files at once, import a single CSV file to several related OData entities, use powerful expressions for mapping, etc.

OData Data Replication

Replicate OData data to a relational database with Skyvia and maintain this database in an actual state. Our cloud data replication service (ELT) can be especially useful if you want to use data analysis and reporting tools for relational databases with your OData data.

Manage Your OData Data Easily

Use power of SQL to manage OData data via Skyvia Query tool. Skyvia provides OData SQL editor with visual query builder that allows you to perform select, insert, update, and delete commands directly against OData data. No need to study OData API.

Skyvia Query also includes Google Sheets Add-on and Excel Add-in that allow OData export to Excel and Google Sheets with data refresh in one click.