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!

What You Read The Most: Splunk Lantern’s Most Popular Articles!

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

See your relevant APM services, dashboards, and alerts in one place with the updated ...

As a Splunk Observability user, you have a lot of data you have to manage, prioritize, and troubleshoot on a ...

Index This | What goes away as soon as you talk about it?

May 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this month’s ...