SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

SSE OPC and DATABASES

allie avatar
allie
12 diapositives · 266 Views · Aug 25, 2014

This guide outlines the setup procedures for using SSE OPC to save data into MS Access (MDB) and MS SQL Server databases. It covers key aspects including database setup locations, naming conventions, user credentials, and custom field names. The differences between Access and SQL databases regarding their setup and data logging features are highlighted, ensuring that users can efficiently log data points, events, and alerts. Key configuration options for both databases are explained, providing users with a clear understanding of how to effectively manage their data logging.

#sse opc and databases #sse opc and databases ppt #powerpoint #presentation
SSE OPC and DATABASES - slide 1
01 / 12SSE OPC and DATABASES
1 / 17

Télécharger la présentation

SSE OPC and DATABASES
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  1. SSE OPC and DATABASES

  2. 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.

  3. 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

  4. AccessSetup 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.

  5. AccessSetup 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

  6. 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

  7. 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.

  8. 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 IntervalChannel, 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.

  9. 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.

  10. 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

  11. 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.

  12. 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.