🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Load data from InfluxDB into RapidMiner

User: "moritz27"
New Altair Community Member
Updated by Jocelyn
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:

Find more posts tagged with

Sort by:
1 - 9 of 91
    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.

    User: "moritz27"
    New Altair Community Member
    OP
    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
    User: "moritz27"
    New Altair Community Member
    OP
    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? 
    User: "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
    Hi @Aion,

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

    Best,
    Roland
    User: "Aion"
    New Altair Community Member
    Hi @rjones13

    screenshot  driver is empty

    Best,
    Aion
    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
    User: "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
    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