3rd party DB Admin Tools

Table of Contents

Machbase can work with a variety of 3rd party DB admin tools as instructed in below. Users can easily manage data with them.

SQuirrel SQL

SQuirreL SQL is a JDBC-supplied database and is an open source product that enables SQL queries and data browsing. Especially It is useful for developers and administrators who need to use multiple databases at the same time. It is written in Java and can be used on a variety of platforms including Linux, Windows and MacOSx.

Installing SQuirreL SQL installation

SQuirreL SQL is an open-source product that you can download and install on your OS at http://www.squirrelsql.org/#installation. If your OS is Windows, run cmd.exe and enter the following command:

Java -jar squirrel-sql-3.5.0-install.jar

Once the installer is running, you can install the program in the normal sequence.

Machbase Driver Register

Select the 'Drivers' tab in the 'Drivers' tab and the 'Aliases' tab on the right side of the screen and click the '+'(Add driver) button to register the Machbase driver.

  1. Enter the # Name entry. (e.g. Machbase)
  2. Select the 'Extra Class Path' tab.
  3. 'Add' button to register machbase.jar. It is located in $MACHBASE_HOME/lib.
  4. Select the registered machbase.jar and press the 'List Drivers' button
  5. Select the mach.jdbc.driver.MachDriver shown in the Class Name column at the bottom.
  6. Example Enter the URL item. (e.g. jdbc: Mach: //127.0.0.1: 5656 / machdb)
  7. Press the 'OK' button.

Alias Creation and Connect

  1. Enter the Name entry (e.g. mach-Test).
  2. Select the Machbase driver registered above in the Driver section.
  3. Modify the URL entry (e.g. jdbc: Mach: //127.0.0.1: 5656 / machdb).
  4. If there is a property to use when connecting, register it by clicking Properties button.
  5. Press the OK button.
  6. Connect to Machbase by double-clicking the registered Alias or by clicking on the Connect button.

Cautions

To prevent Hangul from crashing on Windows OS, modify squirrel-sql.bat to use utf-8 encoding.
(Add -Dfile.encoding = UTF-8 to the program execution command at the bottom of squirrel-sql.bat as shown below)

Start "SQuirreL SQL Client" / B "% LOCAL_JAVA%" -Xmx256m -Dsun.awt.nopixfmt = true -Dfile.encoding = UTF-8 -Dsun.java2d.noddraw = true 
-cp% SQUIRREL_CP% -splash: "% SQUIRREL_SQL_HOME % / Icons / splash.jpg "net.sourceforge.squirrel_sql.client.Main% TMP_PARMS%

SQuirreL SQL 's 'refactoring function' and 'create script function' should not be used immediately due to the difference of the query syntax.
Unusual data type columns such as 'IPV4' are looked up as 'Unknown type' in the Content tab of the table. To do this, run the 'File'-'General Preferences' menu and set the check box to read the data from the 'Unknown Data Types entry' in the 'Data Type Controls tab'.

DBeaver

​​DBeaver is a SQL Client for database managers in general purpose. It supports various databases with JDBC drivers. It helps to manage database structures, runs SQL queries and scripts, and more. It is a GUI program with excellent performance and relatively low memory consumption.

DBeaver installation

You can download it from DBeaver homepage (http://dbeaver.jkiss.org/download/) depending on your OS.
The installation instructions are described in the Installation section of the download page.

Registering Machbase driver

Run the 'Database' -'Driver Manager' menu and press the 'new button'.

  1. Enter Driver Name. (e.g. Machbase. Leave Driver type as Generic)
  2. In the Libraries tab, click th'e Add File' button to register the machbase.jar. It is located in $MACHBASE_HOME/lib.
  3. You can select mach.jdbc.driver.MachDriver from the Driver Class by pressing the Find Class button at the bottom.
  4. If you select mach.jdbc.driver.MachDriver in Driver Class, it will be input to Class Name.
  5. Enter the URL Template and Default Port. If you enter the URL Template, you can not modify the JDBC URL item when creating the Connection.
  6. Press the 'OK' button.

Connection Creation and Connecting

Select the 'Database'-'New connection' Menu.

  1. Select the Machbase driver registered in the Driver list and press the 'Next' button. (e.g. Machbase)
  2. Enter the JDBC URL entry in the 'General' tab. (e.g. jdbc: Mach: //127.0.0.1: 5656 / machdb)
  3. Enter the Username / Password for the Machbase connection and click the 'Next' button. (e.g. SYS / MANAGER)
  4. If necessary, make the network settings and press the 'Next' button.
  5. Make the general settings and press the 'Test Connection' button to check if the connection is established.
  6. If there is a property to use for connection, it can be set in 'Driver properties' tab.
  7. Press the 'OK' button.
  8. You can select and use the registered connection in the 'Database Navigator' tab of the left pane of the main screen.

Precautions

To prevent Hangul from crashing on Windows OS, you should use utf-8 encoding with parameters when running DBeaver. (Run -vmargs -Dfile.encoding = UTF-8 parameter.) Modify the target item in the properties of DBeaver shortcut on the Windows desktop or menu as below.

"C: \ Program Files \ DBeaver \ dbeaver.exe" -nl en -vmargs -Dfile.encoding = UTF-8

Generate SQL functions' and DDL items of DBeaver can not be used immediately because of difference of query syntax. The query statements need to be modified according to its syntax.

FineReport

​FineReport is a 'professional, simple and flexible' reporting tool developed under the concept of 'No code'. With simple drag and drop, you can design complex reports and construct data decision systems.

FineReport Installation

You can download it from FineReport homepage (http://www.finereport.com/en/products/download) depending on your own OS.

Registering the Machbase Driver

Copy the machbase.jar file to the {FineReport installation path}/WebReport/WEB-INF/lib folder.
Run the 'Server' - 'Launch Define Data Connection' menu.

  1. Press the '+' button and select JDBC.
  2. Select the DB item Others.
  3. Type mach.jdbc.driver.MachDriver in the Driver field.
  4. Enter the URL item. (e.g. jdbc: Mach: //127.0.0.1: 5656 / machdb)
  5. Enter the Username / Password for the Machbase connection. (e.g. SYS / MANAGER)
  6. Press the OK button.

Machbase Connection

Server Data Set

  1. Run the 'Server' - 'Server Data Set' menu.
  2. Press the '+' button and select DB query.
  3. Select 'Machbase Driver' in the combo box at the top of the middle tab.
  4. Enter the Query statement to be used on the right side. You can check the results using the 'Preview' icon above.
  5. Press the 'OK' button.
  6. Select the 'Server Data Set tab' in the bottom left panel of the main screen.
  7. Select the registered 'Server Data Set'. (Drag and drop)

Template data set

  1. Select the 'Template data set' tab in the bottom left panel of the main screen.
  2. Press the '+' button and select DB query.
  3. Select 'Machbase Driver' from the combo box on the left.
  4. Enter the Query statement to use on the right. You can check the results using the 'Preview' icon above.
  5. Press the 'OK' button.
  6. Select the Template Data Set tab in the bottom left panel of the main screen.
  7. You can select and use the registered Template Data Set. (Drag and drop)

Precautions

To prevent Hangul from being broken on Windows OS, add -Dfile.encoding = UTF-8 to designer.bat in {FineReport installation path} bin folder and execute designer.bat. (Modify designer.bat as follows.)

..\jre\bin\java -Xms512m -Xmx1024m -Dfile.encoding=UTF-8 -cp ../lib/*;../lib/jetty/*;../WebReport/WEB-INF/lib/* com.fr.start.Designer

The shortcut on the Windows desktop or in the Start menu runs designer.exe, so this fix does not apply. You should modify the target of the shortcut to designer.bat, run cmd.exe, and then run {FineReport installation path} bin designer.bat directly.

results matching ""

    No results matching ""