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?

Best Answer

  • Options
    BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 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.



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