Support Questions
Find answers, ask questions, and share your expertise

Convert an SQl file from Mysql to JSON file in NiFi

New Contributor

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 REPLIES 2

Re: Convert an SQl file from Mysql to JSON file in NiFi

Master Guru

@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

Re: Convert an SQl file from Mysql to JSON file in NiFi

New Contributor

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.