How to transform data from sql server to elastic search through beats?

Elastic Stack Beats
1

Hi,

I need to transform data from sql server to elastic search. I did it through Logstash. Which beat i should use to transform data from sql server without using logstash

2

@manjur To do that we recommend Logstash and the JDBC inputs since you usually need to do more work on the data to ingest it in Elasticsearch correctly, Logstash data manipulations options and filters are well suited for that. Is there any reason why it doesn't work for you?

There was a community beat to interact with SQL, but I haven't used it.

3

logstash uses config file which will be different for different db connection. For example if we have 10 clients i have to give 10 config file for that. So is there any way to do this without config file?

4

You probably can use inline environment variable when starting Logstash and they will be replaced in the configuration.

https://www.elastic.co/guide/en/logstash/current/environment-variables.html

USER="abc" bin/logstash -f myconfig.conf

5

Do i need to install any plugins for that?

6

@manjur No it should work out of the box.

7

thank you.. it worked

8

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