Telegraf input.sql informix support

1

Per documentation, Telegraf doesn’t seem to support an Informix JDBC Driver. How can Telegraf be configured to access and query an Informix server.

2

Hello @swderry,
Welcome!
You can use the execd plugins:

Unless @skartikey has a better idea

1 Like
3

@swderry Welcome to the InfluxData community!

As @Anaisdg suggested, a great way to integrate Informix with Telegraf is by using the inputs.execd plugin. This allows you to run a custom script that connects to Informix, retrieves data, and outputs it in a format Telegraf understands.

Here’s how you can approach it:

  1. Write a script (in Go, Python, Bash, etc.) that queries your Informix database.
  2. Format the output using InfluxDB Line Protocol, which Telegraf can parse.
  3. Configure Telegraf to run your script via the execd plugin.

Sample execd Plugin Configuration

[[inputs.execd]]
  command = ["/path/to/your/informix_script.sh"]
  signal = "none"
  data_format = "influx"

Your script will handle the database connection and query logic, and simply print the results in line protocol to stdout for Telegraf to collect.