{"id":1887,"date":"2026-06-29T09:44:55","date_gmt":"2026-06-29T09:44:55","guid":{"rendered":"https:\/\/integrationobjects.com\/blog\/?p=1887"},"modified":"2026-07-27T13:58:19","modified_gmt":"2026-07-27T13:58:19","slug":"exposing-sql-oracle-data-to-scada-hmi-and-control-systems-via-opc-ua-with-opc-ua-server-for-databases","status":"publish","type":"post","link":"https:\/\/integrationobjects.com\/blog\/exposing-sql-oracle-data-to-scada-hmi-and-control-systems-via-opc-ua-with-opc-ua-server-for-databases\/","title":{"rendered":"OPC UA Server for Databases: Expose SQL &#038; Oracle Data to SCADA"},"content":{"rendered":"<p><em>Expose SQL Server, Oracle, and MySQL data as OPC UA nodes &#8211; no scripting, no middleware to maintain, with OPC UA-grade security built in.<\/em><\/p>\n<p>Every industrial site runs two parallel data worlds. On one side, relational databases hold the information IT and the business depend on &#8211; ERP (Enterprise Resource Planning) tables, MES (Manufacturing Execution System) recipes and batch parameters, asset registries, billing records. On the other, OT systems like <a href=\"https:\/\/integrationobjects.com\/sioth\/scada\">SCADA<\/a> (Supervisory Control and Data Acquisition), HMI (Human Machine Interface), and DCS (Distributed Control System) run on real-time OPC data. When those two worlds need to talk &#8211; and increasingly, they do &#8211; most teams end up writing custom SQL scripts or middleware to move data back and forth. This article explains what SQL to OPC UA means, why custom scripting is the wrong long-term answer, and how OPC UA Server for Databases solves the problem natively.<\/p>\n<h2>Why Bridge SQL and Oracle Databases to OPC UA?<\/h2>\n<p>Relational databases and OPC UA-based control systems were never designed to talk to each other directly. A SQL Server table doesn&#8217;t know what an OPC UA node is, and a SCADA system has no native concept of a database row. Bridging the two has traditionally meant one of two things:<\/p>\n<ul>\n<li>Custom scripts or stored procedures that poll the database on a schedule and push values to an OPC server &#8211; brittle and broken by the next schema change.<\/li>\n<li>Middleware built and maintained in-house by a developer who now owns a permanent maintenance burden, with no built-in OPC UA security model.<\/li>\n<\/ul>\n<p>Neither approach was built with <a href=\"https:\/\/integrationobjects.com\/blog\/category\/opc-ua\/\">OPC UA&#8217;s<\/a> certificate-based encryption, authentication modes, or standardized address space in mind. Neither distinguishes between real-time and historical access. And neither survives a database migration or a column rename without a developer going back into the code. This is exactly the gap <a href=\"https:\/\/integrationobjects.com\/sioth-opc\/sioth-opc-unified-architecture\/opc-ua-server-for-databases\">OPC UA Server for Databases<\/a> closes, with no code to write or maintain.<\/p>\n<h2>What Is OPC UA Server for Databases?<\/h2>\n<p>OPC UA Server for Databases is a plug-and-play <a href=\"https:\/\/integrationobjects.com\/sioth\/opc-ua-universal-server\">OPC UA server<\/a> from Integration Objects that maps tables and columns in your relational database directly to nodes in an OPC UA address space, through a graphical configuration interface &#8211; no SQL scripting and no OPC UA programming required. Once mapped, that data is available to <em>any<\/em> standards-compliant OPC UA client &#8211; a SCADA system, an HMI, a historian,\u00a0exactly as if it were live process data.<\/p>\n<p>It connects natively to:<\/p>\n<ul>\n<li>Microsoft SQL Server<\/li>\n<li>Oracle<\/li>\n<li>Microsoft Access<\/li>\n<li>MySQL<\/li>\n<\/ul>\n<p>The table-to-node mapping is done through a graphical configuration interface. No SQL scripting and no OPC UA programming required.<\/p>\n<p><a id=\"download\" class=\"btn_product_download\" href=\"https:\/\/integrationobjects.com\/download\/sioth-opc\/sioth-opc-unified-architecture\/opc-ua-server-for-databases?code=243&amp;name=OPC+UA+Server+for+Databases&amp;product=sioth-opc%2Fsioth-opc-unified-architecture%2Fopc-ua-server-for-databases\" target=\"_blank\" rel=\"noopener\">Download a Free Trial<\/a><\/p>\n<h2>What Makes It Different<\/h2>\n<p>Most OPC servers and DIY scripts stop at reading a value and mapping it to a tag. OPC UA Server for Databases goes further: alongside native bidirectional read\/write, it supports <strong>configurable insert and select query methods exposed as OPC UA method calls<\/strong>. This lets an <a href=\"https:\/\/integrationobjects.com\/sioth-opc\/sioth-opc-unified-architecture\/opc-ua-client\">OPC UA client<\/a> trigger a parameterized SQL insert or select on demand &#8211; not just read a value, but actively run a query against the database &#8211; all configured graphically, with no custom code. It is the capability that separates this product from generic OPC servers and from in-house middleware.<\/p>\n<h2>SQL to OPC UA Architecture<\/h2>\n<p>The architecture behind SQL to OPC UA is straightforward, and it&#8217;s worth understanding the four stages before you configure anything:<\/p>\n<ol>\n<li>Source database: your SQL Server, Oracle, MySQL, Access, or Wonderware Historian instance, holding the tables you want to expose.<\/li>\n<li>OPC UA Server for Databases: connects to that database via native drivers and maps the tables and columns you choose to OPC UA nodes.<\/li>\n<li>OPC UA address space: the mapped data now exists as standard, readable and writable OPC UA nodes, secured according to the policy you configure.<\/li>\n<li>OPC UA clients: any SCADA, HMI, DCS, or historian, connects as a normal OPC UA client and reads or writes that data in real time.<\/li>\n<\/ol>\n<h2>Key Features of OPC UA Server for Databases<\/h2>\n<h3>Connectivity<\/h3>\n<ul>\n<li>Simultaneous connections to multiple databases (MySQL, Microsoft SQL, Oracle, Microsoft Access) at once<\/li>\n<li>Automatic reconnection to database servers after network glitches<\/li>\n<li>Import and export of OPC tags via CSV files<\/li>\n<\/ul>\n<h3>Data Access<\/h3>\n<ul>\n<li>Read and write OPC UA node data values<\/li>\n<li>Access to both real-time and historical data<\/li>\n<li>Graphically configurable insert and select query methods<\/li>\n<\/ul>\n<h3>Security<\/h3>\n<ul>\n<li>UA TCP and HTTPS transport protocol support<\/li>\n<li>None, Sign, and Sign &amp; Encrypt security modes<\/li>\n<li>Basic256SHA256 and Basic256 security policies<\/li>\n<li>Anonymous and User Name authentication modes<\/li>\n<li>Built-in certificate management<\/li>\n<\/ul>\n<h3>Deployment<\/h3>\n<ul>\n<li>Runs as a Windows service<\/li>\n<li>Compatible with Windows Server 2008 through 2019, and Windows 7, 8, 10 and 11, Windows Server 2022, 2025<\/li>\n<li>OPC Unified Architecture compliant<\/li>\n<\/ul>\n<p><a class=\"wp-block-button__link has-luminous-vivid-orange-background-color has-background no-border-radius\" style=\"display: block; color: black !important; width: max-content; margin: 20px auto;\" href=\"https:\/\/new.integrationobjects.com\/backend\/public\/storage\/products\/64\/OPC%20UA%20Server%20for%20Databases.pdf\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Technical Datasheet<\/strong><\/a><\/p>\n<h2>SQL to OPC UA: Common Use Cases<\/h2>\n<h3>Manufacturing: MES Recipes on the SCADA Screen<\/h3>\n<p>Push batch parameters and recipe data straight from a SQL Server MES table into the SCADA HMI, so operators see setpoints without leaving the control room, and write production counts back to the database automatically as they&#8217;re generated.<\/p>\n<h3>Water &amp; Utilities: Asset and Compliance Data Alongside Live Readings<\/h3>\n<p>Expose billing, compliance, or asset-registry databases on SCADA dashboards so operators can cross-reference live readings against records during inspections, without switching applications.<\/p>\n<h3>Oil &amp; Gas: Historian Data Across Well Sites<\/h3>\n<p>Surface well-test results or data stored in Oracle or SQL Server into OPC UA-based monitoring tools, giving engineers a single, standardized view across distributed well sites.<\/p>\n<h3>Energy &amp; Power: Asset Records Next to ICCP Data<\/h3>\n<p>Feed substation asset and maintenance records from SQL into HMI screens alongside live ICCP (Inter-Control Center Communications Protocol) data, giving operators one unified view instead of two disconnected systems.<\/p>\n<p><a class=\"wp-block-button__link has-luminous-vivid-orange-background-color has-background no-border-radius\" style=\"display: block; color: black !important; width: max-content; margin: 20px auto;\" href=\"https:\/\/integrationobjects.com\/FileDownload\/PDF\/OPCUAServerforDatabasesUserGuide1.1rev.0.pdf\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Download User Guide<\/strong><\/a><\/p>\n<h2>Custom Scripts vs. OPC UA Server for Databases<\/h2>\n<table width=\"624\">\n<thead>\n<tr>\n<td width=\"173\"><strong>Capability<\/strong><\/td>\n<td width=\"225\"><strong>Custom Scripts \/ Middleware<\/strong><\/td>\n<td width=\"225\"><strong>OPC UA Server for Databases<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td width=\"173\"><strong>Setup time<\/strong><\/td>\n<td width=\"225\">Weeks of custom development<\/td>\n<td width=\"225\">Hours, via graphical configuration<\/td>\n<\/tr>\n<tr>\n<td width=\"173\"><strong>Ongoing maintenance<\/strong><\/td>\n<td width=\"225\">Breaks on schema changes; needs a developer<\/td>\n<td width=\"225\">No-code mapping; updated without writing code<\/td>\n<\/tr>\n<tr>\n<td width=\"173\"><strong>Security model<\/strong><\/td>\n<td width=\"225\">Whatever the developer implemented &#8211; if anything<\/td>\n<td width=\"225\">Built-in: certificates, Basic256SHA256 encryption, authentication modes<\/td>\n<\/tr>\n<tr>\n<td width=\"173\"><strong>Real-time + historical<\/strong><\/td>\n<td width=\"225\">Usually only one or the other<\/td>\n<td width=\"225\">Both, natively<\/td>\n<\/tr>\n<tr>\n<td width=\"173\"><strong>Bidirectional writes<\/strong><\/td>\n<td width=\"225\">Custom-coded, case by case<\/td>\n<td width=\"225\">Native read\/write, plus configurable insert\/select methods<\/td>\n<\/tr>\n<tr>\n<td width=\"173\"><strong>Standards compliance<\/strong><\/td>\n<td width=\"225\">None &#8211; proprietary script<\/td>\n<td width=\"225\">OPC Unified Architecture<\/td>\n<\/tr>\n<tr>\n<td width=\"173\"><strong>Vendor support<\/strong><\/td>\n<td width=\"225\">In-house only<\/td>\n<td width=\"225\">Integration Objects support and updates<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h2>Getting Started: From SQL Table to OPC UA Node in 4 Steps<\/h2>\n<ol>\n<li>Install OPC UA Server for Databases and connect it to your SQL Server, Oracle, MySQL, Access, or Wonderware Historian instance.<\/li>\n<li>Map the tables and columns you want to expose to OPC UA nodes, using the graphical configuration tool. No SQL or OPC UA coding required.<\/li>\n<li>Choose your security mode (None, Sign, or Sign &amp; Encrypt) and authentication method (Anonymous or User Name).<\/li>\n<li>Connect any OPC UA client &#8211; SCADA, HMI, historian, or SIOTH\u00ae &#8211; and start reading and writing data in real time.<\/li>\n<\/ol>\n<p><a id=\"download\" class=\"btn_product_download\" href=\"https:\/\/integrationobjects.com\/login?returnUrl=%2Fpricecheck%3Fproduct%3Dsioth-opc%252Fsioth-opc-unified-architecture%252Fopc-ua-server-for-databases\" target=\"_blank\" rel=\"noopener\">Buy Now<\/a><\/p>\n<h2>Frequently Asked Questions<\/h2>\n<style>#sp-ea-1891 .spcollapsing { height: 0; overflow: hidden; transition-property: height;transition-duration: 300ms;}#sp-ea-1891.sp-easy-accordion>.sp-ea-single {margin-bottom: 10px; border: 1px solid #e2e2e2; }#sp-ea-1891.sp-easy-accordion>.sp-ea-single>.ea-header a {color: #444;}#sp-ea-1891.sp-easy-accordion>.sp-ea-single>.sp-collapse>.ea-body {background: #fff; color: #444;}#sp-ea-1891.sp-easy-accordion>.sp-ea-single {background: #eee;}#sp-ea-1891.sp-easy-accordion>.sp-ea-single>.ea-header a .ea-expand-icon { float: left; color: #444;font-size: 16px;}.sp-easy-accordion .sp-ea-single .ea-header a{\r\n  display: block;\r\n    text-decoration: none;\r\n    cursor: pointer;\r\n    font-weight: 600;\r\n    color: #444;\r\n    font-size: 16px;\r\n    line-height: 1;\r\n  box-shadow: none;}<\/style><div id=\"sp_easy_accordion-1782726316\"><div id=\"sp-ea-1891\" class=\"sp-ea-one sp-easy-accordion\" data-ea-active=\"ea-click\" data-ea-mode=\"vertical\" data-preloader=\"\" data-scroll-active-item=\"\" data-offset-to-scroll=\"0\"><div class=\"ea-card ea-expand sp-ea-single\"><h3 class=\"ea-header\"><a class=\"collapsed\" id=\"ea-header-18910\" role=\"button\" data-sptoggle=\"spcollapse\" data-sptarget=\"#collapse18910\" aria-controls=\"collapse18910\" href=\"#\" aria-expanded=\"true\" tabindex=\"0\"><i aria-hidden=\"true\" role=\"presentation\" class=\"ea-expand-icon eap-icon-ea-expand-minus\"><\/i> What is SQL to OPC UA?<\/a><\/h3><div class=\"sp-collapse spcollapse collapsed show\" id=\"collapse18910\" data-parent=\"#sp-ea-1891\" role=\"region\" aria-labelledby=\"ea-header-18910\"> <div class=\"ea-body\"><p>SQL to OPC UA is the practice of exposing data from a SQL Server, Oracle, or other relational database as OPC UA nodes, so OPC UA clients like SCADA systems and HMIs can read and write it in real time, without custom integration code.<\/p><\/div><\/div><\/div><div class=\"ea-card sp-ea-single\"><h3 class=\"ea-header\"><a class=\"collapsed\" id=\"ea-header-18911\" role=\"button\" data-sptoggle=\"spcollapse\" data-sptarget=\"#collapse18911\" aria-controls=\"collapse18911\" href=\"#\" aria-expanded=\"false\" tabindex=\"0\"><i aria-hidden=\"true\" role=\"presentation\" class=\"ea-expand-icon eap-icon-ea-expand-plus\"><\/i> Can OPC UA Server for Databases write data back into SQL or Oracle, not just read it?<\/a><\/h3><div class=\"sp-collapse spcollapse \" id=\"collapse18911\" data-parent=\"#sp-ea-1891\" role=\"region\" aria-labelledby=\"ea-header-18911\"> <div class=\"ea-body\"><p>Yes. It supports both reading and writing OPC UA node values, and its insert and select query methods let OPC UA clients trigger parameterized database operations directly.<\/p><\/div><\/div><\/div><div class=\"ea-card sp-ea-single\"><h3 class=\"ea-header\"><a class=\"collapsed\" id=\"ea-header-18912\" role=\"button\" data-sptoggle=\"spcollapse\" data-sptarget=\"#collapse18912\" aria-controls=\"collapse18912\" href=\"#\" aria-expanded=\"false\" tabindex=\"0\"><i aria-hidden=\"true\" role=\"presentation\" class=\"ea-expand-icon eap-icon-ea-expand-plus\"><\/i> Which databases are supported?<\/a><\/h3><div class=\"sp-collapse spcollapse \" id=\"collapse18912\" data-parent=\"#sp-ea-1891\" role=\"region\" aria-labelledby=\"ea-header-18912\"> <div class=\"ea-body\"><p>Native support covers Microsoft SQL Server, Oracle, Microsoft Access, MySQL, and Wonderware Historian.<\/p><\/div><\/div><\/div><div class=\"ea-card sp-ea-single\"><h3 class=\"ea-header\"><a class=\"collapsed\" id=\"ea-header-18913\" role=\"button\" data-sptoggle=\"spcollapse\" data-sptarget=\"#collapse18913\" aria-controls=\"collapse18913\" href=\"#\" aria-expanded=\"false\" tabindex=\"0\"><i aria-hidden=\"true\" role=\"presentation\" class=\"ea-expand-icon eap-icon-ea-expand-plus\"><\/i> Is OPC UA Server for Databases secure enough for industrial networks?<\/a><\/h3><div class=\"sp-collapse spcollapse \" id=\"collapse18913\" data-parent=\"#sp-ea-1891\" role=\"region\" aria-labelledby=\"ea-header-18913\"> <div class=\"ea-body\"><p>Yes. It supports UA TCP and HTTPS transport, None, Sign, and Sign &amp; Encrypt security modes, Basic256SHA256 and Basic256 security policies, certificate management, and Anonymous or User Name authentication.<\/p><\/div><\/div><\/div><div class=\"ea-card sp-ea-single\"><h3 class=\"ea-header\"><a class=\"collapsed\" id=\"ea-header-18914\" role=\"button\" data-sptoggle=\"spcollapse\" data-sptarget=\"#collapse18914\" aria-controls=\"collapse18914\" href=\"#\" aria-expanded=\"false\" tabindex=\"0\"><i aria-hidden=\"true\" role=\"presentation\" class=\"ea-expand-icon eap-icon-ea-expand-plus\"><\/i> Does it support historical data, or only live values?<\/a><\/h3><div class=\"sp-collapse spcollapse \" id=\"collapse18914\" data-parent=\"#sp-ea-1891\" role=\"region\" aria-labelledby=\"ea-header-18914\"> <div class=\"ea-body\"><p>Both. OPC UA Server for Databases provides access to real-time and historical data stored in the connected database.<\/p><\/div><\/div><\/div><script type=\"application\/ld+json\">{ \"@context\": \"https:\/\/schema.org\", \"@type\": \"FAQPage\", \"@id\": \"sp-ea-schema-1891-6aaea6759f175\", \"mainEntity\": [{ \"@type\": \"Question\", \"name\": \"What is SQL to OPC UA?\", \"acceptedAnswer\": { \"@type\": \"Answer\", \"text\": \"SQL to OPC UA is the practice of exposing data from a SQL Server, Oracle, or other relational database as OPC UA nodes, so OPC UA clients like SCADA systems and HMIs can read and write it in real time, without custom integration code.\" } },{ \"@type\": \"Question\", \"name\": \"Can OPC UA Server for Databases write data back into SQL or Oracle, not just read it?\", \"acceptedAnswer\": { \"@type\": \"Answer\", \"text\": \"Yes. It supports both reading and writing OPC UA node values, and its insert and select query methods let OPC UA clients trigger parameterized database operations directly.\" } },{ \"@type\": \"Question\", \"name\": \"Which databases are supported?\", \"acceptedAnswer\": { \"@type\": \"Answer\", \"text\": \"Native support covers Microsoft SQL Server, Oracle, Microsoft Access, MySQL, and Wonderware Historian.\" } },{ \"@type\": \"Question\", \"name\": \"Is OPC UA Server for Databases secure enough for industrial networks?\", \"acceptedAnswer\": { \"@type\": \"Answer\", \"text\": \"Yes. It supports UA TCP and HTTPS transport, None, Sign, and Sign &amp; Encrypt security modes, Basic256SHA256 and Basic256 security policies, certificate management, and Anonymous or User Name authentication.\" } },{ \"@type\": \"Question\", \"name\": \"Does it support historical data, or only live values?\", \"acceptedAnswer\": { \"@type\": \"Answer\", \"text\": \"Both. OPC UA Server for Databases provides access to real-time and historical data stored in the connected database.\" } }] }<\/script><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Expose SQL Server, Oracle, and MySQL data as OPC UA nodes &#8211; no scripting, no middleware to maintain, with OPC UA-grade security built in. Every<\/p>\n","protected":false},"author":1,"featured_media":1901,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[183],"tags":[192],"class_list":["post-1887","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-opc-ua","tag-opc-ua-server-for-databases"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL to OPC UA: Connect SQL &amp; Oracle to SCADA<\/title>\n<meta name=\"description\" content=\"Learn how SQL to OPC UA works and how to connect SQL Server, Oracle &amp; MySQL data to SCADA, HMI and historians with OPC UA Server for Databases - no custom code required.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/integrationobjects.com\/blog\/exposing-sql-oracle-data-to-scada-hmi-and-control-systems-via-opc-ua-with-opc-ua-server-for-databases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL to OPC UA: Connect SQL &amp; Oracle to SCADA\" \/>\n<meta property=\"og:description\" content=\"Learn how SQL to OPC UA works and how to connect SQL Server, Oracle &amp; MySQL data to SCADA, HMI and historians with OPC UA Server for Databases - no custom code required.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/integrationobjects.com\/blog\/exposing-sql-oracle-data-to-scada-hmi-and-control-systems-via-opc-ua-with-opc-ua-server-for-databases\/\" \/>\n<meta property=\"og:site_name\" content=\"OPC Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Integration.Objects.OPC\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-06-29T09:44:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-07-27T13:58:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/integrationobjects.com\/blog\/wp-content\/uploads\/2026\/06\/OPC-UA-Server-for-Databases-Blog-Post.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1248\" \/>\n\t<meta property=\"og:image:height\" content=\"832\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"OPCBlogAdmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@IntegObjects\" \/>\n<meta name=\"twitter:site\" content=\"@IntegObjects\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"OPCBlogAdmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL to OPC UA: Connect SQL & Oracle to SCADA","description":"Learn how SQL to OPC UA works and how to connect SQL Server, Oracle & MySQL data to SCADA, HMI and historians with OPC UA Server for Databases - no custom code required.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/integrationobjects.com\/blog\/exposing-sql-oracle-data-to-scada-hmi-and-control-systems-via-opc-ua-with-opc-ua-server-for-databases\/","og_locale":"en_US","og_type":"article","og_title":"SQL to OPC UA: Connect SQL & Oracle to SCADA","og_description":"Learn how SQL to OPC UA works and how to connect SQL Server, Oracle & MySQL data to SCADA, HMI and historians with OPC UA Server for Databases - no custom code required.","og_url":"https:\/\/integrationobjects.com\/blog\/exposing-sql-oracle-data-to-scada-hmi-and-control-systems-via-opc-ua-with-opc-ua-server-for-databases\/","og_site_name":"OPC Blog","article_publisher":"https:\/\/www.facebook.com\/Integration.Objects.OPC\/","article_published_time":"2026-06-29T09:44:55+00:00","article_modified_time":"2026-07-27T13:58:19+00:00","og_image":[{"width":1248,"height":832,"url":"https:\/\/integrationobjects.com\/blog\/wp-content\/uploads\/2026\/06\/OPC-UA-Server-for-Databases-Blog-Post.png","type":"image\/png"}],"author":"OPCBlogAdmin","twitter_card":"summary_large_image","twitter_creator":"@IntegObjects","twitter_site":"@IntegObjects","twitter_misc":{"Written by":"OPCBlogAdmin","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/integrationobjects.com\/blog\/exposing-sql-oracle-data-to-scada-hmi-and-control-systems-via-opc-ua-with-opc-ua-server-for-databases\/","url":"https:\/\/integrationobjects.com\/blog\/exposing-sql-oracle-data-to-scada-hmi-and-control-systems-via-opc-ua-with-opc-ua-server-for-databases\/","name":"SQL to OPC UA: Connect SQL & Oracle to SCADA","isPartOf":{"@id":"https:\/\/integrationobjects.com\/blog-\/#website"},"primaryImageOfPage":{"@id":"https:\/\/integrationobjects.com\/blog\/exposing-sql-oracle-data-to-scada-hmi-and-control-systems-via-opc-ua-with-opc-ua-server-for-databases\/#primaryimage"},"image":{"@id":"https:\/\/integrationobjects.com\/blog\/exposing-sql-oracle-data-to-scada-hmi-and-control-systems-via-opc-ua-with-opc-ua-server-for-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/integrationobjects.com\/blog\/wp-content\/uploads\/2026\/06\/OPC-UA-Server-for-Databases-Blog-Post.png","datePublished":"2026-06-29T09:44:55+00:00","dateModified":"2026-07-27T13:58:19+00:00","author":{"@id":"https:\/\/integrationobjects.com\/blog-\/#\/schema\/person\/6efbaf488a07e418b93ff77f00af386b"},"description":"Learn how SQL to OPC UA works and how to connect SQL Server, Oracle & MySQL data to SCADA, HMI and historians with OPC UA Server for Databases - no custom code required.","breadcrumb":{"@id":"https:\/\/integrationobjects.com\/blog\/exposing-sql-oracle-data-to-scada-hmi-and-control-systems-via-opc-ua-with-opc-ua-server-for-databases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/integrationobjects.com\/blog\/exposing-sql-oracle-data-to-scada-hmi-and-control-systems-via-opc-ua-with-opc-ua-server-for-databases\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/integrationobjects.com\/blog\/exposing-sql-oracle-data-to-scada-hmi-and-control-systems-via-opc-ua-with-opc-ua-server-for-databases\/#primaryimage","url":"https:\/\/integrationobjects.com\/blog\/wp-content\/uploads\/2026\/06\/OPC-UA-Server-for-Databases-Blog-Post.png","contentUrl":"https:\/\/integrationobjects.com\/blog\/wp-content\/uploads\/2026\/06\/OPC-UA-Server-for-Databases-Blog-Post.png","width":1248,"height":832},{"@type":"BreadcrumbList","@id":"https:\/\/integrationobjects.com\/blog\/exposing-sql-oracle-data-to-scada-hmi-and-control-systems-via-opc-ua-with-opc-ua-server-for-databases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/integrationobjects.com\/blog-\/"},{"@type":"ListItem","position":2,"name":"OPC UA Server for Databases: Expose SQL &#038; Oracle Data to SCADA"}]},{"@type":"WebSite","@id":"https:\/\/integrationobjects.com\/blog-\/#website","url":"https:\/\/integrationobjects.com\/blog-\/","name":"OPC Blog","description":"OPC and related technologies news from Integration Objects","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/integrationobjects.com\/blog-\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/integrationobjects.com\/blog-\/#\/schema\/person\/6efbaf488a07e418b93ff77f00af386b","name":"OPCBlogAdmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/integrationobjects.com\/blog-\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f2d787c3c48eb147d5b4d0c9d05c6f35a5946c7dc40af2eedbe64030e99ea299?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f2d787c3c48eb147d5b4d0c9d05c6f35a5946c7dc40af2eedbe64030e99ea299?s=96&d=mm&r=g","caption":"OPCBlogAdmin"}}]}},"_links":{"self":[{"href":"https:\/\/integrationobjects.com\/blog\/wp-json\/wp\/v2\/posts\/1887","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/integrationobjects.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/integrationobjects.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/integrationobjects.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/integrationobjects.com\/blog\/wp-json\/wp\/v2\/comments?post=1887"}],"version-history":[{"count":13,"href":"https:\/\/integrationobjects.com\/blog\/wp-json\/wp\/v2\/posts\/1887\/revisions"}],"predecessor-version":[{"id":1983,"href":"https:\/\/integrationobjects.com\/blog\/wp-json\/wp\/v2\/posts\/1887\/revisions\/1983"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/integrationobjects.com\/blog\/wp-json\/wp\/v2\/media\/1901"}],"wp:attachment":[{"href":"https:\/\/integrationobjects.com\/blog\/wp-json\/wp\/v2\/media?parent=1887"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/integrationobjects.com\/blog\/wp-json\/wp\/v2\/categories?post=1887"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/integrationobjects.com\/blog\/wp-json\/wp\/v2\/tags?post=1887"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}