Skip to main content
ssriuaipornchai1-Visitor
1-Visitor
April 2, 2018
Question

How to send data from MSSQL to Thingworx?

  • April 2, 2018
  • 9 replies
  • 6533 views

Hello anyone.

 

I have data in MSSQL.

How I send data to Thingworx?

 

I want to send data when some data income to MSSQL.

 

Thank you

9 replies

Velkumar19-Tanzanite
19-Tanzanite
April 2, 2018

Hi @ssriuaipornchai

 

You can use JDBC extension to connect Thingworx and MSSQL server.

 

https://marketplace.thingworx.com/tools/jdbc-connector-extension

 

After importing, you can directly write SQL Query or Command in MSSQL thing to get data from MSSQL DB.

 

Regards,

Velkumar R

 

Yedukrishnan14-Alexandrite
14-Alexandrite
April 2, 2018

Hello @ssriuaipornchai

         Add MSSQL extension from Thingworx marketplace in Thingworx and configure it. Configuration steps are available in Relational Database Extension documentation in Thingworx marketplace. 

Create a thing with MSSQL thing template.

If connection is Ok, isConnected becomes true.

Write SQL commands and queries in the thing to read and write data.

LeighEmeritus
Emeritus
April 5, 2018

Hi @ssriuaipornchai

Did the responses you received answer your question?  If so, please indicate your Accepted Solution for the benefit of the Community.  If not, please let us know your current status.

Thanks!

Leigh

ssriuaipornchai1-VisitorAuthor
1-Visitor
April 10, 2018

Do you have manual of JDBC extension ?

 

I already import to my Thingworx. But, I don't know "How to use JDCB extention".

 

What's JDBC driver file  ?

Velkumar19-Tanzanite
19-Tanzanite
April 11, 2018

Hi @ssriuaipornchai

 

JDBC is Java Database Connector file.

 

For MSSQL you can get JDBC driver form this link

 

You can follow below steps to create your MSSQL extension:

 

  • To use the builder simply open the JdbcCreator mashup, click the “Choose File” button and select the JDBC driver file you want to use from your local file system.
  • Now click the “Upload” button and a link will be displayed below the buttons, “Download Extension File”.
  • Click this link and save the zip file. This is your extension. You can now import this into the Thingworx platform.
  • The imported extension will create a Thing Template with the name of the file plus “JDBCTemplate”. For example a file named “myDbFile.jar” would create a Template named “myDbFileJDBCTemplate”.
  • Use this template to create a new thing and connect to your data source using JDBC.

 

 

Terms & ConditionsAccessibility statement