Skip to main content
yoprado1-Visitor
1-Visitor
Feb 21, 2018 4:34 PM UTC
Solved

Support for Microsoft SQL Server for PTC Analytics Server 8.2?

Hello,

 

I was hoping to install the latest version of PTC Analytics Server 8.2 on Windows 2016. Is it still a requirement to have Postgres installed and set up for Analytics Server? Our team was hoping to have everything Windows based, so we are planning to use Microsoft SQL Server for Thingworx Core installation. I don't see Postgres on the requirements document on 8.2 for Analytics, but I don't see any RDBMS requirement on there either.

 

Thank you,

York Prado

cmorfinAnswer
19-Tanzanite
Feb 21, 2018 4:42 PM UTC

Hi

 

As you have correctly noticed there is no RDBMS requirement in ThingWorx Analytics 8.2.

ThingWorx Analytics 8.2 does no longer use any database. Data are saved on the file system as parquet format.

 

We also have a native Windows installer with 8.2 (in addition to the docker one) , so you should have a more familiar Windows experience with this new release.

 

Hope this helps

Kind regards

Christophe

 

View in thread

3 replies

cmorfin19-TanzaniteAnswer
19-Tanzanite
Feb 21, 2018 4:42 PM UTC

Hi

 

As you have correctly noticed there is no RDBMS requirement in ThingWorx Analytics 8.2.

ThingWorx Analytics 8.2 does no longer use any database. Data are saved on the file system as parquet format.

 

We also have a native Windows installer with 8.2 (in addition to the docker one) , so you should have a more familiar Windows experience with this new release.

 

Hope this helps

Kind regards

Christophe

 

Translate
    nsampat17-Peridot
    17-Peridot
    Feb 21, 2018 4:43 PM UTC

    York,

     

    Thank you for posting to the Community.

     

    As of ThingWorx Analytics 8.1+, we no longer require a DB for use of our application.

     

    There were changes to the architecture, and currently the data is stored in Apache Parquet format on the File System, which is handled by the Analytics Application directly (no need for an installation steps).

     

    You can use any flavor of ThingWorx Foundation for your front end, but it is required that you have a running ThingWorx Foundation Server prior to installing ThingWorx Analytics.

     

    I have attached the Installation Guide for TWA 8.2 - Windows Deployment for your reference. Please let me know if you have any additional questions.

     

    Regards,

     

    Neel

    Translate
    LeighEmeritus
    Emeritus
    Apr 20, 2018 1:52 AM UTC

    Hi @yoprado

    I just wanted to follow up to see if Christophe and Neel's responses answered the questions you had.  If so, please indicate the appropriate response as the Accepted Solution for the benefit of reference for our Community.  If you have further questions/issues, please advise on your current status.

    Thanks!

    Leigh

    Translate
    Terms & ConditionsAccessibility statement