db_connect informix jdbc driver

[hos_2]

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

[cameronjust · Accepted solution]

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

[hos_2]

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

[cameronjust]

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.

[hos_2]

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.