Connecting Your Splice Machine Database

This topic introduces you to our JDBC and ODBC drivers, and then links to mini-tutorials that walk you through using our drivers with various programming and Business Intelligence tools, in the following sections:

The Splice Machine JDBC Driver

Our JDBC driver is automatically installed on your computer(s) when you install Splice Machine. You’ll find it in the jdbc-driver folder under the splicemachine directory. Typical locations are:

OS Driver Location
Linux / MacOS /splicemachine/jdbc-driver/
Windows C:\splicemachine\jdbc-driver\

The Splice Machine ODBC Driver

You need to install the Splice Machine ODBC driver on the computer on which want to use it; we provide detailed installation instructions for both Unix and Windows computers in our Developer’s Guide.

You must use the Splice Machine JDBC and ODBC drivers to connect with your Splice Machine database; other drivers will not work correctly.

Default Driver Connection Parameters

The following table shows the default connection values you use with Splice Machine. These values are used in all of the Splice Machine connection tutorials:

Connection Parameter Default Value
port 1527
User name splice
Password admin
Database name splicedb

Connecting with Programming Tools

Here are links to tutorials to help you to use our drivers to connect to Splice Machine using your favorite programming languages and tools:

Splice Machine Driver Tutorial Links
JDBC Driver
ODBC Driver

Connecting with Business Intelligence Tools

Here are links to tutorials to help you to use our drivers to connect specific business intelligence tools to Splice Machine:

Splice Machine Driver Tutorial Links
JDBC Driver
ODBC Driver