i'm looking for recommendation for a simple usecase of filtering and transformation of JSON stream
basically i have an stream of JSON or an array. all item of same flat schema (each JSON representing a RDBMS row of a table) I need to : 1) filter out some keys (aka column) 2) transform some values (like replace key words with other in the value par of JSON KV pair 3) modify the K like all lower case it.
I tumble upon, JOLT in the context of a Apache NiFi flow I'm failing to find how to do 3 the key renaming.
on Jolt site, alternative are gracefully pointed to like JsonSurfer and others. Given the use case above, what tool chain would you recommend. It has to be scalable or workable in a stream like fashion (JsonSurfer looks interesting on that end). Also, It'd be great if solution can be included in either Nifi or Talend, unless these tools already have a solution that i don't know of
