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

Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! X

MSSqlServer Extension Example

byutz
1-Newbie

MSSqlServer Extension Example

Hey Everyone,

I can't seem to find many examples in the way of using the MSSqlServer extension.  I have my thing setup, with the MSSql Thing template, and my connection is made, I am just not sure how to proceed with creating a service to do a simple query.  Thank you for the help!

2 REPLIES 2
PaiChung
22-Sapphire I
(To:byutz)

After saving it, go back into edit mode and start a new service.

then for the type of service which defaults to JavaScript, select SQL Query (to bring back data) or SQL Command (to enact on the Database)

Then just built a proper SQL

The Thingworx Fundamentals course has a good chapter on this.

Aanjan
9-Granite
(To:byutz)

Brian, as Pai suggested, the Introduction to ThingWorx course has a separate section called 'Connecting to External Data Sources'. It has examples on how to connect to a SQL database, create queries (and commands) and then bind them to a Mashup.

Top Tags