18 Sep 2019 07:47 AM - last edited on 08 May 2021 10:23 PM by MaciejNeumann
Thank you to the DT community for your help with my previous question(s).
My company has a need to export several sets of timeseries data and store the results in in a SQl server
for consumption from multiple 3rd party apps.
I am unfamiliar with a best way to achieve this.
My first outline would go something like this.
1) From a command line run a CURL command using API v2 to request the data in CSV format
2) Import the CSV file data into SQL (somehow... is there an easy way? )
I have been trying to familiarize myself with all the options..but if there is a larger more supported or recognized way of doing this easily please share any recommendations for how to achieve this.
Solved! Go to Solution.
I'm developer so maybe I have different point of view. But I think it may be much better to create script that will fetch metrics using CRON from Dynatrace API and then send them to MSSQL. It should be easiest to do that in python (https://docs.microsoft.com/en-us/sql/connect/python/python-driver-for-sql-server?view=sql-server-201... -> python connector for MSSQL).