Connects to a SAP HANA database via JDBC. Note that this connection does not require installation of SAP transport packages.
SAP HANA connection support extracting and loading of data. It can be used in extract types Relational, RelationalTable and load types Relational and RelationalSQL provided the necessary authorizations available in the HANA database.
In Relational Table Extracts with a HANA connection, only tables are listed in the dropdown list. CalculationViews can also be pulled, bu the name must be entered manually, since they do not appear in the dropdown list.
Settings
| Host | The host name (DNS name) or the IP address of the server on which the database is located. |
| Port | The TCP/IP port number used by the database. |
| User name | User name for the connection to the database. |
| Password | Password for the connection to the database. |
| Database | Name, schema, or instance of the relational database. |
| Additional JDBC parameters | Optional: Database-specific parameters which are added to the generated JDBC URL. |
For the connection to a SAP Business Warehouse powered by SAP HANA system via this connection type, it is necessary to generate the SAP HANA views from the BW Objects (e.g. Infocubes and DataStore objects). For more information, see the article Generating SAP HANA Views from the BW System.
Updated June 5, 2023