Splunk is a cutting edge operational intelligence and data processing platform that offers a top tier log analysis. It’s a powerful engine that lets you monitor, search, investigate, visualize and report on what’s happening with your IT infrastructure in real time.
There are times where an organization might want to connect to an external database from Splunk to get data from a database or write Splunk enterprise data in to databases etc. Fortunately, Splunk has a DB Connect app that is easily installable in your Splunk Enterprise. This app uses a JDBC driver in the background to perform any operations against the database.
Make sure you have following installed and configured properly, before you go ahead with the tutorial.
In this section, we will go through how to configure the DataDirect JDBC DB2 to work with Splunk DB Connect.
displayName = Progress DataDirect IBM DB2 Driver
serviceClass = com.splunk.dbx2.DefaultDBX2JDBC
jdbcDriverClass = com.ddtek.jdbc.db2.DB2Driver
supportedVersions = 1.0
jdbcUrlFormat = jdbc:datadirect:db2://<;
port = 50000
Name: <Any Name>
Identity: <Identity created in previous step>
App: Splunk DB Connect
Port: <Port for your database>
Host: <IP Address/Hostname of DB2>
Database Types: Progress DataDirect IBM DB2 Driver
Default database: <database name>
JDBC URL Format: <No change needed, will be automatically populated from configuration file>
Now that you have successfully connected your DB2 database with Splunk, feel free to connect more of your databases using Progress DataDirect JDBC drivers for Oracle, Cloudera Hive, Spark SQL and more, using the same approach that we showed you in this tutorial. Also, learn about the unfair advantage that you get by choosing Progress DataDirect connectivity solutions.
Connect any data source to any application
Discussions, tips and tricks for
DataDirect Connect drivers
Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.