topic Re: Can I use DB Connect to interact with Vertica? in Splunk Search

Can I use DB Connect to interact with Vertica?

melonman — Fri, 04 Oct 2013 07:10:07 GMT

Hi,

I want to index/lookup data stored in Vertica.
Could I use DB Connect for this purpuse?
Has anyone actually done?

I would appreciate any info/comment.

Thank you,

Re: Can I use DB Connect to interact with Vertica?

sdaniels — Fri, 04 Oct 2013 11:59:27 GMT

It is possible that you you can connect to Vertica using their JDBC driver, you'll just need to add that driver. Check out the docs online and let us know if you run into any challenges.

Splunk tests and supports connecting to the following databases:

DB2
Microsoft SQL Server
MySQL
Oracle Database
Sybase, Adaptive Server Enterprise version 15.7 Developer's Edition

Also, although unsupported, you can connect to the following databases out-of-the-box:

Generic ODBC support
H2
HyperSQL
PostgreSQL
SQLite

Re: Can I use DB Connect to interact with Vertica?

melonman — Mon, 07 Oct 2013 05:24:05 GMT

Thanks, sdaniels.

I imagine that you are mentioning this:
http://docs.splunk.com/Documentation/DBX/latest/DeployDBX/DefineanewDB

I will go through it and try to follow the instruction.

Re: Can I use DB Connect to interact with Vertica?

splunkben — Mon, 28 Sep 2020 15:01:54 GMT

Did you ever get this working? I'm trying use splunk db connect app to connect to a vertica DB as well but running into errors. Working fine for other db's like netezza, PDS, oracle, mysql, etc. Just wondering what you used in database_types.conf - specifcally did you put anyting for the testQuery line? I"ve got the vertica_jdbc_driver.jar in place in dbx/bin/lib but keep getting errors when trying to connect. Thanks.

Re: Can I use DB Connect to interact with Vertica?

cdo_splunk — Fri, 24 Oct 2014 22:17:02 GMT

Install Vertica thin client –located the JDBC
Add Vertica jdbc driver to the ../apps/dbx/bin/lib directory
If you are using Vertica version version 7 , Vertica jar would be vertica-jdbc-7.0.1-0.jar
Edit database_types.conf from etc/apps/dbx/local:

[vertica]
displayName = {enter a display name}
jdbcDriverClass = com.vertica.jdbc.Driver
defaultPort = {enter Vertica port}
connectionUrlFormat = jdbc:vertica://{0}:{1}/{2}
testQuery = select 1 from {table name}

Re: Can I use DB Connect to interact with Vertica?

cdo_splunk — Fri, 24 Oct 2014 22:17:03 GMT

Verica JDBC driver set up doc. Make sure jar file is in classpath

https://my.vertica.com/docs/5.1.6/HTML/index.htm#17520.htm