Hana - Data Provisioning Server

About

Core Hana process

Articles Related

Management

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>]'

Support

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.

Documentation / Reference

• Administration Guide for SAP HANA Smart Data Integration and SAP HANA Smart Data Quality - Enable the Data Provisioning Server