Connecting twx to external MsSQL database located on another server

[AT_10203640]

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?

[SachinSharma]

@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

[AT_10203640]

ThankYou! @SachinSharma 

[AT_10203640]

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? 

[SachinSharma]

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

[AT_10203640]

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!