Can I use DB Connect to interact with Vertica?

[melonman]

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,

[cdo_splunk]

• 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]

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

[splunkben]

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.

[sdaniels · Accepted solution]

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]

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.