@Randy Gelhausen @Geoffrey Shelton Okot @Vadim In my opinion, Nifi has an advantage over Sqoop because development time is significantly reduced. If you are not planning on bringing TB of data and your incremental data volume is not huge, you can use NiFi to bring data. Bringing data in parallel using Sqoop is a double edge sword. Data gets loaded faster, but it puts load on source data store which may not be acceptable. In an enterprise environment, there are limits on number of connections open to database and parallelism in NiFi can be obtained working on independent datasets or a partition of target data. To me, NiFi shortcomings are more on operational side with not robust options for notification in case of failure.
... View more
