Introduction #
When the Python environment doesn’t have a directly available database connection library, you can connect via JDBC (Java Database Connectivity). SmartChart supports uploading JDBC JAR packages in the dashboard template to extend data source connection capabilities.
| Step | Operation |
|---|---|
| 1. Install JayDeBeApi | pip install JayDeBeApi |
| 2. Upload JAR | Upload JDBC JAR in dashboard template editor |
| 3. Create connection | Driver format: jdbc:xxx://host:port/db |
Use Cases #
When you cannot find a Python connection library for a database, you can use JDBC as an alternative.
Usage #
First, install the JDBC package:
pip install JayDeBeApi
Upload the corresponding JDBC JAR package in any dashboard’s “Template” editor:
Create a new connection, using Impala as an example:
