I have a sql database which will update daily , How can i schedule a upload of the data from this DB to a lookupfile in splunk.
On the off chance that your SQL Database vendor is MYSQL , then you can perform lookups directly against the DB:
http://splunk-base.splunk.com/apps/36664/splunk-mysql-connector