Hana Smart Data Integration – Installing the DP Agent

  • A+
所属分类:Notes

The Data Provisioning Agent hosts all SDI Adapters and acts as the communication interface between Hana and the Adapter. As such the DP Agent version has to match the Hana version. Which version to use is best found out by looking at the PAM (link) for Hana SDI, the Essential Information document.

Hana Smart Data Integration – Installing the DP Agent

The DP Agent can be installed anywhere and one Hana instance can have many agents configured. Hence there is a great freedom. Some adapters might have certain requirements however, e.g. a File Adapter can read all files it has access to. In order to read a file from a local disk drive, the File Adapter and therefore one Agent has to be installed on this local computer.

see architecture

The SDI Agent can be downloaded as SAR file from SAP Service Marketplace like any other SAP application, provided it was licensed.

Hana Smart Data Integration – Installing the DP AgentHana Smart Data Integration – Installing the DP Agent

As the Adapters are written in Java, it is a good idea to check if Java is installed and what version.

Hana Smart Data Integration – Installing the DP Agent

The actual installation is straight forward. The hdbsetup.exe guides through the installation steps.

Hana Smart Data Integration – Installing the DP Agent

Since this is a network service, in case of Windows the domain\username (or hostname\username for local users) has to be provided. And then the service does listen on the two TCP/IP ports, by default 5050 and 5051.

Hana Smart Data Integration – Installing the DP Agent

When the installation is finished, the Windows Services should have a “SAP Hana Data Provisioning Agent” running.

Hana Smart Data Integration – Installing the DP Agent

Now this new agent has to be made known in Hana by executing the create-agent SQL command.The same can be accomplished by running the dpagentconfigtool.

Hana Smart Data Integration – Installing the DP Agent

In order to execute SQL commands the tool has to connect to Hana using the JDBC driver (or https in case Hana is in a different network with a firewall inbetween, e.g. a cloud instance) and the user has to have the required permissions.

Hana Smart Data Integration – Installing the DP Agent

Once connected the tool executes the CREATE AGENT PROTOCOL ‘TCP’ host PORT 5050; command to register an agent. Hence an arbitrary agent name has to be entered and the local hostname.

Note: When using the TCPIP protocol, it is the Agent listening and Hana initiating the communication. Therefore the hostname has to be know to the Hanas system. In larger organisations that means the full qualified hostname has to be used often. Or the static IP address of the Agent computer, if there is one. This gets especially tricky in case the Agent runs on a computer with DHCP.

Hana Smart Data Integration – Installing the DP Agent

At the end the dpagentconfigtool should show that it is connected to Hana successfully, the agent name is registered and the agent is running and listening as shown below.

Hana Smart Data Integration – Installing the DP Agent

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

目前评论:1   其中:访客  1   博主  0

    • ag

      From:
      https://people.sap.com/werner.daehn