We're using Fleet managed Elastic Agents and appropriate integrations to collect logs from various environments and that is working great. We have however quite a few environments where logging is collected from MS-SQL tables. For that purposes we're using Logstash agent with SQL-plugin, that is also working fine, but it's not centrally managed. Logstash agent need to be updated manually. It would be supercool feature to have Elastic Agent Logstash integration to collect data from SQL-tables.
Hi,
Unfortunately, there isn't an integration which can collect data from MS-SQL in the same way as Logstash, and I'm not currently aware of any plans to add it.
Logstash does have some centralized management features which might help you to continue to use and manage Logstash: Centralized Pipeline Management | Elastic Documentation
Do you want to collect metrics or data from SQL? As an alternative, there is an sql_input for integrations which can read metrics from MS-SQL: SQL input | Elastic Documentation. Although there isn't an existing integration which reads arbitrary metrics in the way I think you might want to do. If you want to collect metrics with Fleet managed Elastic Agents, it might be possible for you to write a custom integration which uses the sql input to read metrics.
I'm interested in data collection and I've noticed that SQL metrics integrations exists. I'm a bit surprised that this feature isn't in your development path.