Import Data from CSV (or DB Table) into Prometheus. See example data.

[Jason]

Hi

We use "OpenText Monitoring Agent" which produces this output:

https://github.com/MrHull01/OpenText/blob/main/OT.csv

This data can also be written into a DB table.

What's the easiest (little programming) way to import the data (not
historical) into Prometheus? Which exporter?

Is this data compatible with OpenMetrics standard? Or is there some
parsing / scripting needed?

Which possibilities exists?
Now

thanks
Jason

[Ben Kochie]

No, the data is not compatible and will have to be transformed into Prometheus/OpenMetrics format.

You can write your exporter in any language you want, there are number of official client libraries.

See the documentation:
* https://prometheus.io/docs/instrumenting/writing_exporters/

* https://prometheus.io/docs/instrumenting/clientlibs/

If the data is in an SQL table, you could possibly convert it with an "SQL Exporter".

* https://github.com/justwatchcom/sql_exporter

* https://github.com/free/sql_exporter

--
You received this message because you are subscribed to the Google Groups "Prometheus Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to prometheus-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/8613f71c-79f2-4981-a9bd-9a96c5ecba1e%407748229.xyz.

[Jason]

On 23.08.23 12:07, Ben Kochie wrote:
> If the data is in an SQL table, you could possibly convert it with an
> "SQL Exporter".
> * https://github.com/justwatchcom/sql_exporter
> <https://github.com/justwatchcom/sql_exporter>
> * https://github.com/free/sql_exporter

> <https://github.com/free/sql_exporter>

Hi Ben

We will use SQL Server.
Which of the 2 exporters do you recommend?
I wish to run it in a Docker container.

thanks
Jason