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

[pshashipreetham]

Manufacturing Apps Extension Comes with this Project 

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 ?

[VladimirRosu · Accepted solution]

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.