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

Read data from postgresql.

SOLVED
Highlighted
Newbie

Read data from postgresql.

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Read data from postgresql.

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.

2 REPLIES 2

Re: Read data from postgresql.

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.

Re: Read data from postgresql.

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.