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|
|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)
||1.6||Simba JDBC Driver ****||126.96.36.1994||Yes|
|Sybase ASE||15.7 Developer’s Edition||Sybase jConnect||7.0||No|
|Sybase IQ||188.8.131.5219||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:
- MySQL: When creating a connection to a MySQL database, customize the JDBC URL by adding some additional query parameters. For more information, see JDBC: Inserting unicode UTF-8 characters into MySQL.
- PostgreSQL: Support is built in. No additional steps are required.
- Microsoft SQL Server - Ensure your database columns' data types are N-variant types, such as NVARCHAR versus VARCHAR). For more information, see this post on Stack Exchange.
- Oracle: Change your database character set to AL32UTF8. For more information, see Supporting Multilingual Databases with Unicode.
For all other databases, consult your database's documentation for more information about enabling multi-byte character sets.
All DB Connect-supported databases support setting the Readonly option. For more information, see Create and manage database connections.
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.
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,
|AWS RDS Aurora||x||x||x||x||x|
|Microsoft SQL Server||x||x||x|
|SAP SQL Anywhere||x||x||x|
* Information for Informix databases is not currently available.
How to get help and learn more about Splunk software
This documentation applies to the following versions of Splunk® DB Connect: 2.3.1, 2.4.0, 2.4.1