Splunk Search

Can I use DB Connect to interact with Vertica?

melonman
Motivator

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,

Tags (1)
1 Solution

sdaniels
Splunk Employee
Splunk Employee

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 

View solution in original post

cdo_splunk
Splunk Employee
Splunk Employee
  • 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}

cdo_splunk
Splunk Employee
Splunk Employee

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

0 Karma

splunkben
Explorer

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.

0 Karma

sdaniels
Splunk Employee
Splunk Employee

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 

melonman
Motivator

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.

0 Karma
Get Updates on the Splunk Community!

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...