I have searched and found some articles that describe how to set up data capture from a stored procedure, but I do not understand the conversations, so cannot convert into a concise description of what is required to make it work.
I have not yet even worked out how to set up capture configuration, hopefully that is well defined somewhere.
What I want to do is make a secure (ie no passwords visible) connection to an oracle database. Run a stored procedure, get a bunch of data back (many columns and rows) and store that into an elastic store.
The end result is to visualise the stored data and build alarms accordingly.
Is there any documentation on how to achieve this?