Connect DBSchema with Astra DB using Simba JDBC Driver
You can connect your DataStax Astra DB to DBSchema using the Simba JDBC Driver for Apache Cassandra®. Follow these steps to set up the connection so you can run queries.
Prerequisites
-
Download the DataStax JDBC Driver.
Establish the connection
-
Open DBSchema.
-
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
Astraand 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
Astrain the Choose your Database window. Select Next.
-
In the Astra Connection Dialog, add
JDBC URLasjdbc:cassandra://;AuthMech=<2>;UID=token;PWD=<ApplicationToken>;SecureConnectionBundlePath=<PATH TO YOUR SECURE CONNECT BUNDLE>;TunableConsistency=<6>with the following variables:-
AuthMech: Specifies whether the driver connects to a Cassandra or Astra DB database and whether the driver authenticates the connection.
-
ApplicationToken: Generated from Astra Portal. See Manage application tokens.
-
SecureConnectionBundlePath: Path to where your downloaded Secure Connect Bundle is located. See Downloading 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.
What’s next?
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.