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

Converting SQL to Json

Converting SQL to Json

New Contributor

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


Re: Converting SQL to Json

Super Guru
@Badri Chellappa

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.