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

service to store rows in multiple data table

PreetiGupta
14-Alexandrite

service to store rows in multiple data table

I have an use case where I have multiple part numbers are stored against one vendor. I created Vendor data table & part data table. I would like to store vendor information in Vendor datatable and part information in Part table along with the vendor id. Is this possible? Or I have to store part number as infotable in the Vendor Data table.

4 REPLIES 4

Yes it's totally possible, but you don't have referential integrity on TW.

PreetiGupta
14-Alexandrite
(To:CarlesColl)

thanks Carlos. I think not having referential integrity feature is a limitation on data tables.

Hi

Have a read of Where Should I Store My Thingworx Data?

If you want database type features and some form of referential integrity, there's advantages to storing that data in an RDBMS and using a database extension (easily created with JDBC Extension) to connect it to ThingWorx.

Regards

Ian

PreetiGupta
14-Alexandrite
(To:ibanham)

Thanks Ian for the  feedback.

It is part of the exploration. What all I could do within ThingWorx Platform. Of course I could go RDBMS route, but just do not want to do it yet :-)

thanks again,

Preeti

Top Tags