‣ DBSchema
📖 Reference Documentations and resources
Overview¶
DbSchema is a universal database designer for out-of-the-box schema management and documentation, sharing the schema in the team, and deploying on different databases. Visual tools can help developers, database administrators, and decision-makers to query, explore and manage the data.
DBSchema uses the Simba JDBC driver to connect to Cassandra as the storage backend. The Java driver itself supports connections to Astra DB natively.
Prerequisites¶
- You should have an Astra account
- You should Create an Astra Database
- You should Have an Astra Token
- You should Download your Secure bundle
This article assumes you have installed the latest version of DBSchema on your laptop or PC.
Installation and Setup¶
✅ Step 1: JDBC Driver¶
Download the JDBC driver from the DataStax website:
- Go to https://downloads.datastax.com/#odbc-jdbc-drivers.
- Select Simba JDBC Driver for Apache Cassandra.
- Select JDBC 4.2.
- Read the license terms and accept it (click the checkbox).
- Hit the blue Download button.
- Once the download completes, unzip the downloaded file.
✅ Step 2: Establish the Connection¶
- Open DB Schema
- Select Connect to the Database
-
Select Start
-
In the Choose your database menu, select Cassandra.
-
Select Next.
-
Select JDBC Driver edit option.
-
In the JDBC Driver Manager, select New.
-
In the Add RDBMS window, enter Astra and select OK
-
Select OK in the confirmation message.
-
Upload the Simba JDBC Driver.
-
Select Open
-
Once you upload the Simba JDBC Driver, you will see Astra in the Choose your Database window. Select Next.
-
In the Astra Connection Dialog, add JDBC URL as
with the following variables:jdbc:cassandra://;AuthMech=<2>;UID=token;PWD=<ApplicationToken>;SecureConnectionBundlePath=<PATH TO YOUR SECURE CONNECT BUNDLE>;TunableConsistency=<6>
- AuthMech: Specifies whether the driver connects to a Cassandra or Astra DB database and whether the driver authenticates the connection.
- ApplicationToken: Generated from Astra DB console. See Manage application tokens.
- SecureConnectionBundlePath: Path to where your downloaded Secure Connect Bundle is located. See Get secure connect bundle.
- TunableConsistency: Specifies Cassandra replica or the number of Cassandra replicas that must process a query for the query to be considered successful.
-
Select Connect
-
In the Select Schemas/Catalogs, select the keyspace to which you want to connect.
- Select OK.
✅ Step 3: Final Test¶
Now that your connection is working, you can create tables, introspect your keyspaces, view your data in the DBSchema GUI, and more.
To learn more about DBSchema, see Quick start with DBSchema