How to send data from MSSQL to Thingworx?

[ssriuaipornchai]

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

[Velkumar]

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

[Yedukrishnan]

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.

[Leigh]

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

[ssriuaipornchai]

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  ?

[Velkumar]

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.

[ssriuaipornchai]

Please, suggest me. How to config below list.

JDBC Driver Class Name

JDBC Connection String

connectionValidationStiring

I using MSSQL Express, user is "sa" ( This user can login already and password correct )

[Velkumar]

Hi @ssriuaipornchai

Class Name:

com.microsoft.sqlserver.jdbc.SQLServerDriver

connection String,

jdbc:sqlserver://server IP:PortNumber;databaseName=DBname

Example: jdbc:sqlserver://10.10.2.107:1433;databaseName=MyDB

use can use default connectionValidationStiring

Regards,

Velkumar R

[ssriuaipornchai]

Can't

[ssriuaipornchai]

Now It's now working

Can you remote for me?