Connecting to a SAP HANA database using Data Studio
From the Data Studio v1.6.1 release onwards, we've made it easier to connect to a SAP HANA database directly from Data Studio. With the SAP HANA JDBC connection you can load in data from HANA to Data Studio, or export back.
First, you'll need to locate the SAP HANA driver. The driver (ngdbc.jar) is installed as part of the SAP HANA client installation (if you don't have this, you can download it from the SAP Development Tools site) and by default is located at:
C:\Program Files\sap\hdbclient\on Microsoft Windows platforms
/usr/sap/hdbclient/on Linux and UNIX platforms
Next, deploy the driver to Data Studio's
\drivers folder as described in the custom driver help section of the docs.
Then follow the steps in this video to configure and use the driver in Data Studio: Creating a SAP HANA JDBC connection in Aperture Data Studio v1.6.1 (turn on the closed captions for more detail about what your're seeing).
Data Studio v1.6.1 will be available for download in early November 2019