https://community.cloudera.com/t5/Archives-of-Support-Questions/Nifi-is-it-possible-to-access-fetch-MS-access-file-using/m-p/229969#M72752 <P>There is no native processor to open access databases files. </P><P>You can handle it a couple ways... Easiest would be to export the data from access into csv and ingest that. </P><P>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)</P> Wed, 20 Dec 2017 04:14:55 GMT bhopp 2017-12-20T04:14:55Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Nifi-is-it-possible-to-access-fetch-MS-access-file-using/m-p/229968#M72751 <P>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 ? </P><P>Is there any nifi processor available for Reading / Writing MS access file ?</P><P>Thanks in advance</P> Tue, 19 Dec 2017 17:21:27 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Nifi-is-it-possible-to-access-fetch-MS-access-file-using/m-p/229968#M72751 paresh_baldaniy 2017-12-19T17:21:27Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Nifi-is-it-possible-to-access-fetch-MS-access-file-using/m-p/229969#M72752 <P>There is no native processor to open access databases files. </P><P>You can handle it a couple ways... Easiest would be to export the data from access into csv and ingest that. </P><P>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)</P> Wed, 20 Dec 2017 04:14:55 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Nifi-is-it-possible-to-access-fetch-MS-access-file-using/m-p/229969#M72752 bhopp 2017-12-20T04:14:55Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Nifi-is-it-possible-to-access-fetch-MS-access-file-using/m-p/229970#M72753 <P><A rel="user" href="https://community.cloudera.com/users/86/bhopp.html" nodeid="86">@Benjamin Hopp</A> Thanks for your Reply</P> Wed, 20 Dec 2017 16:32:40 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Nifi-is-it-possible-to-access-fetch-MS-access-file-using/m-p/229970#M72753 paresh_baldaniy 2017-12-20T16:32:40Z