question Bulk Load SQL Server data into MySQL apache Nifi in Support Questions

question Bulk Load SQL Server data into MySQL apache Nifi in Support Questions https://community.cloudera.com/t5/Support-Questions/Bulk-Load-SQL-Server-data-into-MySQL-apache-Nifi/m-p/190452#M152541 I have billions of rows in SQL Server tables and I'm using Nifi to load those rows into MySQL. I tried using putSQL and PutDatabaseRecord both are satisfying the requirement, however they are taking quite long time to load the into MySQL(100k records per minute, for 1 billion it might be 1000+ minutes) as they are doing it record by record. Do we have any bulk load option to load the AVRO/CSV flowfiles into MySQL in Nifi. Could you please suggest an option.Here is my Flow :ListDataBaseTables -> GenerateTableFecth(partition size= 50k records) -> Execute SQL -> ConvertRecord(Avro to CSV) -> PutSQLListDataBaseTables -> GenerateTableFecth(partition size= 50k records) -> Execute SQL(Avro) -> PutDatabaseRecord. Wed, 21 Mar 2018 14:19:23 GMT ramesh_ganginen 2018-03-21T14:19:23Z