Submit your use case or success story to the 2023 edition of the Dataiku Frontrunner Awards ENTER YOUR SUBMISSION

Utilizing MS Access in Dataiku DSS

Many of our users have shown interest in utilizing MS Access in Dataiku DSS. In the interest of knowledge sharing, we wanted to demonstrate how to do just that. 

How to open an MS Access file

  1. Download ucanaccess
  2. Copy ucanaccess-4.0.4.jar and jackcess-2.1.11.jar (including the ones from lib/) into DATA_DIR/lib/jdbc/ (see Installing database drivers for more details)
  3. Restart DSS.
  4. Configure a new connection:
    • JDBC driver class: net.ucanaccess.jdbc.UcanaccessDriver
    • JDBC URL: jdbc:ucanaccess://<filepath> , e.g. jdbc:ucanaccess:///home/johndoe/Documents/fooDB.accdb
    • In the “SQL Dialect” field, select "MySQL < 8"
  5. Create a new dataset using this connection to import an MS Access table in DSS.

Connecting to MS Access file with Date/Time data type 

Be sure to follow the above steps, but utilize UCanAccess 4.0.4

Screenshot 2020-06-30 at 16.19.38.png






Labels (1)
Version history
Publication date:
06-06-2022 04:28 PM
Version history
Last update:
‎06-30-2020 06:42 PM
Updated by: