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
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.
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