How to sync data between Azure SQL Database with Elasticsearch through Logstash

[seerj29 (Sergiu Molnar)]

Hi everyone,

I'm trying to find a way to sync data between Azure SQL Database with Elasticsearch using Logstash.
I found an article about doing this with the JBDC plugin, but if I understood correctly this is only for SQL Server, which is not my case.

Is there any way to do this with Azure SQL Database?

Any advice is much appreciated.
Thanks in advance,
Sergiu

[Badger]

@seerj29

if I understood correctly this is only for SQL Server

Not quite. The jdbc plugin supports whatever Jeremy Evans' sequel library supports. Sequel currently has adapters for ADO, Amalgalite, IBM_DB, JDBC, MySQL, Mysql2, ODBC, Oracle, PostgreSQL, SQLAnywhere, SQLite3, and TinyTDS.

My understanding is that Azure supports JDBC, so you should be able to access it using the jdbc input.

[seerj29 (Sergiu Molnar)]

Oh, ok then. That's awesome.

And if I want to update the Elasticsearch every time some entities are updated in the database, should the Logstash be published somewhere in Azure?