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!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...