====MySQL Live Driver Information====

===Source Properties===

When setting up the MySQL data source, you'll be asked to specify...

^Option^Use^
|Host|The host name or IP address of your MySQL server|
|Port|The port that the MySQL server runs on (normally 3306)|
|Database|The name of the MySQL database to use|
|Username|The username (with read-only access) to use to connect|
|Password|The password that goes with the above username*|
|Table|The name of the table to query|
|Lookup Field|The field that gives you the 'name' of the value - used to connect a single ARDI property with a single row in your database|
|Date Stamp|**Optional** - The name of the //date// column in your database. If not specified, //all// rows are inspected. See the 'Date Stamps' below for more detail.|
|Value|The name of the column that contains the value you are looking for|
|Filter|**Optional** - An additional filter to add to the SQL query|

* Note that this password is visible to all administrative users, which is why you should ensure that the user account is //read only// and can not make changes to the underlying database.

===Link Properties===

These are the options that appear when you link a property to a text data source...

^Option^Use^
|Lookup|The value of the lookup column|

===How It Works===

As an example, let's look at a simple database layout...

^Date^Name^Value^
|2016-01-01 12:15|ALPHA_TEMP|24.04|
|2016-01-01 12:15|BETA_PRESS|2891|
|2016-01-01 12:15|BETA_TEMP|16.29|
|2016-01-01 11:15|ALPHA_TEMP|29.04|
|2016-01-01 11:15|BETA_PRESS|2231|
|2016-01-01 11:15|BETA_TEMP|20.29|

If we wanted to connect to the latest values in this table, we would set the columns of our **data source** so that...

  * Lookup Field = //Name//
  * Value = //Value//
  * Date = //Date//

Then, if we had an asset called "Beta", when we linked the "Pressure" property to data, we would set...

   * Lookup = //BETA_PRESS//

The driver checks for the **Lookup Field** that matches the **Lookup** of the data link and returns the value in the **Value** field. 

So in the case above, the driver would check the first three rows, and set the pressure of the Beta asset to //2891//.

===Date Stamps===

The fastest scenario is if you have a 'latest values' table that contains **only** the most recent data.

There is one case to be aware of - if your recordings aren't //synchronised// (ie. they aren't all recorded simultaneously to the database) - it may take a little while for your driver to get **all** of the data after being restarted. On restart, the driver may capture only the **most recent** data, which may not include some of your points. You may need to wait until new data arrives for the information to be captured. 

This driver doesn't need to know the style or timezone of your date stamps.