I am looking to convert a Database file (SQL or MySQL) to Json. I have already done a conversion from CSV to Json. But I have no luck in finding steps to convert a data file from SQL to Json. Could you please help me with steps to do this. Appreciate your response. Thanks a plenty
Use ConvertRecord processor and configure AvroReader as Record Reader Controller service and JsonSetWriter as Record Writer controller service and in case of Avro Reader you can use Schema Access Strategy as Embedded Avro Schema.
Then you are able to convert Avro datafile from sql to Json format in a efficient manner.
Refer to this link for more details regards to ConvertRecord processor.