Easiest way to connect an SQL database to Thingworx Studio?  For the beginner.

    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.

     

    -Durgesh

     

    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

     

    From here:

    • Import the appropriate DB extension
    • Create a new database thing based on the appropriate template (i.e. MSSQLServer template for MS SQL Server)
    • Configure the JDBC connection string
    • Create a new service
      • On the top left of tthe service panel, in the service handler drop down, select SQL Query
      • Write the SQL query
      • Test the service and create a datashape from the result, apply the datashape to the service
    • Continue as Durgesh responded above by using TWX studio to add external data
      • Find your database thing
      • Find the service you created with the SQL query
      • Bind to your widget

     

    This document was generated from the following discussion: Easiest way to connect an SQL database to Thingworx Studio?  For the beginner.