Preferred solution for logging data from shared variable to a database

[David1980]

Hi,

The scenario is: we have potentially several hundred of variables on SVE where their values need to be stored during operation. (the type mostly double but some array and boolean do xist also)

We can assume all the data is being updated on SVE, the task is to log and store them, without any additional (license) cost at run-time, for analyzing and plotting.

What are the options with labview?

Can you guide me through the options?

examples?

- LV --> DB connectivity --> sql express

- LV --> DSC --> sql (any license cost at run-time) ?

- LV --> TDMS ?

- LV --> TCP/IP --> MySql

anything else?

The development evironment is LV2014 Full professional with DSC module. (requirement no license shall eb needed in run-time (beside run time engine and avialable app like sql express, etc.)

Rgds,

Dave

[mikeporter]

First thing to realize is that for what you are wanting to do options 1, 2 and 4 are really the same option. Regardless of how you access a database you don't need to incur any additional license fee. Where is the database you are going to be accessing? Does it already exist? Option 3 really isn't an option because TDMS isn't a database.

You might want to check the posts I did on database access. Check the link in my signature.

Mike...

[natasftw]

---

@mikeporter wrote:
First thing to realize is that for what you are wanting to do options 1, 2 and 4 are really the same option. Regardless of how you access a database you don't need to incur any additional license fee. Where is the database you are going to be accessing? Does it already exist? Option 3 really isn't an option because TDMS isn't a database.

You might want to check the posts I did on database access. Check the link in my signature.

Mike...

---

Option 2 is going to require a runtime license fee.  The DSC has a pay per machine RTE.  That said, they don't need it and can avoid it.

[mikeporter]

Yes, but the DSC doesn't allow you to access a database. With or without the DSC installed you access databases in the same way.

Mike...

[David1980]

Thx. the database does not exist and has to created. I think DSC is an option which require license fee, right (as natasftw mentioned).

Where in your website u have database related notes?

At the end any recommendation for option to choose?

Rgds,

Dave

[David1980]

More explanation: the logging vi and storing into database, reading, etc. have to be developed. Consider this in your recommendations.

[mikeporter]

Check the link in my signature.

Mike...

[MichaelBalzer]

I take it the reason for not wanting the DSC runtime is cost? Don't forget to factor your development time and costs into your different options - you may find your development costs quickly outweigh the price of the DSC runtime.