How to Import Data from the Bank of Canada Source

Before proceeding, please make sure that you have set up OWOX Data Marts and created at least one storage in the Storages section.

Bank of Canada Storage

Create the Data Mart

Click New Data Mart.
Enter a title and select the Storage.
Click Create Data Mart.

Bank of Canada New Data Mart

Set Up the Connector

Select Connector as the input source type.
Click Set up connector and choose Bank of Canada.
Leave the fields as default and proceed to the next step.

Bank of Canada Input Source

Bank of Canada Fill Data

Configure Data Import

Choose available endpoint.
Select the required fields.
Specify the dataset where the data will be stored (or leave the default).
Click Finish, then Save and Publish Data Mart.

Bank of Canada Publish Data Mart

Run the Data Mart

You now have two options for importing data from Bank of Canada source:

Option 1: Import Current Day’s Data

Choose Manual run → Incremental load to load data for the current day.

Bank of Canada Import New Data

Bank of Canada Incremental Load

ℹ️ If you click Incremental load again after a successful initial load,
the connector will import: Current day’s data, plus Additional days, based on the value in the Reimport Lookback Window field.

Bank of Canada Reimport

Option 2: Manual Backfill for Specific Date Range

Choose Backfill (custom period) to load historical data.

Select the Start Date and End Date.
Click the Run button.

Bank of Canada Backfill

The process is complete when the Run history tab shows the message:
“Success”

Bank of Canada Success

Access Your Data

Once the run is complete, the data will be written to the dataset you specified earlier.

Bank of Canada Import Success

If you encounter any issues:

Check the Run history for specific error messages
Please visit Q&A first
If you want to report a bug, please open an issue
Join the discussion forum to ask questions or propose improvements