Connect an ODBC client to Streambased A.S.K.

Open Database Connectivity (ODBC) is a protocol that allows applications to access data from a database. It connects applications to data sources in databases. Let's bring some real-time data.

We have used RazorSQL client for this tutorial. Other ODBC clients will have similar setup steps. However please refer to the documentation of your application to connect via ODBC.

Prerequisites:

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

• A RazorSQL deployment. This can be downloaded here

Step 1: Fetch your login credentials

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

With ODBC connections 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 3.

Step 2: Download a driver

Streambased is 100% compatible with Trino ODBC drivers. these can be obtained here

Step 3: Configure the driver

1. Open the ODBC data Source application from the windows start menu

2. Navigate to: User DSN -> Add... -> Simba Trino ODBC Driver

3. Enter the following basic configurations:

Property name	Value
Data Source Name	streambased (or any name meaningful to you)
Authentication Type	Basic
Host	beta.streambased.cloud
Port	8443
Catalog	kafka
Schema	streambased
User	[public key from Step 1]
Password	[secret key from Step 1]

1. Click the SSL options button and enable SSL

enable SSL

1. Click OK

2. Click Test… to confirm the details are correct and a connection can be established.

Step 4: [RazorSQL specific] Configure the client

Open RazorSQL and:

1. Click Add Connection Profile and select the OTHER database type

add a connection profile

1. Select the driver source named streambased (or other name specified in step 3) and click CONNECT

connect!

Step 5: Run some queries

When connected a SQL editor will launch, happy querying.

querying Kafka via ODBC