What are differences between Beats and jdbc plugin?

Elastic Stack Beats
1

Hi everybody , I am a newbie in the ES's wonderful world so please be indulgent.

I am thinking about a import and sync strategy for a microsoft sql data source and if I did not misunderstand, I can use the input plugins JDBC or Beats.

But I don't see what are the deeps differences between them,

what are their usefulness? When use one or other one?
What are their benefits and their drawbacks?

Thank you if you can help me

2

Beats does not allow to import data from sql servers. Metricbeat can be used to monitor the stats of some service. What you are probably looking for is JDBC plugin for logstash: https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html