FactorySQL - Revision history

Klbrain: Merged content to Ignition SCADA#FactorySQL, redirecting; unopposed 2020 proposal (easy-merge)

2021-08-18T09:53:53Z

Merged content to Ignition SCADA#FactorySQL, redirecting; unopposed 2020 proposal (easy-merge)

← Previous revision		Revision as of 09:53, 18 August 2021
Line 1:		Line 1:
	~~{{Main\|~~Ignition SCADA}}		#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]]

Widefox: Added {{Merge to}} tag (TW)

2020-07-27T19:52:00Z

Added {{Merge to}} tag (TW)

← Previous revision		Revision as of 19:52, 27 July 2020
Line 1:		Line 1:
	{{Main\|Ignition SCADA}}		{{Main\|Ignition SCADA}}
			{{Merge to\|Ignition SCADA\|discuss=Talk:Ignition SCADA#Proposed merge of FactorySQL into Ignition SCADA\|date=July 2020}}
	{{Multiple issues\|		{{Multiple issues\|
	{{primary sources\|date=February 2013}}		{{primary sources\|date=February 2013}}

Widefox: Added {{Advert}} tag (TW)

2020-07-27T19:51:28Z

Added {{Advert}} tag (TW)

← Previous revision		Revision as of 19:51, 27 July 2020
Line 4:		Line 4:
	{{Notability\|Products\|date=July 2020}}		{{Notability\|Products\|date=July 2020}}
	{{COI\|date=July 2020}}		{{COI\|date=July 2020}}
			{{Advert\|date=July 2020}}
	}}		}}
	[[File:FactorySQL logo.gif\|thumbnail\|FactorySQL box]]		[[File:FactorySQL logo.gif\|thumbnail\|FactorySQL box]]

Widefox: Added {{COI}} tag (TW)

2020-07-27T19:44:58Z

Added {{COI}} tag (TW)

← Previous revision		Revision as of 19:44, 27 July 2020
Line 3:		Line 3:
	{{primary sources\|date=February 2013}}		{{primary sources\|date=February 2013}}
	{{Notability\|Products\|date=July 2020}}		{{Notability\|Products\|date=July 2020}}
			{{COI\|date=July 2020}}
	}}		}}
	[[File:FactorySQL logo.gif\|thumbnail\|FactorySQL box]]		[[File:FactorySQL logo.gif\|thumbnail\|FactorySQL box]]

Widefox: /* top */ fix sect WP:ORDER

2020-07-27T19:11:55Z

top: fix sect WP:ORDER

← Previous revision		Revision as of 19:11, 27 July 2020
Line 1:		Line 1:
		⚫	{{Main\|Ignition SCADA}}
	{{Multiple issues\|		{{Multiple issues\|
	{{primary sources\|date=February 2013}}		{{primary sources\|date=February 2013}}
Line 4:		Line 5:
	}}		}}
	[[File:FactorySQL logo.gif\|thumbnail\|FactorySQL box]]		[[File:FactorySQL logo.gif\|thumbnail\|FactorySQL box]]
⚫	{{Main\|Ignition SCADA}}
	'''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.		'''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.

Widefox: Added {{Notability}} tag (TW)

2020-07-27T19:11:27Z

Added {{Notability}} tag (TW)

← Previous revision		Revision as of 19:11, 27 July 2020
Line 1:		Line 1:
			{{Multiple issues\|
	{{primary sources\|date=February 2013}}		{{primary sources\|date=February 2013}}
			{{Notability\|Products\|date=July 2020}}
			}}
	[[File:FactorySQL logo.gif\|thumbnail\|FactorySQL box]]		[[File:FactorySQL logo.gif\|thumbnail\|FactorySQL box]]
	{{Main\|Ignition SCADA}}		{{Main\|Ignition SCADA}}

Monkbot: Task 16: replaced (6×) / removed (0×) deprecated |dead-url= and |deadurl= with |url-status=;

2019-10-02T17:30:15Z

Task 16: replaced (6×) / removed (0×) deprecated |dead-url= and |deadurl= with |url-status=;

