https://community.splunk.com/t5/Deployment-Architecture/Splunk-DB-Connect-How-to-access-data-from-an-Oracle-database/m-p/115538#M22909 <P>Hello Everyone,</P> <P>I need to fetch data from one table from an Oracle database, but can we fetch data from a table without a unique ID present?</P> <P>I am trying to do this using Database input connection of Splunk db connect app.</P> <P>Thanks<BR /> Gajanan Hiroji</P> Tue, 11 Nov 2014 16:32:29 GMT gajananh999 2014-11-11T16:32:29Z https://community.splunk.com/t5/Deployment-Architecture/Splunk-DB-Connect-How-to-access-data-from-an-Oracle-database/m-p/115538#M22909 <P>Hello Everyone,</P> <P>I need to fetch data from one table from an Oracle database, but can we fetch data from a table without a unique ID present?</P> <P>I am trying to do this using Database input connection of Splunk db connect app.</P> <P>Thanks<BR /> Gajanan Hiroji</P> Tue, 11 Nov 2014 16:32:29 GMT https://community.splunk.com/t5/Deployment-Architecture/Splunk-DB-Connect-How-to-access-data-from-an-Oracle-database/m-p/115538#M22909 gajananh999 2014-11-11T16:32:29Z https://community.splunk.com/t5/Deployment-Architecture/Splunk-DB-Connect-How-to-access-data-from-an-Oracle-database/m-p/115539#M22910 <P>If you are configuring a dbtail monitor on the table, then yes I believe you will need a unique field - preferably an incrementing numeric ID or a timestamp that Splunk can track and increment for the tail. </P> <P>If you are running a dbquery search or a dbdump input then you would not need a unique field. dbquery is real time and does not index the data returned in Splunk. dbdump will grab the entire contents of the table every time it runs; you can append a timestamp at that point and need not worry about a unique identifier or incremental field.</P> Wed, 12 Nov 2014 20:28:15 GMT https://community.splunk.com/t5/Deployment-Architecture/Splunk-DB-Connect-How-to-access-data-from-an-Oracle-database/m-p/115539#M22910 pmdba 2014-11-12T20:28:15Z