Symptom
- When creating an imported/acquiered connection to SAP Hana, Users cannot see SAP Hana in the list of Databases
Environment
- SAP Analytics Cloud (2020.8.9 and higher)
Reproducing the Issue
- Login to SAC (SAP Analytics Cloud)
- Go to Connection
- Create a New Connection
- Search and click on SQL Database
- Select Location and Connection type doesn't list SAP Hana even if it has been copied in c4a_agent_drivers.properties
Cause
SQL database doesn't Have the SAP Hana connection as it is supported using the direct SAP Hana dirver
list of all the Data connectivity for Import: https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/11b4e5ff76eb4747bc255d7037be1f01.html#loio11b4e5ff76eb4747bc255d7037be1f01__p_connectimport
Resolution
Use SAP Hana imported connection driver to connect to Hana instead of SQL Database. make sure you do install the SAP Java Connector (JCo)
See Also
Importing SAP HANA Data to a New or Existing Model: https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2020.13/en-US/af7f3810707f4f39968cb42f4b7a8be5.html
Keywords
KBA , LOD-ANA-ADM , SAC Administration , Problem