Reporting

Help creating new database type and mapping JDBC driver

Dan
Splunk Employee
Splunk Employee

From Andrescolo:

Im trying to use JDBC to connect an AS400 database.
I put the driver JT400.jar in $SPLUNK_HOME/etc/apps/dbx/bin/lib, restart splunk.
When i setup the database, i cant see a new Database type related to the jar file added, and i dont see any other place to configure.

How is posible to map database type with driver?

Tags (1)
1 Solution

piebob
Splunk Employee
Splunk Employee

i've updated the documentation to include a topic on how to do this in more detail:

http://docs.splunk.com/Documentation/DBX/1.0.6/DeployDBX/DefineanewDB

View solution in original post

mwwb
New Member

try the jdbc tutorial at this website http://www.unityjdbc.com/doc/jdbc/jdbc_tutorial.php

it is really easy to understand, great explanations, tons of links for more information, and has sample code.

Hope this helps

0 Karma

piebob
Splunk Employee
Splunk Employee

i've updated the documentation to include a topic on how to do this in more detail:

http://docs.splunk.com/Documentation/DBX/1.0.6/DeployDBX/DefineanewDB

ziegfried
Influencer

To match your JDBC URL jdbc:as400://HOSTNAME;naming=sql;errors=full, you could probably use:

connectionUrlFormat = jdbc:as400://{0};naming=sql;errors=full

in database_types.conf.

Dan
Splunk Employee
Splunk Employee

From Stepmmx:

I have the same problem.
I tried to define AS400 DB2 DB in database_types.conf
[as400]
displayName = DB2 AS400
jdbcDriverClass = com.ibm.as400.access.AS400JDBCDriver
defaultPort = 446
connectionUrlFormat = jdbc:as400://{0}:{1};naming=sql;errors=full

but the connectionUrlFormat is propably wrong 😞

In DBVisualizer I'm using this format:
jdbc:as400://HOSTNAME;naming=sql;errors=full

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud’s AI Assistant in Action Series: Analyzing and ...

This is the second post in our Splunk Observability Cloud’s AI Assistant in Action series, in which we look at ...

Elevate Your Organization with Splunk’s Next Platform Evolution

 Thursday, July 10, 2025  |  11AM PDT / 2PM EDT Whether you're managing complex deployments or looking to ...

Splunk Answers Content Calendar, June Edition

Get ready for this week’s post dedicated to Splunk Dashboards! We're celebrating the power of community by ...