Connect Generic JDBC Client to Kafka
DISCLAIMER:- We have used RazorSQL client for this Tutorial other ODBC clients will have similar setup but please refer to the documentation of your SQL client to connect ODBC driver.
Step 1:- Download Trino Driver
Download the Trino ODBC Driver using the following link https://insightsoftware.com/drivers/trino-odbc-jdbc/
Download RazorSQL from the following link https://razorsql.com/download_win.html
Step 2:- Add ODBC driver using ODBC Data Sources application
a) Open the ODBC data Source application from the windows start menu
b) Navigate to: User DSN> Add...>Simba Trino ODBC Driver
Step 3:- Enter the Configuration
![](https://cdn.prod.website-files.com/66098d655e9084457b00d675/6660d1edb414676bb66056e9_AD_4nXebQo93RXApOB0P361pCur2rxqwGUOc0lNYtu3mV5Hj2D5SCKnhtoFMVKWQpDYqKWuzQMeBC3NenDg1SlqSn-bqCeZ8EMWGjzY-GT4xeghkZ__b3PxcKsyxyI6-teCILV-KQ0SkncFwQliGPBbsedPgh70m.png)
a) Enter the following config:
Data Source Name:- streambased (or any name meaningful to you)
Authentication Type:- No authentication
Host:- streambased.cloud
Port:- 8443
Catlog:- Kafka
Schema:- streambased
b) Click the SSL options button and enable SSL
![](https://cdn.prod.website-files.com/66098d655e9084457b00d675/6660d2400b872e8d9f3bcfda_AD_4nXcTLKUu9P10RcEVaSGl-TtlSC6SUd2yq5inTh8HbSz_PCAqoLBMFvhkSJwte3M9yNj7A0qIy91RTE-7PCX0gzzNnIpufibiIQ2DJuEQpM93q-eujDNSkA95_sDAbXnqLSzr9TuX5qU0cahZqVkXVWt6vX7P.png)
c) Click OK
Step 4:- Test the Connection
Click Test… button and test the connection if the connection is successful click the OK button to add the driver
Step 5:- Open the ODBC client application and select the driver
a) Click Add connection profile select other Database type
![](https://cdn.prod.website-files.com/66098d655e9084457b00d675/6660d2756fe3b376c1613b70_AD_4nXe5oXTiH1najfWptNuKNHYfR0DReHROi_u0SbFrydODB76Rm3bZJKSEZOlH3FbNzDJcZ4ifi5Pbkab-i4004u2geLlLjwnUsntvZlV7IkOsiaQLp2ocW0hpg7Z6RqQugWfIuCol2ouwRE6FZ0IAWJ53pVhf.png)
b) Select the driver source name as Streambased (or any name that is specified while entering the ODBC config)
c) Click CONNECT
![](https://cdn.prod.website-files.com/66098d655e9084457b00d675/6660d2996a03224243c6e8f8_AD_4nXc5u1VTGyhMUq78dvhFZiMD4wkxlSCfZrXhm1EInOd_ruBjh_ss28bA36krG3qlHWcmST-CuxmnFlqEEjDCkQu0jkKHJVlWbCfAKVp47aApqCfYWLSTrmECmF4s2voA3rsj3P4ZljAWNumIv-t7gAoxX2Q.png)
Step 6:- Run your queries
![](https://cdn.prod.website-files.com/66098d655e9084457b00d675/6660d2ac2e81a2a1a119fc19_AD_4nXdJeZ62960Gd8BhQTeVI8J4KHv3gLEGfMqGnopEcuZ6bOZ3NTgpm6O8RHaok9Pj-3h2G9ZtkCeyGVFh5FFcaxP1UnD3JDS5JmRhEl1AnPkFiAzEhlfXCg73_Jdr0BwE-NE6H1e2CP3hSqeMPt0lmiPp1rM.png)