How Kepware exchange log data into SQL DBWord格式.docx
- 文档编号:15788150
- 上传时间:2022-11-16
- 格式:DOCX
- 页数:9
- 大小:506.77KB
How Kepware exchange log data into SQL DBWord格式.docx
《How Kepware exchange log data into SQL DBWord格式.docx》由会员分享,可在线阅读,更多相关《How Kepware exchange log data into SQL DBWord格式.docx(9页珍藏版)》请在冰豆网上搜索。
天津施程联智自动化设备有限公司|AlliedSolutions(Tianjin)AutomationCo.Ltd.
天津市南开区红日南路42号环兴科技园A座336室|No.42HongriSouthRoad,BlockA,#336.Nankai,Tianjin,China30011
Tel:
(+8622)87631104
/05/09|Fax:
(+8622)87631107|Website:
Preparation:
●KepwareEXV5.X
⏹Driver
◆Simulator
⏹Plug-in
◆DataLogger
●SQLServer
⏹SQLServer2008R2
Configurationprocedure
1.PrepareSQLDATABASE,inthisscenarios,weuseSQLserver2008R2
EnableSQLserversecurityandcreateauser“sa”withpassword.
2.Createadatabaseandnamedas“test1”.
3.createODBC,ifyouuse64bitsystem,pleaseopenbelowEXE
“C:
\Windows\SysWOW64\odbcad32.exe”
Thecreationprocedureasbelow
4.configureKepwareEX,weneedconfigure“Channel/device”,”DataLogger”
4.1configureChannel/device
CreateasimulatordevicetosimulatePLCsignal.
“Counter01”isatagwhichvaluewillincreasefrom0to1000.ItsdatawillbeloggedintoSQLserverby“datalogger”.
4.2ConfigureDatalogger
ConfigureODBCdatasourceingeneraltab.
Configuredatasourcein“data”tab.
Steps:
1.Click“add”toadd“OPCdataitem”
2.ClickmapfieldstobuildupmappingfromOPCFieldstoSQLtablecolumn.
3.Select“createanewtableonce…….”Andkeyinatablename
4.Saveconfigurationandinmainmenu:
runtime->
connect.Tostartupdataexchange..
Dataloggertestingresultasbelow:
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- How Kepware exchange log data into SQL DB
![提示](https://static.bdocx.com/images/bang_tan.gif)
链接地址:https://www.bdocx.com/doc/15788150.html