All Apps and Add-ons

db_connect informix jdbc driver

hos_2
Path Finder

How do people connect to informix without buying the jdbc driver? I cannot find a .JAR file with the correct driver class that DB connect uses by default: com.informix.jdbc.IfxDriver

also the link for Informix driver on the following page is broken/missing.

http://docs.splunk.com/Documentation/DBX/3.1.2/DeployDBX/Installdatabasedrivers#Supported_databases

0 Karma
1 Solution

cameronjust
Path Finder

Drivers can be found here for anyone who comes across this question

Official JDBC drivers for DB Connect mentioned here
https://www.ibm.com/developerworks/community/blogs/idsteam/entry/Informix_JDBC_Driver_on_Maven?lang=...

Which I downloaded from here
http://mvnrepository.com/artifact/com.ibm.informix/jdbc/4.10.10

which can be download with this command in linux (if mvn is isntalled)
mvn dependency:get -DgroupId=com.ibm.informix -DartifactId=jdbc -Dversion=4.10.8.1

The files will go into the ~/.m2 directory.

Edit: Also you will need to rename the JAR for DB Connect to pick it up from jdbc-4.10.8.1.jar to ifxjdbc.jar

View solution in original post

0 Karma

cameronjust
Path Finder

Drivers can be found here for anyone who comes across this question

Official JDBC drivers for DB Connect mentioned here
https://www.ibm.com/developerworks/community/blogs/idsteam/entry/Informix_JDBC_Driver_on_Maven?lang=...

Which I downloaded from here
http://mvnrepository.com/artifact/com.ibm.informix/jdbc/4.10.10

which can be download with this command in linux (if mvn is isntalled)
mvn dependency:get -DgroupId=com.ibm.informix -DartifactId=jdbc -Dversion=4.10.8.1

The files will go into the ~/.m2 directory.

Edit: Also you will need to rename the JAR for DB Connect to pick it up from jdbc-4.10.8.1.jar to ifxjdbc.jar

0 Karma

hos_2
Path Finder

Thanks so much for this information. It really helped me out.

However I have one more question:
When adding a custom database to db_connection_types.conf, how do i gather the following information?

serviceClass = com.splunk.dbx2.DefaultDBX2JDBC
jdbcDriverClass = $JDBC driver class$
jdbcUrlFormat = $JDBC URI Format$
ui_default_catalog = $database$

http://docs.splunk.com/Documentation/DBX/3.1.2/DeployDBX/Installdatabasedrivers#Add_the_custom_datab...

0 Karma

cameronjust
Path Finder

Not 100% sure on this sorry.

Check the version in default/db_connection_types.conf for some examples of out of the box databases.

[informix]
displayName = Informix
serviceClass = com.splunk.dbx2.InformixJDBC
jdbcUrlFormat = jdbc:informix-sqli://<host>:<port>/<database>:informixserver=<informixserver>;DELIMIDENT=Y
jdbcDriverClass = com.informix.jdbc.IfxDriver
supportedVersions = 3.0
port = 1526

You shouldn't need to make one for Informix though as it comes out of the box like the one above.

Also I made an edit to my above post noting you need to change the jar file from jdbc-4.10.8.1.jar to ifxjdbc.jar for DB connect to pick up the drivers correctly.

0 Karma

hos_2
Path Finder

Great thanks, I was wondering why I didn't see the new version of informix when I ran reload. I had an older version of the file in my drivers folder and did not realize.

0 Karma
Get Updates on the Splunk Community!

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, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...