Load data from InfluxDB into RapidMiner

moritz27
moritz27 New Altair Community Member
edited November 5 in Community Q&A
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 :smile:

Answers

  • Marco_Barradas
    Marco_Barradas
    Altair Employee
    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
    moritz27 New Altair Community Member
    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
    moritz27 New Altair Community Member
    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
    Aion New Altair Community Member
    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
  • RolandJones
    RolandJones
    Altair Employee
    Hi @Aion,

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

    Best,
    Roland
  • Aion
    Aion New Altair Community Member
    Hi @rjones13

    screenshot  driver is empty

    Best,
    Aion
  • RolandJones
    RolandJones
    Altair Employee
    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
    Aion New Altair Community Member
    Hi @rjones13

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

    Best,
    Aion
  • RolandJones
    RolandJones
    Altair Employee
    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