1 Reply Latest reply on Oct 3, 2017 12:01 PM by jamesm Branched to a new discussion. RSS
    pbreidy Newbie

    Connect SQL DB to Thingworx

    Hello,

     

    I would like to know whether Thingworx can fulfil the following:

     

    1- Is it possible to integrate an SQL database as a structured DB for our Thingworx implementation?

    2- Is it possible to create our own SQL database structure, and make Thingworx use it accordingly?

    3- Can we create our own HTML web forms and integrate them with Thingworx ?

    4- Can we build our own APIs to push and pull from our SQL database (supposedly) serving as a structured DB for our Thingworx instance?

    5- Can we build our own reports (dashboards, Listing, Live reports) and use your functions and controls to inject them with data?

    6- Can we create our own controls and functions?


    Thank you!

      • Re: Connect SQL DB to Thingworx
        jamesm Creator

        1- Is it possible to integrate an SQL database as a structured DB for our Thingworx implementation?

        • Yes, either via using the SQL database as the persistence provider for Thingworx (i.e. Postgres or MSSQL Server), by using the JDBC connector extension (for any database with a JDBC driver) from the marketplace (ThingWorx IoT Marketplace) or by exposing an API layer on top of the database.

        2- Is it possible to create our own SQL database structure, and make Thingworx use it accordingly?

        • Yes, see above; in this case you would use the JDBC driver approach

        3- Can we create our own HTML web forms and integrate them with Thingworx ?

        •      Yes, you can use the underlying REST APIs exposed by Thingworx in custom HTML web forms

        4- Can we build our own APIs to push and pull from our SQL database (supposedly) serving as a structured DB for our Thingworxinstance?

        • Yes, this actually happens automatically as you create web services to query (or write commands) to your SQL database via the JDBC driver approach -- every query or command exposes a RESTful endpoint that you can then use. You could also write a custom API layer on top of your database and Thingworx could interact with that API.

        5- Can we build our own reports (dashboards, Listing, Live reports) and use your functions and controls to inject them with data?

        • I'm not sure I see the difference between this and the HTML web form question? Could you clarify?

        6- Can we create our own controls and functions?

        • Yes