Hi Aahlad, is MS SQL installed as persistence provider or you trying to connect to MS SQL via the RDBMS Extension? It looks like you are mixing two methods. If you are trying to connect via the RDBMS extension you'll need to create Thing of type MSSqlServer ThingTemplate
If you are are attempting to configure it for Persistence Provider it'll need to be done in platform-settings.json file in ThingworxPlatform folder
Yes we are connecting MS SQL as persistence provider, it is done separately.
But here what we are doing is connecting thing which has "Databse" as base ThingTemplate to MsSQL.
So here all we need is the possible values of DriverClassName for MSSQL.
Please let us know what need to do to achieve this.
Thanks for clarifying . I could see the same behaviour until i imported the MSSQLConnector_Extension Relation Databases connectors
It appears the JDBC driver already included is not accessible like that, after importing the extension I created a Thing of ThingTemplate MSSqlServer (FYI this added sqljdbc jar in \\webapps\Thingworx\WEB-INF\extensions)
And following configuration :
Hope this'd help.
We are using "Database" as Base Thing Template and configuring MSSQL DB details in Configuration tab, not MSSqlServer(as ThingTemplate).
For Postgressql we are able to connect thing, it is giving connected as true, but for MSSql it is giving connected as false.
Is there any way to connect thing to DB by using "Database" as base thing template.