storing data tables in influxdb

[AA_9993205]

Hi,

I am planning to shift from Postgres to influxdb however I'm not sure how data tables will be stored as there is no documentation available. Is there any walk around to do this.

thanks

Adarsh

[VladimirN]

 Hi Adarsh,

Here are some helpful resources:

• "Using InfluxDB as the Persistence Provider": https://support.ptc.com/help/thingworx/platform/r9/en/index.html#page/ThingWorx/Help/Composer/DataStorage/PersistenceProviders/using_influxdb_as_the_persistence_provider.html
• "Use ThingWorx with InfluxDB Cloud": https://docs.influxdata.com/influxdb/cloud/tools/thingworx/
• "PTC ThingWorx and InfluxDB: Key Resources": https://www.influxdata.com/partners/ptc-thingworx/

[AA_9993205]

influx db does not support data tables so how can i store non time series data in influxdb

[slangley]

Hi @AA_9993205.

Can you explain your use case?  Influxdb is used for streams and value streams, whereas datatables are used for more static data.  If we had a better understanding of your needs, we could possibly suggest an alternative.  For example, you could set up your data table in a different database via jdbc as opposed to the persistence provider you're using for ThingWorx.

Regards.

--Sharon