It's a pain to distribute and maintain certificate (.pem) files on Windows clients for the ODBC driver for Hortonworks. The Spotfire connector for Hortonworks should have a checkbox that enables the system trust store instead of the driver's local certificate file on disk.