You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kafka.apache.org by Ma...@dell.com on 2018/05/28 09:22:09 UTC

Avro to JSON

Hi Team,

Looking for optimal solution to convert Avro format to JSON.
The final objective is to save the JSON in Sql Server DB.

If anyone of you have worked on this, please suggest the best option.

Regards
Madhu


Re: Avro to JSON

Posted by "Matthias J. Sax" <ma...@confluent.io>.
Just revert the `VALUE_FORMAT` types...

On 5/28/18 10:59 PM, Madhu.Kartha@dell.com wrote:
> Dell - Internal Use - Confidential  
> 
> Thanks.. The link has JSON to Avro.
> I was looking for the other way. 
> 
> Regards
> Madhu
> 
> -----Original Message-----
> From: Gwen Shapira [mailto:gwen@confluent.io] 
> Sent: Tuesday, May 29, 2018 9:35 AM
> To: dev
> 
> 
> Subject: Re: Avro to JSON
> 
> Here's how you do it with KSQL:
> https://gist.github.com/miguno/40caf67d2f122d8da528d878c99a4e29
> And then you can use Connect with JDBC connector to upload the result to SQL Server.
> 
> On Mon, May 28, 2018 at 2:22 AM, <Ma...@dell.com> wrote:
> 
>> Hi Team,
>>
>> Looking for optimal solution to convert Avro format to JSON.
>> The final objective is to save the JSON in Sql Server DB.
>>
>> If anyone of you have worked on this, please suggest the best option.
>>
>> Regards
>> Madhu
>>
>>
> 
> 
> --
> *Gwen Shapira*
> Product Manager | Confluent
> 650.450.2760 | @gwenshap
> Follow us: Twitter <https://twitter.com/ConfluentInc> | blog <http://www.confluent.io/blog>
> 


RE: Avro to JSON

Posted by Ma...@dell.com.
Dell - Internal Use - Confidential  

Thanks.. The link has JSON to Avro.
I was looking for the other way. 

Regards
Madhu

-----Original Message-----
From: Gwen Shapira [mailto:gwen@confluent.io] 
Sent: Tuesday, May 29, 2018 9:35 AM
To: dev


Subject: Re: Avro to JSON

Here's how you do it with KSQL:
https://gist.github.com/miguno/40caf67d2f122d8da528d878c99a4e29
And then you can use Connect with JDBC connector to upload the result to SQL Server.

On Mon, May 28, 2018 at 2:22 AM, <Ma...@dell.com> wrote:

> Hi Team,
>
> Looking for optimal solution to convert Avro format to JSON.
> The final objective is to save the JSON in Sql Server DB.
>
> If anyone of you have worked on this, please suggest the best option.
>
> Regards
> Madhu
>
>


--
*Gwen Shapira*
Product Manager | Confluent
650.450.2760 | @gwenshap
Follow us: Twitter <https://twitter.com/ConfluentInc> | blog <http://www.confluent.io/blog>

Re: Avro to JSON

Posted by Gwen Shapira <gw...@confluent.io>.
Here's how you do it with KSQL:
https://gist.github.com/miguno/40caf67d2f122d8da528d878c99a4e29
And then you can use Connect with JDBC connector to upload the result to
SQL Server.

On Mon, May 28, 2018 at 2:22 AM, <Ma...@dell.com> wrote:

> Hi Team,
>
> Looking for optimal solution to convert Avro format to JSON.
> The final objective is to save the JSON in Sql Server DB.
>
> If anyone of you have worked on this, please suggest the best option.
>
> Regards
> Madhu
>
>


-- 
*Gwen Shapira*
Product Manager | Confluent
650.450.2760 | @gwenshap
Follow us: Twitter <https://twitter.com/ConfluentInc> | blog
<http://www.confluent.io/blog>