Make sure below entry is present inside Addins.xml file (<Installation directory>\Automation Services\x.x\webroot\bin) on Automation Server Machine -
<AddIn FullTypeName="Spotfire.Dxp.Data.Adapters.Hana.HanaAddIn, Spotfire.Dxp.Data.Adapters.Hana.AddIn"/>
Note: The entry present in the below reference link for SAP HANA is incorrect. So please make use of the above mentioned entry for the SAP HANA.
Reference Image - "Addins.PNG"