Skip to main content
P
18-Opal
pshashipreetham18-Opal
18-Opal
July 28, 2022
Solved

PTC.SCA.SCO.DataConnection in Thingworx without Manufacturing Apps Extension

  • July 28, 2022
  • 1 reply
  • 1448 views

Manufacturing Apps Extension Comes with this Project 

Shashi_Preetham_0-1659024090707.png

This Project Usually helps the user to create the tables based on DataShape, and do some operations like insert as shown below

 

 

var result = Things["PTC.SCA.SCO.PostgresDatabase"].Insert({
	infoTable: MaterialClasses,
	dataShapeName: "PTC.SCA.SCO.MaterialClass"
});

 

 

Similar way for the query, update Code Snippets can be used. 

This is the very Optimized way to avoid the Performance issue of DataTables (if there are more than 20,000 or 100,000 Records ).

But this Project comes with Manufacturing Apps only
1. How this can be achieved in Thingworx where there is no Manufacturing Apps ?

2. Is there a way to use PTC.SCA.SCO.DataConnection in Thingworx without Manufacturing Apps ?

Best answer by VladimirRosu_116627

For question 1: from a technical perspective in most cases what that method is doing is a pure SQL insert operation that you can achieve with the Database Thing itself very easily on your own, without needing to go in the implementation detail for Manufacturing Apps.

For question 2, the answer is no.

1 reply

V
VladimirRosu_11662719-TanzaniteAnswer
19-Tanzanite
July 28, 2022

For question 1: from a technical perspective in most cases what that method is doing is a pure SQL insert operation that you can achieve with the Database Thing itself very easily on your own, without needing to go in the implementation detail for Manufacturing Apps.

For question 2, the answer is no.

    Terms & ConditionsCookie settingsAccessibility statement