2941485 - Cannot See SAP Hana in the SQL Database connection list for acquired/imported connection within SAP Analytics Cloud (SAC)

• When creating an imported/acquiered connection to SAP Hana, Users cannot see SAP Hana in the list of Databases

• SAP Analytics Cloud (2020.8.9 and higher)

1. Login to SAC (SAP Analytics Cloud)
2. Go to Connection
3. Create a New Connection
4. Search and click on SQL Database
5. Select Location and Connection type doesn't list SAP Hana even if it has been copied in c4a_agent_drivers.properties

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

Use SAP Hana imported connection driver to connect to Hana instead of SQL Database. make sure you do install the SAP Java Connector (JCo)

Importing SAP HANA Data to a New or Existing Model: https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2020.13/en-US/af7f3810707f4f39968cb42f4b7a8be5.html

KBA , LOD-ANA-ADM , SAC Administration , Problem