Selecting a Data Store

ThingWorx Model and Data Best Practices > Storing Data with ThingWorx > Data Storage Options > Selecting a Data Store

Refer to the data store specific sections for details on specific data stores.

PostgreSQL or MS SQL Server

Either can be used in production. The primary discriminator is the comfort factor of the operating IT professionals within your organization. In addition:

• PostgreSQL and MS SQL Server are enterprise-grade production databases with wide industry adoption.

• PostgreSQL is the most widely used with ThingWorx, and can be considered the most mature due to the large ThingWorx user base and length of existence.

• While PostgreSQL is open source, PTC has documented most installation and configuration steps that are necessary to use with ThingWorx. See Using PostgreSQL as your Persistence Provider .

• The commercial data store option, MSSQL Server, assumes that the user is familiar with capacity planning, installation, and configuration of this data store and meet their licensing requirements.

• PTC does not ship the JDBC drivers required to operate with MS SQL Server due to licensing restrictions. You are expected to acquire these drivers from the vendor.

Was this helpful?