Authentication SSL
Description
No description available [API reference]
Instructions
Kylin 5 JDBC over HTTPS. User and password remain the Kylin REST user.
- Use the HTTPS port of the Kylin server (often 443 or a custom TLS port). This Auth sets
ssl=true. - Create a Kylin REST user with query access to the project. Paste user and password.
- After Finish, replace host, port, and project. If the certificate is private, import it into the Java truststore used by JDBC Bridge.
- Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
- Done. You can query from C#, Python, PowerShell, and ODBC apps.
Parameters
| Parameter | Required | Default value | Options | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
|
Name:
Label: JDBC driver file(s) Filled by the wizard after download. Separate multiple JARs with a semicolon (e.g. C:\ZappySys\Jdbc\MyConnector\driver.jar). |
YES |
C:\ZappySys\Jdbc\Apache Kylin\kylin-jdbc-5.0.4.jar
|
|||||||||
|
Name:
Label: Host JDBC host name or IP (e.g. MyHostName). |
YES |
MyHostName
|
|||||||||
|
Name:
Label: TCP port JDBC port (e.g. 443). |
YES |
443
|
|||||||||
|
Name:
Label: Project Kylin project name (e.g. MyProject). |
YES |
MyProject
|
|||||||||
|
Name:
Label: User name Kylin REST user with query permission on the project. |
YES | ||||||||||
|
Name:
Label: Password Kylin REST password for that user. |
YES | ||||||||||
|
Name:
Label: Driver class Optional. Leave blank to auto-detect from the JAR unless SPI is ambiguous (e.g. org.apache.kylin.jdbc.Driver). |
org.apache.kylin.jdbc.Driver
|
||||||||||
|
Name:
Label: SSL Set true so the driver calls Kylin over HTTPS (e.g. Yes from the dropdown). Use the server HTTPS port. |
true
|
|