User's manual OPC/ADO-Bridge
Contents
1. opc avo Bridge Ioj x File Edit View Extras BO A 8 F 000 e XT Welcome to the ixTS OPC ADO Bridge Transfering OPC data fo every ADO database First steps Configuration of the bridge The OPC 4D0 Bridge needs an OPC Source Server to read OPC data and a destination database which is accessible using the ADO interface Click on Setup bridge in the Edit menu to make these settings now You may also find a step by step introduction for the initial setup in the online help under the topic First steps Event log System To start working with the bridge an OPC Source Server and an ADO des tination database need to be defined and the OPC elements which should be stored in the database must be selected To select the OPC server as well as the ADO database and make all necessary setting select Setup bridge from the Edit menu or click to the corresponding link in the Welcome panel or on the E icon in the toolbar The following dialog will appear Getting started e 4 X User s manual OPC ADO Bridge opc ado0 Bridge setup Source server namespace Destination database None z None v QNo OPC source server selected Qno destination data base selected Please note that right now no OPC Source Server is Please note that at this time no destination database is selected selected Click on Setup database to select a destination database Please select a source server using the drop down box above2. excellent software by Ud OPC ADO Bridge User s manual OPC ADO Bridge User s manual This manual is a product of iXTS Software GmbH Germany IXTS Software GmbH Hohenadlstrasse 4 85737 Ismaning Germany Phone 49 89 95 84 08 0 Fax 49 89 95 84 08 19 http www iXTS de IXTS Software GmbH does not assume any liability either implicit or explicit for this publication This lim ited liability also includes though not exclusively the economic use of this product and its suitability for certain purposes The user bears all risks which arise from the use of this information In no event will iIXTS Software GmbH be liable for direct or indirect incidental consequential or special damages arising from any defect in this documentation even if iXTS Software GmbH has been notified of the possibility of such damages Furthermore iXTS Software GmbH reserves the right to occasionally revise and modify this publication without being obliged to notify any person or organization that such a revision or modification has taken place Trademarks All trademarks and product names mentioned in this manual but not listed here are trademarks or regis tered trademarks of their respective owners Technical Support Should you have any questions about the use of this product please contact us by e mail support iXTS de Confidentiality The information contained herein is confidential and proprietary to iXTS Software GmbH Germany
3. gt Rea Reals HCCOo1ST State table Signal status translatior Unti G TriggerTime Timestamp of dat MM DD hh mm ss UInt2 in 1001 OPC quality Saw toothed Waves In UInk4 red 1002 OPC quality Saw toothed Waves In j 9 Square Waves 4 Il gt Edit settings A The table field is linked to the OPC OPC element name Inti element Int1 Unlink Link ID Saw toothed Waves Inti Table field name 1001 Action when writing orc value Default value if OPC quality is BAD Alternative value OK Cancel Accept ZZ The setup dialog is split up into three regions In the upper left area the OPC source server and its namespace is shown To the right the struc ture of the selected database is shown More information for the currently selected items are shown at the bottom of the dialog OPC source server namespace The OPC source server can be selected using the drop down list in the upper left area After selecting a source server the OPC ADO Bridge will try to start the source server and fetch its namespace to display it in the tree view below the list box When the namespace is available any OPC item can be linked to a table column in the database either by using drag n drop or the link button between the two tree views Already linked items are marked with the icon the link can be re moved by using the unlink button ADO database structure The ADO database which should store
4. It may not be disclosed or transferred directly or indirectly to any third party without the explicit written permis sion of iXTS Software GmbH All rights reserved No part of this document may be reproduced stored in a retrieval system translated or transmitted in any form or by any means electronic mechanical photocopying recording or other wise without prior written permission by iXTS Software GmbH Copyright 2005 iXTS Software GmbH Germany All rights reserved V1 1 10 2005 Contents Introduction 1 Whatis the OPC ADO Bridge P siccccsscninnnceesaeencude adhd wniniccnadendondadumineeiddeacedantinieninietens 1 VIVO SAOUIG use this AMUN acces cctenctedencrccesontucendsahenetedeesndeenoheevenndaesecaceuexeteieeexcrtens 1 Overview Of the manual ccccccccsecceceeececee cess ceeeecesaecesseeeesseeceseeeeseeeeseeeeesees 2 COP GC OMI ANS asses dasecrcts dd roc ct scien tines cctdoeeree aia aa EE a a aa EE ye doe voces semen aA 2 BSN Sesser cnet corse eres ce nesting eset deere Toa A A EAS E O E EE 2 Getting started 3 System requirements sssini ii a Ei Aa EAREN 3 Software requirements ccccccseececessceceseeeceeeeeceeeeceecesseeeessaeeesegeeesegeeees 3 Hardware requirements cccccccceccceeeeceececeeeeceeeeseeeseeeseeeseeesseeeseeesaees 3 IE Ee a PAE E ee EA ANEAN ene E 4 EEE 0 A I E E A E E E A N E ee eee ee 4 Selecting the OPC source server ccccccsesececeeseceeceseeeceaeeecsaus
5. Maximum directory size MB Log events from the following sources OK Cancel Help The event log is used to log all relevant information including errors and warnings which occur during the applications lifetime Depending on the situation a more or less communicative system may be desirable This can be controlled by setting the logging level Six different levels are available Nothing Very little Little Normal Extended and All The de fault value is normal which means that all important information is logged without flooding the log with irrelevant details This setting should nor mally not be changed except for diagnostic purposes See section Logging to learn more about this The Limit event rate checkbox is by default checked which means that in case that an excessive amount of events is created by the system e g due to a malfunction or due to a high OPC load in conjunction with the logging level set to Al the rate is limited by dropping events This option is included to prevent the system from hanging due to a overload caused by consecutive repaint operations This option should only be un checked if under certain circumstances the dropping of events is not de sired This may lead to the described consequences Y User s manual OPC ADO Bridge UserInterface 21 X User s manual OPC ADO Bridge The meaning of Propagate errors and warnings to windows event log is quite self explaining
6. will be retrieved from another ADO database or from different tables within the same database To make use of this option the command Use a configuration database in the File menu must be selected which will open the following dialog ELES a configuration database x The configuration of the OPC ADO Bridge can be loaded from a database Please select now this so called configuration database Connection parameters Connection string Ef JF Data Source INTS_ Access ihe User name ee Password et ___ Connection options IF the bridge configuration should be stored at a later time or the connection parameters for the configuration database or the retrieved information From the configuration database may be stored How to you want to proceed f Link to configuration database IF a link to the configuration database is created later changes in the database will have effect on the OPC 400 Bridge Import data from the configuration database IF the data is imported From the configuration database all later changes in the database will not hawe any effect to the OPC 400 Bridge configuration cres eo The database containing the configuration information must be accessi ble using ADO and the connection string must be entered in the first line of the dialog Alternatively the connection string can be assembled using the Microsoft Windows connection string wizard by clicking on the button right bes
7. can be extremely valuable for troubleshooting By default the automatic saving to hard disk is dis abled and must be enabled when necessary Also by default the applica tion logs not very much information i e that the logging level is set to normal Both settings can be changed in the Event log tab of the Envi ronment options dialog The higher the log level the more information is recorded However the performance of the OPC ADO Bridge may decrease at higher log levels The recommended logging level is Normal In most cases the Extended logging level should be sufficient to troubleshoot the problem If not the All logging level will record all information available within the application In general all errors and other information of immediate importance to the user are logged when the Little or Very little logging level is selected all warnings and other information of not immediate but still significant importance to the user when the Normal logging level is selected Infor mation of moderate importance to the user will be logged using the Ex tended logging level and further information especially for the support personnel will be recorded if the logging level is set to All Especially in higher logging levels a lot of events may be produced so the application load may increase significantly To avoid this effect the OPC ADO Bridge allows to restrict which software classes are allowed to send events to the event log To configure
8. now ready to be used Getting started e 10 User Interface The main window The main window of the OPC ADO Bridge is divided in four sections e OPC source server and session information e ADO destination database and session information e Last values retrieved from the OPC server e Event log where all error warning or other information is logged The amount of information shown here depends on the respective settings in the environment options Please re fer to the section Setting the environment options to learn more about this All sections except the current values section can be collapsed using the commands in the View menu or by clicking on the E Sign in the upper left corner of the respective section OPC ADO Bridge 2 5 x File Edit View Extras DGAlW E O O e IXTS OPC source server Current session Properties of the OPC Source Server State OK Computer WARMIN Active since 2005 09 29 13 24 37 Name Matrikon OPC Server for Simulation an Current server time 2005 09 29 14 32 35 ID Matrikon OPC Simulation 1 Last update 2005 09 29 14 32 35 Yersion 1 1 30 Update interval 1 00 seconds Change endor information Matrikon Consulting Inc 780 448 1010 Last execution time 5 249 ms http www matrikon com ADO destination database State OK Connection Provider MSDASQL 1 Persist Security Info True Data Source OPCDB Connected since 2005 09 29 13 25 41 Last database write 2005 09
9. to show its namespace Edit settings Please select an item from the source server namespace of a table or table colum of the destination database fo inspect or change jt properties OK Cancel Accept A Selecting the OPC source server Now first an OPC source server must be selected using the dropdown list in the upper left side of the dialog Hii Destination database Source server namespace Matrikon OPC Server for Simulation and Testir 3 None Qno destination data base selected a g Localhost Please note that at this time no destination database is selected ga IXTS Benchmark Server Click on Setup database to select a destination database 8 iXTS OPC Gateway Server AS prOpckit Hierarchical Browsing Demo Matrikon OPC Server For Simulation ang E E Microsoft Windows Netzwerk JD Please select an item from the source server namespace of a fable or fable column of the destination database to ingpect or change i properties OK Cancel Accept Establishing connection to OPC source server Matrikon OPC Server For Simulation and Testing h When a source server has been selected its namespace will be retrieved and filled into the tree view on the left side of the dialog Getting started e 5 X User s manual OPC ADO Bridge FJ OPC ADO Bridge setup Source server namespace Matrikon OPC Server for Simulation and Testir g Matrikon OPC Server For Simulat
10. 29 14 32 35 Forced data write in 60 seconds Change Last execution time 21 035 ms Current values Description Time stamp Vale Unit State Table field Value table State table Saw toothed Waves Intl Saw toothed wave 14 32 35 455 81 Not provided Good 1001 Hccool HCCOO1ST Saw toothed Waves Int2 Saw toothed wave 14 32 35 455 0 Not provided Good 1002 Hccoo1 HCCoo1ST Saw toothed Waves Int Saw toothed wave 14 32 35 455 37035 Not provided Good 1003 Hccoo1 HCcoo1sT Adjust columns O Event log ime Message Cid Created from 2005 09 29 13 24 27 955 OPC ADO Bridge started X User s manual OPC ADO Bridge User Interface e 11 The File Menu FH OPC ADO Bridge File Edit View Extras New Ctrl M y Open Ctrl C JE Use a configuration database Close Ld gave Ctrl 5 Save as Quit Last execution time The following commands are available in the File menu tion database to a configuration in a database Ll Save Save as Save the current configuration to a file Shut down the bridge and quit the application The Edit Menu FHoOPC ADO Bridge File Edit View Extras 7 E E Copy Chrl C l ET Export event log R Pause ewent log 5 a Setup bridge F3 A C Oo Restart date collection L i Pause collection of data U Oo Stop collection of data L z Y User s manual OPC ADO Briage gt o Userintemae 12 The following commands are ava
11. 35 ID Matrikon OPC Simulation 1 Last update 2005 09 29 14 32 35 ersion 1 1 307 Update interval 1 00 seconds Change endor information Matrikon Consulting Inc 780 448 1010 Last execution time 5 249 ms http www matrikon com ADO destination database State OK Connection Provider MSDASOQL 1 Persist Security Info True Data Source OPCDB Connected since 2005 09 29 13 25 41 Last database write 2005 09 29 14 32 35 Forced data write in 60 seconds Change Last execution time 21 035 ms Current values Signal Description Time stamp Vale Unit State Tablefield Value table State table Saw toothed Waves Intl Saw toothed wave 14 32 35 455 81 Not provided Good 1001 Hccoo1 HCCOO1ST Saw toothed Waves Int2 Saw toothed wave 14 32 35 455 0 Not provided Good 1002 Hccoo1 HCCOO1ST Saw toothed Waves Int Saw toothed wave 14 32 35 455 37035 Not provided Good 1003 Hccoo1 HCcoo1st Adjust columns Time Message Created from cid 2005 09 29 13 24 27 955 OPC ADO Bridge started Getting started e 9 X User s manual OPC ADO Bridge Saving the configuration To store the configuration for the next time the OPC ADO Bridge will be started select Save from the File menu The configuration will be loaded automatically the next time when the OPC ADO Bridge is started To change this behavior please refer to the chapter General options Congratulation The configuration is completed and the bridge is
12. This option is checked by default If desired the logged events can also be stored on hard disk by checking the Save event log checkbox In this case a directory for the log files must be selected and a maximum file and directory size must be given When the maximum file size is reached the current file is closed and a new file is created When the maximum directory size is reached the old est log file will be deleted automatically Another possibility to limit the number of logged events especially when the logging level is set to All is given by the option Log events from the following sources By un checking some of the listed event sources all events from these sources will be dropped The list is dynamically cre ated so at the first start up the list will be empty When the first message from a new source is received this sender will be added to the list By de fault all senders are enabled and changing this setting should only be necessary for diagnostic purposes See section Logging to learn more about how to use this feature User Interface e 22 Diagnostics Logging X User s manual OPC ADO Bridge The OPC ADO Bridge generates a variety of so called events which con tain information about the current program state occurred error or other details These events are always logged within the application in the event log and may also be written automatically to the hard disk In case of a problem with the application the log files
13. a2VM600 table into an alphanumeric ID string which is then used as the OPC ID at the OPC server User Interface e 16 Example The following tables form an exemplary configuration database and may help to understand how to use the configuration database Tab Viper Parameter Id Value 1 1 4 VIPERAutoDSN 10 DBA_MCURR 11 DBA_MCURRSTAT 12 V 13 TriggerTime 14 YYYY MM DD hh mm ss 15 True 16 60 17 True 18 10000 20 localhost 21 OPCServer WinCC 22 GOOD 23 UNCERTAIN 24 BAD Comment OPC Update interval s DSN for ODBC destination database Prefix used together with the MachinelD to determine the value table name in the des tination database Prefix used together with the MachinelD to determine the status table name in the des tination database Prefix used together with the PointID to de termine the fieldname in the value and status table where the OPC values should be stored Suffix PointID Field name for the transmission time stamp Formatstring for the transmission time stamp Overwrite mode enabled new data will overwrite old data instead of appending new data Forced Data Write time The current data will be stored at least every 60 Seconds even if they haven t changed Replace bad OPC values OPC values will be replaced if quality is BAD Substitute value for OPC values with quality BAD Name or IP of the compute containing the OPC source server ID of the OPC source s
14. amp Matrikon OPC Server For Simulation and Testing a Table Column Action Type Properties E O Simulation Items OPCDB gt Bucket Brigade S J HCCo01 Overwrite State table HCC0015T O Random O TriggerTime Timestamp YYYY MM DD hh mm ss Read Error S 1001 OPC value Saw toothed Waves Int1 E Saw toothed Waves S y1002 OPC value Saw toothed Waves Int2 Intl S 41003 OPC value Saw toothed Waves Int4 Inte 1004 aa 1005 a asdsdf Reals 4 HCCOO1ST State table Signal status translation eee C Hccooz Unt Fal HCCOO2ST Ulnt4 E Square Waves 4 Il gt Edit settings JDExisting data will be overwritten with Table name dinvoesie new data Add new data instead Action on arrival of new As replace data gt State table OK Cancel Accept Establishing connection to OPC source server Matrikon OPC Server For Simulation and Testing A After confirming all changes and closing the dialog the bridge is setup completely and the data transmission can start The main window should now show some information about the OPC source server the ADO des tination database and the transmitted data opc aD0 Bridge 5 x File Edit View Extras aa UG A H FIOOO e OPC source server Current session Properties of the OPC Source Server State OK Computer WARMIN Active since 2005 09 29 13 24 37 Name Matrikon OPC Server for Simulation an Current server time 2005 09 29 14 32
15. an item from the source server namespace of a fable or fable colam of the destination database fo inspect or change it properties OK Cancel Accept Establishing connection to OPC source server Matrikon OPC Server For Simulation and Testing jh This will open the standard Windows dialog for setting up the properties of an ADO data link and allows the selection of an OLE DB Provider e g for an Oracle Database a Microsoft SQL Server or an ODBC compliant database together with the respective database More information about Getting started e 6 X User s manual OPC ADO Bridge how to set up this properties can be found in the Microsoft Data Link Help which is available from within the dialog by clicking the Help button When the database is selected and the connection has been established successfully the database structure is diplayed in form of a tree on the right hand of the dialog FHOPC ADO Bridge setup 10l x Destination database Source server namespace Matrikon OPC Server For Simulation and Testir OPCDB amp Matrikon OPC Server For Simulation and Testing Properties 5 Simulation Items OPCDB gt Bucket Brigade Hccoo1 gt Random E TriggerTime HO Read Ero e a a fy v1001 E Saw toothed Waves fa v1002 z Inti 5 v1003 z intz E v1004 Int fa vi005 oes fE asdsdf Real i _ HCCOO1ST Real Uinti Hec
16. at the application will try to re load the last used configuration from the previous run Maybe it is also desirable to define a fixed configuration file which always will be opened without regarding what was opened before In this case use the option load this configuration For automation and to ease the status monitoring of the OPC ADO Bridge application it may be desired to set the Application window cap tion to an individual value and or to include the current application status in the window caption by checking the Show critical errors in main window caption checkbox By changing the language settings the language for the applications GUI can be set Available languages are German and English User Interface e 20 Default values Environment options lt lt x 1 General Timestamp format T YYYY MM DD hh mm ss Default values MM DD hh mm ss hh mm ss DD MM Y Event log hh mm ss DD MM YY l hh mm ss In the Default values tab the timestamp formats can be edited which are offered in the drop down list for the timestamp format of the database fields which should receive the time stamp of the data collection Event log x 1 General Event logging Logging level Normal z gt s A Default values M Limit event rate V Propagate errors and warnings to windows event log Storing the event log Save eventlog Destination path IR sdfsdf Maximum File size KB
17. eesssaaeees 5 Selecting the destination ADO database cccccceccccseeceseeeeeeeeeeeeeeeees 6 Configuring the data transfer cccccccccseeeeeeseeeeeeeaeeeeeeaeeeeeesaeeeeseeeeeeas T Saving the configuration naanneoanneoeaneeoenneosarneornrnrsnnrrnnrrrsnnerrnnrrrsnneer 10 User Interface 11 The man WNdOW swiss Gauss dea lctea ere btun Gone a e a E E a EEAS 11 The File Menu sicca cnc fennssiiendincdsndncunsdesnleauddewwensdevedateuddenduaudcvenuaubtendecdssosuade 12 The Edit I MN css tee ees Gas neste niaan ei See eaa aea a 12 The View Menu scare dorset oPnrrees hewn Gone datoaicus Somadendise ones Sactesenedoendeee desenuse denesece 13 The Exiras Menu cystic ot Sigerse See Cendana bo denen doce rnadaeeeeas EEE 14 Using a configuration database cccccccecccceecceeececceeceeaeeeeseeeeesseeeseneeeseeeesaaees 15 A SS ONIN A sna ste neces eect ap coche ede cat ERSE 16 Sening UP NO IS ast sesteste eaS Epi R E 18 OPC source server NAMESPACE ccccseececeseeecececeneeceeseeseuseeseneeesaaees 18 ADO database structure oie vs0c2ds ccevdesddnsmedsesbenecsednensdsreh sae ccededeedeacdesertiast sade 18 SVAN PO ONS CNN Sr arncs discrete ae vse anette r coeiezsedaece ne ESE 19 Setting the environment options cccceeceeceeeeeeeceeeeeecaeeeeeeaeeeeseeseeesaeeeesseeeees 20 General OPtiONS cccccceecccseeccceeeeeceeeeeceecesseneessaeeeseueessaeeeseneeesegeessaaees 20 Default va
18. erted to the Universal time co ordinated which ignores the geographic information and is therefore in dependent from the local time zone User Interface e 19 If the data received from an OPC source server for a linked field column amp has a bad quality it can be replaced by another value by checking the Default value if OPC quality is BAD checkbox and providing a substi tute value for this case After setting up the server configuration click on Accept to keep the dia log open or on OK to close it Setting the environment options X User s manual OPC ADO Bridge By setting the environment options the overall behavior of the OPC ADO Bridge can be adjusted to the personal needs The settings are divided into three categories General options M Start options On application startup l yA Default values pror Event log start with empty configuration load this configuration M Application window caption C Default User defined wIN_TS J Show critical errors in main window caption M Language settings Selected language English z OK Cancel The general options include the start options which control the applica tion behavior regarding the server configuration at startup Available op tions are to start with empty configuration which under normal cir cumstances doesn t make much sense The default setting is re load last configuration which means th
19. erver Quality Translation GOOD Quality Translation UNCERTAIN Quality Translation BAD Tab Viper lO_Data2VM600 Enabled TRUE FALSE TRUE Tab KKS ID 10 21 30 KKSID MachinelD PointiD 10 1000 100002 21 1000 100003 30 2000 200005 KKS xxMBY10FT010XQ01 CKA0O1EP211XT05 CKA0O1EP211XT04 Resulting OPC ADO bridge items OPC ID xxMBY10FT010XQ01 CKA01EP211XT04 X User s manual OPC ADO Bridge Destination field V100002 V200005 Destination table DBA_MCURR1000 DBA_MCURR2000 User Interface e 17 Setting up the bridge X User s manual OPC ADO Bridge The bridge configuration can be changed using the OPC ADO Bridge setup dialog which can be opened using the Setup bridge command in the Edit menu opc aD0 Bridge setup Ioj x Source server namespace Destination database Matrikon OPC Server for Simulation and Testir OPCDB v g Matrikon OPC Server For Simulation and Testing Table Column Action Type Properties Simulation Items OPCDB gt Bucket Brigade E B Hcco0i Overwrite State table HCC001S O Random O TriggerTime Timestamp of dat MM DD hh mm ss Read Error co ZZ 1001 OPC value Saw toothed Waves In CQ Saw toothed Waves S 1002 OPC value Saw toothed Waves In i S 1003 OPC value Saw toothed Waves In T ae C v1004 Constant value 210 T vi 1005 Key value 33 bag 5 Autowert
20. f OPC ADO Bridge It explains how to install and configure the software as well as how to perform common tasks Introduction e 1 Overview of the manual This manual consists of several chapters and is structured as follows Introduction This introductory chapter Getting started Setting up the OPC ADO Bridge in a couple of minutes System description A short technical description of the OPC ADO Bridge User Interface A detailed description of the user interface including all dialogs and menus Diagnostics Makes familiar with the logging features of the OPC ADO Bridge OPC Compliance References X User s manual OPC ADO Bridge The OPC ADO Bridge can interact with OPC Servers compliant to the OPC DA 2 05 Specification that support all required interfaces and addi tionally the OPCBrowserServerAddressSpace interface To learn more about OPC visit the website of the OPC Foundation at http Awww opcfoundation org The OPC Data Access Custom Interface Specification Version 2 05 is also available from the OPC foundation To learn more about ADO and its possibilities pleas visit the Microsoft website at http www microsoft com or the Microsoft Developer Network at http msdn microsoft com Introduction e 2 Getting started System requirements The OPC ADO Bridge hat both Software and Hardware minimum system requirements These requirements must be met in order for the server to work properly Software requirement
21. f a linked status table see above and its properties can therefore no be changed it is locked Item properties When an item is selected in the OPC Source Server namespace or in the ADO Database structure or both if two items are linked the item proper ties and settings are displayed in the bottom area of the dialog Most of the properties are self explaining so only a few a little bit more sophisti cated properties should be mentioned here When the OPC Source Server 4 is selected the Update interval can be changed This interval will be used to set the Update Rate in the cor responding OPC Group on the OPC Server When the ADO Database is selected the Maximum write interval can be changed After this interval a forced write to the database will be executed even if the source data has not been changed This may be used like a keep alive signal When a state table 54 is selected the Translation table for the signal quality can be edited The translation table allows to replace the numeric OPC values for the signal qualities Good Uncertain Bad with user defined strings or numbers If no translation table is provided the nu meric value will be written instead When a time stamp field is selected the format string for the time might be changed This can be necessary because different databases are expecting time data with different formats When the Save as UTC checkbox is checked the time will be conv
22. g E OPC s Curren S State Refresh F5 f F ebin m The following commands are available in the View menu OPC source Collapse or expand the OPC source server panel server Destination data Collapse or expand the Destination database panel base Event log Collapse or expand the Event log panel Refresh Gather the current values from the OPC source server and refresh the shown information User smanualOPC ADO Bridge gt Userinterface 13 The Extras menu FHOPC ADO Bridge Fie Edit view Extras a GF g b4 E7 Environment options F12 EPE ource Close current event log file The following commands are available in the Extras menu Open the environment option dialog to set startup options event logging and default values Please refer to section Setting the environment options for detailed information Environment options Close current event log Close the current event log file This option is only file useful in conjunction with the automatic event log saving to hard disk to finalize the currently opened file and start a new one Y User s manual OPC ADO Briage gt Userintermace 14 Using a configuration database X User s manual OPC ADO Bridge As a special option the OPC ADO Bridge can also be configured by using a configuration database In this case all information necessary to setup the bridging functionality between an OPC Server and an ADO database
23. ide the input box The database can be used in two different ways 1 Linked This means that the connection information for the database is stored in the local configuration When the con figuration is saved to a file in fact only the link information is saved and when the file will be opened again the link infor mation is retrieved and the actual OPC ADO Bridge configu ration is again retrieved from the database User Interface e 15 X User s manual OPC ADO Bridge Using this option allows the dynamic configuration of the OPC ADO Bridge by changing the database entries Cau tion Changes in the database will have no effect until the respective file containing the database link information is re loaded into the OPC ADO Bridge Import Another possibility is to import the information from the configuration database Doing this means that once the configuration information is read from the database the con nection information for the database is discarded When the configuration is saved to a file the actual configuration will be saved and reloading the file will result in exactly this configu ration whether the database have been changed in the meantime or not This option is useful when the database is only available for a short time or when changes in the data base should not automatically affect the OPC ADO Bridge configuration After selecting one of these two options the dialog can be closed using the Link Import button a
24. ilable in the Edit menu Copy the selected entries of the event log to the clip board Only available when the event log is displayed and not empty Exports the currently displayed event log to a file Note This command is intended to be used to save only the currently displayed events to a file To save events automatically the auto store function should be used Please refer to the section Setting the environment op tions ER Export event log Pause event log Pause the event log to prevent updates while navigating in the event log Caution Pausing the event log may result in losing events as they are not gathered from the application while the event log is paused Opens the setup bridge dialog Please refer to section E Setup bridge Setting up the bridge for detailed information oO Restart data Restarts the data collection after it was paused or collection stopped see below ii Pause data col Pauses the data collection from the OPC server Paus ing means that the OPC group is deactivated so the OPC server will no longer raise callbacks The connec tion to the server remains established lection oO Stop data col Stops the data collection from the OPC server The bridge will release all opened groups on the server and lection l disconnect completely from the server The View Menu FH oOPC ADO Bridge File Edit view Extras 7 F JE e OPC source server K Destination database w Event lo
25. ion and Testing E O Simulation Items O Bucket Brigade O Random O Read Error EO Saw toothed Waves Sj nti Int2 Int4 Money Real4 Real UInt1 UInt2 ulnt4 gt Square Waves ul Edit settings lolx Destination database Qno destination data base selected Please note that at this time no destination database is selected Click on Setup database to select a destination database J Please select an item from the source server namespace of a fable or fable colum of the destination database fo inspect or change it properties OK Cancel Accept Establishing connection to OPC source server Matrikon OPC Server For Simulation and Testing f Selecting the destination ADO database Now the ADO database which should store the data of the OPC server must be defined This can be done by selecting the New item in the drop down list on the upper right side FJ OPC ADO Bridge setup Source server namespace Matrikon OPC Server for Simulation and Testir g Matrikon OPC Server For Simulation and Testing E O Simulation Items gt Bucket Brigade Random O Read Error 5 Saw toothed Waves Inti z Intz Int4 Money Real Real UInt1 UInt2 uInt4 gt Square Waves i We 11 EN ENT ET Destination database A A Rs selected Click on Setup database to select a destination database iai ots Edit settings J Please select
26. lues 00 0 ecccccecccsecccceseeeseeeeceeeeeseeeeeseaseseucesseeeessaeeesseeeeseneessaas 21 BS NO oe ss vane ree a AE AS aaa AEE 21 Diagnostics 23 LOGOD ha ee cst nee tein nh E E w pasresan cyseaseh bpenene tees yalee eeneadee sia 23 X User s manual OPC ADO Bridge Contents e iii Introduction What is the OPC ADO Bridge A broad variety of industrial systems and devices in especially Supervi sory Control and Data Acquisition systems SCADA Data Collection Systems DCS and Programmable Logic Controllers PLCs support the standardized OPC interface to share their data among each other On the other hand companies often store their data in enterprise data bases which usually can be accessed using the ADO technology as e g an Oracle database a Microsoft SQL Server or any ODBC compliant da tabase The OPC ADO Bridge allows the connection of these two different enter prise sub systems Data can be retrieved automatically from OPC servers and stored in an ADO database There are two main uses for the OPC ADO Bridge e Archive process values from an OPC server to an ADO da tabase to create a process historian The data can then be analyzed using any tool which can operate on ADO data bases e Exchange data with other systems which do not support the OPC interface but can access the database using ADO or any other way Who should use this manual X User s manual OPC ADO Bridge This manual is intended for all users o
27. nd the configuration will be load from the data base Database Format For a successful configuration import from the database the database must meet the following requirements 1 The database must contain at least 3 tables named Tab Vi per Parameter Tab Viper lO Data2VM600 and Tab KKS The table Tab Viper Parameter contains the global con figuration parameters and and must have at least the col umns KanallD Longint ID Longint and Value Text While for all records concerning the OPC ADO Bridge con figuration the field KanallD must have the value 0 the val ues for ID can vary between 1 and 24 whereby the respec tive Value field contains the actual configuration information The table Tab Viper IO_Data2VM600 contains the main in formation regarding the question which OPC items should be retrieved from the OPC Server and in which field they should be stored It must have at least the columns Enabled Boo lean KKSID Longint MachinelD Longint and PointID Longint Each record with the Enabled field set to TRUE indicates an active bridge item with its OPC source item de termined by the KKSID the destination table name deter mined by the MachinelD and the destination table field de termined by the PointID The table Tab KKS is used to translate the numerical KKSID from the Tab Viper lO_Dat
28. o2 uint2 _ Hccoo2sT ulnt4 E Square Waves gt 4 Ill gt Edit settings Dou can link Inti with V1001 For OPC element name Inti writing the OPC value in the database OPC element ID Saw toothed Waves Inti Or you can write a constant value a key value or the timestamp of the Table field name 1001 data collection Action when writing None bd OK Cancel Accept Establishing connection to OPC source server Matrikon OPC Server For Simulation and Testing h This procedure needs to be repeated for each OPC item that should be stored in the database Apart of the OPC data also the timestamp of the transmission can be stored by selecting the respective column in the da tabase and changing the Action when writing to Timestamp of data collection To store also the quality information of the received OPC data a state table must be assigned to the table that contains the OPC values value table This can be done by first selecting the table itself and the chang ing its state table property to the desired state table The state table must contain at least for all used columns in the value table a corresponding column with the same name in the state table otherwise the assignment as a state table will fail Getting started e 8 X User s manual OPC ADO Bridge opc AD0 Bridge setup Source server namespace Destination database Matrikon OPC Server for Simulation and Testir OPCDB Y
29. ooz UInt2 F W HCCO02ST UlInt4 gt Square Waves 4 Il Edit settings i Please select an item from the source server namespace of a fable or fable colum of the destination database to ingpect or change jt properties OK Cancel Accept Establishing connection to OPC source server Matrikon OPC Server For Simulation and Testing Z Configuring the data transfer The main purpose of the OPC ADO Bridge is transferring data from an OPC server to an ADO destination database so the first step in configur ing the data transfer should be the setup of links between OPC items and database columns or fields respectively Establishing a link is a very easy task as only the source item in the OPC tree and the corresponding table column in the database must be selected and button with the link symbol must be pressed The linked table column will then store all data received from the OPC server item Getting started e 7 X User s manual OPC ADO Bridge FG orc ADO Bridge setup E Ioj x Source server namespace Destination database Matrikon OPC Server for Simulation and Testir v OPCDB v amp Matrikon OPC Server For Simulation and Testing Properties E Simulation Items S OPCDB O Bucket Brigade amp _ Hcco01 O Random EE TriggerTime O Read Error cJN v1001 EO Saw toothed Waves F5 v1002 5 1003 z Inte E v1004 z Int4 5 1005 Money 5 asdsdf Real4 Reals _ HCcoo1ST Ulni C Hcco
30. s The OPC ADO Bridge requires at a minimum the following software Micosoft Windows 2000 XP or 2003 Internet Explorer 4 01 Service Pack 1 or better OPC DA 2 0x server applications Microsoft ActiveX Data Objects 2 5 Library ADO and Micro soft ADO Extension for DDL and Security 2 5 Library ADOX Both components are normally pre installed on all systems running Windows 2000 or higher but are also in cluded in the Microsoft Data Access Components package 2 5 MDAC which can be obtained from http msdn microsoft com data mdac downloads Hardware requirements The OPC ADO Bridge requires at a minimum the following hardware X User s manual OPC ADO Bridge Intel Pentium I 500 MHz 128 MB RAM 20 MB fee hard disk space Getting started e 3 Installation First steps X User s manual OPC ADO Bridge Once you are certain that your system meets the system requirements you are ready to install the OPC ADO Bridge To install the OPC ADO Bridge double click setup exe on your OPC ADO Bridge media and follow the instructions on the screen The setup includes the OPC Core components from the OPC Founda tion which are necessary for any OPC application to work properly If these components are not installed on your system the OPC ADO Bridge will not work correctly neither any other standard OPC applica tion After installing and starting the OPC ADO Bridge for the first time you will see the following screen
31. the data received from the OPC server can be selected using the drop down list in the upper right area After selecting the ADO database the OPC ADO Bridge will try to open the database and retrieve its internal structure including table names and columns The structure is then displayed in a tree view below the list box User Interface e 18 X User s manual OPC ADO Bridge Each table is displayed with one of the following icon _ The table is not used and will not be altered by the OPC ADO Bridge La The table contains at least one column field that will be altered by the OPC ADO Bridge New data will replace existing data SQL command Update Ly The table contains at least one column field that will be altered by the OPC ADO Bridge New data will be added to the table SQL command Nsert 1 The table is a status table which is linked to another table in the database The columns fields within a table also have different icons depending on what kind of data will be stored in it H The column field is not used and will not be altered by the OPC ADO Bridge gt The column field is linked with an OPC item and will store the data received for this item The column field will store the timestamp of the last data trans mission The column field is used as a key field to select a specific record within a table that contains more than one record The column field will store a constant value The column field is part o
32. this feature a deeper under standing of the software architecture is necessary so under normal cir cumstances all classes should remain enabled as event sources Diagnostics e 23
Download Pdf Manuals
Related Search