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

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

Shashi_Preetham
16-Pearl

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

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 ?

Shashi Preetham (psp316r)
1 ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

1 REPLY 1

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.

Announcements