Could Sqoop [1] be an option? [1]: http://sqoop.apache.org/
> On 22 Mar 2018, at 16:33, Sivaprasanna <[email protected]> wrote: > > I had a chance to attempt a question raised on stackoverflow regarding > moving data from SQL Server to MySQL using NiFi. The user is using > GenerateTableFetch to read data from SQL Server and then try to use LOAD > DATA command in ExecuteSQL but this involves writing the read SQL Server > data to filesystem and then load it, which is a performance hit, I > suggested the user to try PutDatabaseRecord but I have never tried the > approach myself and going by the docs, I think it won't show any > performance benefit than LOAD DATA because the former reads from file and > inserts at a high speed while the latter reads content and parses it > according to the configured Record Reader and insert the rows as a single > batch. Confused, I wanted to get the community's opinion/thoughts on this. > Please attempt the questions, if you have better suggestions. > > Links: > > - > > https://stackoverflow.com/questions/49400447/bulk-load-sql-server-data-into-mysql-apache-nifi?noredirect=1#comment85843021_49400447 > - > > https://stackoverflow.com/questions/49380307/flowfile-absolute-path-nifi/49398500?noredirect=1#comment85805848_49398500 > > Thanks, > > Sivaprasanna
