Authentication SSL connection
Description
No description available [API reference]
Instructions
Starburst with TLS from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools.
- Same as Non-SSL Auth. Use port 443 (or your TLS port) and
SSL=true. - Fill user and password from the coordinator or Starburst Galaxy/Galaxy-like console.
- 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\Starburst\trino-jdbc-476.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: User name Database user. Leave empty if the server allows anonymous JDBC. |
YES | ||||||||||
|
Name:
Label: Password Database password. Leave empty if none. |
YES | ||||||||||
|
Name:
Label: Driver class Optional. Leave blank to auto-detect from the JAR unless SPI is ambiguous (e.g. io.trino.jdbc.TrinoDriver). |
io.trino.jdbc.TrinoDriver
|
||||||||||
|
Name:
Label: SSL SSL flag for this JDBC URL (e.g. Yes from the dropdown). |
true
|
|