I am planning to use MSFT SQL Server Connector which is available in ElasticCloud 8.9.0. As per the documentation it is compatible with SQL Server 2017 or higher. So I am not able to use SQL Server 2016 using this connector. I have 2 questions:
Is there any way to push the content of SQL Server 2016 using any Elastic Agent which configured on SQL Server Instance to ingest data in Elastic Index?
While using SQL Server version 2019, How to see the detailed logs for SQL Server Connector Full Sync. On the UI I am able to see only see one line that it is not able to connect to SQL Instance. I need to check what is the exact error in detail with verbose log kind of.
Looking for you response of these 2 questions.