OData Replication to PostgreSQL

Create a copy of OData data (with schema) in a PostgreSQL database with no effort.

How It Works

Copying OData data to PostgreSQL cannot be simpler. You just need to perform the following three simple steps.

OData replication to PostgreSQL - OData connection

Specify necessary connection parameters for OData.

OData replication to PostgreSQL - PostgreSQL connection

Specify necessary connection parameters for PostgreSQL.

Skyvia supports secure connections to PostgreSQL.

OData replication to PostgreSQL - select objects

Select OData objects to replicate.

Just select check boxes in a list of OData objects (e.g. entities). If necessary, you can tweak it in more details - replicate only part of OData fields and filter data to replicate.

Key Features

Automatic Schema Creation

You don't need to prepare the PostgreSQL database - Skyvia creates the tables corresponding to the OData objects - entities - automatically.

Execution on Schedule

Skyvia can more than just create a copy of the OData data in PostgreSQL - it can keep this copy in an up-to-date state automatically. All you need is to configure a schedule when to update the PostgreSQL replica database.

Complete or Partial Replication

With Skyvia you can copy all the data from a OData object or disable replication for some OData object fields. You can also configure filters for data to replicate.