Convert an SQl file from Mysql to JSON file in NiFi

[#1]

Can Anyone please help me??

To find a solution of converting the SQL file to Json file 

by unsing Nifi. In a Step wise format

[#2]

@bhavya 

The more detail you provide along with example of what you are trying to accomplish in yoru use case may help you get more involvement from the community on your query.

"SQL file"?  Are you trying to execute an SQL query and write the results returned by that query in JSON format?

If so, you'll want to take a look at the ExecuteSQLRecord [1] processor and the JsonRecordSetWriter [2] controller service.

[1] https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-standard-nar/1.13.2/org.apach...

[2] https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-record-serialization-services...

Thanks,
Matt

[#3]

Yeah!I want to execute the SQL file and convert into Json But I'm not getting how to do as I'm at first level of learning.