There are different scenarios you can use to connect Design Studio to HANA database. It primarily depends on Design Studio installation. If you are using Design Studio locally on the system, you can connect to HANA database using an ODBC connection. When Design Studio is available via BI platform, you need to create an ODBC connection in CMC and that can be used to connect to HANA.
To use ODBC connection in Design Studio, you have to create a User/System DSN.
If you are using the 64-bit version of Design Studio, navigate to the following folder on your local system: C:\Windows\System32. Open the odbcad32.exe file and open User DSN tab -> Click on Add button and select HDBODBC driver -> Finish.
When you have a 32-bit version of Design Studio, navigate to the following folder on your local system: C:\Windows\SysWOW64. Open the “odbcad32.exe” file. And navigate to User DSN tab -> Click on Add and select the HDBODBC32 driver -> Finish.
For more details, you can navigate to this link: https://blogs.sap.com/2016/03/29/connecting-hana-to-design-studio/