I have a database file (test.db) that I would like to read into KNIME.
The DB is protected with a password.
I can access it via SQLiteStudio with the database type: System.Data.SQLite.
How can I establish the connection in Knime?
If i try to use the SQLite Connector i get an error like this:
java.sql.SQLException: Cannot get schemas from database. Reason: [SQLITE_NOTADB] File opened that is not a database file (file is not a database)