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.
Last updated
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.
Last updated
A running Streambased instance, for instructions see
A RazorSQL deployment. This can be downloaded
Streambased is 100% compatible with Trino ODBC drivers. these can be obtained
Open the ODBC data Source application from the windows start menu
Navigate to: User DSN -> Add... -> Simba Trino ODBC Driver
Enter the following basic configurations:
Data Source Name
streambased (or any name meaningful to you)
Authentication Type
Basic
Host
[server host]
Port
[server port]
Catalog
kafka
Schema
streambased
Click OK
Click Test…
to confirm the details are correct and a connection can be established.
Open RazorSQL and:
Click Add Connection Profile
and select the OTHER database type
Select the driver source named streambased (or other name specified in step 3) and click CONNECT
When connected a SQL editor will launch, happy querying.