All Apps and Add-ons

Is it possible to connect Splunk DB Connect 2 works with an Azure SQL Database?

rubeniturrieta
Communicator

Hi guys,

I'm trying to connect Splunk DB Connect 2 with a SQL Azure database. Should this work? Are there any special considerations?

Any help will be grateful

Thank you

0 Karma
1 Solution

egcthistle
Explorer

Sure, though I had to make some changes/additions to various conf files to get this to work.

..\Splunk\etc\apps\splunk_app_db_connect\local\db_connection_types.conf
Add the following stanza

[sqlazure]
displayName = SQLAzure
useConnectionPool = false
jdbcDriverClass = com.microsoft.sqlserver.jdbc.SQLServerDriver
serviceClass = com.splunk.dbx2.MSSQLJDBC
port = 1433
jdbcUrlFormat =jdbc:sqlserver://<host>:<port>;databaseName=<database>
testQuery = SELECT 1 AS test

..\Splunk\etc\apps\splunk_app_db_connect\local\db_connections.conf
(this is mine just in case, I didn't need to make changes)

[yourDBName]
connection_type = sqlazure
database = yourDBName
host = yourDBServer
identity = yourIdentity
readonly = 1
disabled = 0
port = 1433

..\Splunk\etc\system\local\web.conf
add line

splunkdConnectionTimeout = 120

View solution in original post

egcthistle
Explorer

Sure, though I had to make some changes/additions to various conf files to get this to work.

..\Splunk\etc\apps\splunk_app_db_connect\local\db_connection_types.conf
Add the following stanza

[sqlazure]
displayName = SQLAzure
useConnectionPool = false
jdbcDriverClass = com.microsoft.sqlserver.jdbc.SQLServerDriver
serviceClass = com.splunk.dbx2.MSSQLJDBC
port = 1433
jdbcUrlFormat =jdbc:sqlserver://<host>:<port>;databaseName=<database>
testQuery = SELECT 1 AS test

..\Splunk\etc\apps\splunk_app_db_connect\local\db_connections.conf
(this is mine just in case, I didn't need to make changes)

[yourDBName]
connection_type = sqlazure
database = yourDBName
host = yourDBServer
identity = yourIdentity
readonly = 1
disabled = 0
port = 1433

..\Splunk\etc\system\local\web.conf
add line

splunkdConnectionTimeout = 120

rubeniturrieta
Communicator

Thanks you very much 😄

0 Karma

mholme59
Explorer

Thank you, this helped me as well.

0 Karma

roopasree
Engager

@egcthistle ,@kamlesh_vaghela ,@niketnilay ,@ranjith_kumar @493669 @harishalipaka @FrankVl @rubeniturrieta @mholme59

Hi guys,

I am able to send data from splunk to sql server,
Now I need to send data from splunk to Azure portal Sql ,in this process what is the option to select connection type .

please suggest one link or document to send data from splunk to Azure SQL.
Thanks in advance.

0 Karma
Get Updates on the Splunk Community!

Optimize Cloud Monitoring

  TECH TALKS Optimize Cloud Monitoring Tuesday, August 13, 2024  |  11:00AM–12:00PM PST   Register to ...

What's New in Splunk Cloud Platform 9.2.2403?

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

Stay Connected: Your Guide to July and August Tech Talks, Office Hours, and Webinars!

Dive into our sizzling summer lineup for July and August Community Office Hours and Tech Talks. Scroll down to ...