FactorySQL: Difference between revisions
Content deleted Content added
Merged content to Ignition SCADA#FactorySQL, redirecting; unopposed 2020 proposal (easy-merge) Tag: New redirect |
|||
| Line 1: | Line 1: | ||
#REDIRECT [[Ignition SCADA#FactorySQL]] |
|||
{{Merge to|Ignition SCADA|discuss=Talk:Ignition SCADA#Proposed merge of FactorySQL into Ignition SCADA|date=July 2020}} |
|||
{{Multiple issues| |
|||
{{primary sources|date=February 2013}} |
|||
{{Notability|Products|date=July 2020}} |
|||
{{COI|date=July 2020}} |
|||
{{Advert|date=July 2020}} |
|||
}} |
|||
[[File:FactorySQL logo.gif|thumbnail|FactorySQL box]] |
|||
'''FactorySQL''' is an [[OLE for process control|OPC]] based [[Middleware]] product by [[Inductive automation|Inductive Automation]] that bridges the gap between industrial [[Programmable logic controller|PLCs]] and [[SQL database|SQL Databases]].<ref>{{cite web |url=http://www.automationmag.com/columns/automation-software-factorypmi-a-review-of-web-based-scada/hmi.html |title=AUTOMATION SOFTWARE - FactoryPMI: A review of web-based SCADA/HMI |publisher=Manufacturing Automation |author=Jeremy Pollard |date=17 Jan 2007 |accessdate=29 Dec 2012 |url-status=dead |archiveurl=https://web.archive.org/web/20130425021621/http://www.automationmag.com/columns/automation-software-factorypmi-a-review-of-web-based-scada/hmi.html |archivedate=2013-04-25 }}</ref> FactorySQL is a drag and drop [[.NET Framework|.NET]] application that runs as a [[Windows service]]. FactorySQL version 1.0 was released in 2003 and [[deprecated]] at version 4 in 2010 with the release of [[Ignition SCADA|Ignition]]<ref>Bond, Andrew [http://www.controlglobal.com/industrynews/2010/078.html Free OPC-UA Server Unlocks Linux's Potential], 3/2010</ref> Inductive Automation offers the OPC-UA module for free.<ref>{{cite web|url=http://www.inductiveautomation.com/news/item/275|title=Free OPC-UA Server Offers More Than a Great Price|accessdate=5 Jan 2013|date=8 Mar 2011|url-status=dead|archiveurl=https://archive.is/20130216063923/http://www.inductiveautomation.com/news/item/275|archivedate=2013-02-16}}</ref> As of January 2013, FactorySQL is still being sold and supported. |
|||
{{R from merge}} |
|||
==Groups and Items== |
|||
{{R to section}} |
|||
FactorySQL configuration is done with standard ''Groups''. This unit of configuration can morph from a historical logger, real-time status and control synchronizer, downtime tracker, recipe manager, etc.<ref>{{cite web|url=http://www.inductiveautomation.com/news/item/183 |archive-url=https://archive.is/20130216064344/http://www.inductiveautomation.com/news/item/183 |url-status=dead |archive-date=16 February 2013 |title=Press Release: Inductive Automation Releases FactoryPMI 3.1 and FactorySQL 4.1 |date=11 December 2007 |accessdate=21 Jan 2013 }}</ref> The group configuration defines the database connection, table, timing options, triggering options, and "direction". Direction defines whether read or write operations come from or go to the OPC server from the SQL database. "Bidirectional" allows a change from either side to be written to the other. ''Groups'' contain ''Items''. ''Items'' are dragged from an OPC browsing tree or manually created. Each item represents a fully qualified OPC path along with a column name in the SQL database. Items also contain scaling options, OPC information, and other modes of operation. |
|||
==Features== |
|||
Features listed from vendor web site.<ref>{{cite web |url=http://www.inductiveautomation.com/products/factorysql |title=Inductive Automation FactorySQL web site |accessdate=21 Jan 2013 |url-status=dead |archiveurl=https://web.archive.org/web/20130118160813/http://www.inductiveautomation.com/products/factorysql |archivedate=2013-01-18 }}</ref> |
|||
* '''Easy Browsing''' Browse OPC servers from navigation tree. |
|||
* '''Drag & Drop Configuration''' Drag and drop tags from OPC browser to groups |
|||
* '''Bi-Directional Data Transfer''' Transfer data between PLCs and Databases, with a full range of options: timers, counters, triggers, and handshakes |
|||
* '''Built in Email Alerts''' |
|||
* '''Simple Group Visualization''' Visual indication of group status including running, stopped, or error status |
|||
* '''Stored Procedure Group''' Map [[OLE for process control|OPC]]data to and from SQL [[Stored procedures|stored procedure]] parameters. |
|||
* '''Block Data Group''' mirror large blocks of OPC data in an SQL database through the use of [[Array data structure|array]] read and writes. |
|||
* '''Remote Configuration''' Group configuration over the network via [[TCP connection#Protocol operation|TCP connection]]. |
|||
* '''Supports Most PLCs and Database Systems''' Support nearly every [[OLE for process control|OPC]] compliant PLC and [[Odbc|ODBC]] compliant SQL database. |
|||
* '''Redundancy''' Supports primary and backup failover modes.<ref>{{cite web |url=http://www.pr.com/press-release/32133|title=Press Release: Inductive Automation Announces the Release of FactorySQL 3.0 and FactoryPMI 2.0 Paving the Way for a Redundant Web Based SCADA System|date=8 March 2007 |accessdate=21 Jan 2013}}</ref> |
|||
* '''SQLTags''' Proprietary means to "turn any SQL database into a high-performance industrial tag database".<ref>{{cite web |url=http://www.inductiveautomation.com/products/factorysql |title=Inductive Automation FactorySQL web site |accessdate=21 Jan 2013 |url-status=dead |archiveurl=https://web.archive.org/web/20130118160813/http://www.inductiveautomation.com/products/factorysql |archivedate=2013-01-18 }}</ref> |
|||
==History== |
|||
FactorySQL was initially written to be a [[drag and drop]] [[OLE for process control|OPC]] to [[SQL]] [[data logger]]. Functionality was introduced to become a [[Transaction manager|Transaction Manager]] and [[Operational historian|Industrial Historian]]. |
|||
FactorySQL introduced [[SQLTags]] support with version 4.1 in December 2007.<ref>{{cite web|url=http://www.inductiveautomation.com/news/item/183 |archive-url=https://archive.is/20130216064344/http://www.inductiveautomation.com/news/item/183 |url-status=dead |archive-date=16 February 2013 |title=Press Release: Inductive Automation Releases FactoryPMI 3.1 and FactorySQL 4.1 |date=11 December 2007 |accessdate=21 Jan 2013 }}</ref> |
|||
==References== |
|||
{{reflist}} |
|||
==External links== |
|||
*[https://web.archive.org/web/20130118160813/http://www.inductiveautomation.com/products/factorysql Inductive Automation FactorySQL page] |
|||
*[http://files.inductiveautomation.com/whitepapers/IABenchmarkWhitepaper2008.pdf 2008 Inductive Automation Benchmark White Paper] |
|||
[[Category:Industrial automation software]] |
[[Category:Industrial automation software]] |
||
Latest revision as of 09:53, 18 August 2021
Redirect to:
- From a merge: This is a redirect from a page that was merged into another page. This redirect was kept in order to preserve the edit history of this page after its content was merged into the content of the target page. Please do not remove the tag that generates this text (unless the need to recreate content on this page has been demonstrated) or delete this page.
- For redirects with substantive page histories that did not result from page merges use {{R with history}} instead.
- To a section: This is a redirect from a topic that does not have its own page to a section of a page on the subject. For redirects to embedded anchors on a page, use {{R to anchor}} instead.