Jdbc driver for ms access download

Here is the easiest way to connect Yellowfin to your Microsoft Access database. This method bypasses much of Access' ODBC setup requirements, and is relatively quick to set up. 

1. Download the latest UCanAccess binary zip file from here: http://sourceforge.net/projects/ucanaccess/files/
2. Extract the files
3. Copy files located in the extracted “lib” directory to [YourYellowfinInstallDirectory]
4. Copy the ucanaccess-x.x.x.jar file from the extracted directory to [YourYellowfinInstallDirectory]
5. Navigate to [YourYellowfinInstallDirectory]
6. Locate the JDBCDrivers section, and add the following line to the top of the block. net.ucanaccess.jdbc.UcanaccessDriver, (See screenshot, make sure to include the comma at the end!) 
7. Save the web.xml file
8. Restart Yellowfin
9. Create a new Data source from the admin control panel
10. Choose “Generic JDBC driver” in the 'Database Type' dropdown
11. Select “net.ucanaccess.jdbc.UcanaccessDriver” NOTE: Although the option to select Microsoft Access via the 'Database Type' dropdown may now be accessible, it is very important to select the Generic JDBC Driver option instead.
12. Use the following connection string (See screenshot for example setup that does not require authentication):

For Linux/Mac servers
jdbc:ucanaccess:///path/to/mdbfile.mdb;showSchema=true

For Windows servers
jdbc:ucanaccess://c:/path/to/mdbfile.mdb;showSchema=true

The database should now be accessible to Yellowfin, go and build yourself a view!