Export dynaTrace sessions data in SQL Server
Is the dynatrace team planning to setup a process whereby the sessions could be exported in a database (i.e., SQL server) so it could be used to create custom reports? I am creating weekly management reports and they are pretty arduous given the fact that I have to copy and paste the purepaths data in an Excel file and massage them to create the custom reports. It would be a lot easier if there was a way to export the data directly into SQL and write queries to create the reports.
Regards,
Anoh Brou
Hi Anoh! Do you have a sample what this report looks like? Dynatrace comes with a couple of export mechanisms the question is which one is the right one for you. Eg. Business transaction export, rest interface,...
Hi Klaus,
Here is a sample of a management report that I have been creating. It is really painful as I have to copy the purepaths data into Excel, massage it and create the report along with the graphs.
Regards,
Have you looked at the Server- and Clientside XML Reporting? It allows you to pull out data from any dynatrace dashboard and receive it as XML. You can also use the Reporting (REST) to get any type of report format we provide (CSV, Excel, ...). So - using these REST INterfaces allows you to query any type of data from dynatrace in a programatic way. You could write a little tool that queries that data through REST - simliar to what you proposed for getting data from a SQL Database.
I hope this works for you. The REST Interfaces we provide are pretty powerful and many users use them to pull out data in an automated way and use it in external tools or reports
Andi
