| import{_ as a,r as s,o as c,c as r,b as t,d as e,a as i,e as n}from"./app-CMFulpLG.js";const d={},l=t("h1",{id:"ignition-iotdb-connector",tabindex:"-1"},[t("a",{class:"header-anchor",href:"#ignition-iotdb-connector"},[t("span",null,"Ignition-IoTDB Connector")])],-1),p=t("h2",{id:"_1、product-overview",tabindex:"-1"},[t("a",{class:"header-anchor",href:"#_1、product-overview"},[t("span",null,"1、Product Overview")])],-1),g=t("ol",null,[t("li",null,"Introduction to Ignition")],-1),h={href:"https://docs.inductiveautomation.com/docs/8.1/getting-started/introducing-ignition",target:"_blank",rel:"noopener noreferrer"},u=n('<ol start="2"><li><p>Introduction to the Ignition-IoTDB Connector</p><p>The ignition-IoTDB Connector is divided into two modules: the ignition-IoTDB Connector,Ignition-IoTDB With JDBC。 Among them:</p><ul><li>Ignition-IoTDB Connector: Provides the ability to store data collected by Ignition into IoTDB, and also supports data reading in Components. It injects script interfaces such as <code>system. iotdb. insert</code>and<code>system. iotdb. query</code>to facilitate programming in Ignition</li><li>Ignition-IoTDB With JDBC: Ignition-IoTDB With JDBC can be used in the<code>Transaction Groups</code>module and is not applicable to the<code>Tag Historian</code>module. It can be used for custom writing and querying.</li></ul><p>The specific relationship and content between the two modules and ignition are shown in the following figure.</p><figure><img src="https://alioss.timecho.com/docs/img/20240703114443.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure></li></ol><h2 id="_2、installation-requirements" tabindex="-1"><a class="header-anchor" href="#_2、installation-requirements"><span>2、Installation Requirements</span></a></h2>',2),m=t("thead",null,[t("tr",null,[t("th",{style:{"text-align":"center"}},[t("strong",null,"Preparation Content")]),t("th",{style:{"text-align":"center"}},"Version Requirements")])],-1),f=t("td",{style:{"text-align":"center"}},"IoTDB",-1),I={style:{"text-align":"center"}},b={href:"https://www.timecho.com/docs/UserGuide/latest/Deployment-and-Maintenance/IoTDB-Package_timecho.html",target:"_blank",rel:"noopener noreferrer"},D=t("td",{style:{"text-align":"center"}},"Ignition",-1),T={style:{"text-align":"center"}},y={href:"https://docs.inductiveautomation.com/docs/8.1/getting-started/installing-and-upgrading",target:"_blank",rel:"noopener noreferrer"},_=t("tr",null,[t("td",{style:{"text-align":"center"}},"Ignition-IoTDB Connector module"),t("td",{style:{"text-align":"center"}},"Please contact Business to obtain")],-1),B=t("td",{style:{"text-align":"center"}},"Ignition-IoTDB With JDBC module",-1),v={style:{"text-align":"center"}},w={href:"https://repo1.maven.org/maven2/org/apache/iotdb/iotdb-jdbc/",target:"_blank",rel:"noopener noreferrer"},C=n(`<h2 id="_3、instruction-manual-for-ignition-iotdb-connector" tabindex="-1"><a class="header-anchor" href="#_3、instruction-manual-for-ignition-iotdb-connector"><span>3、Instruction Manual For Ignition-IoTDB Connector</span></a></h2><h3 id="_1、introduce" tabindex="-1"><a class="header-anchor" href="#_1、introduce"><span>1、Introduce</span></a></h3><p>The Ignition-IoTDB Connector module can store data in a database connection associated with the historical database provider. The data is directly stored in a table in the SQL database based on its data type, as well as a millisecond timestamp. Store data only when making changes based on the value pattern and dead zone settings on each label, thus avoiding duplicate and unnecessary data storage.</p><p>The Ignition-IoTDB Connector provides the ability to store the data collected by Ignition into IoTDB.</p><h3 id="_2、installation-steps" tabindex="-1"><a class="header-anchor" href="#_2、installation-steps"><span>2、Installation Steps</span></a></h3><p>Step 1: Enter the <code>Configuration</code> - <code>System</code> - <code>Modules</code> module and click on the <code>Install or Upgrade a Module</code> button at the bottom</p><figure><img src="https://alioss.timecho.com/docs/img/Ignition-IoTDB连接器-1.PNG" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>Step 2: Select the obtained <code>modl</code>, select the file and upload it, click <code>Install</code>, and trust the relevant certificate.</p><figure><img src="https://alioss.timecho.com/docs/img/20240703-151030.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>Step 3: After installation is completed, you can see the following content</p><figure><img src="https://alioss.timecho.com/docs/img/Ignition-IoTDB连接器-3.PNG" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>Step 4: Enter the <code>Configuration</code> - <code>Tags</code> - <code>History</code> module and click on <code>Create new Historical Tag Provider</code> below</p><figure><img src="https://alioss.timecho.com/docs/img/Ignition-IoTDB连接器-4.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>Step 5: Select <code>IoTDB</code> and fill in the configuration information</p><figure><img src="https://alioss.timecho.com/docs/img/Ignition-IoTDB连接器-5.PNG" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>The configuration content is as follows:</p><table><tr><th>Name</th><th>Description</th><th>Default Value</th><th>Notes</th></tr><tr><th colspan="4">Main</th></tr><tr><td>Provider Name</td><td>Provider Name</td><td>-</td><td></td></tr><tr><td>Enabled</td><td></td><td>true</td><td>The provider can only be used when it is true</td></tr><tr><td>Description</td><td>Description</td><td>-</td><td></td></tr><tr><th colspan="4">IoTDB Settings</th></tr><tr><td>Host Name</td><td>The address of the target IoTDB instance</td><td>-</td><td></td></tr><tr><td>Port Number</td><td>The port of the target IoTDB instance</td><td>6667</td><td></td></tr><tr><td>Username</td><td>The username of the target IoTDB</td><td>-</td><td></td></tr><tr><td>Password</td><td>Password for target IoTDB</td><td>-</td><td></td></tr><tr><td>Database Name</td><td>The database name to be stored, starting with root, such as root db</td><td>-</td><td></td></tr><tr><td>Pool Size</td><td>Size of SessionPool</td><td>50</td><td>Can be configured as needed</td></tr><tr><th colspan="2">Store and Forward Settings</th><td>Just keep it as default</td><td></td></tr></table><h3 id="_3、instructions" tabindex="-1"><a class="header-anchor" href="#_3、instructions"><span>3、Instructions</span></a></h3><h4 id="configure-historical-data-storage" tabindex="-1"><a class="header-anchor" href="#configure-historical-data-storage"><span>Configure Historical Data Storage</span></a></h4><ul><li><p>After configuring the <code>Provider</code>, you can use the <code>IoTDB Tag Historian</code> in the <code>Designer</code>, just like using other <code>Providers</code>. Right click on the corresponding <code>Tag</code> and select <code>Edit Tag (s) </code>, then select the History category in the Tag Editor</p><figure><img src="https://alioss.timecho.com/docs/img/ignition-7.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure></li><li><p>Set <code>History Disabled</code> to <code>true</code>, select <code>Storage Provider</code> as the <code>Provider</code> created in the previous step, configure other parameters as needed, click <code>OK</code>, and then save the project. At this point, the data will be continuously stored in the 'IoTDB' instance according to the set content.</p><figure><img src="https://alioss.timecho.com/docs/img/ignition-8.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure></li></ul><h4 id="read-data" tabindex="-1"><a class="header-anchor" href="#read-data"><span>Read Data</span></a></h4><ul><li><p>You can also directly select the tags stored in IoTDB under the Data tab of the Report</p><figure><img src="https://alioss.timecho.com/docs/img/ignition-9.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure></li><li><p>You can also directly browse relevant data in Components</p><figure><img src="https://alioss.timecho.com/docs/img/ignition-10.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure></li></ul><h4 id="script-module-this-function-can-interact-with-iotdb" tabindex="-1"><a class="header-anchor" href="#script-module-this-function-can-interact-with-iotdb"><span>Script module: This function can interact with IoTDB</span></a></h4><ol><li>system.iotdb.insert：</li></ol><ul><li><p>Script Description: Write data to an IoTDB instance</p></li><li><p>Script Definition：</p><p><code>system.iotdb.insert(historian, deviceId, timestamps, measurementNames, measurementValues)</code></p></li><li><p>Parameter：</p><ul><li><code>str historian</code>：The name of the corresponding IoTDB Tag Historian Provider</li><li><code>str deviceId</code>：The deviceId written, excluding the configured database, such as Sine</li><li><code>long[] timestamps</code>：List of timestamps for written data points</li><li><code>str[] measurementNames</code>：List of names for written physical quantities</li><li><code>str[][] measurementValues</code>：The written data point data corresponds to the timestamp list and physical quantity name list</li></ul></li><li><p>Return Value: None</p></li><li><p>Available Range：Client, Designer, Gateway</p></li><li><p>Usage example:</p><div class="language-bash line-numbers-mode" data-ext="sh" data-title="sh"><pre class="language-bash"><code>system.iotdb.insert<span class="token punctuation">(</span><span class="token string">"IoTDB"</span>, <span class="token string">"Sine"</span>, <span class="token punctuation">[</span>system.date.now<span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">]</span>,<span class="token punctuation">[</span><span class="token string">"measure1"</span>,<span class="token string">"measure2"</span><span class="token punctuation">]</span>,<span class="token punctuation">[</span><span class="token punctuation">[</span><span class="token string">"val1"</span>,<span class="token string">"val2"</span><span class="token punctuation">]</span><span class="token punctuation">]</span><span class="token punctuation">)</span> |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><h2 id="_4、ignition-iotdb-with-jdbc" tabindex="-1"><a class="header-anchor" href="#_4、ignition-iotdb-with-jdbc"><span>4、Ignition-IoTDB With JDBC</span></a></h2><h3 id="_1、introduce-1" tabindex="-1"><a class="header-anchor" href="#_1、introduce-1"><span>1、Introduce</span></a></h3><p>Ignition-IoTDB With JDBC provides a JDBC driver that allows users to connect and query the Ignition IoTDB database using standard JDBC APIs</p><h3 id="_2、installation-steps-1" tabindex="-1"><a class="header-anchor" href="#_2、installation-steps-1"><span>2、Installation Steps</span></a></h3><p>Step 1: Enter the <code>Configuration</code> - <code>Databases</code> -<code>Drivers</code> module and create the <code>Translator</code></p><figure><img src="https://alioss.timecho.com/docs/img/Ignition-IoTDB With JDBC-1.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>Step 2: Enter the <code>Configuration</code> - <code>Databases</code> - <code>Drivers</code> module, create a <code>JDBC Driver</code> , select the <code>Translator</code> configured in the previous step, and upload the downloaded <code>IoTDB JDBC</code>. Set the Classname to <code>org. apache. iotdb. jdbc.IoTDBDriver</code></p><figure><img src="https://alioss.timecho.com/docs/img/Ignition-IoTDB With JDBC-2.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>Step 3: Enter the <code>Configuration</code> - <code>Databases</code> - <code>Connections</code> module, create a new <code>Connections</code> , select the<code>IoTDB Driver</code> created in the previous step for <code>JDBC Driver</code>, configure the relevant information, and save it to use</p><figure><img src="https://alioss.timecho.com/docs/img/Ignition-IoTDB With JDBC-3.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><h3 id="_3、instructions-1" tabindex="-1"><a class="header-anchor" href="#_3、instructions-1"><span>3、Instructions</span></a></h3><h4 id="data-writing" tabindex="-1"><a class="header-anchor" href="#data-writing"><span>Data Writing</span></a></h4><p>Select the previously created <code>Connection</code> from the <code>Data Source</code> in the <code>Transaction Groups</code></p><ul><li><code>Table name </code>needs to be set as the complete device path starting from root</li><li>Uncheck <code>Automatically create table</code></li><li><code>Store timestame to</code> configure as time</li></ul><p>Do not select other options, set the fields, and after <code>enabled</code> , the data will be installed and stored in the corresponding IoTDB</p><figure><img src="https://alioss.timecho.com/docs/img/数据写入-1.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><h4 id="query" tabindex="-1"><a class="header-anchor" href="#query"><span>Query</span></a></h4><ul><li>Select <code>Data Source</code> in the <code>Database Query Browser</code> and select the previously created <code>Connection</code> to write an SQL statement to query the data in IoTDB</li></ul><figure><img src="https://alioss.timecho.com/docs/img/数据查询-ponz.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure>`,47);function x(S,k){const o=s("ExternalLinkIcon");return c(),r("div",null,[l,p,g,t("p",null,[e("Ignition is a web-based monitoring and data acquisition tool (SCADA) - an open and scalable universal platform. Ignition allows you to more easily control, track, display, and analyze all data of your enterprise, enhancing business capabilities. For more introduction details, please refer to "),t("a",h,[e("Ignition官网"),i(o)])]),u,t("table",null,[m,t("tbody",null,[t("tr",null,[f,t("td",I,[e("Version 1.3.1 and above are required to be installed, please refer to IoTDB for installation "),t("a",b,[e("Deployment Guidance"),i(o)])])]),t("tr",null,[D,t("td",T,[e("Requirement: 8.1 version (8.1.37 and above) of version 8.1 must be installed. Please refer to the Ignition official website for installation "),t("a",y,[e("Installation Guidance"),i(o)]),e("（Other versions are compatible, please contact the business department for more information）")])]),_,t("tr",null,[B,t("td",v,[e("Download address："),t("a",w,[e("https://repo1.maven.org/maven2/org/apache/iotdb/iotdb-jdbc/"),i(o)])])])])]),C])}const q=a(d,[["render",x],["__file","Ignition-IoTDB-plugin_timecho.html.vue"]]),P=JSON.parse('{"path":"/UserGuide/latest/Ecosystem-Integration/Ignition-IoTDB-plugin_timecho.html","title":"Ignition-IoTDB Connector","lang":"en-US","frontmatter":{"description":"Ignition-IoTDB Connector 1、Product Overview Introduction to Ignition Ignition is a web-based monitoring and data acquisition tool (SCADA) - an open and scalable universal platfo...","head":[["link",{"rel":"alternate","hreflang":"zh-cn","href":"https://iotdb.apache.org/zh/UserGuide/latest/Ecosystem-Integration/Ignition-IoTDB-plugin_timecho.html"}],["meta",{"property":"og:url","content":"https://iotdb.apache.org/UserGuide/latest/Ecosystem-Integration/Ignition-IoTDB-plugin_timecho.html"}],["meta",{"property":"og:site_name","content":"IoTDB Website"}],["meta",{"property":"og:title","content":"Ignition-IoTDB Connector"}],["meta",{"property":"og:description","content":"Ignition-IoTDB Connector 1、Product Overview Introduction to Ignition Ignition is a web-based monitoring and data acquisition tool (SCADA) - an open and scalable universal platfo..."}],["meta",{"property":"og:type","content":"article"}],["meta",{"property":"og:image","content":"https://alioss.timecho.com/docs/img/20240703114443.png"}],["meta",{"property":"og:locale","content":"en-US"}],["meta",{"property":"og:locale:alternate","content":"zh-CN"}],["meta",{"property":"og:updated_time","content":"2024-07-17T09:47:14.000Z"}],["meta",{"property":"article:modified_time","content":"2024-07-17T09:47:14.000Z"}],["script",{"type":"application/ld+json"},"{\\"@context\\":\\"https://schema.org\\",\\"@type\\":\\"Article\\",\\"headline\\":\\"Ignition-IoTDB Connector\\",\\"image\\":[\\"https://alioss.timecho.com/docs/img/20240703114443.png\\",\\"https://alioss.timecho.com/docs/img/Ignition-IoTDB%E8%BF%9E%E6%8E%A5%E5%99%A8-1.PNG\\",\\"https://alioss.timecho.com/docs/img/20240703-151030.png\\",\\"https://alioss.timecho.com/docs/img/Ignition-IoTDB%E8%BF%9E%E6%8E%A5%E5%99%A8-3.PNG\\",\\"https://alioss.timecho.com/docs/img/Ignition-IoTDB%E8%BF%9E%E6%8E%A5%E5%99%A8-4.png\\",\\"https://alioss.timecho.com/docs/img/Ignition-IoTDB%E8%BF%9E%E6%8E%A5%E5%99%A8-5.PNG\\",\\"https://alioss.timecho.com/docs/img/ignition-7.png\\",\\"https://alioss.timecho.com/docs/img/ignition-8.png\\",\\"https://alioss.timecho.com/docs/img/ignition-9.png\\",\\"https://alioss.timecho.com/docs/img/ignition-10.png\\",\\"https://alioss.timecho.com/docs/img/Ignition-IoTDB%20With%20JDBC-1.png\\",\\"https://alioss.timecho.com/docs/img/Ignition-IoTDB%20With%20JDBC-2.png\\",\\"https://alioss.timecho.com/docs/img/Ignition-IoTDB%20With%20JDBC-3.png\\",\\"https://alioss.timecho.com/docs/img/%E6%95%B0%E6%8D%AE%E5%86%99%E5%85%A5-1.png\\",\\"https://alioss.timecho.com/docs/img/%E6%95%B0%E6%8D%AE%E6%9F%A5%E8%AF%A2-ponz.png\\"],\\"dateModified\\":\\"2024-07-17T09:47:14.000Z\\",\\"author\\":[]}"]]},"headers":[{"level":2,"title":"1、Product Overview","slug":"_1、product-overview","link":"#_1、product-overview","children":[]},{"level":2,"title":"2、Installation Requirements","slug":"_2、installation-requirements","link":"#_2、installation-requirements","children":[]},{"level":2,"title":"3、Instruction Manual For Ignition-IoTDB Connector","slug":"_3、instruction-manual-for-ignition-iotdb-connector","link":"#_3、instruction-manual-for-ignition-iotdb-connector","children":[{"level":3,"title":"1、Introduce","slug":"_1、introduce","link":"#_1、introduce","children":[]},{"level":3,"title":"2、Installation Steps","slug":"_2、installation-steps","link":"#_2、installation-steps","children":[]},{"level":3,"title":"3、Instructions","slug":"_3、instructions","link":"#_3、instructions","children":[]}]},{"level":2,"title":"4、Ignition-IoTDB With JDBC","slug":"_4、ignition-iotdb-with-jdbc","link":"#_4、ignition-iotdb-with-jdbc","children":[{"level":3,"title":"1、Introduce","slug":"_1、introduce-1","link":"#_1、introduce-1","children":[]},{"level":3,"title":"2、Installation Steps","slug":"_2、installation-steps-1","link":"#_2、installation-steps-1","children":[]},{"level":3,"title":"3、Instructions","slug":"_3、instructions-1","link":"#_3、instructions-1","children":[]}]}],"git":{"createdTime":1719993846000,"updatedTime":1721209634000,"contributors":[{"name":"CritasWang","email":"critas@outlook.com","commits":1}]},"readingTime":{"minutes":4.59,"words":1378},"filePathRelative":"UserGuide/latest/Ecosystem-Integration/Ignition-IoTDB-plugin_timecho.md","localizedDate":"July 3, 2024","autoDesc":true}');export{q as comp,P as data}; |
