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

Need To Know How Does PTC ThingWorx platform support java enterprise application and database porting

Highlighted
Level 7

Need To Know How Does PTC ThingWorx platform support java enterprise application and database porting

Hello All, Here we can discuss about Does PTC ThingWorx platform support java enterprise application and database porting

Let's get started!

ThingWorx does not have any inherent database porting methods available, however, it is not be terribly hard to write you own - I've done this and assisted with this for several migrations when the database backend was changing and data was still pouring into the old server while we brought the new one online. ThingWorx provides JDBC Connectors, a SQL connector, so you could easily read the database rows out and write into ThingWorx. Or write RESTful services to talk from Twx server A to Twx server B. Less easy, I suppose, if you have tons and tons of both meta data and actual rows of data.

If you are serious about Thingworx, you are likely running at least two servers, the Platform server and a database server. (These should not be the same box.) In this case you have more porting options (like pg_dump if you are on Postgres, or similar dump tool if you are on DataStax or SAP) to another database. If you are using AWS Certified or another cloud database you can take an image of the database and spin up a new one. This is often easier than exporting entities and data, esp once you have a lot of both.

As for application porting... there is not really a good way to do this. ThingWorx mostly runs on JavaScript based scripts. You can develop extension packages and that is all done Java, but you would have to do that yourself and mush you original Java it into the ThingWorx extension package format, or at least wrap it with their Entities. That is not where ThingWorx shines as a development platform - it's a great platform overall but not for that, yet.

Thanks

Nicolewells

1 REPLY 1

Re: Need To Know How Does PTC ThingWorx platform support java enterprise application and database po

ThingWorx community is here: https://community.ptc.com/t5/IoT-AR/ct-p/IoTAR