{"id":451,"date":"2025-04-17T09:51:17","date_gmt":"2025-04-17T09:51:17","guid":{"rendered":"http:\/\/opcconnect.integrationobjects.com\/?p=451"},"modified":"2026-04-13T08:09:36","modified_gmt":"2026-04-13T08:09:36","slug":"collect-opc-hda-data","status":"publish","type":"post","link":"https:\/\/integrationobjects.com\/blog\/collect-opc-hda-data\/","title":{"rendered":"How to Collect OPC HDA Data and Store It in MS SQL Server Using OPC Easy Archiver"},"content":{"rendered":"\r\n<p data-start=\"355\" data-end=\"643\">Collecting historical OPC HDA data and storing it in MS SQL Server is essential for industrial reporting, analytics, and compliance. Using <a href=\"https:\/\/integrationobjects.com\/sioth-opc\/sioth-opc-data-archiving\/opc-easy-archiver\/\">OPC Easy Archiver<\/a>, engineers can reliably log OPC HDA data, ensure data integrity during network disruptions, and integrate historical data with SQL-based analytics tools.<\/p>\r\n<p data-start=\"355\" data-end=\"643\">This step-by-step guide will show you how to configure OPC Easy Archiver to collect OPC HDA data and store it in MS SQL Server efficiently.<\/p>\r\n\r\n\r\n\r\n<h2 data-start=\"1668\" data-end=\"1687\">What is OPC HDA?<\/h2>\r\n<p data-start=\"794\" data-end=\"1053\">OPC HDA (Historical Data Access) is a standard that enables clients to retrieve historical process data from OPC servers. Unlike real-time OPC DA data, <a href=\"https:\/\/integrationobjects.com\/blog\/historize-industrial-data-opc-easy-archiver\/\">OPC HDA<\/a> focuses on archived values, timestamps, and aggregated trend data, which is critical for:<\/p>\r\n<ul data-start=\"1055\" data-end=\"1176\">\r\n<li data-section-id=\"h6axu\" data-start=\"1055\" data-end=\"1079\">\r\n<p data-start=\"1057\" data-end=\"1079\">Performance analysis<\/p>\r\n<\/li>\r\n<li data-section-id=\"1ucaxr1\" data-start=\"1080\" data-end=\"1114\">\r\n<p data-start=\"1082\" data-end=\"1114\">Compliance and audit reporting<\/p>\r\n<\/li>\r\n<li data-section-id=\"6bni6n\" data-start=\"1115\" data-end=\"1143\">\r\n<p data-start=\"1117\" data-end=\"1143\">Root cause investigation<\/p>\r\n<\/li>\r\n<li data-section-id=\"1go4fs6\" data-start=\"1144\" data-end=\"1176\">\r\n<p data-start=\"1146\" data-end=\"1176\">Long-term process monitoring<\/p>\r\n<\/li>\r\n<\/ul>\r\n<p data-start=\"1178\" data-end=\"1347\">This allows organizations to perform advanced analytics and reporting while maintaining a structured, centralized historical database.<\/p>\r\n<h3 data-section-id=\"1660xjq\" data-start=\"1354\" data-end=\"1397\"><strong data-start=\"1358\" data-end=\"1395\">Why Store OPC HDA Data in MS SQL?<\/strong><\/h3>\r\n<p data-start=\"1399\" data-end=\"1457\">Logging OPC HDA to MS SQL offers several advantages:<\/p>\r\n<ul data-start=\"1459\" data-end=\"1993\">\r\n<li data-section-id=\"ii5zcf\" data-start=\"1459\" data-end=\"1567\">\r\n<p data-start=\"1461\" data-end=\"1567\"><strong data-start=\"1461\" data-end=\"1485\">Centralized Storage:<\/strong> Consolidate historical data from multiple OPC HDA servers in a single database.<\/p>\r\n<\/li>\r\n<li data-section-id=\"hnw429\" data-start=\"1568\" data-end=\"1653\">\r\n<p data-start=\"1570\" data-end=\"1653\"><strong data-start=\"1570\" data-end=\"1593\">Advanced Analytics:<\/strong> Use SQL queries or BI tools to analyze historical trends.<\/p>\r\n<\/li>\r\n<li data-section-id=\"erouby\" data-start=\"1654\" data-end=\"1759\">\r\n<p data-start=\"1656\" data-end=\"1759\"><strong data-start=\"1656\" data-end=\"1677\">Data Reliability:<\/strong> OPC Easy Archiver includes store-and-forward capabilities to prevent data loss.<\/p>\r\n<\/li>\r\n<li data-section-id=\"m5inm3\" data-start=\"1760\" data-end=\"1876\">\r\n<p data-start=\"1762\" data-end=\"1876\"><strong data-start=\"1762\" data-end=\"1792\">Compliance &amp; Traceability:<\/strong> Maintain structured historical records for audits and operational investigations.<\/p>\r\n<\/li>\r\n<li data-section-id=\"tvbvk2\" data-start=\"1877\" data-end=\"1993\">\r\n<p data-start=\"1879\" data-end=\"1993\"><strong data-start=\"1879\" data-end=\"1906\">Enterprise Integration:<\/strong> Easily connect historical data to dashboards, cloud systems, or analytics platforms.<\/p>\r\n<\/li>\r\n<\/ul>\r\n<h2 data-start=\"2264\" data-end=\"2303\">Solution Overview: OPC Easy Archiver<\/h2>\r\n<p data-start=\"2305\" data-end=\"2383\"><a href=\"https:\/\/integrationobjects.com\/blog\/category\/opc-data-archiving\/\">OPC Easy Archiver<\/a> is a powerful data logging solution that enables you to:<\/p>\r\n<ul>\r\n<li data-start=\"2387\" data-end=\"2423\">Collect OPC data (including OPC HDA)<\/li>\r\n<li data-start=\"2426\" data-end=\"2456\">Store it in standard databases<\/li>\r\n<li data-start=\"2459\" data-end=\"2478\">Export to CSV files<\/li>\r\n<li data-start=\"2481\" data-end=\"2546\">Ensure reliable data delivery with store-and-forward capabilities<\/li>\r\n<\/ul>\r\n<h2 data-section-id=\"bi2bwy\" data-start=\"3409\" data-end=\"3456\"><strong data-start=\"3413\" data-end=\"3454\">Benefits of OPC HDA to MS SQL Logging<\/strong><\/h2>\r\n<p data-start=\"3458\" data-end=\"3506\">Storing OPC HDA data in MS SQL Server ensures:<\/p>\r\n<ul data-start=\"3508\" data-end=\"3857\">\r\n<li data-section-id=\"1gl3nbk\" data-start=\"3508\" data-end=\"3583\">\r\n<p data-start=\"3510\" data-end=\"3583\"><strong data-start=\"3510\" data-end=\"3533\">Advanced Reporting:<\/strong> Use SQL queries or BI tools for trend analysis.<\/p>\r\n<\/li>\r\n<li data-section-id=\"155llh8\" data-start=\"3584\" data-end=\"3647\">\r\n<p data-start=\"3586\" data-end=\"3647\"><strong data-start=\"3586\" data-end=\"3607\">Reliable Storage:<\/strong> Store-and-forward prevents data loss.<\/p>\r\n<\/li>\r\n<li data-section-id=\"p72huk\" data-start=\"3648\" data-end=\"3736\">\r\n<p data-start=\"3650\" data-end=\"3736\"><strong data-start=\"3650\" data-end=\"3676\">Improved Traceability:<\/strong> Structured historical logs support compliance and audits.<\/p>\r\n<\/li>\r\n<li data-section-id=\"2wojrj\" data-start=\"3737\" data-end=\"3857\">\r\n<p data-start=\"3739\" data-end=\"3857\"><strong data-start=\"3739\" data-end=\"3766\">Enterprise Integration:<\/strong> Seamlessly connect historical data to analytics platforms, dashboards, or cloud systems.<\/p>\r\n<\/li>\r\n<\/ul>\r\n<h3 data-section-id=\"zjrggr\" data-start=\"3864\" data-end=\"3888\"><strong data-start=\"3868\" data-end=\"3886\">Video Tutorial<\/strong><\/h3>\r\n<p data-start=\"3890\" data-end=\"4099\">For a hands-on walkthrough, watch our video demonstrating\u00a0how to connect to the server, configure the archiver, and store data in SQL Server.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><a href=\"https:\/\/integrationobjects.com\/opc-demos\/how-to-configure-opc-easy-archiver-to-store-opc-hda-data-into-sql\/\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"550\" class=\"wp-image-452\" src=\"https:\/\/integrationobjects.com\/blog\/wp-content\/uploads\/2019\/10\/Capture-1024x550.png\" alt=\"collect opc hda data\" srcset=\"https:\/\/integrationobjects.com\/blog\/wp-content\/uploads\/2019\/10\/Capture-1024x550.png 1024w, https:\/\/integrationobjects.com\/blog\/wp-content\/uploads\/2019\/10\/Capture-300x161.png 300w, https:\/\/integrationobjects.com\/blog\/wp-content\/uploads\/2019\/10\/Capture-768x413.png 768w, https:\/\/integrationobjects.com\/blog\/wp-content\/uploads\/2019\/10\/Capture.png 1394w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\r\n\r\n\r\n\r\n<h2 data-section-id=\"1i9ix39\" data-start=\"4106\" data-end=\"4126\"><strong data-start=\"4110\" data-end=\"4124\">Conclusion<\/strong><\/h2>\r\n<p data-start=\"4128\" data-end=\"4384\">Logging OPC HDA to MS SQL simplifies historical data management, improves compliance, and enables advanced analytics. By following this guide and using OPC Easy Archiver, industrial teams can centralize their historical data securely and efficiently.<\/p>\r\n<h2 data-start=\"4128\" data-end=\"4384\">FAQ on OPC HDA<\/h2>\r\n<style>#sp-ea-1820 .spcollapsing { height: 0; overflow: hidden; transition-property: height;transition-duration: 300ms;}#sp-ea-1820.sp-easy-accordion>.sp-ea-single {margin-bottom: 10px; border: 1px solid #e2e2e2; }#sp-ea-1820.sp-easy-accordion>.sp-ea-single>.ea-header a {color: #444;}#sp-ea-1820.sp-easy-accordion>.sp-ea-single>.sp-collapse>.ea-body {background: #fff; color: #444;}#sp-ea-1820.sp-easy-accordion>.sp-ea-single {background: #eee;}#sp-ea-1820.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-1776067542\"><div id=\"sp-ea-1820\" 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-18200\" role=\"button\" data-sptoggle=\"spcollapse\" data-sptarget=\"#collapse18200\" aria-controls=\"collapse18200\" href=\"#\" aria-expanded=\"true\" tabindex=\"0\"><i aria-hidden=\"true\" role=\"presentation\" class=\"ea-expand-icon eap-icon-ea-expand-minus\"><\/i> What is OPC HDA and how is it collected in industrial systems? <\/a><\/h3><div class=\"sp-collapse spcollapse collapsed show\" id=\"collapse18200\" data-parent=\"#sp-ea-1820\" role=\"region\" aria-labelledby=\"ea-header-18200\"> <div class=\"ea-body\"><p><span class=\"TextRun SCXW204504452 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW204504452 BCX0\">OPC Easy Archiver collects OPC HDA (Historical Data Access) data directly from OPC servers, capturing archived values, timestamps, and process history for storage and analysis in MS SQL Server.<\/span><\/span><span class=\"EOP SCXW204504452 BCX0\" data-ccp-props=\"{}\">\u00a0<\/span><\/p><\/div><\/div><\/div><div class=\"ea-card sp-ea-single\"><h3 class=\"ea-header\"><a class=\"collapsed\" id=\"ea-header-18201\" role=\"button\" data-sptoggle=\"spcollapse\" data-sptarget=\"#collapse18201\" aria-controls=\"collapse18201\" href=\"#\" aria-expanded=\"false\" tabindex=\"0\"><i aria-hidden=\"true\" role=\"presentation\" class=\"ea-expand-icon eap-icon-ea-expand-plus\"><\/i> How can OPC HDA data be saved into MS SQL Server?<\/a><\/h3><div class=\"sp-collapse spcollapse \" id=\"collapse18201\" data-parent=\"#sp-ea-1820\" role=\"region\" aria-labelledby=\"ea-header-18201\"> <div class=\"ea-body\"><p><span class=\"TextRun SCXW102355033 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW102355033 BCX0\">OPC Easy Archiver saves OPC HDA data directly into MS SQL Server, automatically writing historical process values into structured database tables.<\/span><\/span><span class=\"EOP SCXW102355033 BCX0\" data-ccp-props=\"{}\">\u00a0<\/span><\/p><\/div><\/div><\/div><div class=\"ea-card sp-ea-single\"><h3 class=\"ea-header\"><a class=\"collapsed\" id=\"ea-header-18202\" role=\"button\" data-sptoggle=\"spcollapse\" data-sptarget=\"#collapse18202\" aria-controls=\"collapse18202\" href=\"#\" aria-expanded=\"false\" tabindex=\"0\"><i aria-hidden=\"true\" role=\"presentation\" class=\"ea-expand-icon eap-icon-ea-expand-plus\"><\/i> Why do industries use MS SQL Server for OPC HDA data?<\/a><\/h3><div class=\"sp-collapse spcollapse \" id=\"collapse18202\" data-parent=\"#sp-ea-1820\" role=\"region\" aria-labelledby=\"ea-header-18202\"> <div class=\"ea-body\"><p><span class=\"TextRun SCXW67467767 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW67467767 BCX0\">OPC Easy Archiver stores OPC HDA data in MS SQL Server, enabling centralized historical data management and fast access for reporting and analytics.<\/span><\/span><span class=\"EOP SCXW67467767 BCX0\" data-ccp-props=\"{}\">\u00a0<\/span><\/p><\/div><\/div><\/div><div class=\"ea-card sp-ea-single\"><h3 class=\"ea-header\"><a class=\"collapsed\" id=\"ea-header-18203\" role=\"button\" data-sptoggle=\"spcollapse\" data-sptarget=\"#collapse18203\" aria-controls=\"collapse18203\" href=\"#\" aria-expanded=\"false\" tabindex=\"0\"><i aria-hidden=\"true\" role=\"presentation\" class=\"ea-expand-icon eap-icon-ea-expand-plus\"><\/i> Can historical OPC data be used for reporting and analytics?<\/a><\/h3><div class=\"sp-collapse spcollapse \" id=\"collapse18203\" data-parent=\"#sp-ea-1820\" role=\"region\" aria-labelledby=\"ea-header-18203\"> <div class=\"ea-body\"><p><span class=\"TextRun SCXW242917041 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW242917041 BCX0\">OPC Easy Archiver delivers OPC HDA data into MS SQL Server, making it\u00a0<\/span><span class=\"NormalTextRun SCXW242917041 BCX0\">immediately<\/span><span class=\"NormalTextRun SCXW242917041 BCX0\">\u00a0available for reporting, dashboards, and advanced analytics tools.<\/span><\/span><span class=\"EOP SCXW242917041 BCX0\" data-ccp-props=\"{}\">\u00a0<\/span><\/p><\/div><\/div><\/div><div class=\"ea-card sp-ea-single\"><h3 class=\"ea-header\"><a class=\"collapsed\" id=\"ea-header-18204\" role=\"button\" data-sptoggle=\"spcollapse\" data-sptarget=\"#collapse18204\" aria-controls=\"collapse18204\" href=\"#\" aria-expanded=\"false\" tabindex=\"0\"><i aria-hidden=\"true\" role=\"presentation\" class=\"ea-expand-icon eap-icon-ea-expand-plus\"><\/i> How is OPC HDA data integration with databases simplified? <\/a><\/h3><div class=\"sp-collapse spcollapse \" id=\"collapse18204\" data-parent=\"#sp-ea-1820\" role=\"region\" aria-labelledby=\"ea-header-18204\"> <div class=\"ea-body\"><p><span class=\"TextRun SCXW183469008 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW183469008 BCX0\">OPC Easy Archiver simplifies OPC HDA integration with MS SQL Server, automatically mapping OPC tags to database tables without custom coding.<\/span><\/span><span class=\"EOP SCXW183469008 BCX0\" data-ccp-props=\"{}\">\u00a0<\/span><\/p><\/div><\/div><\/div><script type=\"application\/ld+json\">{ \"@context\": \"https:\/\/schema.org\", \"@type\": \"FAQPage\", \"@id\": \"sp-ea-schema-1820-69edfe4b2a7db\", \"mainEntity\": [{ \"@type\": \"Question\", \"name\": \"What is OPC HDA and how is it collected in industrial systems? \", \"acceptedAnswer\": { \"@type\": \"Answer\", \"text\": \"OPC Easy Archiver collects OPC HDA (Historical Data Access) data directly from OPC servers, capturing archived values, timestamps, and process history for storage and analysis in MS SQL Server.\u00a0\" } },{ \"@type\": \"Question\", \"name\": \"How can OPC HDA data be saved into MS SQL Server?\", \"acceptedAnswer\": { \"@type\": \"Answer\", \"text\": \"OPC Easy Archiver saves OPC HDA data directly into MS SQL Server, automatically writing historical process values into structured database tables.\u00a0\" } },{ \"@type\": \"Question\", \"name\": \"Why do industries use MS SQL Server for OPC HDA data?\", \"acceptedAnswer\": { \"@type\": \"Answer\", \"text\": \"OPC Easy Archiver stores OPC HDA data in MS SQL Server, enabling centralized historical data management and fast access for reporting and analytics.\u00a0\" } },{ \"@type\": \"Question\", \"name\": \" Can historical OPC data be used for reporting and analytics?\", \"acceptedAnswer\": { \"@type\": \"Answer\", \"text\": \"OPC Easy Archiver delivers OPC HDA data into MS SQL Server, making it\u00a0immediately\u00a0available for reporting, dashboards, and advanced analytics tools.\u00a0\" } },{ \"@type\": \"Question\", \"name\": \"How is OPC HDA data integration with databases simplified? \", \"acceptedAnswer\": { \"@type\": \"Answer\", \"text\": \"OPC Easy Archiver simplifies OPC HDA integration with MS SQL Server, automatically mapping OPC tags to database tables without custom coding.\u00a0\" } }] }<\/script><\/div><\/div>\r\n","protected":false},"excerpt":{"rendered":"<p>Collecting historical OPC HDA data and storing it in MS SQL Server is essential for industrial reporting, analytics, and compliance. Using OPC Easy Archiver, engineers<\/p>\n","protected":false},"author":1,"featured_media":1695,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[189],"tags":[53],"class_list":["post-451","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-opc-data-archiving","tag-opc-easy-archiver"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>OPC HDA to MS SQL: Step-by-Step Guide Using OPC Easy Archiver<\/title>\n<meta name=\"description\" content=\"Learn how to collect OPC HDA historical data and store it in MS SQL Server using OPC Easy Archiver. Step-by-step guide for industrial data logging and database integration.\" \/>\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\/collect-opc-hda-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"OPC HDA to MS SQL: Step-by-Step Guide Using OPC Easy Archiver\" \/>\n<meta property=\"og:description\" content=\"Learn how to collect OPC HDA historical data and store it in MS SQL Server using OPC Easy Archiver. Step-by-step guide for industrial data logging and database integration.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/integrationobjects.com\/blog\/collect-opc-hda-data\/\" \/>\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=\"2025-04-17T09:51:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-13T08:09:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/integrationobjects.com\/blog\/wp-content\/uploads\/2019\/10\/Collect-and-store-OPC-HDA-data-into-a-MS-SQL-database-\u2013-Demo-Video.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"3 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"OPC HDA to MS SQL: Step-by-Step Guide Using OPC Easy Archiver","description":"Learn how to collect OPC HDA historical data and store it in MS SQL Server using OPC Easy Archiver. Step-by-step guide for industrial data logging and database integration.","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\/collect-opc-hda-data\/","og_locale":"en_US","og_type":"article","og_title":"OPC HDA to MS SQL: Step-by-Step Guide Using OPC Easy Archiver","og_description":"Learn how to collect OPC HDA historical data and store it in MS SQL Server using OPC Easy Archiver. Step-by-step guide for industrial data logging and database integration.","og_url":"https:\/\/integrationobjects.com\/blog\/collect-opc-hda-data\/","og_site_name":"OPC Blog","article_publisher":"https:\/\/www.facebook.com\/Integration.Objects.OPC\/","article_published_time":"2025-04-17T09:51:17+00:00","article_modified_time":"2026-04-13T08:09:36+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/integrationobjects.com\/blog\/wp-content\/uploads\/2019\/10\/Collect-and-store-OPC-HDA-data-into-a-MS-SQL-database-\u2013-Demo-Video.jpg","type":"image\/jpeg"}],"author":"OPCBlogAdmin","twitter_card":"summary_large_image","twitter_creator":"@IntegObjects","twitter_site":"@IntegObjects","twitter_misc":{"Written by":"OPCBlogAdmin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/integrationobjects.com\/blog\/collect-opc-hda-data\/","url":"https:\/\/integrationobjects.com\/blog\/collect-opc-hda-data\/","name":"OPC HDA to MS SQL: Step-by-Step Guide Using OPC Easy Archiver","isPartOf":{"@id":"https:\/\/integrationobjects.com\/blog-\/#website"},"primaryImageOfPage":{"@id":"https:\/\/integrationobjects.com\/blog\/collect-opc-hda-data\/#primaryimage"},"image":{"@id":"https:\/\/integrationobjects.com\/blog\/collect-opc-hda-data\/#primaryimage"},"thumbnailUrl":"https:\/\/integrationobjects.com\/blog\/wp-content\/uploads\/2019\/10\/Collect-and-store-OPC-HDA-data-into-a-MS-SQL-database-\u2013-Demo-Video.jpg","datePublished":"2025-04-17T09:51:17+00:00","dateModified":"2026-04-13T08:09:36+00:00","author":{"@id":"https:\/\/integrationobjects.com\/blog-\/#\/schema\/person\/6efbaf488a07e418b93ff77f00af386b"},"description":"Learn how to collect OPC HDA historical data and store it in MS SQL Server using OPC Easy Archiver. Step-by-step guide for industrial data logging and database integration.","breadcrumb":{"@id":"https:\/\/integrationobjects.com\/blog\/collect-opc-hda-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/integrationobjects.com\/blog\/collect-opc-hda-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/integrationobjects.com\/blog\/collect-opc-hda-data\/#primaryimage","url":"https:\/\/integrationobjects.com\/blog\/wp-content\/uploads\/2019\/10\/Collect-and-store-OPC-HDA-data-into-a-MS-SQL-database-\u2013-Demo-Video.jpg","contentUrl":"https:\/\/integrationobjects.com\/blog\/wp-content\/uploads\/2019\/10\/Collect-and-store-OPC-HDA-data-into-a-MS-SQL-database-\u2013-Demo-Video.jpg","width":1920,"height":1080,"caption":"OPC HDA to MS SQL"},{"@type":"BreadcrumbList","@id":"https:\/\/integrationobjects.com\/blog\/collect-opc-hda-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/integrationobjects.com\/blog-\/"},{"@type":"ListItem","position":2,"name":"How to Collect OPC HDA Data and Store It in MS SQL Server Using OPC Easy Archiver"}]},{"@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\/451","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=451"}],"version-history":[{"count":12,"href":"https:\/\/integrationobjects.com\/blog\/wp-json\/wp\/v2\/posts\/451\/revisions"}],"predecessor-version":[{"id":1696,"href":"https:\/\/integrationobjects.com\/blog\/wp-json\/wp\/v2\/posts\/451\/revisions\/1696"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/integrationobjects.com\/blog\/wp-json\/wp\/v2\/media\/1695"}],"wp:attachment":[{"href":"https:\/\/integrationobjects.com\/blog\/wp-json\/wp\/v2\/media?parent=451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/integrationobjects.com\/blog\/wp-json\/wp\/v2\/categories?post=451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/integrationobjects.com\/blog\/wp-json\/wp\/v2\/tags?post=451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}