Splunk Search

Splunk DB Connect: How to connect custom Netezza database?

theouhuios
Motivator

I am trying to connect a Netezza DB to Splunk via DB Connect. Please see the database_type.conf below .

    [netezza]
    displayName = NetezzaDB
    jdbcDriverClass = org.netezza.driver
    defaultPort = 5480
    connectionUrlFormat = jdbc:netezza://{0}:{1}/{2}
    testQuery = select * from _v_user

The jar file is placed in bin/lib too. I get an error Encountered the following error while trying to save: In handler 'databases': JDBC driver (org.netezza.driver) for database type NetezzaDB is not installed

-rwxr-xr-x 1 splunk splunk  345064 Oct 22 13:36 nzjdbc.jar

has anyone connected a Netezza Db to splunk?

Errors: Logs says its registering JDBC driver. But still it errors

2014-10-22 14:17:13.281 dbx1309:INFO:Generic - Registering JDBC driver=org.netezza.driver
2014-10-22 14:17:13.281 dbx1309:ERROR:DatabaseInfoCommand - Error while executing command: Error getting database connection: JDBC driver (org.netezza.driver) for database type NetezzaDB is not installed

esix_splunk
Splunk Employee
Splunk Employee

For DBX 2, the following will work for Netezza:

[netezza]
displayName = Netezza
jdbcDriverClass = org.netezza.Driver
serviceClass = com.splunk.dbx2.postgres.PostgresJDBC
port = 5432
jdbcUrlFormat = jdbc:netezza://<host>:<port>/<database>

ServiceClass is derived from Netezza being a Postgres derivative. If there is a better serviceClass that this should be using, someone please let us know.

0 Karma

datasearchninja
Communicator

HI. The class name is org.netezza.Driver, rather than org.netezza.driver

I have this setup configured and working:

[netezza]
displayName = Netezza
jdbcDriverClass = org.netezza.Driver
defaultPort = 5432
connectionUrlFormat = jdbc:netezza://{0}:{1}/{2}
testQuery = SELECT 1 AS test
Get Updates on the Splunk Community!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

(view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...