Solved! Go to Solution.
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
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