# Knime Integration with ElasticSearch

**URL:** <https://forum.knime.com/t/knime-integration-with-elasticsearch/39588>\
**Category:** KNIME Analytics Platform\
**Created:** [February 7, 2022, 5:39pm UTC](https://forum.knime.com/t/knime-integration-with-elasticsearch/39588 "2022-02-07T17:39:30Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![vibha43](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/v/b77776/32.png) [@vibha43](https://forum.knime.com/u/vibha43)\
**Post date:** [February 7, 2022, 5:39pm UTC](https://forum.knime.com/t/knime-integration-with-elasticsearch/39588/1 "2022-02-07T17:39:31Z")

</div>

Hello,  
I am trying to integrate ElasticSearch with Knime. I am currently using Knime client 4.2.2 in accordance with the server we have currently. I was trying out the connection in local but I get the following error. Any suggestions would be really appreciated.  
WARN : KNIME-Worker-4-DB Reader 0:40 : : TransactionManagingWrapper : DB Reader : 0:40 : A local transaction has not been closed!  
WARN : KNIME-Worker-4-DB Reader 0:40 : : TransactionManagingWrapper : DB Reader : 0:40 : An error occurred during the closure of the unclosed local transaction.  
java.sql.SQLException: Auto-commit is enabled  
at org.elasticsearch.xpack.sql.jdbc.JdbcConnection.rollback(JdbcConnection.java:115)  
at org.knime.database.connection.impl.managing.transaction.BroadTransactionManagingConnectionWrapper$ShortTransaction.close(BroadTransactionManagingConnectionWrapper.java:231)

---

<div class="post-metadata">

**Author:** ![ScottF](https://forum-cdn.knime.com/user_avatar/forum.knime.com/scottf/32/61316_2.png) [@ScottF](https://forum.knime.com/u/ScottF)\
**Post date:** [February 10, 2022, 3:19pm UTC](https://forum.knime.com/t/knime-integration-with-elasticsearch/39588/2 "2022-02-10T15:19:34Z")

</div>

Hi @vibha43 -

I think we need more information about what you’re doing here. Can you upload an example workflow (no included credentials, please!) that documents what you’ve tried so far?

---

<div class="post-metadata">

**Author:** ![danielesser](https://forum-cdn.knime.com/user_avatar/forum.knime.com/danielesser/32/331_2.png) [@danielesser](https://forum.knime.com/u/danielesser)\
**Post date:** [February 10, 2022, 4:57pm UTC](https://forum.knime.com/t/knime-integration-with-elasticsearch/39588/3 "2022-02-10T16:57:15Z")

</div>

Hey @vibha43,

Besides the **[Elasticsearch Nodes](https://nodepit.com/product/elasticsearch)** might be worth a try to integrate Elasticsearch with KNIME the easy way and read and write data from and to your cluster. Feel free to try them and see if they fit your use case.

> **[Elasticsearch Nodes](https://nodepit.com/product/elasticsearch)**
>
> Take control of your search. Handle and query documents from Elasticsearch within KNIME.

_Disclaimer: I am the developer of these nodes. Feel free to reach out to me in case of questions._

Best regards,  
Daniel

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [May 11, 2022, 4:58pm UTC](https://forum.knime.com/t/knime-integration-with-elasticsearch/39588/4 "2022-05-11T16:58:15Z")

</div>

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