Nifi : is it possible to access /fetch MS access file using nifi ?

[#1]

Hi , Let we have 3 server Server-A window server(MS access file placed in D drive) , Server-B( nifi installed on this server ) , Server-C Hadoop Installed on server Question : we want to transfer /Fetch file access file from server-A to FTP server-C and put into the hadoop using nifi is it possible ? how ?

Is there any nifi processor available for Reading / Writing MS access file ?

Thanks in advance

[#2 · Accepted solution]

There is no native processor to open access databases files.

You can handle it a couple ways... Easiest would be to export the data from access into csv and ingest that.

The other method would be to connect to the server running MS Access via JDBC. However, I believe this would require a 3rd party driver, as Microsoft only has ODBC drivers for Access (but this may no longer be the case)

[#3]

@Benjamin Hopp Thanks for your Reply