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!

Leveraging Detections from the Splunk Threat Research Team & Cisco Talos

  Now On Demand  Stay ahead of today’s evolving threats with the combined power of the Splunk Threat Research ...

New in Splunk Observability Cloud: Automated Archiving for Unused Metrics

Automated Archival is a new capability within Metrics Management; which is a robust usage & cost optimization ...

Calling All Security Pros: Ready to Race Through Boston?

Hey Splunkers, .conf25 is heading to Boston and we’re kicking things off with something bold, competitive, and ...