Data Extraction via API (OData)
The statistical data can be accessed via API using OData. OData (Open Data Protocol) is an ISO/IEC approved, OASIS standard for exposing data via a rest API. It is natively supported as a data source in the majority of BI tools, including Microsoft PowerBI, Qlik, SAP BusinessObjects,… All testing has been done with Micrososft PowerBI.
Accessing the data requires you to generate an API token and using that token in the software of your choice to expose the data.
Generating the token
You can generate a token under your user preferences, in the section ‘Personal access tokens’.
Click on ‘Generate new token’ and give the token a meaningful name. Click on ‘Create’ to generate the token.
Generating a token
The token needs to be copied from the interface at this moment. You will not be able to see the token again at a later stage. If you forget the token, you will need to generate a new token and update your consumers.
Connecting to the data source
In this example we will use PowerBI. Consult the manual of your BI tool if you are using a different tool.
In PowerBI, create a new report. Go to ‘Get data' and select 'OData feed'
Register a basic OData feed with the correct URL. The URL is the same address used to log in to DOQMIND, with “/odata“ added to the end.
example of the URL used in PowerBI
You’ll be asked to authenticate. Select ‘Basic’ and fill ‘apikey’ as username and the token you generated before as password. Make sure you select the URL that ends with ‘odata’ from the dropdown.
configuring the OData feed in PowerBI with the token and selecting the correct URL
Click connect.
You will see the 3 available datasets in the Navigator menu. Select the sets you want to use and click ‘Load’ or 'Transform', depending on what you want to do. The data will load and you can now start building dashboards.
The 3 datasets that are available are identical to the Projects, Tasks and Actors dataset as described here.
