Upon request, Rego will setup an ODATA connection into your Clarity instance. This may be used to connect tools such as Microsoft PowerBI to the Clarity data warehouse schema. The process of querying data into PowerBI requires detailed knowledge of the Clarity data warehouse dataset and is not meant to replace the supported reporting tools within Clarity. Access to the Clarity transactional data is not possible.
First, create a username in Clarity that will be the “Service Account” for all ODATA connections. For this new username, make sure that Force Password Change for the user is unchecked and External Authentication for the user is unchecked. You will also need to provide “OData – Access” and “Data Warehouse OData Service - Navigate” rights to the user.
Second, run the ‘Load Data Warehouse’ and then the ‘Refresh Data Warehouse OData Model’ before the first connection from Power BI. Run the ‘Refresh Data Warehouse OData Model’ job every time there is a structural change to the DWH (example – tables/columns added/removed).
Lastly, to connect PowerBI to ODATA, set the endpoint URLs, these can be found within Clarity in Admin > Settings:
https://odata-<environment_tier>.us-services.moventus.com/api/odata/<OData_authenticator>_dev
https://odata-<environment_tier>.us-services.moventus.com/api/odata/<OData_authenticator>_ds
And set the username in this specific pattern:
User: <clarity_username>|<OData_authenticator>
Password: <clarity_user_password>
An example below:
Once connected the tables will be available to retrieve data:
