View source for OPC with Microsoft SQL Server

{{HomePage}}
It is a common requirement in automation to store or retrieve data to or from SQL databases. QuickOPC makes it easy for you to create OPC SQL solutions, i.e. integrate OPC client functionality into your database solution with Microsoft SQL Server. Reading a value from OPC Data Access server, or writing a data value can be achieved in just several lines of code. QuickOPC component interfaces hide the complexities of OPC and allow you to focus on your main task.

[[Category:Example]] [[Category:QuickOPC]] [[Category:SQL Server]]
<div class="content-intro">
<p>Dedicated solutions that integrate OPC and SQL databases exist from various vendors. For example, you can purchase packages that log the OPC data into the database, or packages that download recipes from the database to the technology. If you have more specialized needs, then a development work is needed to make the OPC SQL integration happen, and that's where QuickOPC components can help. Using programming language of your choice, you can express custom application logic that dedicated solutions cannot provide.</p>
<p>Useful links: [[:Category:SQL Server]]</p>
</div>
<div class="content-1block">
<h3>Integration Scenario</h3>
<p>You are writing an application that connects to the SQL server using traditional means, such as ADO.NET, OLEDB, or ODBC. You have great flexibility in selecting technologies and application types - there are almost no limitations: Your code can be written C/C++, C#, VB6, VB.NET, or just about anything else.</p>
<p>You will use QuickOPC.NET components&nbsp;if the technology is based on&nbsp;Microsoft .NET,&nbsp;or you will&nbsp;use QuickOPC-COM if it is&nbsp;a language or tool that is capable of working with OLE automation objects. Either of these QuickOPC variations will give you client access to OPC servers located on your network.</p>
<p class="attention">[[QuickOPC.NET: How to log OPC Data Access item changes into a SQL Server database]] <br /> [[How to log OPC Unified Architecture data changes into a SQL Server database]]</p>
<p>The SQL server can stay free of any custom, OPC-related&nbsp;code.</p>
</div>
<p>The PubSub variety of OPC UA (as opposed to client-server) uses message-oriented middleware to deliver the data. QuickOPC supports it as well. Code example is available in the documentation, and installed with the product.</p>
<hr />