I had originally been requested to provide a proof of concept where GoldenGate can be used to process XML messages from a JMS queue. I was able to do this using the Oracle GoldenGate Application Adapters. However, I have now been informed that the messages will be in JSON format. Does anyone have any ideas of how this can be achieved using GoldenGate?
If not using GoldenGate, any other solutions for consuming messages in JSON format from a JMS queue to insert into an Oracle database?