To connect to the OData endpoint using the credentials provided by Rego on Clarity 15.7 and above first Upon request, Rego will setup an ODATA connection into your Clarity instance. This may be used to connect tools such as Microsoft PowerBI to Clarity data. The process of querying data into PowerBI requires detailed knowledge of the Clarity dataset and is not meant to replace the supported reporting tools within Clarity.
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 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 the OData endpoint, set the URL as:
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>_devV4
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:
...