You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@nifi.apache.org by 尹文才 <ba...@gmail.com> on 2017/06/22 03:01:05 UTC

Extract data from Microsoft Access with NIFI Processors

Hi guys, currently I need to use NIFI to extract data of a Microsoft Access
database, is there a currently available NIFI processor that can do this or
do I have to write one for it? Thanks.

Regards,
Ben

Re: Extract data from Microsoft Access with NIFI Processors

Posted by 尹文才 <ba...@gmail.com>.

Thanks Joe, I thought I need to write one but when I searched on Google I
found an open source JDBC driver specifically for Microsoft access called
UCanAccess, with its drivers and dependent jars I managed to use the
existing QueryDatabaseTable Processor to extract data from Microsoft
Access😀.

/Ben

2017-06-22 11:41 GMT+08:00 Joe Witt <jo...@gmail.com>:

> Ben
>
> If you can get a hold of a jdbc/odbc driver then you might be able to
> use existing processors and just point at the jdbc jar.  Otherwise,
> you might need to write one.  Please let us know which path you go.
>
> Thanks
>
> On Wed, Jun 21, 2017 at 11:01 PM, 尹文才 <ba...@gmail.com> wrote:
> > Hi guys, currently I need to use NIFI to extract data of a Microsoft
> Access
> > database, is there a currently available NIFI processor that can do this
> or
> > do I have to write one for it? Thanks.
> >
> > Regards,
> > Ben
>

Re: Extract data from Microsoft Access with NIFI Processors

Posted by Joe Witt <jo...@gmail.com>.

Ben

If you can get a hold of a jdbc/odbc driver then you might be able to
use existing processors and just point at the jdbc jar.  Otherwise,
you might need to write one.  Please let us know which path you go.

Thanks

On Wed, Jun 21, 2017 at 11:01 PM, 尹文才 <ba...@gmail.com> wrote:
> Hi guys, currently I need to use NIFI to extract data of a Microsoft Access
> database, is there a currently available NIFI processor that can do this or
> do I have to write one for it? Thanks.
>
> Regards,
> Ben