Skip to main content
ssriuaipornchai1-Visitor
1-Visitor
Apr 2, 2018 9:37 AM UTC
Question

How to send data from MSSQL to Thingworx?

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
Apr 2, 2018 9:47 AM UTC

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

 

Translate
Yedukrishnan14-Alexandrite
14-Alexandrite
Apr 2, 2018 9:54 AM UTC

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.

Translate
LeighEmeritus
Emeritus
Apr 5, 2018 2:19 PM UTC

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

Translate
ssriuaipornchai1-VisitorAuthor
1-Visitor
Apr 10, 2018 6:47 AM UTC

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  ?

Translate
Velkumar19-Tanzanite
19-Tanzanite
Apr 11, 2018 7:21 AM UTC

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.

 

 

Translate
Terms & ConditionsAccessibility statement