API to pull data from dT
Hello,
I am a Compuware Guardian Consultant and my client wanted to know if we have an api to pull data out of dT (be it from performance warehouse or session store or from the server itself).
Basically they want to take this data from dT and present it in their own home grown dashboard app which is build using these technologies Oracle, MS SQL Server and Informatica.
Not sure if we have other customers who had similar requests but I just wanted to know if this was even possible.
A second option, which personally I am not in favor of, is to query our database and extract relevant data but that would require for us to know the database schema.
Any help is highly appreciated.
Thank you for your time.
Srikar
Hi Srikar,
There is no API as such, and the PW schema is not public (but also not so hard to figure out).
Something that I've done is to build dashboards that have the data I want, then use our reporting interface to deliver the data in some other format like XML, Excel XLS, or CSV. Then the customer can take that data (most popular for me is XML) and render that along with other data in some integrated reports.
Hope this helps,
Rob
Hi Srikar
To add to Rob's comment. Here is the link to the REST interface that he is talking about: Reporting REST
Andi
Rob, Andi,
Thank you for your prompt responses.
I will let my customer know they can export data in the above mentioned formats.
Thanks,
Srikar
