# Database stored procedure reading output **URL:** \ **Category:** Kibana\ **Created:** [September 29, 2021, 11:55am UTC](https://discuss.elastic.co/t/database-stored-procedure-reading-output/285467 "2021-09-29T11:55:32Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![tractor\_boy](https://avatars.discourse-cdn.com/v4/letter/t/278dde/32.png) [@tractor\_boy](https://discuss.elastic.co/u/tractor_boy)\ **Post date:** [September 29, 2021, 11:55am UTC](https://discuss.elastic.co/t/database-stored-procedure-reading-output/285467/1 "2021-09-29T11:55:32Z")
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? Many thanks ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [September 29, 2021, 9:51pm UTC](https://discuss.elastic.co/t/database-stored-procedure-reading-output/285467/2 "2021-09-29T21:51:23Z")
What does the data output from the database look like? ---
**Author:** ![tractor\_boy](https://avatars.discourse-cdn.com/v4/letter/t/278dde/32.png) [@tractor\_boy](https://discuss.elastic.co/u/tractor_boy)\ **Post date:** [September 30, 2021, 6:46am UTC](https://discuss.elastic.co/t/database-stored-procedure-reading-output/285467/3 "2021-09-30T06:46:28Z")
The stored procedure isn't yet written so could most likely be of a variety of forms depending on what kibana requires. What I was hoping for was a guide on how to set up kibana such that it can request the data from a stored procedure (package/procedure) and load that into elastic such that it can then be display and alarmed on. ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [September 30, 2021, 9:46pm UTC](https://discuss.elastic.co/t/database-stored-procedure-reading-output/285467/4 "2021-09-30T21:46:27Z")
Kibana cannot do that, you'd need to use Logstash with it's JDBC input. ---
**Author:** ![tractor\_boy](https://avatars.discourse-cdn.com/v4/letter/t/278dde/32.png) [@tractor\_boy](https://discuss.elastic.co/u/tractor_boy)\ **Post date:** [October 1, 2021, 7:15am UTC](https://discuss.elastic.co/t/database-stored-procedure-reading-output/285467/5 "2021-10-01T07:15:12Z")
thanks. Is there any documentation to that effect that you know of? ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [October 1, 2021, 7:29am UTC](https://discuss.elastic.co/t/database-stored-procedure-reading-output/285467/6 "2021-10-01T07:29:34Z")
Yep, [Jdbc input plugin | Logstash Reference [7.15] | Elastic](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html) ---
**Author:** ![tractor\_boy](https://avatars.discourse-cdn.com/v4/letter/t/278dde/32.png) [@tractor\_boy](https://discuss.elastic.co/u/tractor_boy)\ **Post date:** [October 1, 2021, 7:53am UTC](https://discuss.elastic.co/t/database-stored-procedure-reading-output/285467/7 "2021-10-01T07:53:39Z")
thanks ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [October 29, 2021, 7:54am UTC](https://discuss.elastic.co/t/database-stored-procedure-reading-output/285467/8 "2021-10-29T07:54:08Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.