Skip to main content
schakravarthy1-Visitor
1-Visitor
October 24, 2017
Question

how do i get a table that i created in postgre to thingworx?

  • October 24, 2017
  • 6 replies
  • 4055 views

i want to transfer the table created in postgre to thingworx composer, can you pls tell me the procedure for it.

6 replies

supandey5-Regular Member
5-Regular Member
October 24, 2017

Hi Swetha, are you using PostgreSQL as your ThingWorx's Persistence Provider or are you connecting to it via the JDBC connector/RDBMS connector? Also could you please elaborate a bit on your use case, are you just looking to show some data in ThingWorx Composer via a Mashup with for e.g. a grid widget? That won't require you to transfer data, you will be able to show this data in the mashup just via the SQL services.

schakravarthy1-VisitorAuthor
1-Visitor
October 26, 2017

Hi Sushant , i wana display my database values in my mashup, so i need procedure for that . Also is there any proper demo video for understanding data storage in thingworx?

supandey5-Regular Member
5-Regular Member
October 26, 2017

Swetha assuming this is an external database, you can configure the Relational Databases Connectors ​or JDBC Connector Extension ​to connect to the database and query the table, you can download these extensions to ThingWorx from the ThingWorx Marketplace. Both of these extensions include the setup guide.

Additional reading :

Accelerate analytics and transactions on external data store for ThingWorx using Oracle 12c In Memory Column Store featu…

Types of JDBC Calls from JDBC Extension & RDBMS Extension in ThingWorx

Terms & ConditionsAccessibility statement