Skip to Main Content
  • Questions

  • Generate AVRO binary from PL SQL or convert JSON to AVRO in PL SQL

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, George Adrian.

Asked: April 23, 2020 - 11:27 am UTC

Last updated: April 24, 2020 - 3:23 am UTC

Version: 12.1.0.2.0

Viewed 1000+ times

You Asked

Hello,

Is there any possibility to generate Avro binary directly from PL/SQL or to convert JSON to Avro binary in PL/SQL?

I need to ingest via a REST API some bulk data from Oracle database to a Big Data system using Google Cloud.

I didn't found anything on this subject.

Thank you!

George

and Connor said...

We don't have anything natively

But could not do something like:

- unload the data to flat file JSON
- use the java command line tools from Avro Tools to format into AVRO format

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Design

New to good database design? Check out Chris Saxon's full fundamentals class.