Accessing QIS data with your BI tools
In today’s data centric world more and more businesses rely on corporate wide Business Intelligence (BI) platforms to support their decision-making process.
However, connecting to the underlying data-sources can be problematic! Software solutions often have complex schemas and structures which are difficult to access, navigate and comprehend.
Furthermore, connecting directly to a live data-source for reporting purposes is a high-risk strategy that can cause serious performance issues for end users and can result in data loss.
What is the solution?
In recognition of the challenge, we want to make it easy for all customers to leverage the critical data contained within your QIS solution. The new QIS Report Driver takes the complexity out of data acquisition and manipulation by providing a simplified flattened structure which is easy to access, understand and utilize.
• Simplified data structure makes it easy to create reports and dashboards with 3rd party solutions
• Independent report tables eliminate performance issues and the risk of “live” data locks
• A single reporting database makes it easier to generate corporate wide reports
• Fast to implement, easy to manage and highly configurable
So, how does it work?
The QIS Report Driver is designed to export event data, test results, user comments and specifications from individual or multiple processes to a set of archive tables within a separate reporting database. Running in the background, the driver constantly scans QIS for any new or amended records and exports all changes as required.
Access to this vital information is further simplified through SQL views which combine data from all the reporting tables. Enabling your team to simply select and exploit a single dataset to drive reports and dashboard from your preferred BI solution.