https://community.splunk.com/t5/Getting-Data-In/How-to-setup-quot-Metadata-quot-characteristics-in-Splunk-DB/m-p/220665#M43340 <P>Hello Friends, Please help me to solve this issue.. </P> Tue, 15 Sep 2015 06:46:03 GMT rupesh_patil20 2015-09-15T06:46:03Z https://community.splunk.com/t5/Getting-Data-In/How-to-setup-quot-Metadata-quot-characteristics-in-Splunk-DB/m-p/220664#M43339 <P>Hello,</P> <P>Finally I have configure my Remote sql server database with splunk using Splunk DB connect V2, but.. in my setup of last step I really don't know what to write(fill in those fields &gt;&gt; <A href="http://screencast.com/t/RNqNKkvn">http://screencast.com/t/RNqNKkvn</A> ). For your information I have taken the screenshot which will help you to guide me.</P> <P><A href="http://screencast.com/t/0xxdLo8W">http://screencast.com/t/0xxdLo8W</A> &gt; Done Name Input successfully<BR /> <A href="http://screencast.com/t/sIOhgIVFr">http://screencast.com/t/sIOhgIVFr</A> &gt; Choose and Preview Table successfully<BR /> <A href="http://screencast.com/t/OtezGx3nI1">http://screencast.com/t/OtezGx3nI1</A> &gt; Set Parameter successfully<BR /> <A href="http://screencast.com/t/RNqNKkvn">http://screencast.com/t/RNqNKkvn</A> &gt; What should I enter here in source and sourcetype?**</P> <P>From SQL Server I am retrieving the data, which i want to put in the index named "dev_zipcode". This data I needed for my application.<BR /> Thanks !!<BR /> Awaited for your quick response.</P> Mon, 14 Sep 2015 06:38:07 GMT https://community.splunk.com/t5/Getting-Data-In/How-to-setup-quot-Metadata-quot-characteristics-in-Splunk-DB/m-p/220664#M43339 rupesh_patil20 2015-09-14T06:38:07Z https://community.splunk.com/t5/Getting-Data-In/How-to-setup-quot-Metadata-quot-characteristics-in-Splunk-DB/m-p/220665#M43340 <P>Hello Friends, Please help me to solve this issue.. </P> Tue, 15 Sep 2015 06:46:03 GMT https://community.splunk.com/t5/Getting-Data-In/How-to-setup-quot-Metadata-quot-characteristics-in-Splunk-DB/m-p/220665#M43340 rupesh_patil20 2015-09-15T06:46:03Z https://community.splunk.com/t5/Getting-Data-In/How-to-setup-quot-Metadata-quot-characteristics-in-Splunk-DB/m-p/220666#M43341 <P>You set them to values that make it easy for you to understand where the data came from (source), and what format it is (sourcetype). So for example, I have a DB input set up where I set source to the name of the database and table, <CODE>securitylogs_AccountUpdates</CODE>, and I set the sourcetype to <CODE>securitylogs</CODE>. I then used the sourcetype to describe how to parse the timestamp in <CODE>props.conf</CODE>. That way, if I set up more inputs from other tables in the same database, I can use the same sourcetype so I get all that parsing done the same way.</P> <P>You might not need any special parsing, so just make sure the values you put in Source and Sourcetype make sense for the future.</P> <P>Here's some more info on the two concepts:</P> <UL> <LI>Source: <A href="http://docs.splunk.com/Splexicon:Source">http://docs.splunk.com/Splexicon:Source</A></LI> <LI>Sourcetype: <A href="http://docs.splunk.com/Splexicon:Sourcetype">http://docs.splunk.com/Splexicon:Sourcetype</A></LI> </UL> Tue, 15 Sep 2015 11:56:10 GMT https://community.splunk.com/t5/Getting-Data-In/How-to-setup-quot-Metadata-quot-characteristics-in-Splunk-DB/m-p/220666#M43341 laserval 2015-09-15T11:56:10Z https://community.splunk.com/t5/Getting-Data-In/How-to-setup-quot-Metadata-quot-characteristics-in-Splunk-DB/m-p/220667#M43342 <P>Thanks Laserval.<BR /> I will do the needful as you suggested. </P> Wed, 16 Sep 2015 05:49:03 GMT https://community.splunk.com/t5/Getting-Data-In/How-to-setup-quot-Metadata-quot-characteristics-in-Splunk-DB/m-p/220667#M43342 rupesh_patil20 2015-09-16T05:49:03Z