All Apps and Add-ons

How can I connect multiple databases in Splunk DBConnect?

saibal6
Path Finder

I have installed and configured Splunk DB_Connect in my Splunk instance, and connected one database with it and it's working successfully.

But I want to connect multiple database server without creating multiple db connections in the Splunk DB_Connect. Is this possible?
Are there any limitations of database server connections?

Please suggest to me the best way to connect multiple database servers without creating multiple db connections and please attach a link also.

0 Karma

DalJeanis
SplunkTrust
SplunkTrust

I'm not sure what your reasoning is here. Why would you want to juggle all that? Your DBConnect will need, for each target database, proper connection strings as well as proper SQL queries to retrieve data. Each database will have distinct data and distinct queries.

Even if you are, for example, querying production and UAT version s of the same database, you are much better off procedurally setting those up as separate connections, so that you can make sure they each get ingested into the appropriate indexes.

adonio
Ultra Champion

imho you have to create a connection for each database.
how can you connect to multiple servers (with multiple unique databases in them) with a single connection?
would love to learn i am mistaking here, but to your first question, the answer in my opinion is: "no".
as for the second question regarding limitations of db server connections, do you mean from the splunk DB Connect app side?? or from the db server side?
as for your suggestion request, like mentioned above, would love to learn i am wrong here, but i dont think there is a way.
hope it helps

Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...