2160172 - How to connect Datahub with HANA database

Symptom

Basic configuration of the Data Hub to work with the HANA database.

Environment

Datahub with HANA databse

Resolution

Connect DataHub with HANA databse
1  Increase the heap size of Tomca See Managing Performance for the Data Hub.
2 Add a database driver to the Tomcat server's classpath (i.e ngdbc-0.73.0.jar)
3 Create a local db datahub on HANA database
4 Configure the local.properties to use that DB.
<code>

# DH database

dataSource.driverClass=com.sap.db.jdbc.Driver

# 5.5 changed to use dataSource.className

dataSource.className=com.sap.db.jdbcext.DataSourceSAP

dataSource.jdbcUrl=jdbc:sap://hana1.database.fra.hybris.com:30115/?reconnect=true

dataSource.username=user

dataSource.password=password

</code>

Difference 5.3 and 5.5

There is a change to the Data Source configuration. In the local.properties file (in the external dependencies folder), change the property dataSource.driverClass=com.sap.db.jdbc.Driver to dataSource.className=com.sap.db.jdbcext.DataSourceSAP (or the relevant DataSource implementation of the database configured in dataSource.jdbcUrl property). Otherwise, the datahub-webapp starts using the default hsql database.

See Also

Getting Started with the DataHub:
https://wiki.hybris.com/pages/viewpage.action?title=Getting+Started+with+the+Data+Hub&spaceKey=release5
HANA Database:
https://wiki.hybris.com/display/release5/HANA+Database

Keywords

datahub, HANA

Header Data

Released On	05.06.2015 15:12:59
Release Status	Released to Customer
Component	CEC-COM-CPS Commerce Platform & Suite (hybris)
Other Components	CEC-COM-CPS-OTH CPS other topics (hybris)
Priority	Normal
Category	How To
Development Platform	Java