Hana - Data Provisioning Server

Enable

When SAP HANA is first installed, the Data Provisioning Server is disabled. Enabling the Data Provisioning Server gives you the ability to use SAP HANA smart data integration. Context

• In a single-container SAP HANA database, you can enable the Data Provisioning Server by setting the system property of the daemon.ini configuration file dpserver instances to 1.
• in a multi-database container environment (hxe), use the ALTER DATABASE SQL command.

ALTER DATABASE <database_name> ADD 'dpserver' AT LOCATION '<hostname>[:<port_number>]'

SAP DBTech JDBC: [7]: feature not supported: Only applicable to user databases

ALTER DATABASE SYSTEMDB ADD 'dpserver' AT LOCATION 'localhost';

The 'dpserver'' server has to be enabled on a tenant database instead of on the SYSTEMDB.