Skip to main content
1-Visitor
June 26, 2015
Solved

For ThingWorx 6.0, can we just use MySQL extention to use an external DB and don't use Neo4J at all?

  • June 26, 2015
  • 1 reply
  • 1562 views

some customer asked if they can use their own RDBMS rather than our 3D storage engine. Is this possible? and if yes, how do we handle this storage scenario in ThingWorx?

    Best answer by AdamR

    The Thingworx Model and it's built in storage structures are not able to be extended to another RDBMS at this time.  For version 6.0 the model will always be neo4j and data can be held in DSE Cassandra or neo4j.

    You can however use the Thingworx jdbc connector (using a driver provided by the RDBMS vendor) to connection to any outside data store.  You can then build in structures to store and/or query data (and make other SQL calls) to that system.  This is something that needs to be setup/built/configured for each outside data store on a case by case basis at this time.

    1 reply

    AdamR14-AlexandriteAnswer
    14-Alexandrite
    June 29, 2015

    The Thingworx Model and it's built in storage structures are not able to be extended to another RDBMS at this time.  For version 6.0 the model will always be neo4j and data can be held in DSE Cassandra or neo4j.

    You can however use the Thingworx jdbc connector (using a driver provided by the RDBMS vendor) to connection to any outside data store.  You can then build in structures to store and/or query data (and make other SQL calls) to that system.  This is something that needs to be setup/built/configured for each outside data store on a case by case basis at this time.

    dsun1-VisitorAuthor
    1-Visitor
    June 30, 2015

    Thanks Adam! Got your points.