Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X
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.
Yes it's totally possible, but you don't have referential integrity on TW.
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
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