topic Re: how to upload oracle table dump or CSV files in splunk collection? in Getting Data In

how to upload oracle table dump or CSV files in splunk collection?

abarnwal — Fri, 22 May 2015 15:12:24 GMT

Hi All
We have a requirement to upload oracle table dump to splunk collection. We have generated dump in CSV file format but couldn't find any utility to upload the same in splunk collection. We have got to know splunk collection works in similar fashion as Mongo DB collection. We have found a command to upload CSV file in mongo DB collection but didn't find any option to run same command in splunk. Please let us know if there is any option to achieve the same.

Thanks in advance

Re: how to upload oracle table dump or CSV files in splunk collection?

abarnwal — Fri, 22 May 2015 15:16:09 GMT

Below is the command to load csv file in mongo DB collection:

mongoimport --db users --collection contacts --type csv --headerline --file /opt/backups/contacts.csv

Here collection name is contacts and CSV file name is contacts.csv.

Re: how to upload oracle table dump or CSV files in splunk collection?

neelamssantosh — Sat, 23 May 2015 14:59:18 GMT

If the csv/file and splunk are in same location then use the below link upto "upload lookup table"
http://docs.splunk.com/Documentation/Splunk/6.2.3/PivotTutorial/AddlookupfilestoSplunk

then to search/access the data use the command,
"| lookup filename.csv" or "| inputlookup filename.csv"

For more information,
http://docs.splunk.com/Documentation/Splunk/6.2.3/Knowledge/Addfieldsfromexternaldatasources

Re: how to upload oracle table dump or CSV files in splunk collection?

abarnwal — Mon, 25 May 2015 06:28:54 GMT

@Neelamssantosh, Thanks for your reply.
The link which you have provided is for creating file based lookups to search data more efficiently.
My requirement is different. I need to load oracle table dump/CSV files in splunk KV store collection.
Please refer to below link to know more about KV store collection:
http://dev.splunk.com/view/SP-CAAAEZT