Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Setting Up the DBeaver Client for Splice Machine

DZone's Guide to

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.

· Database Zone
Free Resource

Traditional relational databases weren’t designed for today’s customers. Learn about the world’s first NoSQL Engagement Database purpose-built for the new era of customer experience.

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

This section presents installation instructions for the DBeaver Client for installing the DBeaver client on MacOS and on Windows computers.

Installing the DBeaver Client on MacOS

Follow these steps to download and install DBeaver on your MacOS computer:

  1. 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.
  2. Copy the application to your Applications folder. Double-click the file you downloaded and then copy the DBeaver.app to your Applications folder.

Installing DBeaver on Windows

Follow these steps to install DBeaver on your Windows PC.

  1. Download the installer. Download the installer for the enterprise edition of DBeaver for Windows.
  2. Run the installer. Double-click the dbeaver-<version>.exe file 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.Screen shot of the settings for creating a DBeaver driver definition for the Splice Machine driverNote: 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.

Selecting the Splice Machine driver as the DBeaver connection type

Fill in the Create new connection screen as shown here:Creating a new DBeaver connection for Splice MachineNote: 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.Finishing creation of a new connection for DBeaver

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: Using DBeaver with Splice Machine

And that's it!

Learn how the world’s first NoSQL Engagement Database delivers unparalleled performance at any scale for customer experience innovation that never ends.

Topics:
splice machine ,dbeaver ,sql ,database ,tutorial

Published at DZone with permission of Gary Hillerson, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

THE DZONE NEWSLETTER

Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

X

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}