Is it possible to import data from file into sql server and use logstash?
Hello,
Do you want to load data into sqlserver using logstash?
can you elaborate your requirement.
Hi
Yes.
I was using bulk insert. But i want to use logstash and don't run ssms.
I created a sample table:
create table sample:
CREATE TABLE [dbo].[sample](
[Id] [bigint] NULL,
[Name] nvarchar NULL
)
and I want to load test.txt data into that.
this is my text file data:
id|name
1|john
2|jack
3|marry
Using logstash, you can load data from sql server into elasticsearch.
But i am not sure whether we can import data from file into sql server using logstash.
Hope someone helps you, if it is possible.
Regards
There is a community output plugin for pushing data to SQL Server or any-other JDBC enabled source.
theangryangle has done a fantastic job with this and we leverage it for dual feeding data from kafka into ES and SQL Server.
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.