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’))

发表评论