dpagent连接HANA多租户模式

Prerequisites

The Agent Admin HANA User must have the following roles or privileges.

Action

Role or Privilege

Connect to SAP HANA

  • System privilege: AGENT ADMIN
  • System privilege: ADAPTER ADMIN

Roles and Privileges

Procedure

  1. Navigate to the <DPAgent_root>/configTool directory.
  2. 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.
  1. Connect to the SAP HANA server.
  1. Click Connect to HANA.
  2. 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

如果使用过程中遇到问题,可 **点击此处** 交流沟通。

版权所有,转载时必须以链接形式注明作者和原始出处及本声明。

(2)

相关文章

发表回复

登录后才能评论