How-to | Utilize MS Access#

Many users have shown interest in utilizing MS Access in Dataiku. Let’s demonstrate how to do just that.

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

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

Connect to MS Access file with Date/Time data type#

Be sure to follow the above steps, but use UCanAccess 4.0.4.

../../_images/ms-access.png