cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Export DMI Data to a 3rd PartyReport Generator

genesius_jarom1
Organizer

Is anyone using a 3rd party report generator with DMI? For the online reports the DMI engine(?) is great. However, when having to produce a PDF report, there are many issues with DMI. The main one being formatting. There is no way in DMI to create page breaks and use different font styles, etc.

Thanks in advance and God Bless,

Genesius

9 REPLIES 9

david_alonso
Dynatrace Pro
Dynatrace Pro

I don't know in which version you are, but you can use the rest interface to get the data to show in other tools:

https://community.dynatrace.com/community/display/...

There are improvements in the 12.4 too. I hope it helps

An other solution is to use task scheduling:

https://community.dynatrace.com/community/display/...

For your need, you can configure a new task which will generate a csv file from a DMI report and send the result into a FTP file. Then, the datafile can be processed by your 3rd party report generator.

I have seen that working well in some customers I worked with.

genesius_jarom1
Organizer

Thank you @david alonso and @antoine buffotot.

This
language is completely new to me, huge learning curve. So bear with me
if I ask some obvious, but ridiculously simple questions in the future.

Do
you know if there is a training video in the Academy that explains this
better? Also, one where the instructor is not talking so fast that it
is very difficult to follow? Are there other links, outside of
Compuware, that explain this language in a simplier way?

Thanks and God bless,

Genesius

brett_b2
Inactive

Hey Genesius,

I've had to export data from DC RUM to DataDog (a 3rd party BI tool) and made a DC RUM 'plugin' to help me do so. Check it out on my GitHub, https://github.com/barrebre/RESTfulDC

genesius_jarom1
Organizer

I was a database developer (Teradata and MS Access SQL) and wrote some VBA code for the last few years. In the past, I have written some simple webpages in HTML4, CSS; as well as working with XML for a few months. But with REST I am at a complete loss.

I have looked for tutorials and examples, and it is all foreign to me.

Do I need to install something on the CAS server first? I installed Rest Easy into my Firefox browser and after I connect to the CAS and try to run simple REST command (http://1.2.3.4:5/rest/dmiquery/getApplications) the browser continues to display "Please Wait. Sending the request" with no output. There less than 25 applications configured.

Again I apologize for my naivete, but I am completely confused.

Thanks and God bless,

Genesius

genesius_jarom1
Organizer

Told you I was naive with this. I forgot to add the :port after the CAS's IP address.

But now I don't know what to do with this output from REST Easy.

{"offset":0,"resultsCount":7,"count":7,"results":[["CVENT","Central Analysis Server"],["UEM","RUM Browser"],["HTTPLOG","Analysis"],["HTTPCOMP","Hit-level Analysis"],["ALARMS","Tools"],["HM","DB status"],["SYSTEMDIAG","Diagnostic"]]}

Where's the data, the list of my applications? Or does this get fed into another process?

Thanks and God bless,

Genesius

brett_b2
Inactive

Genesius,

Per the link David provided above, you can read the documentation on how to proceed from the 'REST Examples'. https://community.dynatrace.com/community/display/...

Now that you have found the possible applications to view, you need to submit another query. Next is getDataViews. It will be something like this:

1.2.3.4:5/rest/dmiquery/getDataViews?appId=CVENT

Where appId is the one you've chosen from the getApplications results.

Also, I would strongly encourage you to try to use the tool I developed for this exact use case. Instead of having to fiddle with the [cumbersome] REST interface, you can use a javascript tool to do all of the work for you. https://github.com/barrebre/RESTfulDC

Hope this helps!

genesius_jarom1
Organizer

Thanks @Brett Barrett,

I actually enjoy working with the code, I understand the process so much more when I do. "Give a man a fish you feed him for a day. Teach a man to fish you feed him for a lifetime."

At the present, I am not able to load your files onto the CAS. However, using a different REST plugin for FF I was able to get my output (response) but, I need it in CSV format.

Request

http ://1.2.3.4:5/rest/dmiquery/getDMIData3?appId=CVENT&viewId=ClientViewDb&resolution=r&dimensionIds=['bgAppl','appl']&metricIds=['cByte','sByte','c_sByte']

Response

{"columnHeader":["bgAppl","appl","cByte","sByte","c_sByte"],"formattedData":[["Appl1","2021APPLICATION","9208468.0","8.1067688E7","9.027616E7"],["Appl2","UAT_WEB","14326.0","44690.0","59016.0"],["Appl3","TEST-APP","161688.0","2669682.0","2831370.0"],etc.

With the different delimiters used -- , [ ] " -- how do import this into Excel, Access or another reporting tool. Is there a parameter for changing the Response to CSV, or Excel, or any other format. I added the parameter &type=csv to the end of the Request and the Response was the same as above.

Having this Request work is only a test to understand the functionality. How would the Request be written for a report that I created which includes the views, resolution, dimension, etc.?

Once I have this working, then I can research the Task solution @Antoine Buffotot suggested.

Thanks and God bless,

Genesius

Not for the moment they will get this format that is JSON format. It is an standard that a lot of tools are able to read. Mostly you can get it too in in javascript or java format. If you wan to get a csv from a DMI you have to go over the Antoine solution. On the task there is one of the parameters that allow you to export to a pdf or txt (csv).

Next week I'll be able to have a javacode that read this format coming from a CAS, I'm working in a DT AM plugin to get in in the DTAM as a metric, If I've the time I hope to finish it next week.

I hope it helps