Support Questions
Find answers, ask questions, and share your expertise

NIFI connection with MS access Database

New Contributor

What is the available JDBC open-source driver to connect Apache NIFI with MS Access Database.

@Nifi @ApacheNifi 

2 REPLIES 2

Explorer

Hi @MattWho ,

 

We are struggling to connect to MS Access DB from Nifi 1.13.0 using Ucanaccess 5.0.1 Driver , we are getting error as "Given file does not exist" 

Can you please suggest on this or if you have used any other driver  or any information around that

 

There is a Cdata driver which works but that is a licensed product , we are looking for something

in the open source region

Rising Star

Few points when connecting to any DataBase from NiFi 

NiFi has Generic controller service named DBCPConnectionPool which used to create connection pool to given database and processors such as ExecuteSQL or  PutSql will use this controller service to obtain connection and run the given queries.

 

What is needed as minimum prerequisite  to start with DBCPConnectionPool  

 

1. Determine type of Database 

2. Determine the JDBC URL syntax supported by Database 

3. The Database client Driver which works outside of NiFi to connect to same Database needs to be placed on each NiFi nodes on given location which can be read user who is running NiFi as service 

 

All above needs to be provided by user , if Ucanaccess 5.0.1 client Driver works outside of NiFi then it should work with DBCPConnectionPool as well, Where you are getting this message "Given file does not exist" ? Is client driver is present on NiFi hosts and configured Database Driver Location is correct ? permissions? 

 

You mentioned There is a Cdata driver which works but that is a licensed product" , it works from where ? from NiFi:DBCPConnectionPool?

 

Thank You. 

; ;