How to add a new JDBC drivers for use in Yellowfin
17 October, 2011
Yellowfin ships with a list of commonly used JDBC drivers (see screenshot below).
If you wish to use a driver that is not available in Yellowfin you can simply add this driver to the JDBC Driver list.
Note: Databases in the list that are 'greyed' out are missing the actual JDBC driver.
[size="14">To add a new driver:[/size]
1. Copy your JDBC driver JAR file(s) into the Yellowfin/appserver/webapps/ROOT/WEB-INF/lib/ directory.
2. Restart the Yellowfin service.
[size="16">IF[/size] the DB Name is not in Yellowfin's database list
you will need to edit the web.xml (located :Yellowfin/appserver/webapps/ROOT/WEB-INF/) and manually add it to the driver list.
Add your driver name under the 'JDBCDrivers' parameter.
Example:
[code]
[color="#EE4243"> com.ddtek.jdbc.openedge.OpenEdgeDriver, [/color]
[/code]
Once you have added the name, save the file and restart the Yellowfin service.
The driver will now be available when using the 'Generic JDBC Data Source'
If you want to add a new database name to the list, please email [color="#0F3CFF">support@Yellowfin.bi[/color]