Load data from InfluxDB into RapidMiner

moritz27

Hello all,

i need to analyze data stored in a InfluxDB. Sadly there is no JDBC driver for this database. Is there any way to do this anyway?

I have searched the web and this forum without any usefull hint.

Any help is appreciated!

Best regards and thanks in advance

MarcoBarradas

Hi @mortiz,

It seems you can connect to it via API
https://docs.influxdata.com/influxdb/v1.8/tools/api/

For this you can download the WebMining Extension from the marketplace and use the Get Operator or Post depending on what you want to do.

moritz27

Thanks for your suggestion! Sadly Im not able to install extensions behind proxy, have to fix this first. Will reply if I have more details

moritz27

Hello again,

I managed to install the extension manualy but sadly I'm not able to query the DB. I get the following error:   "REST service could not be asccessed". When i try the same query from the same machine from CMD I get the expected result.

I tried the "/health HTTP endpoint" from the link you provided for the influxDB API: "curl -XGET "192.168.132.210:8086/health"

Any ideas? 

Aion

Hello all,

I need load data from influxDb with rapidminer set up connection jdbc follow Image capture?

Any help is appreciated!

Best regards and thanks in advance

rjones13

Hi @Aion,

Could you please post a screenshot of your driver tab as well?

Best,
Roland

Aion

Hi @rjones13

screenshot  driver is empty

Best,
Aion

rjones13

Hi @Aion,

If you're not using one of our pre-built connections, you'll need to add the driver yourself. This webpage should help: https://docs.rapidminer.com/latest/studio/connect/database/jdbc/

Best,
Roland

Aion

Hi @rjones13

Case use influxDb.
If driver have follow picture.
Please recommend file.jar download or choose file.jar.

Best,
Aion

rjones13

Hi @Aion,

I would look via a search engine for "InfluxDB JDBC driver", such as: https://dbschema.com/jdbc-driver/influxdb.html

Then follow the steps above.

Best,

Roland