Connecting rapidminer with SQLite

jules_t

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?

BalazsBaranyRM

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

BalazsBaranyRM

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

Thank you very much! My connection is no created successfully.

Best regards,

Julia