← Previous revision		Revision as of 17:30, 2 October 2019
Line 2:		Line 2:
	[[File:FactorySQL logo.gif\|thumbnail\|FactorySQL box]]		[[File:FactorySQL logo.gif\|thumbnail\|FactorySQL box]]
	{{Main\|Ignition SCADA}}		{{Main\|Ignition SCADA}}
	'''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 \|~~deadurl~~=~~yes~~ \|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 ~~\|df=~~ }}</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\|~~deadurl~~=~~yes~~\|archiveurl=https://archive.is/20130216063923/http://www.inductiveautomation.com/news/item/275\|archivedate=2013-02-16~~\|df=~~}}</ref> As of January 2013, FactorySQL is still being sold and supported.		'''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.

	==Groups and Items==		==Groups and Items==
	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 \|~~dead-~~url=~~yes~~ \|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.		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==
	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 \|~~deadurl~~=~~yes~~ \|archiveurl=https://web.archive.org/web/20130118160813/http://www.inductiveautomation.com/products/factorysql \|archivedate=2013-01-18 ~~\|df=~~ }}</ref>		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.		* '''Easy Browsing''' Browse OPC servers from navigation tree.
Line 20:		Line 20:
	* '''Supports Most PLCs and Database Systems''' Support nearly every [[OLE for process control\|OPC]] compliant PLC and [[Odbc\|ODBC]] compliant SQL database.		* '''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>		* '''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 \|~~deadurl~~=~~yes~~ \|archiveurl=https://web.archive.org/web/20130118160813/http://www.inductiveautomation.com/products/factorysql \|archivedate=2013-01-18 ~~\|df=~~ }}</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==		==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 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 \|~~dead-~~url=~~yes~~ \|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>		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==		==References==

InternetArchiveBot: Rescuing 1 sources and tagging 0 as dead. #IABot (v2.0beta15)

2019-08-15T18:22:48Z

Rescuing 1 sources and tagging 0 as dead. #IABot (v2.0beta15)

← Previous revision		Revision as of 18:22, 15 August 2019
Line 31:		Line 31:

	==External links==		==External links==
	*[http://www.inductiveautomation.com/products/factorysql/ Inductive Automation FactorySQL page]		*[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]		*[http://files.inductiveautomation.com/whitepapers/IABenchmarkWhitepaper2008.pdf 2008 Inductive Automation Benchmark White Paper]

InternetArchiveBot: Rescuing 4 sources and tagging 0 as dead. #IABot (v1.5.4)

2017-09-27T11:27:53Z

Rescuing 4 sources and tagging 0 as dead. #IABot (v1.5.4)

← Previous revision		Revision as of 11:27, 27 September 2017
Line 2:		Line 2:
	[[File:FactorySQL logo.gif\|thumbnail\|FactorySQL box]]		[[File:FactorySQL logo.gif\|thumbnail\|FactorySQL box]]
	{{Main\|Ignition SCADA}}		{{Main\|Ignition SCADA}}
	'''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}}</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}}</ref> As of January 2013, FactorySQL is still being sold and supported.		'''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 \|deadurl=yes \|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 \|df= }}</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\|deadurl=yes\|archiveurl=https://archive.is/20130216063923/http://www.inductiveautomation.com/news/item/275\|archivedate=2013-02-16\|df=}}</ref> As of January 2013, FactorySQL is still being sold and supported.

	==Groups and Items==		==Groups and Items==
Line 8:		Line 8:

	==Features==		==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 \|deadurl=yes \|archiveurl=https://web.archive.org/web/20130118160813/http://www.inductiveautomation.com~~:80~~/products/factorysql \|archivedate=2013-01-18 \|df= }}</ref>		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 \|deadurl=yes \|archiveurl=https://web.archive.org/web/20130118160813/http://www.inductiveautomation.com/products/factorysql \|archivedate=2013-01-18 \|df= }}</ref>

	* '''Easy Browsing''' Browse OPC servers from navigation tree.		* '''Easy Browsing''' Browse OPC servers from navigation tree.
Line 20:		Line 20:
	* '''Supports Most PLCs and Database Systems''' Support nearly every [[OLE for process control\|OPC]] compliant PLC and [[Odbc\|ODBC]] compliant SQL database.		* '''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>		* '''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 \|deadurl=yes \|archiveurl=https://web.archive.org/web/20130118160813/http://www.inductiveautomation.com~~:80~~/products/factorysql \|archivedate=2013-01-18 \|df= }}</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 \|deadurl=yes \|archiveurl=https://web.archive.org/web/20130118160813/http://www.inductiveautomation.com/products/factorysql \|archivedate=2013-01-18 \|df= }}</ref>

	==History==		==History==

Mitch Ames: Remove supercategory of existing category per WP:SUBCAT using AWB

