topic Re: Splunk DB Connect: How to connect custom Netezza database? in Splunk Search

Splunk DB Connect: How to connect custom Netezza database?

theouhuios — Wed, 22 Oct 2014 18:24:03 GMT

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

Re: Splunk DB Connect: How to connect custom Netezza database?

datasearchninja — Wed, 15 Apr 2015 03:39:12 GMT

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

Re: Splunk DB Connect: How to connect custom Netezza database?

esix_splunk — Fri, 15 May 2015 05:44:37 GMT

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.