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
Motivator

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
Motivator

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!

Improve Your Security Posture

Watch NowImprove Your Security PostureCustomers are at the center of everything we do at Splunk and security ...

Maximize the Value from Microsoft Defender with Splunk

 Watch NowJoin Splunk and Sens Consulting for this Security Edition Tech TalkWho should attend:  Security ...

This Week's Community Digest - Splunk Community Happenings [6.27.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...