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

Community Tip - Stay updated on what is happening on the PTC Community by subscribing to PTC Community Announcements. X

Connecting twx to external MsSQL database located on another server

AT_10203640
6-Contributor

Connecting twx to external MsSQL database located on another server

Hi Team,
I have installed thingworx with postgreSQL Database. In order to fetch data from other sources,  I am trying to connect twx to an external MsSQL database running on another server.  Could you please help me out with this?

5 REPLIES 5

@AT_10203640 

 

You can refer below article and developer portal tutorial for detailed steps,

https://www.ptc.com/en/support/article/CS318728

https://developer.thingworx.com/resources/guides/external-databases

 

Regards,

Sachin Sharma

ThankYou! @SachinSharma 

Hi @SachinSharma , Is is possible to fetch real time data with this approach? Also if you could tell the minimum data rate(eg per min/ per hour etc) with which it could be fetched? 

@AT_10203640 Fetching real time data you mean data from devices or from the database? Can you please explain your use case?

Hi @SachinSharma, Sorry  for getting back so late. Actually I am deploying a ML Model using an external PMML file. Now I have to get the input data for the Model from a table on MsSQL database. Also If you could help me out on how to give that data to ML Model, that would be great!
PS: It's a pre-trained model. I only have to feed data on which I need predictions.

Thankyou!

 

Top Tags