Open Exchange Rates (Edge)

Configure Open Exchange Rates as a Source in your Pipeline

Perform the following steps to configure your Open Exchange Rates Source:

1. Click Pipelines in the Navigation Bar.

2. Click + Create Pipeline in the Pipelines List View.

3. On the Select Source Type page, select Open Exchange Rates.

4. On the Select Destination Type page, select the type of Destination you want to use.

5. In the Configure Source screen, specify the following:

   

   • Source Name: A unique name for your Source, not exceeding 255 characters. For example, Open Exchange Rates Source.

   • In the Connect to Open Exchange Rates section, specify the following:

     • App ID: The App ID that you obtained from Open Exchange Rates.

     • Historical Data Start Year: The year from which Hevo must ingest the daily historical exchange rates. Hevo ingests the rates starting from 1 January of this year. Default value: 2010. You cannot change this value after you create the Pipeline. Read API Requests and the Historical Data Start Year to choose a value that your plan supports.

6. Click Test & Continue to test the connection to your Open Exchange Rates Source. Once the test is successful, you can proceed to set up your Destination.

---

Data Replication

Hevo replicates data for all the objects selected on the Configure Objects page during Pipeline creation. By default, all supported objects and their available fields are selected. However, you can modify this selection while creating or editing the Pipeline.

Hevo replicates data in the following ways:

• Historical data: In the first run of the Pipeline, Hevo ingests the daily exchange rates of each day from 1 January of the Historical Data Start Year up to the last day that has ended in Coordinated Universal Time (UTC).

• Incremental data: In each subsequent run, as per the sync frequency:

  • For the Historical Rates object, Hevo ingests the daily exchange rates of each day that has ended since the last ingested day. Hevo does not ingest the rates of the current UTC day until the day ends.

  • For the Currencies and Latest Exchange Rates objects, Hevo ingests the entire data of the object and replaces the existing record in the Destination.

You can resync all the objects.

Note: You can create a Pipeline with this Source only using the Merge load mode. The Append mode is not supported for this Source.

---

Schema and Primary Keys

Hevo uses the following schema to upload the records in the Destination. For a detailed view of the objects, fields, and relationships, click the ERD.

---

Data Model

The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:

---