| import{_ as t,c as a,b as i,o as s}from"./app-Bhq43HqP.js";const n={};function o(l,e){return s(),a("div",null,e[0]||(e[0]=[i(`<h1 id="dataease" tabindex="-1"><a class="header-anchor" href="#dataease"><span>DataEase</span></a></h1><h2 id="product-overview" tabindex="-1"><a class="header-anchor" href="#product-overview"><span>Product Overview</span></a></h2><ol><li><p>Introduction to DataEase</p><p>DataEase is an open-source data visualization and analysis tool that provides a drag and drop interface, allowing users to easily create charts and dashboards. It supports MySQL SQL Server、Hive、ClickHouse、 Multiple data sources such as Dameng can be integrated into other applications. Can help users quickly gain insights into data and make decisions.For more detailed information, please refer to<a href="https://www.fit2cloud.com/dataease/index.html" target="_blank" rel="noopener noreferrer">DataEase official website</a></p><div style="text-align:center;"><img src="https://alioss.timecho.com/docs/img/DataEase2.png" alt="" style="width:60%;"></div></li><li><p>Introduction to the DataEase-IoTDB Connector</p><p>IoTDB can be efficiently integrated with DataEase through API data sources, and IoTDB data can be accessed through the Session interface using API data source plugins. This plugin supports customized data processing functions, providing users with greater flexibility and more diverse data operation options.</p><div style="text-align:center;"><img src="https://alioss.timecho.com/docs/img/DataEase-English2.png" alt="" style="width:70%;"></div></li></ol><h2 id="installation-requirements" tabindex="-1"><a class="header-anchor" href="#installation-requirements"><span>Installation Requirements</span></a></h2><table><thead><tr><th style="text-align:left;"><strong>Preparation Content</strong></th><th style="text-align:left;"><strong>Version Requirements</strong></th></tr></thead><tbody><tr><td style="text-align:left;">IoTDB</td><td style="text-align:left;">Version not required, please refer to installation IoTDB <a href="https://www.timecho.com/docs/zh/UserGuide/latest/Deployment-and-Maintenance/IoTDB-Package_timecho.html" target="_blank" rel="noopener noreferrer">Deployment guidance</a></td></tr><tr><td style="text-align:left;">JDK</td><td style="text-align:left;">Suggest JDK11 and above versions (recommend deploying JDK17 and above versions)</td></tr><tr><td style="text-align:left;">DataEase</td><td style="text-align:left;">Request v1 series v1.18 version, please refer to DataEase official website for installation <a href="https://dataease.io/docs/v2/installation/offline_INSTL_and_UPG/" target="_blank" rel="noopener noreferrer">Installation Guide</a>（V2. x is currently not supported, please contact Timecho Business for compatibility with other versions）</td></tr><tr><td style="text-align:left;">DataEase-IoTDB Connector</td><td style="text-align:left;">Please contact Timecho Business for assistance</td></tr></tbody></table><h2 id="installation-steps" tabindex="-1"><a class="header-anchor" href="#installation-steps"><span>Installation Steps</span></a></h2><p>Step 1: Please contact the business to obtain the compressed file and unzip the installation package（ iotdb-api-source-1.0.0.zip ）</p><p>Step 2: After decompression,Modify the configuration file<code>application.properties</code> in the <code>config</code> folder</p><ul><li>port<code>server.port</code> can be modified as needed</li><li><code>iotdb.nodeUrls</code> need to configure the address and port of the IoTDB instance to be connected</li><li><code>iotdb.user</code> need to configure the username for IoTDB</li><li><code>iotdb.password</code> password for IoTDB needs to be configured</li></ul><div class="language-Properties line-numbers-mode" data-highlighter="prismjs" data-ext="Properties" data-title="Properties"><pre><code><span class="line"># Port to start IoTDB API Source listening</span> |
| <span class="line"></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div></li></ol><div style="text-align:center;"><img src="https://alioss.timecho.com/docs/img/DataEase-English8.png" alt="" style="width:70%;"></div><ol start="6"><li>Click on the【Auth config】tab, select【Basic Auth】as the authentication method, and enter the IoTDB username and password accurately</li></ol><div style="text-align:center;"><img src="https://alioss.timecho.com/docs/img/DataEase-English9.png" alt="" style="width:70%;"></div><ol start="7"><li>Click【Next】，you will see the interface return result in the<code>data</code>section.If the following figure shows the interface,returned<code>time</code>、 <code>rownumber</code>and <code>value</code>information，at the same time, it is necessary to specify the data types of each field。。After completing the settings, click the 'Save' button in the bottom right corner of the interface.</li></ol><div style="text-align:center;"><img src="https://alioss.timecho.com/docs/img/DataEase-English11.png" alt="" style="width:70%;"></div><ol start="8"><li>After saving, enter the new API data source page and click the 【 Save 】 button in the upper right corner.</li></ol><div style="text-align:center;"><img src="https://alioss.timecho.com/docs/img/DataEase-English12.png" alt="" style="width:70%;"></div><ol start="9"><li>Save Data Source: After saving, you can view the data source and its detailed information under the API classification menu, or edit the data source.</li></ol><div style="text-align:center;"><img src="https://alioss.timecho.com/docs/img/DataEase-English13.png" alt="" style="width:70%;"></div><h3 id="configure-the-dataset" tabindex="-1"><a class="header-anchor" href="#configure-the-dataset"><span>Configure the dataset</span></a></h3><ol><li>Create API dataset: navigate to in the navigation bar【Data Set】page，Click on the top left corner of the page 【 + 】 symbol，Select the【API dataset】type and choose the directory where this dataset is located to enter the New API Dataset page.</li></ol><div style="text-align:center;"><img src="https://alioss.timecho.com/docs/img/DataEase-English14.png" alt="" style="width:49%;"><img src="https://alioss.timecho.com/docs/img/DataEase-English15.png" alt="" style="width:49%;"></div><ol start="2"><li>On the New API Dataset page, select the newly created API data source and the corresponding data table contained in the dataset (left in the figure below), and set the dataset name (right in the figure below). After setting up, click the【 Save 】button in the upper right corner of the page to complete the creation of the dataset.</li></ol><div style="text-align:center;"><img src="https://alioss.timecho.com/docs/img/DataEase-English16.png" alt="" style="width:49%;"><img src="https://alioss.timecho.com/docs/img/DataEase-English17.png" alt="" style="width:49%;"></div><ol start="3"><li>Select the newly created dataset and enter【Field Manage】tag page, then mark the required fields (such as rowNum) as dimensions</li></ol><div style="text-align:center;"><img src="https://alioss.timecho.com/docs/img/DataEase-English18.png" alt="" style="width:70%;"></div><ol start="4"><li><p>onfigure update frequency: Click on 【Update info】on the【Add Task】page and set the following information:</p><p>Task Name: Fill in according to the actual situation</p><p>Update method: Select【Full update】</p><p>Execution frequency: Set according to the actual situation (considering DataEase acquisition speed, it is recommended to set it to update every 5 seconds). For example, if it needs to be set to update every 5 seconds, you can choose【Expression setting】Aad in【cron expression】set as<code>0/5 * * * * ? *</code><br> After the configuration is complete, click the【confirm】button in the bottom right corner of the page to save the settings.</p></li></ol><div style="text-align:center;"><img src="https://alioss.timecho.com/docs/img/DataEase-English19.png" alt="" style="width:70%;"></div><ol start="5"><li>The task has been successfully added. You can click on the top left corner of the page【Execution record】option to view execution records</li></ol><div style="text-align:center;"><img src="https://alioss.timecho.com/docs/img/DataEase-English20.png" alt="" style="width:70%;"></div><h3 id="configure-dashboard" tabindex="-1"><a class="header-anchor" href="#configure-dashboard"><span>Configure dashboard</span></a></h3><ol><li>Jump to the 【 Dashboard 】 page in the navigation bar and click on it【 + 】symbol creation directory，and in the corresponding directory，Click on the【 + 】symbol and select from the pop-up menu【Create Dashboard】</li></ol><div style="text-align:center;"><img src="https://alioss.timecho.com/docs/img/DataEase-English21.png" alt="" style="width:70%;"></div><ol start="2"><li>After setting up as needed, click on【Confirm】. Taking custom settings as an example, confirm and enter the new dashboard page.</li></ol><div style="text-align:center;"><img src="https://alioss.timecho.com/docs/img/DataEase-English22.png" alt="" style="width:70%;"></div><ol start="3"><li>On the new dashboard page, click the【Chart】button to open a pop-up window for adding <a href="http://views.In" target="_blank" rel="noopener noreferrer">views.In</a> the pop-up window, select the previously created dataset and click【Next】continue with the operation.</li></ol><div style="text-align:center;"><img src="https://alioss.timecho.com/docs/img/DataEase-English23.png" alt="" style="width:70%;"></div><ol start="4"><li>In the step of selecting icon types, choose a suitable chart type based on the display requirements,Like the【Base Line】. After selecting, click the 【Confirm】 button to apply the selection.</li></ol><div style="text-align:center;"><img src="https://alioss.timecho.com/docs/img/DataEase-English24.png" alt="" style="width:70%;"></div><ol start="5"><li>In the chart configuration interface, drag and drop the<code>rowNum</code>field to the category axis (usually the X-axis) and the<code>value</code>field to the value axis (usually the Y-axis).</li></ol><div style="text-align:center;"><img src="https://alioss.timecho.com/docs/img/DataEase-English25.png" alt="" style="width:70%;"></div><ol start="6"><li>In the category axis settings of the chart, select to set the sorting method to ascending, so that the data will be displayed in ascending order. Set the data refresh frequency to determine the frequency of chart updates. After completing these settings, you can further adjust other formatting and style options of the chart, such as color, size, etc., to meet display needs.After adjusting, click the【save】button in the upper right corner of the page to save the chart configuration.</li></ol><blockquote><p>Due to the possibility of DataEase automatically updating the dataset, the original API data returned in ascending order may be out of order. Therefore, it is necessary to manually specify the sorting method in the chart configuration.</p></blockquote><div style="text-align:center;"><img src="https://alioss.timecho.com/docs/img/DataEase-English26.png" alt="" style="width:70%;"></div><ol start="7"><li>View the effect after exiting editing</li></ol><div style="text-align:center;"><img src="https://alioss.timecho.com/docs/img/DataEase-English27.png" alt="" style="width:70%;"></div>`,67)]))}const d=t(n,[["render",o],["__file","DataEase.html.vue"]]),c=JSON.parse('{"path":"/UserGuide/latest/Ecosystem-Integration/DataEase.html","title":"DataEase","lang":"en-US","frontmatter":{"description":"DataEase Product Overview Introduction to DataEase DataEase is an open-source data visualization and analysis tool that provides a drag and drop interface, allowing users to eas...","head":[["link",{"rel":"alternate","hreflang":"zh-cn","href":"https://iotdb.apache.org/zh/UserGuide/latest/Ecosystem-Integration/DataEase.html"}],["meta",{"property":"og:url","content":"https://iotdb.apache.org/UserGuide/latest/Ecosystem-Integration/DataEase.html"}],["meta",{"property":"og:site_name","content":"IoTDB Website"}],["meta",{"property":"og:title","content":"DataEase"}],["meta",{"property":"og:description","content":"DataEase Product Overview Introduction to DataEase DataEase is an open-source data visualization and analysis tool that provides a drag and drop interface, allowing users to eas..."}],["meta",{"property":"og:type","content":"article"}],["meta",{"property":"og:locale","content":"en-US"}],["meta",{"property":"og:locale:alternate","content":"zh-CN"}],["meta",{"property":"og:updated_time","content":"2024-09-18T06:09:55.000Z"}],["meta",{"property":"article:modified_time","content":"2024-09-18T06:09:55.000Z"}],["script",{"type":"application/ld+json"},"{\\"@context\\":\\"https://schema.org\\",\\"@type\\":\\"Article\\",\\"headline\\":\\"DataEase\\",\\"image\\":[\\"\\"],\\"dateModified\\":\\"2024-09-18T06:09:55.000Z\\",\\"author\\":[]}"]]},"headers":[{"level":2,"title":"Product Overview","slug":"product-overview","link":"#product-overview","children":[]},{"level":2,"title":"Installation Requirements","slug":"installation-requirements","link":"#installation-requirements","children":[]},{"level":2,"title":"Installation Steps","slug":"installation-steps","link":"#installation-steps","children":[]},{"level":2,"title":"Instructions","slug":"instructions","link":"#instructions","children":[{"level":3,"title":"Sign in DataEase","slug":"sign-in-dataease","link":"#sign-in-dataease","children":[]},{"level":3,"title":"Configure data source","slug":"configure-data-source","link":"#configure-data-source","children":[]},{"level":3,"title":"Configure the dataset","slug":"configure-the-dataset","link":"#configure-the-dataset","children":[]},{"level":3,"title":"Configure dashboard","slug":"configure-dashboard","link":"#configure-dashboard","children":[]}]}],"git":{"createdTime":1726639795000,"updatedTime":1726639795000,"contributors":[{"name":"W1y1r","email":"150988475+W1y1r@users.noreply.github.com","commits":1}]},"readingTime":{"minutes":5.69,"words":1708},"filePathRelative":"UserGuide/latest/Ecosystem-Integration/DataEase.md","localizedDate":"September 18, 2024","autoDesc":true}');export{d as comp,c as data}; |
