Connecting rapidminer with SQLite

jules_t
jules_t New Altair Community Member
edited November 2024 in Community Q&A
Hello community, I´ve searched for similar questions in advance but cannot really adapt the answer I´ve seen so I will try this way. I would like to import data from our database which is in SQLite. To establish the connection I downloaded the JDBC Driver for SQLite and followed the steps in the assistant to create connections. The problem is I don´t have a value for "port" since SQLite doesn´t listen to a port as I understand.
Can anyone help me?
Tagged:

Best Answer

  • BalazsBaranyRM
    BalazsBaranyRM New Altair Community Member
    Answer ✓
    Hi @jules_t,

    you can set the JDBC URL specification to manual and enter the path there:


    You just enter the file name of your database after the jdbc:sqlite: part.

    Regards,
    Balázs

Answers

  • BalazsBaranyRM
    BalazsBaranyRM New Altair Community Member
    Answer ✓
    Hi @jules_t,

    you can set the JDBC URL specification to manual and enter the path there:


    You just enter the file name of your database after the jdbc:sqlite: part.

    Regards,
    Balázs
  • jules_t
    jules_t New Altair Community Member
    Thank you very much! My connection is no created successfully.
    Best regards,
    Julia

Categories