All Apps and Add-ons

Import complete Database tables using DB connect

splunkdivya
Explorer

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

venkatasri
Builder

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
Take the 2021 Splunk Career Survey

Help us learn about how Splunk has
impacted your career by taking the 2021 Splunk Career Survey.

Earn $50 in Amazon cash!