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

Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! 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
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

Announcements

Top Tags