Reference

Authentication SSL connection

Description

No description available [API reference]

Instructions

MySQL with TLS from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools.

  1. Same as Default Auth. Use this when the server requires TLS (managed Cloud SQL, RDS, SkySQL).
  2. After Finish, confirm sslMode on the JDBC URL matches your server (REQUIRED vs VERIFY_CA).
  3. Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
  4. Done. You can query from C#, Python, PowerShell, and ODBC apps.

Parameters

Parameter Required Default value Options
Name: DriverFilePaths

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\MySQL\mysql-connector-j-9.3.0.jar
Name: HostName

Label: Host

JDBC host name or IP (e.g. MyHostName). 		YES MyHostName
Name: Port

Label: TCP port

JDBC port (e.g. 3306). 		YES 3306
Name: SslMode

Label: SSL mode

MySQL/MariaDB sslMode (e.g. Required from the dropdown). 		YES REQUIRED
Name Value
Notset
Preferred PREFERRED
Required REQUIRED
Verify CA VERIFY_CA
Verify identity VERIFY_IDENTITY
Trust trust
Name: UserName

Label: User name

Database user. Leave empty if the server allows anonymous JDBC. 		YES
Name: Password

Label: Password

Database password. Leave empty if none. 		YES
Name: DriverClass

Label: Driver class

Optional. Leave blank to auto-detect from the JAR unless SPI is ambiguous (e.g. com.mysql.cj.jdbc.Driver). 		com.mysql.cj.jdbc.Driver
Name: Database

Label: Database name

Database, schema, or catalog name (e.g. MyDatabase). 		MyDatabase