Skip to Content

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.

Agentinstall0.png

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.

Agentinstall1.pngAgentinstall2.png

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

Agentinstall3.png

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

Agentinstall4.png

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.

Agentinstall5.png

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

Agentinstall6.png

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.

Agentinstall7.png

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.

Agentinstall8.png

Once connected the tool executes the CREATE AGENT <agent name> PROTOCOL ‘TCP’ host <hostname or IP> 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.

Agentinstall9.png

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.

Agentinstall10.png

To report this post you need to login first.

12 Comments

You must be Logged on to comment or reply to a post.

  1. Tom Dammer

    /wp-content/uploads/2016/08/1_1026125.pngHi,

    I cant register the Agent. I can connect to HANA.

    It doesn’t matter what I type in the field Agent Name?

    in the Hostname field i tried ip adress and Full Hostname.

    Doesn’t help.

    Regards

    Tom

    (0) 
    1. Yuriy Volosenko

      Hi Tom,

      you have to start Agent as Admin. Enter ip insted of Hostname. Also take look in Firewall settings. You have to create inbound rule like folow.Restart you Agent. Also corp domain can make troubles.

      /wp-content/uploads/2016/09/bild_1029380.jpg

      (0) 
  2. ram nath

    Hi Werner

    We have installed the HANA SDI Excel agent as well but in the definition we are not getting scaling factor like decimal(P,S)
    Ex : Decimal(34,2) for the calculation  of currency,it is showing the value in the data preview but  $110.894888888889 like this it is showing ,I applied filter to restrict the datatype as 32,2 (or) 34,2  throws an error of inconsistent model.

    (0) 
      1. Patel Hardik

        Hi Werner

        This is fantastic blog. It is very useful. We have¬†recently installed DP Agent with the help of this blog. And it is working fine ¬†We¬†are trying to bring data from SQL Sever 2012 to HANA DB using SDI¬†and Data Provisioning Technologies. We have created HANA virtual tables on SQL Server database’s tables and it has same structures and data types as tables in SQL Sever database.

        But we have encountered an issue and it is very critical for us in our project.

        Issue: Р when we do data preview on HANA virtual table which has same table structure and data type as SQL Server, we seeing that data/numbers are converting into Bytes in HANA. This is only when  columns of numeric data types (SMALLINT) may get inserted into the database with incorrect values.

        For example, a SMALLINT value of 1 may be seen inserted into the database(HANA) as value 256.

        It would really great if you have any suggestions on this.

        We have installed our HANA SPS 11 on IBM Power 8 System which is on Linux OS. I am not sure if it is JDBC driver issue or OS level issue.
        Thanks,
        Hardik

         

        (0) 
  3. ram nath

    Thanks  Werner Daehn for the reply .Can we expect it will be fixed with any patches or need to wait for the next release of SDI.

    (0) 
  4. Patel Hardik

    Hi Werner

    This is fantastic blog. It is very useful. We have recently installed DP Agent with the help of this blog. And it is working fine  We are trying to bring data from SQL Sever 2012 to HANA DB using SDI and Data Provisioning Technologies. We have created HANA virtual tables on SQL Server database’s tables and it has same structures and data types as tables in SQL Sever database.

    But we have encountered an issue and it is very critical for us in our project.

    Issue: ‚Äď ¬†when we do data preview on HANA virtual table which has same table structure and data type as SQL Server, we seeing that data/numbers are converting into Bytes in HANA. This is only when¬† columns of numeric data types (SMALLINT) may get inserted into the database with incorrect values.

    For example, a SMALLINT value of 1 may be seen inserted into the database(HANA) as value 256.

    It would really great if you have any suggestions on this.

    We have installed our HANA SPS 11 on IBM Power 8 System which is on Linux OS. I am not sure if it is JDBC driver issue or OS level issue.
    Thanks,
    Hardik

     

    (0) 
  5. AshlinGabriel Rajan

    Hi Guys,

     

    I managed to start agent and also connected to HANA,

    EMBEDDED
    ENABLED
    DISABLED
    ENABLED
    No issues with firewall but i dont see any adapters. could you please help me pointing me where i got screwed,, now i cannot register  agent.
    i am trying to implement real cool stuff here..
    i am using HCP
    Br,
    Gabriel
    (0) 

Leave a Reply