Use own SQL database to store result, and only use WATS for presenting data

Follow

Anders Pedersen Sekanina

• May 22, 2023 07:25

If we setup Teststand to store test results in a local sql database, is it then possible that Wats uses this database, so we can use Wats only to show statistic etc?

Regards Anders

0

• 

  Tom Andres Lomsdalen

  • May 22, 2023 10:22

  Hi Anders, I would say no, you would have to store the UUT reports in WATS to be able to run the analytics. You could however store in both systems (WATS and native TS DB). What would be your argument(s) to use a local TS SQL DB in addition/instead of WATS? 

  0

  Comment actions Permalink
• 

  Anders Pedersen Sekanina

  • May 23, 2023 07:19

  Hi Tom

  Yes I could see I had misunderstood, at Wats we are paying for capacity of analyzing data and not for the storage. I had thought we could save something by storing the data locally.

  But we do have some quite large arrays of data, that we want to save to local database/XML reports, but not upload to Wats. In normal Teststand reports it is possible to set it up to ignore large arrays, I can't find that option in Wats?

  0

  Comment actions Permalink
• 

  Tom Andres Lomsdalen

  • May 25, 2023 15:11

  Hi.

  No, the WATS add-on have no additional filter option. You can disable logging on steps (exclude from WATS logging) or "filter" chart data/arrays from the code module. Normally we recommend storing all important information to WATS. You may have distributed test stations and access to data is one important element. What you save in WATS upload may cost more in data access and handling in the end.

  Some options would be to store data locally from steps in TS that is not logging to WATS (disable report recording) or store arrays as attachments in WATS, or make a custom converter.

   

  0

  Comment actions Permalink

Please sign in to leave a comment.