Prerequisites
The Agent Admin HANA User must have the following roles or privileges.
Action |
Role or Privilege |
Connect to SAP HANA |
|
Roles and Privileges
Procedure
- Navigate to the <DPAgent_root>/configTool directory.
- Start the configuration tool.
- On Windows, run dpagentconfigtool.exe.
- On Linux, run ./dpagentconfigtool.
NoteStart the configuration tool using the Data Provisioning Agent installation owner. The installation owner is the same user that is used to start the agent service.
- Connect to the SAP HANA server.
- Click Connect to HANA.
- Specify the hostname, port, and Agent Admin HANA User credentials for the SAP HANA server.
Tip
To determine the correct port number when SAP HANA is deployed in a multi-database configuration, execute the following SQL statement(以SYSTEM用户登录SYSTEMDB执行如下SQL语句,里边的SQL_PORT就是dpagent要连接的端口,‘<DBNAME>替换成对应的数据库、例如S4D):
SELECT DATABASE_NAME,SERVICE_NAME,PORT,SQL_PORT,(PORT + 2) HTTP_PORT
FROM SYS_DATABASES.M_SERVICES WHERE DATABASE_NAME='<DBNAME>’ and
((SERVICE_NAME=’indexserver’ and COORDINATOR_TYPE= ‘MASTER’) or (SERVICE_NAME=’xsengine’))
本文作者: GavinDong
版权属于: GavinDong博客
文章链接: https://gavindong.com/3080.html
如果使用过程中遇到问题,可 **点击此处** 交流沟通。
版权所有,转载时必须以链接形式注明作者和原始出处及本声明。