Streambased Documentation
  • Home
  • Overview
    • Key Concepts
  • Streambased Cloud
    • Streambased Cloud UI
      • Create your first Streambased cluster
      • Create your first Streambased API Key
      • Running your first A.S.K Query
      • Exploring your data using S.S.K
    • Iceberg Service for Kafka - I.S.K.
      • Overview
      • Architecture
      • Usage
      • Quick Start
    • Analytics Service for Kafka - A.S.K.
      • Overview
      • Architecture
      • Connecting to Streambased A.S.K.
        • Connect Superset to Streambased A.S.K.
        • Connect Jupyter to Streambased A.S.K.
        • Connect a JDBC Client to Streambased A.S.K.
        • Connect an ODBC client to Streambased A.S.K.
        • Connect a Python Application (SQL Alchemy) to Streambased A.S.K.
    • Storage Service for Kafka - S.S.K.
      • Overview
      • Connecting to Streambased S.S.K.
        • Connecting a S3 compatible client to Streambased S.S.K.
        • Connect a S3manager to Streambased S.S.K.
  • Streambased Platform
    • Overview
    • Requirements
    • Step by Step Installation
    • Configuration
    • Connecting Analytical Applications to Streambased
      • Connect Superset to Streambased
      • Connect Jupyter to Streambased
      • Connect a JDBC Client to Streambased
      • Connect an ODBC client to Streambased
      • Connect a Python Application (SQL Alchemy) to Streambased
Powered by GitBook
On this page
  • Prerequisites:
  • Step 1: Fetch your login credentials
  • Step 2: Download the Trino JDBC Driver
  • Step 3: [Squirrel SQL specific] Create a new driver
  • Step 4: [Squirrel SQL specific] Create a new alias
  • Step 5: [Squirrel SQL specific] Run some queries
  1. Streambased Cloud
  2. Analytics Service for Kafka - A.S.K.
  3. Connecting to Streambased A.S.K.

Connect a JDBC Client to Streambased A.S.K.

Java Database Connectivity (JDBC) is a Java API that allows applications to connect to databases. It enables Java based applications to execute queries and retrieve data. Let's real-time it up!

PreviousConnect Jupyter to Streambased A.S.K.NextConnect an ODBC client to Streambased A.S.K.

Last updated 3 months ago

We have used , an free and open source JDBC client for this tutorial. Other JDBC clients and applications will have a similar setup procedure but may need additional steps. Please refer to the documentation of your specific client for these.

Prerequisites:

  • An active Streambased Cloud account, sign up or log in

  • A JDBC supporting client/library

Step 1: Fetch your login credentials

Access to Streambased Cloud is managed via API-keys, you can create one for you new connection

With Squirrel SQL you will use your public key as the database username and your secret key as the database password. Make a note of these for Step 2.

Step 2: Download the Trino JDBC Driver

Streambased is 100% compatible with the Trino JDBC driver, you can obtain it from . Store this in a place that is easily accesible by your client application.

Step 3: [Squirrel SQL specific] Create a new driver

  1. Select New Driver.

  2. Enter the following information in each field:

Property Name
Value

Name

Streambased

Example URL

jdbc:trino://host:port?SSL=true

Website URL

https://streambased.io

  1. Select the Extra Class Path tab, Click Add and navigate to the JDBC driver .jar you downloaded in Step 2.

  2. Click List Drivers and Set the Class Name to io.trino.jdbc.TrinoDriver.

  3. Click OK.

Step 4: [Squirrel SQL specific] Create a new alias

  1. Select New Alias

  2. Enter the following information in each field:

Property Name
Value

Name

Streambased (or other meaningful name)

Driver

The one created in Step 3

Url

jdbc:trino://ask-beta.streambased.cloud:8443?SSL=true

Username

[public key from Step 1]

Password

[secret key from Step 1]

Step 5: [Squirrel SQL specific] Run some queries

Clicking Connect will bring up a SQL editor, happy querying!

Squirrel SQL
here
here
here
run queries