Just commenting here because I'm not sure that the documentation is really clear on the point: when adding a local database like sqlite, the database name should be the fully qualified path to the database file.
Correct.
Alternatively you can place the SQLite file into $SPLUNK_HOME/var/dbx
(you might need to create this directory) and name it as database_name.sqlitedb
, then you can use "database_name" instead of the fully qualified path.
thanks for this information, the documentation has been updated to clarify:
http://docs.splunk.com/Documentation/DBX/1.0.8/DeployDBX/Addadatabaseconnection#Manage_database_conn...