2017-03-30T12:46:50Z

Remove supercategory of existing category per WP:SUBCAT using AWB

← Previous revision		Revision as of 12:46, 30 March 2017
Line 34:		Line 34:
	*[http://files.inductiveautomation.com/whitepapers/IABenchmarkWhitepaper2008.pdf 2008 Inductive Automation Benchmark White Paper]		*[http://files.inductiveautomation.com/whitepapers/IABenchmarkWhitepaper2008.pdf 2008 Inductive Automation Benchmark White Paper]

	[[Category:Industrial software]]
	[[Category:Industrial automation software]]		[[Category:Industrial automation software]]

← Previous revision		Revision as of 19:52, 27 July 2020
Line 1:		Line 1:
	{{Main\|Ignition SCADA}}		{{Main\|Ignition SCADA}}
			{{Merge to\|Ignition SCADA\|discuss=Talk:Ignition SCADA#Proposed merge of FactorySQL into Ignition SCADA\|date=July 2020}}
	{{Multiple issues\|		{{Multiple issues\|
	{{primary sources\|date=February 2013}}		{{primary sources\|date=February 2013}}

← Previous revision		Revision as of 19:51, 27 July 2020
Line 4:		Line 4:
	{{Notability\|Products\|date=July 2020}}		{{Notability\|Products\|date=July 2020}}
	{{COI\|date=July 2020}}		{{COI\|date=July 2020}}
			{{Advert\|date=July 2020}}
	}}		}}
	[[File:FactorySQL logo.gif\|thumbnail\|FactorySQL box]]		[[File:FactorySQL logo.gif\|thumbnail\|FactorySQL box]]

← Previous revision		Revision as of 19:44, 27 July 2020
Line 3:		Line 3:
	{{primary sources\|date=February 2013}}		{{primary sources\|date=February 2013}}
	{{Notability\|Products\|date=July 2020}}		{{Notability\|Products\|date=July 2020}}
			{{COI\|date=July 2020}}
	}}		}}
	[[File:FactorySQL logo.gif\|thumbnail\|FactorySQL box]]		[[File:FactorySQL logo.gif\|thumbnail\|FactorySQL box]]

← Previous revision		Revision as of 19:11, 27 July 2020
Line 1:		Line 1:
			{{Multiple issues\|
	{{primary sources\|date=February 2013}}		{{primary sources\|date=February 2013}}
			{{Notability\|Products\|date=July 2020}}
			}}
	[[File:FactorySQL logo.gif\|thumbnail\|FactorySQL box]]		[[File:FactorySQL logo.gif\|thumbnail\|FactorySQL box]]
	{{Main\|Ignition SCADA}}		{{Main\|Ignition SCADA}}

← Previous revision		Revision as of 17:30, 2 October 2019
Line 2:		Line 2:
	[[File:FactorySQL logo.gif\|thumbnail\|FactorySQL box]]		[[File:FactorySQL logo.gif\|thumbnail\|FactorySQL box]]
	{{Main\|Ignition SCADA}}		{{Main\|Ignition SCADA}}
	'''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 \|~~deadurl~~=~~yes~~ \|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 ~~\|df=~~ }}</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\|~~deadurl~~=~~yes~~\|archiveurl=https://archive.is/20130216063923/http://www.inductiveautomation.com/news/item/275\|archivedate=2013-02-16~~\|df=~~}}</ref> As of January 2013, FactorySQL is still being sold and supported.		'''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.

	==Groups and Items==		==Groups and Items==
	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 \|~~dead-~~url=~~yes~~ \|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.		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==
	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 \|~~deadurl~~=~~yes~~ \|archiveurl=https://web.archive.org/web/20130118160813/http://www.inductiveautomation.com/products/factorysql \|archivedate=2013-01-18 ~~\|df=~~ }}</ref>		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.		* '''Easy Browsing''' Browse OPC servers from navigation tree.
Line 20:		Line 20:
	* '''Supports Most PLCs and Database Systems''' Support nearly every [[OLE for process control\|OPC]] compliant PLC and [[Odbc\|ODBC]] compliant SQL database.		* '''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>		* '''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 \|~~deadurl~~=~~yes~~ \|archiveurl=https://web.archive.org/web/20130118160813/http://www.inductiveautomation.com/products/factorysql \|archivedate=2013-01-18 ~~\|df=~~ }}</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==		==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 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 \|~~dead-~~url=~~yes~~ \|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>		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==		==References==