I'd be very grateful if someone can list out the steps to connect an SQL database to a thingmark in Studio.
Maybe a table that will have 3 columns and 9 rows.
Even the most basic steps will be of help, thank you!!!
Message was edited by: Sushant Pandey moved it to Studio
Charlie Koenig: I am not sure if I understood your request correctly and it will help if you can clarify.Do you want to get data from MS SQL data into ThingWorx Studio.
As per my understanding you will have to first configure this SQL database as external data into ThingWorx and use ThingWorx services to retrieve the required data from SQL database.
Then, using ThingWorx Studio you can access the data by using option add External Data.
Grab the JDBC extension package from the marketplace: https://marketplace.thingworx.com/tools/jdbc-connector-extension
or, if it's for Postgres, MSSQL, MySql, or Oracle, you can grab the specific extension with the JDBC driver included here: https://marketplace.thingworx.com/tools/Relational-databases-connectors