Hi Atul, any data store configured as default persistence provider will handle both metadata and the data for ThingWorx. Usually you'd want to use DSE for very high volume of data as expected with streams, value streams, data table etc.
Are you planning to use only DSE? I'm not quite sure if you can remove the other PersistenceProvider and use just the DSE for it, may be someone else who tried this could comment.
Please refer to the following guide: https://support.ptc.com/WCMS/files/166016/en/Getting_Started_with_DataStax_Enterprise_and_ThingWorx_1.pdf
On Page 20; it mentions that The entity information resides in the embedded Neo4j data store (not in Cassandra).
And on Page 6, it adds Benefits of DSE as Separates data processes from Platform processes
So, per my understanding; there is a core database like H2/Postgresql and DSE for big Data.
I hope it helps.
Thanks Sushant and Ankit.
So based on PTC/TW DSE documentation, we can say that:-
- TW need to have a separate core database like Neo4j/postgres/H2 as model-provider (to store metadata) and
- DSE(Cassandra) as persistence provider, can only be used as data-provider (to store run-time data in data_table/value_stream/steam etc.).
Hey Polina Osipova I think you tried something like this, can you confirm if DSE alone can work as the sole PersistenceProvider for TWX or is it must to have an another Persistence Provider like H2 or Neo4J etc.
Atul Tripathi: One should use Persistence Provider as PostgreSQL, H2, Neo4J, MSSQL only. So, DSE at present cannot be persistence provided and can be used only as a data-provider to store run-time data.
Hope it clarifies.