Skip to main content
A
AitorP1-Visitor
1-Visitor
July 26, 2021
Solved

MSSQL Server as Persistance

  • July 26, 2021
  • 1 reply
  • 1390 views

Hi,

I am not able to see/add/use MSSQL as Persistance provider. I have trial version Thingworx.

My goal is to save data form keepware and work with this data. Do a graph with this data for example. I guess I have to save the data to a persitance server.


I have followed all the instructions from Support (https://support.ptc.com/help/thingworx/platform/r9/es/index.html#page/ThingWorx%2FHelp%2FInstallation%2FInstallation%2Finstall_java_and_apache_tomcat.html%23wwID0EHC3O ) and https://support.ptc.com/help/thingworx/platform/r9/es/index.html#page/ThingWorx%2FHelp%2FComposer%2FDataStorage%2FPersistenceProviders%2Fmssql_database_setup_for_thingworx_windows.html%23wwID0E6QAW

But I don't know what to do more. I guess it should appear here but it does not appear:

AP_9996685_0-1627297537227.png

 

I think I have followed all steps but maybe I have something missing.

Someone has the same problem?

 

Thanks

Best answer by slangley

Hi @AitorP 

 

Why is it necessary to run SQL Server for evaluating the product?  The trial version allows you to assess functionality.  If you decide to move forward to purchase the product, you can install the SQL Server version at that time.  

 

If you are interested in a different type of trial, I recommend that you reach out to the Sales team to discuss options.

 

Regards.

 

--Sharon

1 reply

S
slangleyCommunity Manager
Support
July 26, 2021

Hi @AitorP 

 

You indicated you have a trial version, which is packaged with H2 as the persistence provider.  Are you trying to modify this trial version to use SQL Server instead?  If so, you need to follow these instructions for setting up the database, but you may run into other issues.  If you already have a ThingWorx license, you can install the product using the Foundation installer instead of the trial version.

 

Please let us know if you have further questions.

 

Regards.

 

--Sharon

A
AitorP1-VisitorAuthor
1-Visitor
July 26, 2021

Hi sharon,

Thanks for your answer, I do not have license for the moment.
I followed the intructiones from the link you attached witohut success.

Maybe The question is if is possible to do have MSSQL as a Persistence provider without license.
Thanks.

S
slangleyCommunity ManagerAnswer
Support
July 26, 2021

Hi @AitorP 

 

Why is it necessary to run SQL Server for evaluating the product?  The trial version allows you to assess functionality.  If you decide to move forward to purchase the product, you can install the SQL Server version at that time.  

 

If you are interested in a different type of trial, I recommend that you reach out to the Sales team to discuss options.

 

Regards.

 

--Sharon

Terms & ConditionsAccessibility statement