WinCC的实时数据通过OPC DA记录到MS Access、MS SQL Server和Oracle数据库中的方法指南(中文)
- 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。
Ѣ ԩՓ⫼WinCC Industrial Data Bridge WinCCⱘ 䗮䖛OPC DA䆄 MS AccessǃMS SQL Server
Oracle Ё
How to transfer process data of WinCC to MS Access,MS SQL Server and Oracle via
WinCC Industrial Data Bridge and OPC DA
㽕 Getting-Startedҟ㒡њWinCC Ϯ ḹⱘ ⧚ ⫼⡍⚍ˈ ⫼ҹOracle 9iЎ՟䆺㒚䇈 њ㒘 ℹ偸DŽ
䬂䆡 Ϯ ḹˈOPC DAˈ WinCCˈ MS Accessˈ MS SQL Serverˈ Oracle
Key Words Industrial Data Bridge, OPC DA, WinCC, MS Access, MS SQL Server, Oracle A&D Service & Support Page 2-15
Ⳃ
Ѣ ԩՓ⫼:LQ&& ,QGXVWULDO 'DWD %ULGJH :LQ&&ⱘ 䗮䖛23& '$䆄 06
$FFHVVǃ06 64/ 6HUYHU 2UDFOH Ё
:LQ&& ,QGXVWULDO 'DWD %ULGJHㅔҟ
㛑
Ӭ⚍
Փ⫼:LQ&& ,QGXVWULDO 'DWD %ULGJH :LQ&&ⱘ 䗮䖛23& '$䆄 2UDFOH Ё 䰘 ˉ 㤤㔥
A&D Service & Support Page 3-15
Ѣ ԩՓ⫼WinCC Industrial Data Bridge WinCCⱘ 䗮䖛OPC DA䆄 MS AccessǃMS SQL Server Oracle Ё
:LQ&& ,QGXVWULDO 'DWD %ULGJHㅔҟ
㛑
WinCC/IndustrialDataBridge( Ϯ ḹ) ⫼ 㞾 ( )䖲 ITϪ⬠ˈ 䆕њ ⱘ ⌕DŽ䖭ѯ㉏ ⱘ՟ 㞾 乚 䞠ⱘOPC ITϪ⬠ ⱘSQL DŽԴ ⫼ӫ ϡ ⱘ ( Ё OPCˈSQLˈ OLE-DBˈOfficeḐ )ˈ ϡ 䗴 ⫳ѻⱘ㋏㒳䲚 ϔ䍋DŽԴ Ӌⱘ ⸔Ϟˈ ⫼ 䕃ӊ ㋏㒳㒘 (ϡ䳔㽕㓪)DŽ䗮 ˈ OPC DA ⱘ WinCC ⑤ˈ㗠ϔϾ 䚼 Ⳃⱘ DŽ
Ѣ 䞣ˈ ҹ128ǃ 512ǃ2K 10KϾ 䞣 կDŽ
ϡ ⱘ 䗴 ⫳ѻⱘ㞾 ㋏㒳П䯈ˈ䗮䖛“IndustrialDataBridge”䖯㸠 Ѹ (՟ 䗮䖛OPC)DŽ䗮䖛“ IndustrialDataBridge”䖲 OPC 㛑 ϡ 䆒 ⑤ Ⳃⱘ П䯈䗮䆃DŽ
x䗮䖛OPC ˈ ҹ䖲 ⬅ӫ ϡ 䗴 ⫳ѻⱘSCADA ⲥ㾚㋏㒳DŽ
x 䖛 Excel Accesㄝ 䕃ӊ DŽг 䲚 ˈҹ ḷ 䞣 DŽ
x SQL ⫼ 䞛䲚 ⱘ⫳ѻ Ⳃⱘ DŽ㋏㒳 џӊ偅 ⸔ϞˈՓ⫼OPC ˈҢ ⑤Ӵ䕧 ˈ 㗙 ⫼ 䗕/ Ⳉ Ң Ӵ䕧 DŽx ⫼ϔϾ Ў ⑤ˈԴ 䜡 䆒 Ⳉ Ӵ䕧 WinCC Ӵ䕧 ϔϾ DŽ 䖭ḋ ˈԴ ⫼OPC DA 䆓䯂ˈWinAC ODK 䗕/
Ў 䖒 Ⳃⱘ ⱘ DŽ
Ӭ⚍
x 㞾 䖲 IT⦃
A&D Service & Support Page 4-15
xՓ⫼ӫ ϡ ⱘ ( Ё OPCˈSQLˈOLE-DBˈOfficeḐ )䲚 ⬅ϡ 䗴 ⫳ѻⱘ㋏㒳
xՓ⫼ 䕃ӊⱘㅔ ǃӋḐ ⧚ⱘ㒘 (ϡ䳔㽕㓪)
x Ͼ㋏㒳П䯈 䖯㸠催 㛑ⱘ Ѹ
Փ⫼:LQ&& ,QGXVWULDO 'DWD %ULGJH :LQ&&ⱘ 䗮䖛23& '$䆄 2UDFOH Ё
2.1 WinCC Industrial Data Bridge Oracle 9i DŽ Oracle 9i ㅵ⧚ ⱘ㸼ぎ䯈Ё ゟⳌ ⱘ 㸼㒧 DŽ 1 ⼎DŽ
1˖ ゟOracle㸼㒧
2.2 Industrial Data Bridgeˈḍ 䖲 ˈ ⑤㉏ 䗝 ”OPC Data Access”ˈ Ⳃ ㉏ 䗝 ”Database”DŽ 2 ⼎DŽ
A&D Service & Support Page 5-15
2˖ 䖲
2.3 Ϟ ⱘ”Browse” 䪂⌣㾜 㔥㒰䅵ㅫ ⱘOPC Serverˈ䗝
”OPCServer.WinCC”DŽ 3 ⼎DŽ
A&D Service & Support Page 6-15
3˖䗝 ⑤ⱘOPC Server
A&D Service & Support Page 7-15
2.4 ϟ ⱘ”Browse” 䪂 OLE DB Providerˈ 偅 DŽ 䖲 Ё ⿄ˈⱏ ⱘ⫼ ⷕˈ㋏㒳⫳ 䖲 ヺІDŽ 4 5 ⼎DŽ
4˖䗝 偅
A&D Service & Support Page 8-15
5˖䕧 ⿄ˈⱏ ⫼ ⷕ
2.5 㒘ˈ 㒘䆒 Ё ǃ 䗕 ⱘ⅏ ҹ 䗕 ӊDŽ 6 ⼎DŽ
A&D Service & Support Page 9-15
6˖䆒 㒘
2.6 䖲 Æ㒘ⱘ 㟾 ջˈ ”add”ˈ 㒘 ⑤ⱘOPC ⳂЁ⏏ WinCC 䞣ㅵ⧚ Ёⱘ 䞣ˈ Ⳍ ⱘ ㉏ DŽ 㒘 Ⳃ 䞣Ё䗝 Ⳍ ⱘ 㸼Ḑˈҹ 䯈 DŽ 㒘 .xml ӊDŽ 7 8 ⼎DŽ
⊼ ˖
⏏ 䞣 乏▔⌏WinCC乍Ⳃˈ WinCCⱘOPC ServerDŽ
⹂䅸 ⑤ⱘ 䞣 Ⳃ ⱘ ㉏ ϔ㟈ˈ 䰙 ⫼Ёˈ ⑤ Ё ѯ ㉏ ϡ DŽ
A&D Service & Support Page 10-15
7˖䗝 ⑤ 䞣
A&D Service & Support Page 11-15