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

Best (or easy) Practice for exporting time series from API to SQL server

chris_nelson
Guide

Hello:

Thank you to the DT community for your help with my previous question(s).

 

New Question:

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.

 

Kindest regards,

 

 

 

1 REPLY 1

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).

Sebastian