# How to enrich static data in metricbeat events

**URL:** <https://discuss.elastic.co/t/how-to-enrich-static-data-in-metricbeat-events/211421>\
**Category:** Logstash\
**Created:** [December 11, 2019, 6:28am UTC](https://discuss.elastic.co/t/how-to-enrich-static-data-in-metricbeat-events/211421 "2019-12-11T06:28:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![SunilSMenon](https://avatars.discourse-cdn.com/v4/letter/s/71e660/32.png) [@SunilSMenon](https://discuss.elastic.co/u/SunilSMenon)\
**Post date:** [December 11, 2019, 6:28am UTC](https://discuss.elastic.co/t/how-to-enrich-static-data-in-metricbeat-events/211421/1 "2019-12-11T06:28:44Z")

</div>

Hi,

We have metricbeat installed and it provides the metric events, we would like to enrich the metricbeat events with information which is available in MSSQL DB, can you kindly guide me how to achieve this. I understand logstash will be required, but which filter plugin to be used? If there is a detailed documentation available it will be of great help.

---

<div class="post-metadata">

**Author:** ![yaauie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yaauie/32/23363_2.png) [@yaauie](https://discuss.elastic.co/u/yaauie)\
**Post date:** [December 11, 2019, 10:59pm UTC](https://discuss.elastic.co/t/how-to-enrich-static-data-in-metricbeat-events/211421/2 "2019-12-11T22:59:51Z")

</div>

There are two filters that can be used in Logstash to enrich events using external DB lookups, both using JDBC:

- [JDBC Streaming Filter](https://www.elastic.co/guide/en/logstash/current/plugins-filters-jdbc_streaming.html): perform lookups _per event_ against a live database, optionally caching hot entries.
- [JDBC Static Filter](https://www.elastic.co/guide/en/logstash/current/plugins-filters-jdbc_static.html): perform lookups _per event_ against a local database, which is periodically refreshed from a live database.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [January 8, 2020, 10:59pm UTC](https://discuss.elastic.co/t/how-to-enrich-static-data-in-metricbeat-events/211421/3 "2020-01-08T22:59:55Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.