Connecting rapidminer with SQLite

jules_tjules_t Member Posts: 3 Contributor I
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

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 801 Unicorn
    Solution Accepted
    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

Answers

  • jules_tjules_t Member Posts: 3 Contributor I
    Thank you very much! My connection is no created successfully.
    Best regards,
    Julia
Sign In or Register to comment.