Am new to Telegraf & have some questions related to possibilities of achieving it from Telegraf.
- Execute a Python script which basically will load a table in SQL Server every 1 second.
I don’t wish to use the SQL Server inbuilt scheduler. There won’t be any output just execution of Python script for table loading with telegraf executing the script every 1 second in background.
2.Execute another Python script to connect to SQL Server , perform some data manipulations from Telegraf. This time the data needs to be pushed out to Influx DB.
The default input driver for SQL Server lacks some functionality that’s the reason I am using the Input.Exec to execute Python scripts.
Please , let me know do I need to run 2 different telegraf instances . 1 for the requirement one & another for second requirement It will be very supportive, if someone can share any example for requirement 1 & 2.
Thanks in advance