Skip to main content
1-Visitor
May 3, 2018
Solved

Database connection

  • May 3, 2018
  • 1 reply
  • 1435 views

Hi All,

 

what's the difference between MSSqlServer template and Database template?
I mean...can I use both for a SQL Server connection? Is it possible?
In my case, I want to know specificaly if I can connect with Database template.

Thanks,

A.

Best answer by hchanana

Greetings @Assaito,

 

Database template is the default template for connecting thing with the default database.  The default persistance provide is Postgres for ThingWorx.


MSSqlServer template is a template which provides the default configuration for connecting the SQL Server database. The default configuration contains JDBC Driver Class Name, JDBC Connection String, connectionValidationString etc.

 

If my response has answered your question, please mark as Accepted Solution for the benefit of others who may have the same question.

 

Thanks,

Himanshu

1 reply

hchanana16-PearlAnswer
16-Pearl
May 4, 2018

Greetings @Assaito,

 

Database template is the default template for connecting thing with the default database.  The default persistance provide is Postgres for ThingWorx.


MSSqlServer template is a template which provides the default configuration for connecting the SQL Server database. The default configuration contains JDBC Driver Class Name, JDBC Connection String, connectionValidationString etc.

 

If my response has answered your question, please mark as Accepted Solution for the benefit of others who may have the same question.

 

Thanks,

Himanshu