assets/DBeaver.html-Dv8dBvOi.js - iotdb-website - Git at Google

 import{_ as a}from"./01-RN0IVtsa.js";import{_ as t,a as i,b as r,c as n,d as o,e as s,f as l}from"./09-WtqhKEHX.js";import{_ as d}from"./20230920-192746-BS6swLjI.js";import{_ as c,c as p,b as g,o as m}from"./app-BWhNjvfs.js";const h={};function u(b,e){return m(),p("div",null,e[0]||(e[0]=[g('<h1 id="dbeaver" tabindex="-1"><a class="header-anchor" href="#dbeaver"><span>DBeaver</span></a></h1><p>DBeaver is a SQL client software application and a database administration tool. It can use the JDBC application programming interface (API) to interact with IoTDB via the JDBC driver.</p><h2 id="dbeaver-installation" tabindex="-1"><a class="header-anchor" href="#dbeaver-installation"><span>DBeaver Installation</span></a></h2><ul><li>From DBeaver site: <a href="https://dbeaver.io/download/" target="_blank" rel="noopener noreferrer">https://dbeaver.io/download/</a></li></ul><h2 id="iotdb-installation" tabindex="-1"><a class="header-anchor" href="#iotdb-installation"><span>IoTDB Installation</span></a></h2><ul><li>Download binary version <ul><li>From IoTDB site: <a href="https://iotdb.apache.org/Download/" target="_blank" rel="noopener noreferrer">https://iotdb.apache.org/Download/</a></li><li>Version &gt;= 0.13.0</li></ul></li><li>Or compile from source code <ul><li>See <a href="https://github.com/apache/iotdb" target="_blank" rel="noopener noreferrer">https://github.com/apache/iotdb</a></li></ul></li></ul><h2 id="connect-iotdb-and-dbeaver" tabindex="-1"><a class="header-anchor" href="#connect-iotdb-and-dbeaver"><span>Connect IoTDB and DBeaver</span></a></h2><ol><li><p>Start IoTDB server</p><div class="language-shell line-numbers-mode" data-highlighter="shiki" data-ext="shell" data-title="shell" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code><span class="line"><span style="color:#61AFEF;">./sbin/start-server.sh</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div></li><li><p>Start DBeaver</p></li><li><p>Open Driver Manager</p><figure><img src="'+a+'" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure></li><li><p>Create a new driver type for IoTDB</p><figure><img src="'+t+'" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure></li><li><p>Download <code>iotdb-jdbc</code>， from <a href="https://maven.proxy.ustclug.org/maven2/org/apache/iotdb/iotdb-jdbc/" target="_blank" rel="noopener noreferrer">source1</a> or <a href="https://repo1.maven.org/maven2/org/apache/iotdb/iotdb-jdbc/" target="_blank" rel="noopener noreferrer">source2</a>，choose the corresponding jar file，download the suffix <code>jar-with-dependencies.jar</code> file.<br><img src="'+d+'" alt="" loading="lazy"></p></li><li><p>Add the downloaded jar file， then select <code>Find Class</code>.</p><figure><img src="'+i+'" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure></li><li><p>Edit the driver Settings</p><figure><img src="'+r+`" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><div class="language- line-numbers-mode" data-highlighter="shiki" data-ext="" data-title="" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code><span class="line"><span>Driver Name: IoTDB</span></span>
 <span class="line"><span>Driver Type: Generic</span></span>
 <span class="line"><span>URL Template: jdbc:iotdb://{host}:{port}/</span></span>
 <span class="line"><span>Default Port: 6667</span></span>
 <span class="line"><span>Default User: root</span></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 class="line-number"></div></div></div></li><li><p>Open New DataBase Connection and select iotdb</p><figure><img src="`+n+`" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure></li><li><p>Edit JDBC Connection Settings</p></li></ol><div class="language- line-numbers-mode" data-highlighter="shiki" data-ext="" data-title="" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code><span class="line"><span>JDBC URL: jdbc:iotdb://127.0.0.1:6667/</span></span>
 <span class="line"><span>Username: root</span></span>
 <span class="line"><span>Password: root</span></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></div><figure><img src="`+o+'" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><ol start="10"><li>Test Connection</li></ol><figure><img src="'+s+'" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><ol start="11"><li>Enjoy IoTDB with DBeaver</li></ol><figure><img src="'+l+'" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure>',14)]))}const B=c(h,[["render",u],["__file","DBeaver.html.vue"]]),_=JSON.parse('{"path":"/UserGuide/dev-1.3/Ecosystem-Integration/DBeaver.html","title":"DBeaver","lang":"en-US","frontmatter":{"description":"DBeaver DBeaver is a SQL client software application and a database administration tool. It can use the JDBC application programming interface (API) to interact with IoTDB via t...","head":[["link",{"rel":"alternate","hreflang":"zh-cn","href":"https://iotdb.apache.org/zh/UserGuide/dev-1.3/Ecosystem-Integration/DBeaver.html"}],["meta",{"property":"og:url","content":"https://iotdb.apache.org/UserGuide/dev-1.3/Ecosystem-Integration/DBeaver.html"}],["meta",{"property":"og:site_name","content":"IoTDB Website"}],["meta",{"property":"og:title","content":"DBeaver"}],["meta",{"property":"og:description","content":"DBeaver DBeaver is a SQL client software application and a database administration tool. It can use the JDBC application programming interface (API) to interact with IoTDB via t..."}],["meta",{"property":"og:type","content":"article"}],["meta",{"property":"og:image","content":"https://iotdb.apache.org/img/UserGuide/Ecosystem-Integration/DBeaver/01.png"}],["meta",{"property":"og:locale","content":"en-US"}],["meta",{"property":"og:locale:alternate","content":"zh-CN"}],["meta",{"property":"og:updated_time","content":"2025-02-21T09:31:28.000Z"}],["meta",{"property":"article:modified_time","content":"2025-02-21T09:31:28.000Z"}],["script",{"type":"application/ld+json"},"{\\"@context\\":\\"https://schema.org\\",\\"@type\\":\\"Article\\",\\"headline\\":\\"DBeaver\\",\\"image\\":[\\"https://iotdb.apache.org/img/UserGuide/Ecosystem-Integration/DBeaver/01.png\\",\\"https://iotdb.apache.org/img/UserGuide/Ecosystem-Integration/DBeaver/02.png\\",\\"https://iotdb.apache.org/img/20230920-192746.jpg\\",\\"https://iotdb.apache.org/img/UserGuide/Ecosystem-Integration/DBeaver/03.png\\",\\"https://iotdb.apache.org/img/UserGuide/Ecosystem-Integration/DBeaver/05.png\\",\\"https://iotdb.apache.org/img/UserGuide/Ecosystem-Integration/DBeaver/06.png\\",\\"https://iotdb.apache.org/img/UserGuide/Ecosystem-Integration/DBeaver/07.png\\",\\"https://iotdb.apache.org/img/UserGuide/Ecosystem-Integration/DBeaver/08.png\\",\\"https://iotdb.apache.org/img/UserGuide/Ecosystem-Integration/DBeaver/09.png\\"],\\"dateModified\\":\\"2025-02-21T09:31:28.000Z\\",\\"author\\":[]}"]]},"headers":[{"level":2,"title":"DBeaver Installation","slug":"dbeaver-installation","link":"#dbeaver-installation","children":[]},{"level":2,"title":"IoTDB Installation","slug":"iotdb-installation","link":"#iotdb-installation","children":[]},{"level":2,"title":"Connect IoTDB and DBeaver","slug":"connect-iotdb-and-dbeaver","link":"#connect-iotdb-and-dbeaver","children":[]}],"git":{"createdTime":1688958677000,"updatedTime":1740130288000,"contributors":[{"name":"CritasWang","username":"CritasWang","email":"critas@outlook.com","commits":2,"url":"https://github.com/CritasWang"},{"name":"Lei","username":"Lei","email":"33376433+LeiRui@users.noreply.github.com","commits":1,"url":"https://github.com/Lei"},{"name":"wanghui42","username":"wanghui42","email":"105700158+wanghui42@users.noreply.github.com","commits":1,"url":"https://github.com/wanghui42"},{"name":"石林松","username":"石林松","email":"50943998+shi10lin0s@users.noreply.github.com","commits":1,"url":"https://github.com/石林松"},{"name":"Christofer Dutz","username":"Christofer Dutz","email":"christofer.dutz@c-ware.de","commits":1,"url":"https://github.com/Christofer Dutz"},{"name":"W1y1r","username":"W1y1r","email":"150988475+W1y1r@users.noreply.github.com","commits":2,"url":"https://github.com/W1y1r"}]},"readingTime":{"minutes":1.03,"words":308},"filePathRelative":"UserGuide/dev-1.3/Ecosystem-Integration/DBeaver.md","localizedDate":"July 10, 2023","autoDesc":true}');export{B as comp,_ as data};
	import{_ as a}from"./01-RN0IVtsa.js";import{_ as t,a as i,b as r,c as n,d as o,e as s,f as l}from"./09-WtqhKEHX.js";import{_ as d}from"./20230920-192746-BS6swLjI.js";import{_ as c,c as p,b as g,o as m}from"./app-BWhNjvfs.js";const h={};function u(b,e){return m(),p("div",null,e[0]\|\|(e[0]=[g('<h1 id="dbeaver" tabindex="-1"><a class="header-anchor" href="#dbeaver"><span>DBeaver</span></a></h1><p>DBeaver is a SQL client software application and a database administration tool. It can use the JDBC application programming interface (API) to interact with IoTDB via the JDBC driver.</p><h2 id="dbeaver-installation" tabindex="-1"><a class="header-anchor" href="#dbeaver-installation"><span>DBeaver Installation</span></a></h2><ul><li>From DBeaver site: <a href="https://dbeaver.io/download/" target="_blank" rel="noopener noreferrer">https://dbeaver.io/download/</a></li></ul><h2 id="iotdb-installation" tabindex="-1"><a class="header-anchor" href="#iotdb-installation"><span>IoTDB Installation</span></a></h2><ul><li>Download binary version <ul><li>From IoTDB site: <a href="https://iotdb.apache.org/Download/" target="_blank" rel="noopener noreferrer">https://iotdb.apache.org/Download/</a></li><li>Version >= 0.13.0</li></ul></li><li>Or compile from source code <ul><li>See <a href="https://github.com/apache/iotdb" target="_blank" rel="noopener noreferrer">https://github.com/apache/iotdb</a></li></ul></li></ul><h2 id="connect-iotdb-and-dbeaver" tabindex="-1"><a class="header-anchor" href="#connect-iotdb-and-dbeaver"><span>Connect IoTDB and DBeaver</span></a></h2><ol><li><p>Start IoTDB server</p><div class="language-shell line-numbers-mode" data-highlighter="shiki" data-ext="shell" data-title="shell" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code><span class="line"><span style="color:#61AFEF;">./sbin/start-server.sh</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div></li><li><p>Start DBeaver</p></li><li><p>Open Driver Manager</p><figure><img src="'+a+'" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure></li><li><p>Create a new driver type for IoTDB</p><figure><img src="'+t+'" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure></li><li><p>Download <code>iotdb-jdbc</code>， from <a href="https://maven.proxy.ustclug.org/maven2/org/apache/iotdb/iotdb-jdbc/" target="_blank" rel="noopener noreferrer">source1</a> or <a href="https://repo1.maven.org/maven2/org/apache/iotdb/iotdb-jdbc/" target="_blank" rel="noopener noreferrer">source2</a>，choose the corresponding jar file，download the suffix <code>jar-with-dependencies.jar</code> file.<br><img src="'+d+'" alt="" loading="lazy"></p></li><li><p>Add the downloaded jar file， then select <code>Find Class</code>.</p><figure><img src="'+i+'" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure></li><li><p>Edit the driver Settings</p><figure><img src="'+r+`" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><div class="language- line-numbers-mode" data-highlighter="shiki" data-ext="" data-title="" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code><span class="line"><span>Driver Name: IoTDB</span></span>
	<span class="line"><span>Driver Type: Generic</span></span>
	<span class="line"><span>URL Template: jdbc:iotdb://{host}:{port}/</span></span>
	<span class="line"><span>Default Port: 6667</span></span>
	<span class="line"><span>Default User: root</span></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 class="line-number"></div></div></div></li><li><p>Open New DataBase Connection and select iotdb</p><figure><img src="`+n+`" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure></li><li><p>Edit JDBC Connection Settings</p></li></ol><div class="language- line-numbers-mode" data-highlighter="shiki" data-ext="" data-title="" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code><span class="line"><span>JDBC URL: jdbc:iotdb://127.0.0.1:6667/</span></span>
	<span class="line"><span>Username: root</span></span>
	<span class="line"><span>Password: root</span></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></div><figure><img src="`+o+'" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><ol start="10"><li>Test Connection</li></ol><figure><img src="'+s+'" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><ol start="11"><li>Enjoy IoTDB with DBeaver</li></ol><figure><img src="'+l+'" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure>',14)]))}const B=c(h,[["render",u],["__file","DBeaver.html.vue"]]),_=JSON.parse('{"path":"/UserGuide/dev-1.3/Ecosystem-Integration/DBeaver.html","title":"DBeaver","lang":"en-US","frontmatter":{"description":"DBeaver DBeaver is a SQL client software application and a database administration tool. It can use the JDBC application programming interface (API) to interact with IoTDB via t...","head":[["link",{"rel":"alternate","hreflang":"zh-cn","href":"https://iotdb.apache.org/zh/UserGuide/dev-1.3/Ecosystem-Integration/DBeaver.html"}],["meta",{"property":"og:url","content":"https://iotdb.apache.org/UserGuide/dev-1.3/Ecosystem-Integration/DBeaver.html"}],["meta",{"property":"og:site_name","content":"IoTDB Website"}],["meta",{"property":"og:title","content":"DBeaver"}],["meta",{"property":"og:description","content":"DBeaver DBeaver is a SQL client software application and a database administration tool. It can use the JDBC application programming interface (API) to interact with IoTDB via t..."}],["meta",{"property":"og:type","content":"article"}],["meta",{"property":"og:image","content":"https://iotdb.apache.org/img/UserGuide/Ecosystem-Integration/DBeaver/01.png"}],["meta",{"property":"og:locale","content":"en-US"}],["meta",{"property":"og:locale:alternate","content":"zh-CN"}],["meta",{"property":"og:updated_time","content":"2025-02-21T09:31:28.000Z"}],["meta",{"property":"article:modified_time","content":"2025-02-21T09:31:28.000Z"}],["script",{"type":"application/ld+json"},"{\\"@context\\":\\"https://schema.org\\",\\"@type\\":\\"Article\\",\\"headline\\":\\"DBeaver\\",\\"image\\":[\\"https://iotdb.apache.org/img/UserGuide/Ecosystem-Integration/DBeaver/01.png\\",\\"https://iotdb.apache.org/img/UserGuide/Ecosystem-Integration/DBeaver/02.png\\",\\"https://iotdb.apache.org/img/20230920-192746.jpg\\",\\"https://iotdb.apache.org/img/UserGuide/Ecosystem-Integration/DBeaver/03.png\\",\\"https://iotdb.apache.org/img/UserGuide/Ecosystem-Integration/DBeaver/05.png\\",\\"https://iotdb.apache.org/img/UserGuide/Ecosystem-Integration/DBeaver/06.png\\",\\"https://iotdb.apache.org/img/UserGuide/Ecosystem-Integration/DBeaver/07.png\\",\\"https://iotdb.apache.org/img/UserGuide/Ecosystem-Integration/DBeaver/08.png\\",\\"https://iotdb.apache.org/img/UserGuide/Ecosystem-Integration/DBeaver/09.png\\"],\\"dateModified\\":\\"2025-02-21T09:31:28.000Z\\",\\"author\\":[]}"]]},"headers":[{"level":2,"title":"DBeaver Installation","slug":"dbeaver-installation","link":"#dbeaver-installation","children":[]},{"level":2,"title":"IoTDB Installation","slug":"iotdb-installation","link":"#iotdb-installation","children":[]},{"level":2,"title":"Connect IoTDB and DBeaver","slug":"connect-iotdb-and-dbeaver","link":"#connect-iotdb-and-dbeaver","children":[]}],"git":{"createdTime":1688958677000,"updatedTime":1740130288000,"contributors":[{"name":"CritasWang","username":"CritasWang","email":"critas@outlook.com","commits":2,"url":"https://github.com/CritasWang"},{"name":"Lei","username":"Lei","email":"33376433+LeiRui@users.noreply.github.com","commits":1,"url":"https://github.com/Lei"},{"name":"wanghui42","username":"wanghui42","email":"105700158+wanghui42@users.noreply.github.com","commits":1,"url":"https://github.com/wanghui42"},{"name":"石林松","username":"石林松","email":"50943998+shi10lin0s@users.noreply.github.com","commits":1,"url":"https://github.com/石林松"},{"name":"Christofer Dutz","username":"Christofer Dutz","email":"christofer.dutz@c-ware.de","commits":1,"url":"https://github.com/Christofer Dutz"},{"name":"W1y1r","username":"W1y1r","email":"150988475+W1y1r@users.noreply.github.com","commits":2,"url":"https://github.com/W1y1r"}]},"readingTime":{"minutes":1.03,"words":308},"filePathRelative":"UserGuide/dev-1.3/Ecosystem-Integration/DBeaver.md","localizedDate":"July 10, 2023","autoDesc":true}');export{B as comp,_ as data};