This article explains how to retrieve data from XStudio DB and allow analysis with pivot table.
This is useful
- when you don't find the data you need in the current reports
- when you need to do specific analysis using Pivot table
Before you do so, check that the reports of the statistic do not already contain what you need.
This article is based on Mysql ODBC driver - but should work with the other databases (Oracle, SQLServer, MariaDB), given that you can get an ODBC driver for it.
Step 1 - Download and install the ODBC driver that suits your target OS
For Mysql we tested with version 5.1 , on Windows 10 , using the 64 bits Driver - ODBC Driver
Step 2 - Configure a connection to the XStudio DB
This is done for the whole OS so that any application can use it. It defines the parameters to access the XStudio DB.
If you are an administrator you may trial the procedure with the DB admin credentials.
Once you have tested t and decided to enable it to users, we strongly advise you to create a MYsql account with access rights limited to to read access on the XStudio DB - This is done by your DBA.
They are multiple articles on the web that describe how to create an ODBC connection - hence we refrain from describing it here - just search on the web for "Create an ODBC Connection with Mysqk ( or the DB you are using)
Step 3 - Once the connection is defined in the ODBC DSN , start MS Excel, and start creating your request
the attached file drives you through the complte process of extractng the SUT and requirement data to establish all traceability matrices for all SUT. It can be easily extend to to include tests and/or bug traceability .