Use the reporting tool of your choice – seamlessly integrated thanks to the latest OData standard interface.
Are our project budgets being met? What is the current status of our strategic goals? What data does our management need for the next portfolio meeting? In-depth reporting and analyses of your company’s activities are essential, including for measuring success as well as achieving a strategic orientation and better overall decision-making.
With Clarity as the single source of truth in your company, you have a database full of relevant data from your projects and other investments. The ability to select meaningful data that is attractively visualized will make or break your reporting. The best way to do this is to use a suitable tool that your users already know and that is already integrated into your software infrastructure. Perhaps you also have specific guidelines as to how and where data should be further processed, such as, for example, in an Excel template?
Simply exporting and importing data is often inconvenient and prone to errors. And not every reporting solution meets the criteria mentioned above.
We have the solution for all itdesign Clarity SaaS customers: an interface based on the latest OData standard that allows you to query data from the Clarity database. The advantage is that it lets you use the reporting tool of your choice. The data transfer works smoothly and easily: You select the data in the Clarity data warehouse that you would like to make available. You retrieve the desired data with just a few clicks in the reporting tool of your choice (e.g., Microsoft Power BI, Microsoft Excel, Tableau) and assemble the desired attributes and objects for reporting. You can use all popular features, such as filters, calculations, and various types of visualizations, intuitively and without the need for special training or support from your service provider.
One further added value: You can control and restrict data access based on your rights assignment in Clarity. This ensures that individual users or rights groups can only see the data that they actually need at the project and resource level in the reporting tool.
An OData Standard Reporting Interface
We use the latest technology to transfer data between Clarity and your reporting tool: an interface based on the REST1 and OData standards.
OData stands for the Open Data Protocol. It is an https-based protocol published by Microsoft that enables data exchange between compatible cloud software solutions.
Our OData service gives you read-only access to the data in Clarity’s data warehouse. The Clarity database is integrated into your reporting tool as a data source via URL and login and can be accessed and further processed there. The bottom line is that all you need are login credentials to itdesign’s OData service and your reporting platform.
1 REST stands for Representational State Transfer, a programming paradigm that is intended for creating machine-readable web-based applications.
These Functions Bring Your Added Value
From functional to technical: We have already found a solution for numerous specific requirements for Clarity systems. You too can benefit from our many years of practical experience with 130+ customers and save valuable time and money!