Sign-up our Newsletter  Register on our LinkedIn  Follow us on Twitter  Check out our Facebook  Follow us on Google+

Extract and analyze XStudio data from Excel

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 .





Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.