With the recent update of TrakIT, you can now use your TrakIT installation as a real-time data source for Dashboarding software such as Power BI, Tableau, Google Data Studio and many more.
Configuring the Data Source
TrakIT does not allow direct connections to its database. However, TrakIT can expose any information via a web API endpoint that can be used to retrieve information from specifically designed query reports.
The API endpoint must be in the following syntax:
https://trakit.[yourcompany.com]/api/public/queryreport?APIKey=[YourKey]&RepID=[ReportID]&AsFile=true
Replace the highlighted parts above with the correct information. Please connect with the TrakIT Support team to obtain your API Key and Report ID. The "AsFile" parameter allows you to directly get the report in the designed format (xlsx, csv or txt). If set to false, the API responds with Json format data.
Please note that the above endpoint is accessible from the web to anyone who has the URL and hence must be kept strictly confidential.
Embedding the Dashboard in TrakIT
If the dashboard software you use has the capabilities for embedded dashboards, please let us know the embedded Url for your dashboard and we can include the dashboard in any internal dashboard page in TrakIT.
For any questions or concerns, please contact TrakIT Support.
