In this blog i will complete the scenario and will show you how to install the SAP Data Service Agent and connect them wit your HCP to fetch the data.

Please check also the prevous blogs for more details:

Use SAP HCP IoT Services and HCP Integration Services (HCI-DS) to get your Sensor Data – Part 1

Use SAP HCP IoT Services and HCP Integration Services (HCI-DS) to get your Sensor Data – Part 2

Prerequisite

To enable the scheduler on the SAP HCI DS you need to install the SAP Data Services Agent on your OnPremise System.

schedule.PNG

You can get the Software by clicking on the link in det Agents tab:


dataserviceagent.PNG

Installation

After you have downloaded the executable for the OS you can install the Agent:


install1.PNG

install2.PNG


Setup


After the installation is completed you can configure the DS agent.

agentconfig1.PNG


Enter:

  • Username (email)
  • Password (suser pw)
  • Path to the AgentConfig File

You can download the config file during the creation process of the agent in HCI DS:

agentconfigfile.PNG

After the connection between your OnPremise agent and the HCI DS you can see the green light in the agent tab of HCI DS:

green.PNG

Scheduler

Now we can go back to the Projects tab and can define a new scheduler to fetch our data from SAP HCP.

Scheduler configuration:

schedulerdefinition.PNG

Activate the scheduler:

activatescheduler.PNG

Now we execute our newly created scheduler by selecting “Run Now”:

runnow1.PNG

runnow.PNG

In the Task History you can see the status of the execution:

log.PNG

Result:

The IoT data is fetched on the OnPrem filesystem:

resultfile.PNG

file.PNG

Please feel free to comment on my first blogs in the sdn in the are of the coll SAP HCP Platform 😉

Cheers

Fabian

To report this post you need to login first.

3 Comments

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

  1. Janani Mohan

    Great Blog !

    Could you also address if HCI DS offer Teradata connectivity.

    If it does let me know what database type i need to choose.

    I couldn’t find any Teradata database type in the drop down.

    (0) 
    1. Ben Hofmans

      Hi Janani,
      We just added Teradata support last weekend (Dec 9, 2016). So if you check again, or chek out the PAM, you will see Teradata is supported as source now.

      Thanks,
      Ben.


      Product manager SAP HANA Cloud Integration for data services and HANA smart data inregration

      (0) 
  2. Ben Hofmans

    Hi Fabian, great blog ! I’m product manager for HCI-DS, so really appreciate you writing a blog on this product.

    But did you know we now also have HANA SDI (smart data integration) available on HCP ? You could see it as a successor of HCI-DS for one specific use case: loading data into HANA on HCP. So exactly what you are doing…  SDI provides more adapters (e.g. Twitter or Hadoop), more transformations and provides real-time replication on top of what HCI-DS provides. And best of all: it’s covered under the same license as HCI-DS, so if you have a HANA database on HCP, you can start using it. Check out my blog for more details:
    https://blogs.sap.com/2016/06/22/smart-data-integration-available-for-hcp/

    Thanks,
    Ben.

    Product manager SAP HANA Cloud Integration for data services and HANA smart data inregration

    (0) 

Leave a Reply