indusoft database redundancy webinar
DESCRIPTION
PowerPoint Presentation from Database Redundancy Webinar 11/30/11TRANSCRIPT
InduSoft Web Studio v7.0
Database Connectivity and Redundancy
Layer of abstraction
for Communicat
ion
Layer of abstractionfor Databases/ERP
Layer of abstractionfor Hardware/OS
Platforms Layer of abstraction
for proprietary
systemsInduSoft Web Studio
Open Architecture and Published APIs
Database interface (patented)
Easy-to-configure interface to any SQL Relational Database: SQL Server, Oracle, MySQL, Sybase, OSI PI, MS Access,
Excel, and others…
Interface via standard technologies: ADO.NET, ADO,
OLE-DB, and ODBC
Redundancy and Store-and-forward built-in
features
Alarm history, Event history, Trend history, Process data,OEE dashboards, and more.
“HMI software is being increasingly used as a digital dashboard to show key performance indicators (KPIs) such as overall equipment effectiveness (OEE) for the entire enterprise, and to generate reports of actual performance versus targets.”
ARC Advisory Group
Integration to ERP
How it works
Database Provider(ODBC Driver, OLE-DB Provider, ADO Provider, ADO.Net Provider)
Studio Database Gateway(StADOSvr.exe, StADOSvr.ini)
InduSoft Web Studio / EmbeddedView / CEView
TCP/IP Server
Local Viewer (Viewer.exe) and Thin Client Stations(Web Thin Client, Secure Viewer Thin Client)
TCP/IP (TCP Port 3997, by default)
Must be on the same
computer
TCP/IP (TCP Port 1234, by default)
Typical architectures
InduSoft Web Studio / EmbeddedView / CEView+
Studio Database Gateway+
Database Provider+
SQL Relational Database
Thin Client Stations
TCP/IP
Typical architectures
InduSoft Web Studio / EmbeddedView / CEView+
Studio Database Gateway+
Database Provider
TCP/IP
Thin Client Stations
SQL Relational Database
Typical architectures
InduSoft Web Studio / EmbeddedView / CEView
TCP/IP
Thin Client Stations
Studio Database Gateway+
Database Provider+
SQL Relational Database
Database Connection(Project > Options > Default DB)
Built-in redundancy
Alarm Task
Alarm Control
Event Task
Event Control
Trend Task
Trend Control
Grid Control
Database Redundancy Modes
InduSoft Web StudioEmbeddedView
CEView
Primary Database
SecondaryDatabase
Redundant: In this mode, IWS saves data in both Primary and Secondary Databases. If one of these databases is unavailable, IWS keeps saving data only in the database that is available. When the database that was unavailable becomes available again, IWS synchronizes both databases automatically.
Store and Forward: In this mode, IWS saves data in the Primary Database only. If the Primary Database becomes unavailable, IWS saves the data in the Secondary Database. When the Primary Database becomes available again, IWS moves the data from the Secondary Database into the Primary Database.
How to Contact InduSoft
Email(US) [email protected](Brazil) [email protected](Germany) [email protected]
Support [email protected] site
(English) www.indusoft.com(Portuguese) www.indusoft.com.br(German) www.indusoft-germany.de
Phone (512) 349-0334 (US) +55-11-3293-9139 (Brazil) +49 (0) 6227-732510 (Germany)
Toll-Free 877-INDUSOFT (877-463-8763) Fax (512) 349-0375
Contact InduSoft Today
Germany
USA
Brazil