Splunk DB Connect: How to connect custom Netezza database?

[theouhuios]

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]

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.

[datasearchninja]

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