Facing issue on SQL Server with Elastic Search

Elastic Stack Elasticsearch
1

I have integrated SQL Server with Elastic Search. I face the problem with data type TEXT and NVARCHAR(MAX).

If I use any of this datatype in SQL Server, no result is returned by Elastic Search.

Why does this happen?
Is there any solution for this?
2

Do you use JDBC importer? https://github.com/jprante/elasticsearch-jdbc

3

Thanks for your reply jprante. No, am not use JDBC importer. I will check with that and let u know.

4

I have download JDBC importer. I dont know How to use it in Elastic search?. Will you please explain that.

5

Thank you jprante. After using JDBC importer its working fine.