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

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

Direct Access to Persisted and Metadata Data

vieirac1
9-Granite

Direct Access to Persisted and Metadata Data

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
1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

1 REPLY 1

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

Top Tags