Connect an ODBC client to Streambased

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:

• A running Streambased instance, for instructions see here

• A RazorSQL deployment. This can be downloaded here

Step 1: Download a driver

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

Step 2: 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	[server host]
Port	[server port]
Catalog	kafka
Schema	streambased

1. Click OK

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

By default server port is 8080 and server host is the name of the host on which the docker instance has been launched.

Step 3: [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 4: Run some queries

When connected a SQL editor will launch, happy querying.

querying Kafka via ODBC