All Apps and Add-ons
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Ask a Question
Highlighted

DB connect to SQL to several databases within the same connection

jl
Engager
‎09-17-2019 04:45 AM

Hello.

I'm currently using DB Connect version 3.1.4 Build 42 on a Heavy Forwarder running 7.1.2.

Having a Database connection using driver MS-SQL Server jTDS up and inputs working. When you stet up the connection you choose 'Default Database' to point to the database within your instance you would like to query.

I can't find a way to configure so I can query 2 or more databases in the same connection other than create a new connection and point that database in the 'Default Database'. This would end up with many connections for an average SQL with lets say 25 databases.
Is this possible and how do you configure that?

Ex: A SQL servers holds some databases:
tempdb
master
model

I would like my DB connection to be able to query all 3 databases from the same connection in the same select statement.

Regards,
Jan

0 Karma
Reply
Speak Up for Splunk Careers!

We want to better understand the impact Splunk experience and expertise has has on individuals' careers, and help highlight the growing demand for Splunk skills.