Splunk® DB Connect

Deploy and Use Splunk DB Connect

Download manual as PDF

This documentation does not apply to the most recent version of DBX. Click here for the latest version.
Download topic as PDF

Supported databases

You can connect to many different types of databases with Splunk DB Connect. In addition to the supported databases, which Splunk has tested and certified for use with DB Connect, you may also be able to use other, unsupported JDBC-compatible databases with Splunk DB Connect.

Supported database matrix

Splunk DB Connect supports the databases listed in the following matrix. For information about installing database drivers, see Install database drivers.

The driver listed in the "JDBC driver name/link" column is the driver that Splunk has tested with Splunk DB Connect, but you can use whatever JDBC driver for your database that works well for you.

Database Minimum database version supported JDBC driver name/link JDBC driver version tested SSL support*
AWS RDS Aurora 5.1.24+ MySQL Connector/J 5.1 ** Yes
AWS RedShift 9.3.5 RedshiftJDBC41-1.1.13.1013.jar 1.1 Yes
IBM DB2 for Linux*** 10.5 DB2 JDBC Driver (JCC4)*** 4.16 Yes
Informix 12.10 Informix JDBC Driver 3.0 Yes
MemSQL 5.5.8 MySQL Connector/J 5.1 ** No
Microsoft SQL Server 11.00.2218 Microsoft JDBC Driver for SQL Server 4.0 Yes
jTDS JDBC Driver   No
MySQL 5.1.24+ MySQL Connector/J 5.1 ** Yes
Oracle Database 11g Oracle JDBC driver (ojdbc7.jar) 12.1 Yes
PostgreSQL 9.3.5 JDBC41 PostgreSQL Driver 9.4 Yes
SAP SQL Anywhere
(aka Sybase SA)
16.0.0.1948 Sybase jConnect 7.0 No
Spark SQL
1.6 Simba JDBC Driver **** 1.0.2.1004 Yes
Sybase ASE 15.7 Developer’s Edition Sybase jConnect 7.0 No
Sybase IQ 15.4.0.3019 Sybase jConnect 7.0 No
Teradata 15.00.00.07 Teradata JDBC Driver (terajdbc4.jar and tdgssconfig.jar) 15.0 No

* SSL support: This column specifies whether support has been built into DB Connect for connecting to this database over Secure Sockets Layer (SSL). For information about enabling this functionality, see Create and manage database connections.

** The MySQL Connector/J driver version 6.x, which is still in development as of this writing, is not currently supported by DB Connect, and will not work. Please use the supported version until further notice.

*** IBM DB2 is only supported when the database is running on Linux. Splunk doesn't test or support DB Connect with DB2 on AS/400 or on Windows.

**** SparkSQL support requires Thrift server setup for JDBC http://spark.apache.org/docs/latest/sql-programming-guide.html#running-the-thrift-jdbcodbc-server

Enable output to multi-byte character sets

DB Connect supports sending data that is in a multi-byte character set, such as Traditional Chinese, using a database output. Depending on your database, you may need to change certain settings on the database side to the database to properly receive and store the data:

For all other databases, consult your database's documentation for more information about enabling multi-byte character sets.

Read-only support

All DB Connect-supported databases support setting the Readonly option. For more information, see Create and manage database connections.

SQL aliasing

All DB Connect-supported databases can alias columns or tables with the AS keyword. An example of an alias statement is:

SELECT a AS abc, b AS xyz FROM t1

For important information about aliasing columns, see "Queries containing AS do not change column names as expected" in Troubleshooting.

Other databases

In addition to the supported databases that Splunk has tested and certified for use with DB Connect, you may also be able to use unsupported JDBC-compatible databases with Splunk DB Connect. You will need to provide the necessary JDBC drivers to add your own database types. For more information, see Install drivers for other databases.

Supported rising column types by database

The following matrix summarizes what column types (varchar, number, timestamp, and so on) are supported as rising column value types in DB Connect-supported databases. For more information about rising columns, see the Set parameters section of Create and manage database inputs.

Database varchar int, float, real,
bigint, number
timestamp datetime date
AWS RDS Aurora x x x x x
AWS RedShift x x x
DB2/Linux x x x
Informix *
MemSQL x x x x x
Microsoft SQL Server x x x
MySQL x x x x x
Oracle x x x
PostgreSQL x x x
SAP SQL Anywhere x x x
Sybase ASE x x x
Sybase IQ x x x
Teradata x x x


* Information for Informix databases is not currently available.

PREVIOUS
How to get help and learn more about Splunk software
  NEXT
Prerequisites

This documentation applies to the following versions of Splunk® DB Connect: 2.3.1, 2.4.0, 2.4.1


Was this documentation topic helpful?

Enter your email address, and someone from the documentation team will respond to you:

Please provide your comments here. Ask a question or make a suggestion.

You must be logged into splunk.com in order to post comments. Log in now.

Please try to keep this discussion focused on the content covered in this documentation topic. If you have a more general question about Splunk functionality or are experiencing a difficulty with Splunk, consider posting a question to Splunkbase Answers.

0 out of 1000 Characters