Setting Up the DBeaver Client for Splice Machine
Walk through how to install and configure the DBeaver SQL Client for use with your Splice Machine database.
Join the DZone community and get the full member experience.Join For Free
The DBeaver Client is a graphical SQL client written in Java that allows you to:
- View the structure of a JDBC compliant database.
- Browse the data in tables.
- Issue SQL commands.
Installing the DBeaver Client
Installing the DBeaver Client on MacOS
Follow these steps to download and install DBeaver on your MacOS computer:
- Download the installer. Download the DBeaver for the MacOS ZIP archive. Note: You must have Java version 7.0 or higher installed to run DBeaver.
- Copy the application to your Applications folder. Double-click the file you downloaded and then copy the
DBeaver.appto your Applications folder.
Installing DBeaver on Windows
Follow these steps to install DBeaver on your Windows PC.
- Download the installer. Download the installer for the enterprise edition of DBeaver for Windows.
- Run the installer. Double-click the
dbeaver-<version>.exefile that you downloaded to install DBeaver using the installer’s default values.
Configuring DBeaver for Splice Machine
Before you can use DBeaver with Splice Machine, you must create a new driver definition in DBeaver for Splice Machine. Follow these steps.
Find the Splice Machine JDBC Driver
Make sure you can find the JDBC driver, which is installed on your computer when you install Splice Machine. You’ll find it in the
jdbc-driver folder under the
splicemachine directory. Typical locations are
/splicemachine/jdbc-driver/splicedriver-<version>.jar on MacOS and
C:\splicemachine\jdbc-driver\splicedriver-<version>.jar on Windows.
Create a DBeaver driver definition for the Splice Machine driver
Select Driver Manager from the DBeaver Database menu.
Click the New button to create your new driver definition.
Populate the fields in the Create new driver screen as shown here in the following screen shot. Note: You need to add the Splice Machine JDBC JAR file in the definition. Click the Add File button and then navigate to where it is stored on your computer; for example:
/splicemachine/jdbc-driver/splicedriver-<version>.jar.Note: To fill in the Driver class field, click the Find Class button and select
com.splicemachine.db.jdbc.ClientDriver. Click the OK button to create your new driver definition. Click the Close button to close the DBeaver Driver Manager screen.
Create a DBeaver Connection for Your Database
DBeaver uses pre-defined connections to access your database, so you need to create a connection for each database that you access using the following steps.
Select New Connection from the DBeaver Database menu. Select the Splice Machine Driver connection type in the next screen, then click the Next button.
Fill in the Create new connection screen as shown here:Note: The default username is splice and the default password is admin.
For Server: on a cluster, specify the IP address of an HBase RegionServer. If you’re running the standalone version of Splice Machine, specify localhost.
We recommend testing the connection by clicking the Test Connection button. Splice Machine must be running for a successful connection. Click the Next button. If you have VPN requirements, fill those in on the Network Configuration screen; otherwise, simply click the Next button again.
In the Finish connection creation screen, enter a name for your connection and click the Finish button.
Using DBeaver With Splice Machine
Once you’ve finished adding the driver and connection, follow these steps to use DBeaver.
Start the DBeaver Client
Locate and run the DBeaver application if it’s not already running.
Navigate to Your Database
In the DBeaver Database Navigator, select the connection you want to use; in the example below, we’re using the connection we just connected, which is named Splice Machine – localhost.
Select Database Objects
Expand the tree structure under your connection to expose the database objects that you want to explore:
And that's it!
Published at DZone with permission of Gary Hillerson, DZone MVB. See the original article here.
Opinions expressed by DZone contributors are their own.