If you can convert the MS Access file to CSV (either via export inside the application or by invoking a command-line tool, which can then be called from NiFi via ExecuteProcess or ExecuteStreamCommand), you can use any of the CSV processors to access the data (i.e. GetFile + ConvertCSVToAvro) and then treat the Avro records as normal. If you cannot, you may want to explore ExecuteScript and use a JDBC driver which supports Access files [1] to extract the data that way.
[1] http://ucanaccess.sourceforge.net/site.html <http://ucanaccess.sourceforge.net/site.html> Andy LoPresto [email protected] [email protected] PGP Fingerprint: 70EC B3E5 98A6 5A3F D3C4 BACE 3C6E F65B 2F7D EF69 > On Jan 24, 2017, at 9:04 AM, Selvam Raman <[email protected]> wrote: > > Hi, > > I have .dmp(MS access) file. > How can i read this file in Nifi flow(like database) and store the result > table in s3 location. > > -- > Selvam Raman > "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"
signature.asc
Description: Message signed with OpenPGP using GPGMail
