We have SAP HANA Express Edition 2.0 SPS3 on premise, HANA Client for the same (We have upgraded the client for HANA 2.0 SPS3) and SAP Data Services 4.2 SP9. We created data store for SAP HANA using DSN. DSN is created using HDBODBC driver and the connection test was successful.
In data store for SAP HANA, we are not able to see tables in HANA but we can see views created on top of it. When we executed a job, it gave following error :
ODBC call <SQLDriverConnect> for data source <XXX> failed: <[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified