Knime and Azure Cosmos

[parthak]

Hello Knime Users,

I am stuck with a predicament.

I have JSON data as the output of my KNIME workflow, which needs to be pushed into Cosmos DB.
I have tried various methods to no avail. Is there any way in which this is possible using Knime?

[parthak]

I used the DB Connector to connect to the database using JDBC and then used the DB Writer node to write into the db, but I am getting this error. “WARN DB Writer 0:699 Error during preparation”

[ipazin]

Hi there @parthak,

and usually DB Writer works just fine?

Although it is regarding different database you might find this topic helpful:

Insert JSON value into Postgresql database table

I’m facing a problem with insertion of JSON data into PostgreSQL database table column. How to congifure “DB Insert” node in order to be able to insert JSON into a table with JSON type column?

Br,
Ivan