Regarding Mongodb

[DMu3]

Hello,
Can anyone tell how to connect mongodb into ThingWorx, and how to give jdbc settings for mongodb in thingworx?

[posipova]

MongoDB is not supported with ThingWorx.

[wposner-2]

Any database that has a JDBC driver is supported in TWX.

[posipova]

Cassandra was the only Nosql db that was supported. Mongodb is not tested/supported BY PTC

[wposner-2]

The OP didn't say anything about the default persistence provider.  ANY DB supporting a JDBC driver can be connected to TWX and used as a secondary persistence provider.

[posipova]

Unfortunately, that isn't the case with ThingWorx and we do not support MongoDB as a secondary /external persistence provider:

https://www.ptc.com/en/support/article/CS300235

[Constantine · Accepted solution]

Hello @DMu3,

You need to go via JDBC-extension route described in Help: http://support.ptc.com/help/thingworx_hc/thingworx_8_hc/en/#page/ThingWorx%2FHelp%2FExtensibility%2F...

This will allow you to create SQL services to insert, query, delete, etc. (just like JavaScript services, but in SQL). This will NOT allow you to store your entities (things, data tables, etc.) in MongoDB.

/ Constantine