Skip to main content
V
vieirac110-Marble
10-Marble
December 13, 2019
Solved

Direct Access to Persisted and Metadata Data

  • December 13, 2019
  • 1 reply
  • 841 views
In case using an external application, is it possible to access data model metadata directly (without calling Thingworx services) and also persisted data (postgres or influxdb)?

Tks
Chris
Best answer by Constantine

Hello,

 

Yes, you can connect to Postgres database using connection that you configured during ThingWorx installation.

 

However, you should not do it for the whole array of different reasons -- security, caching, data integrity, performance, etc. Besides, ThingWorx tends to store a large part of its data in JSONs, requiring additional parsing after you do the query, so it may not be as practical as you might expect. 

 

My overall advise -- just don't do it, it's almost certainly a bad idea. ThingWorx offers a whole lot of integration mechanisms, all of which work better.

 

/ Constantine

1 reply

C
Constantine18-OpalAnswer
18-Opal
December 14, 2019

Hello,

 

Yes, you can connect to Postgres database using connection that you configured during ThingWorx installation.

 

However, you should not do it for the whole array of different reasons -- security, caching, data integrity, performance, etc. Besides, ThingWorx tends to store a large part of its data in JSONs, requiring additional parsing after you do the query, so it may not be as practical as you might expect. 

 

My overall advise -- just don't do it, it's almost certainly a bad idea. ThingWorx offers a whole lot of integration mechanisms, all of which work better.

 

/ Constantine

Terms & ConditionsAccessibility statement