{"id":547,"date":"2024-01-26T13:24:24","date_gmt":"2024-01-26T12:24:24","guid":{"rendered":"https:\/\/word.mondoit.de\/?page_id=547"},"modified":"2024-05-03T13:12:14","modified_gmt":"2024-05-03T11:12:14","slug":"database-management","status":"publish","type":"page","link":"https:\/\/word-automation.com\/en\/database-management\/","title":{"rendered":"Database managment"},"content":{"rendered":"<div data-elementor-type=\"wp-page\" data-elementor-id=\"547\" class=\"elementor elementor-547\" data-elementor-settings=\"{&quot;ha_cmc_init_switcher&quot;:&quot;no&quot;}\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-14d87ab elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"14d87ab\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;,&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t\t<div class=\"elementor-background-overlay\"><\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-090bed3 elementor-invisible\" data-id=\"090bed3\" data-element_type=\"column\" data-settings=\"{&quot;animation&quot;:&quot;fadeIn&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-14d7680 elementor-widget elementor-widget-heading\" data-id=\"14d7680\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-default\">Database managment<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5ff315e elementor-widget elementor-widget-text-editor\" data-id=\"5ff315e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Some machine operators still use Excel files to document their data. document their data. In this article, we will show you why database is always worthwhile and how you can save machine data from an S7\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6b35092 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6b35092\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-71bf556\" data-id=\"71bf556\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-54903e8 elementor-widget elementor-widget-spacer\" data-id=\"54903e8\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8d2af9e elementor-widget elementor-widget-text-editor\" data-id=\"8d2af9e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p dir=\"auto\"><span data-font=\"font-montserrat\">In today's world, data is becoming ncreasingly important as it is generated\ngenerated, stored and processed everywhere. Be it for customer and supplier contact with customers and suppliers, in production or\nadministrative matters - data is the most important asset. <\/span><\/p><p dir=\"auto\"><span data-font=\"font-montserrat\">Some machine operators still use Excel files to document their data. document their data. In this article, we will show you why database is always worthwhile and how you can save machine data from an S7<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bccde3e elementor-widget elementor-widget-spacer\" data-id=\"bccde3e\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-82d01d0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"82d01d0\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6ad39ea\" data-id=\"6ad39ea\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-cb3ddeb elementor-widget elementor-widget-image\" data-id=\"cb3ddeb\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"1631\" height=\"376\" src=\"https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/DMBS.png\" class=\"attachment-full size-full wp-image-549\" alt=\"\" srcset=\"https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/DMBS.png 1631w, https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/DMBS-300x69.png 300w, https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/DMBS-1024x236.png 1024w, https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/DMBS-768x177.png 768w, https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/DMBS-1536x354.png 1536w\" sizes=\"(max-width: 1631px) 100vw, 1631px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-25d5cb7 elementor-widget elementor-widget-spacer\" data-id=\"25d5cb7\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a1239fe elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a1239fe\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div data-ha-element-link=\"{&quot;url&quot;:&quot;\\\/database-management\\\/#opcua&quot;,&quot;is_external&quot;:&quot;&quot;,&quot;nofollow&quot;:&quot;&quot;}\" style=\"cursor: pointer\" class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-8f34610 hover-scale-block\" data-id=\"8f34610\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-072fac5 ha-has-bg-overlay elementor-widget elementor-widget-text-editor\" data-id=\"072fac5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\tDatabase managment\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e49d84d hover-scale-image-block elementor-widget elementor-widget-image\" data-id=\"e49d84d\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1492\" height=\"921\" src=\"https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/OPC_UA.jpg\" class=\"attachment-full size-full wp-image-553\" alt=\"\" srcset=\"https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/OPC_UA.jpg 1492w, https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/OPC_UA-300x185.jpg 300w, https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/OPC_UA-1024x632.jpg 1024w, https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/OPC_UA-768x474.jpg 768w\" sizes=\"(max-width: 1492px) 100vw, 1492px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7dd17b3 ha-has-bg-overlay elementor-widget elementor-widget-text-editor\" data-id=\"7dd17b3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h4>OPC UA\u00a0<\/h4><p><em>\"Structured data all the way to the cloud\"<\/em>\u00a0<br \/><br \/><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div data-ha-element-link=\"{&quot;url&quot;:&quot;\\\/database-management\\\/#s7&quot;,&quot;is_external&quot;:&quot;&quot;,&quot;nofollow&quot;:&quot;&quot;}\" style=\"cursor: pointer\" class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-2459ea1 hover-scale-block\" data-id=\"2459ea1\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d36e0aa ha-has-bg-overlay elementor-widget elementor-widget-text-editor\" data-id=\"d36e0aa\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\tDatabase managment\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2b2babb hover-scale-image-block elementor-widget elementor-widget-image\" data-id=\"2b2babb\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1352\" height=\"537\" src=\"https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/S7-Machinendaten.png\" class=\"attachment-full size-full wp-image-552\" alt=\"\" srcset=\"https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/S7-Machinendaten.png 1352w, https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/S7-Machinendaten-300x119.png 300w, https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/S7-Machinendaten-1024x407.png 1024w, https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/S7-Machinendaten-768x305.png 768w\" sizes=\"(max-width: 1352px) 100vw, 1352px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fe29b20 ha-has-bg-overlay elementor-widget elementor-widget-text-editor\" data-id=\"fe29b20\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h4>S7 Machine DATA in SQL database<\/h4><p>To be able to work with extensive S7 machine data, we recommend an SQL database.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7775cc3 opcua elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7775cc3\" data-element_type=\"section\" id=\"opcua\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;,&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t\t<div class=\"elementor-background-overlay\"><\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b244098 elementor-invisible\" data-id=\"b244098\" data-element_type=\"column\" data-settings=\"{&quot;animation&quot;:&quot;fadeIn&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-47a3a10 elementor-widget elementor-widget-heading\" data-id=\"47a3a10\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-default\">OPC UA<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-070d85e elementor-widget elementor-widget-text-editor\" data-id=\"070d85e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><em data-font=\"font-montserrat\">\"Structured data all the way to the cloud\"<\/em><span data-font=\"font-montserrat\">\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-318bef6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"318bef6\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-6b9d8d6\" data-id=\"6b9d8d6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-446b287 elementor-widget elementor-widget-image\" data-id=\"446b287\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1210\" height=\"820\" src=\"https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/OPCUA.png\" class=\"attachment-full size-full wp-image-550\" alt=\"\" srcset=\"https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/OPCUA.png 1210w, https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/OPCUA-300x203.png 300w, https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/OPCUA-1024x694.png 1024w, https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/OPCUA-768x520.png 768w\" sizes=\"(max-width: 1210px) 100vw, 1210px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-7816327\" data-id=\"7816327\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2e47219 elementor-widget elementor-widget-text-editor\" data-id=\"2e47219\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p dir=\"auto\">The open, Ethernet-based communication standard OPC UA (Open Platform  Communications Unified Architecture) offers the best conditions for digitalisation. Ideal for communication between machines and vertically into the cloud. For real-time communication at field level, Siemens combines OPC UA with PROFINET in a shared Industrial Ethernet network.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ef29db2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ef29db2\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5f13924\" data-id=\"5f13924\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-87758ad elementor-widget elementor-widget-spacer\" data-id=\"87758ad\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-45aeee0 elementor-widget elementor-widget-elementskit-heading\" data-id=\"45aeee0\" data-element_type=\"widget\" data-widget_type=\"elementskit-heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"ekit-wid-con\" ><div class=\"ekit-heading elementskit-section-title-wraper text_left   ekit_heading_tablet-   ekit_heading_mobile-\"><h2 class=\"ekit-heading--title elementskit-section-title\">OPC UA <span><span>Client\/Server<\/span><\/span><\/h2><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-51a700b elementor-widget elementor-widget-text-editor\" data-id=\"51a700b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p dir=\"auto\">OPC UA with client\/server communication is widely used in automation widespread in automation.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-94df3d2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"94df3d2\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-f0a5925\" data-id=\"f0a5925\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bfffef0 elementor-widget elementor-widget-text-editor\" data-id=\"bfffef0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p dir=\"auto\">OPC UA with client\/server communication is widely used in automation. widespread in automation. In this proven \"one-to-one\" communication mechanism, each OPC UA client receives a point-to-point access to the data of the OPC UA server via point-to-point communication. UA server: The OPC UA client sends a request to the OPC UA server and receives a response from it.\nand receives a response from it.<\/p><p dir=\"auto\">This enables reliable, secure and encrypted data encrypted data exchange with reduced bandwidth and without data data loss, even if the environment and network quality are not optimal and network quality are not optimal and are subject to interference.<\/p><p dir=\"auto\">Client\/server communication is always based on TCP\/IP.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-110809b\" data-id=\"110809b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c8aa2e9 elementor-widget elementor-widget-image\" data-id=\"c8aa2e9\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1125\" height=\"837\" src=\"https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/OPC_UA_1.png\" class=\"attachment-full size-full wp-image-554\" alt=\"\" srcset=\"https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/OPC_UA_1.png 1125w, https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/OPC_UA_1-300x223.png 300w, https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/OPC_UA_1-1024x762.png 1024w, https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/OPC_UA_1-768x571.png 768w\" sizes=\"(max-width: 1125px) 100vw, 1125px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0dd36e2 s7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0dd36e2\" data-element_type=\"section\" id=\"s7\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;,&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t\t<div class=\"elementor-background-overlay\"><\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-aebfde9 elementor-invisible\" data-id=\"aebfde9\" data-element_type=\"column\" data-settings=\"{&quot;animation&quot;:&quot;fadeIn&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e0dbe88 elementor-widget elementor-widget-heading\" data-id=\"e0dbe88\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-default\">S7 Machine DATA in SQL database <\/h1>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4fdd480 elementor-widget elementor-widget-text-editor\" data-id=\"4fdd480\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>To be able to work with extensive S7 machine data, we recommend an SQL database.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-854716a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"854716a\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;,&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t\t<div class=\"elementor-background-overlay\"><\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-011d46e\" data-id=\"011d46e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9a56246 elementor-widget elementor-widget-spacer\" data-id=\"9a56246\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-057a7fe elementor-widget elementor-widget-text-editor\" data-id=\"057a7fe\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p dir=\"auto\"><span data-font=\"font-montserrat\">In order to be able to work with extensive S7 machine data, we recommend an SQL database. What exactly this is and how it\nworks is explained in the next step. Then we will show you how you can enter a data record from your Siemens S7 PLC into a database table into a database table.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b573e99 elementor-widget elementor-widget-image\" data-id=\"b573e99\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1454\" height=\"262\" src=\"https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/PLC_Datenbank.png\" class=\"attachment-full size-full wp-image-551\" alt=\"\" srcset=\"https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/PLC_Datenbank.png 1454w, https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/PLC_Datenbank-300x54.png 300w, https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/PLC_Datenbank-1024x185.png 1024w, https:\/\/word-automation.com\/wp-content\/uploads\/2024\/01\/PLC_Datenbank-768x138.png 768w\" sizes=\"(max-width: 1454px) 100vw, 1454px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-36c9f62 elementor-widget elementor-widget-text-editor\" data-id=\"36c9f62\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p dir=\"auto\">But first we would like to clarify the question of why you shoul use a database at all. You can simply store your manage your machine data in Excel tables and graphs, right?\nThat's not wrong, but a database offers decisive advantages:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8648728 ha-has-bg-overlay elementor-widget elementor-widget-text-editor\" data-id=\"8648728\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\tThat's not wrong, but a database brings decisive advantages:\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1a9d3f8 ha-has-bg-overlay elementor-widget elementor-widget-text-editor\" data-id=\"1a9d3f8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul dir=\"auto\"><li><span data-font=\"font-montserrat\">Multi-user\u00a0<\/span><\/li><li><span data-font=\"font-montserrat\">More security\u00a0<\/span><\/li><li><span data-font=\"font-montserrat\">Suitable for large amounts of data<\/span><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-880131a elementor-widget elementor-widget-spacer\" data-id=\"880131a\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-684d2da elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"684d2da\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-6fb6887\" data-id=\"6fb6887\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-78d0f23 elementor-widget elementor-widget-text-editor\" data-id=\"78d0f23\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p dir=\"auto\">As you can see, managing your machine data in a database offers database offers decisive advantages. To summarise, the central centralised data management simplifies all processes. Data from a database are also easier to read and manage. If you are searching\nfor certain data records, for example, this search can be completed in a\ndatabase can be completed in less than a second.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-8970d09\" data-id=\"8970d09\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7e4e852 ha-has-bg-overlay elementor-widget elementor-widget-text-editor\" data-id=\"7e4e852\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\tThat's not wrong, but a database brings decisive advantages:\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bddce7a ha-has-bg-overlay elementor-widget elementor-widget-text-editor\" data-id=\"bddce7a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul dir=\"auto\"><li><span data-font=\"font-montserrat\">High compatibility<\/span><\/li><li><span data-font=\"font-montserrat\">Reliable and fast <\/span><\/li><li><span data-font=\"font-montserrat\">High security standard <\/span><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3725a54 elementor-section-boxed elementor-section-height-default elementor-section-height-default elementor-invisible\" data-id=\"3725a54\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;,&quot;animation&quot;:&quot;fadeIn&quot;,&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t\t<div class=\"elementor-background-overlay\"><\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3654688\" data-id=\"3654688\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-96aca79 elementor-widget elementor-widget-spacer\" data-id=\"96aca79\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aa92bde elementor-widget elementor-widget-elementskit-heading\" data-id=\"aa92bde\" data-element_type=\"widget\" data-widget_type=\"elementskit-heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"ekit-wid-con\" ><div class=\"ekit-heading elementskit-section-title-wraper text_left   ekit_heading_tablet-   ekit_heading_mobile-\"><h2 class=\"ekit-heading--title elementskit-section-title\">Better than <span><span>Excel<\/span><\/span><\/h2><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-35c6806 elementor-widget elementor-widget-text-editor\" data-id=\"35c6806\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p dir=\"auto\"><span data-font=\"font-montserrat\">However, if you save your data in Excel files, the search is often time-consuming and cumbersome. Excel is therefore suitable for small data volumes that are required by a single person. An SQL database is the next logical step if you \nwant to store and manage larger amounts of data. Another plus point: Increased security of your data. Multi-user capability,\nthe possibility for several people to work with the data at the same time work with the data at the same time make your production more professional and\nmore efficient. <\/span><\/p><p dir=\"auto\"><span data-font=\"font-montserrat\">Databases are everywhere these days, even your Google searches are recorded in a structured database. With view of the increasing amount of data that we generate every day and have at our disposal every day, the importance of databases\ncannot be overlooked. <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-85b2b67 elementor-widget elementor-widget-text-editor\" data-id=\"85b2b67\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p dir=\"auto\">MySQL is recommended due to its longevity and popularity. It is perfect for getting started, which is why we will show you below in the article how you can write machine data from an S7 to an SQL database and vice versa.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f09413e elementor-widget elementor-widget-spacer\" data-id=\"f09413e\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9a64e1e elementor-widget elementor-widget-text-editor\" data-id=\"9a64e1e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p dir=\"auto\"><span data-font=\"font-montserrat\">Good data management is increasingly becoming a strategic <\/span><span data-font=\"font-montserrat\">competitive advantage for companies. Because today, data forms the foundation <\/span><span data-font=\"font-montserrat\">of all departments: Purchasing, production, sales, controlling. They all\u00a0<\/span><span data-font=\"font-montserrat\">rely on up-to-date and readily available information. Find out more and <\/span><span data-font=\"font-montserrat\">contact us.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-42b8180 elementor-align-left elementor-widget__width-initial elementor-widget elementor-widget-button\" data-id=\"42b8180\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-md elementor-animation-grow\" href=\"\/en\/kontakt\/\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">CONTACT US<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-373ba85 elementor-widget elementor-widget-spacer\" data-id=\"373ba85\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>Database management Einige Maschinenbetreiber nutzen auch heute noch Excel-Dateien, um ihre Daten zu dokumentieren. Wir zeigen Ihnen in diesem Artikel, warum sich eine Datenbank immer lohnt und wie Sie Maschinendaten einer S7 SPS in einer SQL-Datenbank speichern k\u00f6nnen.\u00a0 In der heutigen Zeit werden Daten immer wichtiger, da sie \u00fcberall generiert, gespeichert und verarbeitet werden. Sei [&hellip;]<\/p>","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"elementor_header_footer","meta":{"footnotes":""},"class_list":["post-547","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/word-automation.com\/en\/wp-json\/wp\/v2\/pages\/547","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/word-automation.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/word-automation.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/word-automation.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/word-automation.com\/en\/wp-json\/wp\/v2\/comments?post=547"}],"version-history":[{"count":91,"href":"https:\/\/word-automation.com\/en\/wp-json\/wp\/v2\/pages\/547\/revisions"}],"predecessor-version":[{"id":2274,"href":"https:\/\/word-automation.com\/en\/wp-json\/wp\/v2\/pages\/547\/revisions\/2274"}],"wp:attachment":[{"href":"https:\/\/word-automation.com\/en\/wp-json\/wp\/v2\/media?parent=547"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}