cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

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

dsun
1-Newbie

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
AdamR
12-Amethyst
(To:dsun)

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.

View solution in original post

2 REPLIES 2
AdamR
12-Amethyst
(To:dsun)

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.

dsun
1-Newbie
(To:AdamR)

Thanks Adam! Got your points.

Top Tags