Re: Other than the analysis tool, can you access the database files/tables? (271 Views)
Reply
Advisor
johnwseitz
Posts: 42
Registered: ‎05-09-2013
Message 1 of 6 (357 Views)

Other than the analysis tool, can you access the database files/tables?

It would be more convenient and practical if we were able to gain access to the tables on the data from LR runs.  Much the same way the tables are accessible in ALM/QC.  I know in the controller you can set a location to where the folder is created per run.  But the MDB file located in those folders appears to have no values, yet they can populate just fine in the analysis tool. 

 

many thanks

HP Expert
vmanolova
Posts: 528
Registered: ‎05-24-2012
Message 2 of 6 (321 Views)

Re: Other than the analysis tool, can you access the database files/tables?

[ Edited ]

Hi,

 

You can open the MDB files in Microsoft Access and they will contain a raw data.

 

Analysis is the tool which should be used to analyze the row results generated after the scenario run in the Controller.

 

Kind regards,

 

 

HP Support
If you haven’t tried it yet, come and join us in our entitled forums at Support Customer Forums
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Occasional Collector
Demian_Orlov
Posts: 3
Registered: ‎11-20-2013
Message 3 of 6 (303 Views)

Re: Other than the analysis tool, can you access the database files/tables?

Most Native monitors (like Windows Resources or Sitescope) save monitored info in plain text format (offline.dat and offl_*.def files), so Notepad or any other plain text editor/viewer are only tools other Analysis you can access monitored data.

Occasional Advisor
schernikov
Posts: 10
Registered: ‎08-19-2011
Message 4 of 6 (283 Views)

Re: Other than the analysis tool, can you access the database files/tables?

The structure of the Analysis DB is not public and not going to be such. The internal structure may change at any time.

The good option for you can be Analysis API - this is .NET api that allows you to access all the graphs data (except Raw Data). Filtering is also available tehre.

This is the recomended way.

Sergey Chernikov
HP LoadRunner R&D
Advisor
johnwseitz
Posts: 42
Registered: ‎05-09-2013
Message 5 of 6 (275 Views)

Re: Other than the analysis tool, can you access the database files/tables?

thank you -- can you please explain more about the API you referenced? 

Occasional Advisor
schernikov
Posts: 10
Registered: ‎08-19-2011
Message 6 of 6 (271 Views)

Re: Other than the analysis tool, can you access the database files/tables?

The best way to start is to look at the "Analysis API Reference".

It is available from the "Start Menu"->HP Software->Documentation->Analysis API Reference.

Also you can look to the sample application's sources (is installed together with LR):

 

C:\Program Files\HP\LoadRunner\samples\AnalysisAPI\AnalysisApiSample.zip

Sergey Chernikov
HP LoadRunner R&D
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.