Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Solved Go to solution

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

New Contributor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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

Rising Star

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)

2 REPLIES 2
Highlighted

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

Rising Star

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)

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

New Contributor

@Benjamin Hopp Thanks for your Reply