Connects to a SAP HANA database via JDBC. Note that this connection does not require installation of SAP transport packages.
SAP HANA connection supports extracting and loading of data. It can be used in Relational and RelationalTable extracts and Relational and RelationalSQL loads, provided the necessary authorizations are available in the HANA database.
In Relational Table Extracts with a HANA connection, only tables are listed in the dropdown list. For calculation views, use the SAP HANA View Extract.
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 that are added to the generated JDBC URL. Refer to the documentation of the database vendor for a list of possible values. |
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 January 31, 2024