Facing issue on SQL Server with Elastic Search

(jayaramu) #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?

(Jörg Prante) #2

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

(jayaramu) #3

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

(jayaramu) #4

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

(jayaramu) #5

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

(system) #6