cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X

Connection of Microsoft SQL with Thingworx

pagrawal-2
2-Guest

Connection of Microsoft SQL with Thingworx

As I had connect Oracle with the TWX earlier.

Now I need to connect the MS SQL with TWX.

So can anyone please help how to proceed with that?

I tried but not got any luck.

Thanks.

3 REPLIES 3

Prashant, are you stuck at a specific spot? Do you have the correct extension/ jar file imported?

Hi Anjan,

Thanks for reply.

I am connecting my TWX with MS SQL Database.

So for that I import SQL_Connector_Extension which I created manually by putting metadata.xml and sqljdbc4.jar file.

Then I create a thing and implement that template then add a service and fire a query after putting configuration details which are:

JDBC Driver Class Name     :     com.microsoft.sqlserver.jdbc.SQLServerDriver

JDBC Connection String     :     jdbc:sqlserver://TCIDATA1.whirlpool.com;DatabaseName=TCI_History

Now should I have to put port in the URL also???

Because I am getting this error while executing the service:

So this is the whole scenario.

I hope you are getting me.

ankigupta
5-Regular Member
(To:pagrawal-2)

Hi Prashant,

Try following:

  • Try changing the connection Validation String to "SELECT GETDATE()".
  • Try the Microsoft SQL Extension available on ThingWorx Marketplace. http://marketplace.thingworx.com/Items/Relational-databases-connectors
  • Try Restarting the ThingWorx Tomcat.
  • Try re-importing the extension i.e. Delete the extension. Then reboot your ThingWorx instance. Then import the extension again.

Hope it helps.

Thanks,

Ankit Gupta

Top Tags