Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

Does HDF support data transfer from Relational Databases(RDBMS) to HDFS

avatar
Frequent Visitor
 
1 ACCEPTED SOLUTION

avatar
Master Guru

Yes you can use the QueryDatabaseTable processor for incrementally retrieving data from a relational database table, see this article:

https://community.hortonworks.com/articles/51902/incremental-fetch-in-nifi-with-querydatabasetable.h...

Then you can use PutHDFS to store the data in HDFS.

View solution in original post

2 REPLIES 2

avatar
Master Guru

Yes you can use the QueryDatabaseTable processor for incrementally retrieving data from a relational database table, see this article:

https://community.hortonworks.com/articles/51902/incremental-fetch-in-nifi-with-querydatabasetable.h...

Then you can use PutHDFS to store the data in HDFS.

avatar
Frequent Visitor

Thanks Bryan Bende!