Skip to main content

Search

Welcome to Tibero GTS!

dbeaver-Tibero Integration Method

Document TypeㅣTechnical Information

CategoryㅣInterface/Integration

Applicable Product Versionㅣ7FS02PS

Document NumberㅣTIITI009

 

Overview

You can use an external SQL editor through the jdbc file included in the Tibero engine.
Below is a guide on how to use dbeaver, one of the SQL editors.
Note
Tibero Studio, a GUI tool for database development provided by Tibero, comes with jdbc built-in by default.
 
 
 

Method

1.  Prepare jdbc driver 

Extract the jdbc file from the Tibero engine.

$TB_HOME/client/lib/jar/tibero7-jdbc.jar


2.  Create generic driver (dbeaver)

Path: Dbeaver top menu Database > Driver Manager > New to create a new tibero driver

2.1.  Settings

  • Driver Name : tibero7 (name can be freely assigned)
  • Driver Type : Generic
  • Class Name : com.tmax.tibero.jdbc.TbDriver
  • URL Template : jdbc:tibero:thin:@192.168.1.72:8629:tibero
  • Port : 8629
  • Default Database : tibero
 

2.2.  Libraries

Specify the jdbc file extracted in step 1 by Add File.
 

 

3.  Create dbeaver connection

Path: Dbeaver top menu Database > New Database Connection

3.1.  Find the Driver created in step 2 (Tibero7) > Next

3.2.  Enter Connect by URL and account, then Test Connection > Confirm

 
 

 

 

 

Related to