Skip to main content
S
sdhawane1-Visitor
1-Visitor
May 19, 2017
Solved

Read data from postgresql.

  • May 19, 2017
  • 1 reply
  • 3314 views

I am new to thingworx. I have thing which I used to connect with postgresql DB . I have one mashup. On mash up button click I want to read data from postgresql DB table using thingworx javascript. I dont want to use import extension approach. Please suggest how to read DB data using mashup

Best answer by supandey

Hi Sachin, I'm not sure what you mean with import extension approach because if you don't have PostgreSQL as your default persistence provider you must have setup the database connection using the extension.

But like you already said you have a working connection to PostgreSQL you can simply create scripts as SQL Query/Command to query the data which can be pulled into your Mashup.

1 reply

S
supandey5-Regular MemberAnswer
5-Regular Member
May 19, 2017

Hi Sachin, I'm not sure what you mean with import extension approach because if you don't have PostgreSQL as your default persistence provider you must have setup the database connection using the extension.

But like you already said you have a working connection to PostgreSQL you can simply create scripts as SQL Query/Command to query the data which can be pulled into your Mashup.

S
sdhawane1-VisitorAuthor
1-Visitor
May 19, 2017

Thanks Sushant for quick reply.

Creating a script as SQL Query to query the data and bind that data to mashup worked out. I created one service in thing which will query the data and return the result. I bonded that service to Clicked function of button on mashup and it worked out. I can see data on mashup

Thanks a lot.

Terms & ConditionsCookie settingsAccessibility statement