Skip to Content
Author's profile photo Terence Chue

HANA Cloud Platform Integration Service – Part 3

continued from HCP Integration Service – Part 2

Create an OS directory for data and config and use them in the configuration for a new FileAdapter

51-Config-File-Adapter-1.png

Register the FileAdapter

52-Config-File-Adapter-2.png

53-Config-File-Adapter-3.png

The next steps will create a virtual table. Remember the file source itself is remote (on-premise) and HANA is in the cloud. This virtual table will capture the file contents and is dynamic – not only will be file be presented as a table but subsequent CRUD operations on the file itself will be accessible on the cloud through iterative queries against the virtual table. What is happening is that:

  • query against the virtual table triggers a request to SDI. This is a blocking request. SDI enqueues this request for the DP agent
  • at periodic intervals, the DP agent logs in into HCP and picks up this request. The DP agent then pushes the file contents to HCP
  • SDI serves this to the blocking request (the query)
  • The query returns the result set. No data is stored in HANA.
  • Note that this is just one technical use case of the DP Agent. The DP agent can also be used for bulk loads (via a flowgraph) or as a change capture agent for several databases.

Create a remote source based on file adapter:

(Note: System Privilege “CREATE REMOTE SOURCE” is required)

54-Remote-Virtual-1.png

55-Remote-Virtual-2.png

Create the config file in the on-premise OS config directory created previously

56-Remote-Virtual-3.png

Create the CSV file in the data directory

57-Remote-Virtual-4.png

Import virtual table:

58-Remote-Virtual-5.png

A query against the virtual table displays contents of the on-premise file!

59-Remote-Virtual-6.png

Modifications to file and a subsequent query displays the modifications on HCP as well.

60-Remote-Virtual-7.png

61-Remote-Virtual-8.png

There you have it. The intent was to present a simple install and execution of SDI in HCP to understand the technical value of HCP, Integration Services

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Douglas Maltby
      Douglas Maltby

      Hi Terence,

      I just wanted to leave you a word of thanks for these 3 blogs on SDI. I recently came across them while researching SDI for our own potential use, and I've just successfully installed SDI on SAP Cloud Platform trial and used the FileAdapter agent to connect SCP to files on a remote Windows VM. Your detailed guide still works almost 2 years later!

      Thank you for your detailed illustration and guidance!

      Doug