Transcript Advanced Training Databases SQL and Access

SSE OPC and
DATABASES
Overview…
•
•
Setup the SSE OPC to save data to a MS Access database file (mdb)
Setup the SSE OPC to save data to MS SQL database
THE MAIN DIFFERENCE BETWEEN ACCESS AND SQL IS YOUR
DATABASE SETUP.
TO SAVE THE ACTUAL DATA POINT TO THE DATABASE, IS
EXACTLY THE SAME FOR ACCESS AND SQL.
Access Setup
Location in SSE OPC:
On the CHANNEL setup, you will find a ‘DATABASE SETUP’ tab.
Database File Name:
The SSE OPC will create a Access MDB file with the name entered in this field - example
AccessDB.mdb
Database Path/ODBC-Name:
The path where the user wants to save the MDB file
NB!!!! YOUR PATH MUST HAVE A ‘\’ AT THE END
Database type:
Set this field to ‘MS Access Direct’ – this informs the SSE OPC that it must try and connect
to a MS Access database file
DB User Name:
If the Database file was created with a User Name, you can enter the User Name here and
the SSE OPC will connect to the Access database file with the correct User Name
Access Setup
DB User PW:
If the Database file was created with a Password, you can enter the Password here and
the SSE OPC will connect to the Access database file with the correct Password
Use Oracle Standards:
To ensure that the SSE OPC does not use reserved words as field names in the Database.
If you are unsure of this setting, enabled it.
Field Setup:
When you double click on that field, a new screen will pop up.
Access Setup
Use It:
The user can choose which values will be saved in the Access Table by the SSE OPC
Field Name:
The user can setup custom field names that the SSE OPC will create in the MS Access
Table
Access Setup
Tag Name Format:
If the Channel, Device and TagName ticks are enabled the SSE OPC will take the Channel Name
add a ‘_’, followed by the Device Name and finally adding the Tag Name
Example above:
Channel was not enabled
Device was enabled – ‘BULSK’
Tag Name was enabled – ‘LOAD_VOLT’
thus – BULSK_LOAD_VOLT
Data Points to be Saved
to a Database File
AINs, DINs, CINs and FINs are data points that supports database logging (saving)l
DB Table Name:
The user choose a name for the MS Access Table that will be created by the SSE OPC
DB Log Dead-Band:
Specifies the value that the EU Value should change before it will be logged into the Database
DB Log if < 0:
When data is received by the SSE OPC from a RTU, it will check the value of each entry. If the
"DB Log if < 0" is selected the SSE OPC will log all ranges of the incoming value to the DB.
Data Points to be
Saved to a Database
File
DB Log Events:
When the SSE OPC receives an event from an RTU, it checks whether the "DB Log Events" is
checked. If so, the SSE OPC will handle the Event and write it to the database.
DB Log Poll:
When the SSE OPC polls the registers of a RTU, the SSE OPC will only write data to the
database when this option is checked.
DB Log Logger:
If selected, the SSE OPC will save the RTU Logger data to the database.
(Works together with Log Delay Interval Channel, Address & Port Settings, Log Delay Interval)
Log Data to OPC:
Every time the SSE OPC receives Logger data from a RTU, the SSE OPC checks whether
this option is selected. If selected, the Log entry will be written to the OPC Foundation Level
along with the Logger Timestamp.
Log Data to EU Val:
Every time the SSE OPC receives Logger data from a RTU, the SSE OPC checks whether
this option is selected. If selected, the EU Val will be updated with Logger data.
Data Points to be
Saved to a Database
File
Log Alarm Zones to DB:
An Alarm Zone can have a value of 0 to 4. they represent in sequence "LoLo", "Lo", "Normal",
"Hi", and "HiHi" Alarm States. When an Alarm occurs the RTU will send the Alarm Zone to the
SSE OPC. If enabled, SSE OPC write the Alarm zone State's value to the database.
Log Events Counters to DB:
When enabled, the SSE OPC will save that specified Data point’s ‘Event Counter’ to the
database before the SSE OPC reset the event counter.
MS SQL Setup
Database File Name:
The name of your MS SQL Database
Database Server Name
The name of your SQL Server name (Usually your PC name)
Database Type:
Set this field to ‘MS SQL Server Direct’ – this informs the SSE OPC that it must try and connect
to a MS SQL database file
MS SQL Setup
DB User Name:
Enter the User Name here and the SSE OPC will connect to the SQL database file with the
correct User Name
DB User PW:
Enter the Password here and the SSE OPC will connect to the SQL database file with the
correct Password
Use Oracle Standards:
To ensure that the SSE OPC does not use reserved words as field names in the Database.
If you are unsure of this setting, enabled it.
Difference between
Access and SQL
THE MAIN DIFFERENCE BETWEEN ACCESS AND SQL IS YOUR DATABASE SETUP.
TO SAVE THE ACTUAL DATA POINT TO THE DATABASE, IS EXACTLY THE SAME FOR ACCESS AND SQL.