Skip to main content
avillanueva
23-Emerald I
avillanueva23-Emerald I
23-Emerald I
February 18, 2025
Solved

Data_table or Relational Table? Need advice

  • February 18, 2025
  • 1 reply
  • 557 views

Novice Thingworx developer here. We have some existing Navigate apps developed by a 3rd party and I am trying to understand them so I can create new ones. My background and experience is in relational databases. Some of the data that is managed in these apps is managed in a data table. I can see the records in the data_table. These record counts range from a few hundred to a few thousand entries. A related app has data records that total up to tens to hundreds of thousand records. Those are stored in their own SQL Server table. The developer wrote a SQLDatabaseConnection Thing  and a DataShape to manage that interface. Is there a common rule when you go one way vs another? 

Best answer by Velkumar

Hi @avillanueva 

 

Please check this post : Where Should I Store My Thingworx Data? - PTC Community

 

There is no common rule for defining where to store data, but it is recommended to use an external database with a JDBC connection for better performance.

 

/VR

1 reply

V
19-Tanzanite
Velkumar19-TanzaniteAnswer
19-Tanzanite
February 19, 2025

Hi @avillanueva 

 

Please check this post : Where Should I Store My Thingworx Data? - PTC Community

 

There is no common rule for defining where to store data, but it is recommended to use an external database with a JDBC connection for better performance.

 

/VR

    Terms & ConditionsCookie settingsAccessibility statement