Can I use an ODBC connector and poll data from another database into InfluxDB? The clients database is extremely old but I can read values using ODBC. I want to poll it every 10 minutes and read and store about 1000 values coming in from a SCADA system.

Excellent idea. I also see it suports CSV files so I suppose a clumsy way forward would be to trigger an Excel file to launch, collect the data using ODBC, save it as a CSV file, then launch an input reader to collect the CSV file and process it. I could do this once per day. I couldn’t find docu…

So something to remember is that Telegraf will run every 10 seconds(by default). You don’t really schedule an input plugin inside Telegraf, it just runs at the set interval. The other option instead of using telegraf is to write a script and run it either as a service or in cron. We do both(scripts…

I wrote a simple Python script that opens the ODBC connection, grabs my data, creates a CSV file and writes to the file then shuts down. All works perfectly. The format is Tag_ID, TimeStamp,Value So I have multiple rows with timestamps for every device ID, some have only a few entries, some have …

If you only need to do this every 24 hours, I would probably skip Telegraf altogether. Run your python script to build/collect the data(skip the CSV completely) and store it as an array. Then create a second part of your script that just writes it to influxdb directly Docs for doing so Writing Da…

Copy time series data from an ODBC compliant database to InfluxDB

Esity December 12, 2018, 3:48am 2

Not directly but you could use the exec plugin. With this you would write a script(ruby,python etc) that can grab this data and return it to Telegraf. From there it could be stored in Influx.

Topic		Replies	Views
Data ingestion continuously Telegraf telegraf	2	913	November 25, 2019
How to collect stock market data from a datafeed (EODHistorical) through Telegraf? Telegraf telegraf , time-series , python	2	1571	December 4, 2021
Easiest way (for a beginner) to import csv data with time Telegraf csv	4	8135	March 10, 2021
Data ingestion - CSV files Telegraf telegraf	7	2517	November 11, 2019
InfluxDB v2 input plugin? Telegraf	4	1100	February 3, 2022

Copy time series data from an ODBC compliant database to InfluxDB

Related topics