topic Re: can Splunk DB Connect connect to a mysql express remote db? in Splunk Search

can Splunk DB Connect connect to a mysql express remote db?

khid — Fri, 07 Dec 2012 10:26:21 GMT

is it possible to get connected to a mysql express remote database throught this apps ?

Re: can Splunk DB Connect connect to a mysql express remote db?

Ayn — Fri, 07 Dec 2012 11:03:32 GMT

There is no thing as "mysql express"...

Re: can Splunk DB Connect connect to a mysql express remote db?

piebob — Wed, 12 Dec 2012 16:13:39 GMT

do you mean SQL Server Express? or hmmm: http://download.cnet.com/dotConnect-for-MySQL-Express/3000-10254_4-10907786.html

Re: can Splunk DB Connect connect to a mysql express remote db?

yannK — Wed, 12 Dec 2012 17:30:10 GMT

According to the app's readme :
http://splunk-base.splunk.com/apps/50803/splunk-db-connect

The Supported DBMS are

Microsoft SQL Server
Sybase
PostgreSQL
SQLite
H2
HyperSQL
Generic ODBC support

so your mysterious Mysql express is not listed, but MYSQL and MSSQL are.

Re: can Splunk DB Connect connect to a mysql express remote db?

piebob — Wed, 12 Dec 2012 17:43:41 GMT

if the db you are interested in connecting to has a JDBC driver, it will probably work.
here are the instructions:
http://docs.splunk.com/Documentation/DBX/1.0.6/DeployDBX/DefineanewDB

of particular interest: Note: At a minimum, Splunk DB Connect supports querying custom-defined database connections. For some custom database connections, features related to generation of queries may not work. Additionally, depending on the JDBC driver's implementation of database-metadata, the custom dbinfo search command may not work.