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: