I want to ingest data into Elastic search from MS SQL using Logstash and I was able to achieve this by setting up MS SQL JDBC plugin on my machine locally. But for upper environments, we will be going with Elastic Cloud deployment, and I cannot find relevant documentation for doing the same on Elastic Cloud.
The use case we want to achieve here is syncing data from a database into Elastic search to implement a search functionality so calls to fetch data are made to the ES instead of db. Just to point, we are using Azure app services instead of VMs. Please help.
Also, please suggest if there is any better approach to achieve the mentioned use case.