All Apps and Add-ons

Import complete Database tables using DB connect


Hi There!

I have a usecase wherein I need to import the complete database, like one particular table of ALL the Schemas of ALL the catalogs available in a connection in one input.
I do have access to the Database as well
Do we have a way around for the same.

Thanks in advance for your help!

Labels (1)
Tags (1)
0 Karma

Path Finder

Hi @splunkdivya 

  • You can use Splunk DB connect batch input to import entire table, it takes a while depends on schedule of input and table size
  • You will need one input for each table in schema unless you write a SQL query that combines all the information from multiple tables which might be complex I wouldn't do that

Note: "Batch input mode is ideal for unchanging historical data that will be indexed into Splunk once. It can also be useful for re-indexing data that updates through time"

Splunk docs link would help to start with, How Splunk DB Connect works - Splunk Documentation 


An upvote would be appreciated if it helps!

0 Karma
.conf21 CFS Extended through 5/20!

Don't miss your chance
to share your Splunk
wisdom in-person or
virtually at .conf21!

Call for Speakers has
been extended through
Thursday, 5/20!