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.