Hy everybody! I am new in elasticsearch and beginner in docker also. I need to know what is the best way to connect an ms sql data base to an elastichsearch docker instance? Thanks for Help!

Means you want to sync MSSQL data into elasticsearch ? If yes, the best way is to use logsatsh with JBBC input Something like this may help input { jdbc { jdbc_driver_library => "/opt/mssql-jdbc-7.5.1.jre9.jar" jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver" jdbc…

Thank you! Somewhere can i find a yaml for this solution?

You can check more details here I will suppose you have already an MSSQL database running on a host and you want to sync it to a new Es instance with logstash. The logstash config looks like this input { jdbc { #> jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;pr…

Thank you so much! It helps a lot.

Discuss the Elastic Stack

MS SQL+ ELASTICSEARCH

Elastic Stack Logstash

ylasri (Yassine LASRI) December 14, 2020, 12:16pm 4

by yaml you means a docker-compose configuration ?

Topic		Replies	Views
Logstash Pipeline for Microsoft SQL Server to Elasticsearch Logstash docker	10	12095	February 5, 2020
Mssql Logstash	3	444	August 29, 2018
Mssql jdbc Logstash	5	1898	September 22, 2017
SQL Server data to Elasticsearch using LogStash Logstash	4	436	October 14, 2021
SQL Server data to Elasticsearch using LogStash Logstash	1	276	August 26, 2021

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

MS SQL+ ELASTICSEARCH

Related topics