Contact the database administrator to update the database to provide its certificate during the SSL handshake.
Connect to the database with the Other Databases (ODBC) connector as it allows for a certificate to be attached.
Use a TDC file with the following contents when connecting to the database. For more information on creating and using TDC files, see Make customizations global with a .tdc file.
<connection-customization class='spark' enabled='true' version='9.0'>
<vendor name='spark' />
<driver name='spark' />
<customization name='odbc-connect-string-extras' value='TrustedCerts=filepath_to_certificate;CAIssuedCertNamesMismatch=1' />
Replace filepath_to_certificate with the file path of the trusted certificate on the machine that is connecting to the database. Note that the file path does not need to be wrapped in double quotation marks.