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

Community Tip - Need help navigating or using the PTC Community? Contact the community team. X

Usage of SQL service

shasegawa
1-Newbie

Usage of SQL service

We can write Thing service with SQL by importing Relational Databases Connectors or JDBC Connector Extension. However I could not find usage manual. I'd like to know detailed usage, capability (e.g. What statement can be used?  Can I use transaction? etc.) and limitations. I also found some fragmented information in the thingworx community. But I want coherent document.


1 REPLY 1
supandey
19-Tanzanite
(To:shasegawa)

Hi Satoshi , are you looking for information on what sort of SQL queries could be used? I'm not sure if there's any specific documentation on that since via JDBC you can pretty much call all sorts of SQL queries, PL/SQL packages, etc. I have so far managed to use all the CRUD SQL statements and PL/SQL blocks from the ThingWorx SQL Service

Top Tags