Connection to Sqlite DB

Question

Thanks

I’ve added JAR file to jdbc connection to sqlite, but how I can test connection to insert data to DB ?

I did:

1.In destination I use DATABASE

2. In Database Update settings/Connection I put

jdbc:sqlite:@localhost:af_test.db

3. Save , but I got error message "Database connection required"

Answer 1

The Connection is the database connection you setup in the Database Connections. Once you create one it will show up in the list. The reason we do this is to allow you to define the connection once and then use it in multiple channels without having to define it over and over. Also you can update userName Passwords and server names in one place and it will update all the places it is used.

To create the connection please see this KB.

https://www.qvera.com/kb/index.php/2056/how-do-i-create-a-db-connection?show=2057#a2057