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

Elastic Stack Logstash
1

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

2

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.

3

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?

4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.