Download SnappyData JDBC Driver

Download the SnappyData JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.

Connect SnappyData in DbSchema Install the driver, open a connection, reverse engineer your schema, and sync changes visually.
SnappyData guide Free Download

About the SnappyData JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to SnappyData. DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation. Driver files are usually published by the database vendor or an open-source project.

JDBC URL format

Host, port, database name, and SSL options are passed in a URL starting with jdbc:. Each SnappyData driver uses its own syntax — see the connection details below.

The SnappyData JDBC driver

SnappyData (now TIBCO ComputeDB) is an in-memory data platform combining Apache Spark with a columnar store for mixed OLTP/OLAP workloads. It enables Spark SQL, streaming analytics, and ad-hoc queries on live transactional data in a single unified platform.

The SnappyData JDBC URL

  • Required File(s): snappydata-client-xxx.jar
  • Java Driver Class: com.pivotal.gemfirexd.jdbc.ClientDriver
  • JDBC URL: jdbc:snappydata:HOST:PORT/[DB]
  • Website: SnappyData

Download SnappyData JDBC Driver

The driver archive is a zip file. Extract it and load the .jar files using DbSchema's Driver Manager. The driver can also be found here.

Connecting to SnappyData

A SnappyData cluster has locators, leads and servers. Clients connect to a locator, which then points them at a server.

  1. Connect to a locator on port 1527. The locator is the entry point and hands the client a server to work with, which is how the cluster balances connections and survives a server going away.
  2. Make the servers reachable as well. Because the locator redirects you, opening only the locator's port is not enough on a firewalled cluster — the server ports have to be reachable from your machine too.
  3. Note the URL has no double slash. SnappyData uses jdbc:snappydata:host:1527, following its Apache Derby heritage rather than the //host:port form most drivers use.
  4. Open port 1527 in the server's firewall. The database listens on port 1527 unless it was installed with a different one. A host firewall on the server blocks incoming connections on that port until a rule allows them. The firewall guide has the commands for Windows, ufw, firewalld and iptables.
  5. Connect from DbSchema. In the Connection Dialog choose Remote computer or custom port, fill in the server host and the port, then press Test Connection to check that the server answers before you connect.

DbSchema and SnappyData

DbSchema connects to SnappyData using the JDBC driver and renders column tables and row tables in the schema diagram. Use the SQL Editor to run Spark SQL queries against live in-memory data.

Test the driver with DbSchema

Connect SnappyData, build your first ER diagram in minutes. No account required.

1
Download driver & DbSchema

Get the SnappyData driver zip below and install DbSchema for Windows, macOS, or Linux.

2
Register the .jar

In DbSchema, open Driver Manager, add the extracted JAR, and paste your JDBC URL.

3
Design & document

Reverse engineer SnappyData, edit the model visually, and publish schema documentation.

Free DbSchema Download

Use SnappyData visually in DbSchema

After the JDBC driver connects, you get ER diagrams, SQL editor, schema sync, and HTML documentation in one desktop app. Compare DbSchema editions.

ER diagrams

Reverse engineer SnappyData into an interactive diagram and edit structures visually.

SQL & query builder

Run SQL with autocomplete or compose queries without writing every join by hand.

Schema documentation

Export HTML docs your team can browse without installing DbSchema.

Full SnappyData guide

Connection tips, ports, SSL, and schema design workflows on the database landing page.

SnappyData guide

Other drivers teams often configure alongside SnappyData.

Browse all JDBC driver downloads

Teams working with SnappyData often use these engines too. Explore dedicated guides and JDBC setup for each.

Browse all 100+ supported databases