Tuesday, 08 June 2021 08:46

Using SDI FileAdapter to write to Azure file share

Written by Sohit Tandon
Rate this item
(0 votes)
Source https://blogs.sap.com/2021/06/09/using-sdi-fileadapter-to-write-to-azure-file-share/
“© 2020. SAP SE or an SAP affiliate company. All rights reserved.” “Used with permission of SAP SE”

In this blog we will create an Azure file share and use it as a destination for SAP SDI FileAdapter.

Prerequisites

  1. Azure Account
  2. SAP HANA Data Provisioning Agent server enabled
  3. SAP HANA Data Provisioning Agent installed

Let’s start by creating the Azure file share. Login to the Azure portal and create a premium storage account  as depicted in the below screenshot

Create Storage Account

Once the storage account is created, create a file share by clicking on the + sign as shown in the below screenshot

Create%20a%20File%20Share%20in%20the%20storage%20account

Create a File Share in the storage account

Click on the file share once it is created and then click connect . Thereafter choose Windows and copy the command

Get%20the%20command%20to%20connect%20to%20the%20fileshare

Get the command to connect to the file share

Run the command from a powershell session on the Windows machine where DP Agent is running. That would mount the file share persistently as shown in the below screenshot.

Mount%20the%20Azure%20file%20share%20to%20DP%20agent%20host%20machine

Mount the Azure file share to DP agent host machine

Now we will create a symbolic link to the azure mount under DP Agent installation directory (C:\usr\sap\dataprovagent) using the mklink command

Note that the directory azshare shoud not exist before you run the below command from a command prompt as an adminstrator

C:\Windows\system32>mklink /d "c:\usr\sap\dataprovagent\azshare" \\p****.file.core.windows.net\myshare\

Create%20symbolic%20link%20using%20mklink%20command

Create symbolic link using mklink command

Once the softlink is created, you will see a folder as shown below

softlink%20folder%20under%20c%3A/usr/sap/dataprovagent

softlink folder under c:/usr/sap/dataprovagent

Now we will create a folder data inside the softlink and place a simple csv file (sample.txt) there. Here are the contents of the csv file.

Contents%20of%20sampledata.txt%20file

Contents of sampledata.txt file

Next we need to create a cfg file for this csv using the createfileformat.bat utility located in C:\usr\sap\dataprovagent\agentutils using the sample command as below

createfileformat.bat -file c:\usr\sap\dataprovagent\azshare\data\sampledata.txt -cfg c:\usr\sap\dataprovagent\azshare\data\

This would result in a cfg file in the same directory as the txt file

sample%20csv%20and%20cfg%20file

sample csv and cfg file

Here is the content of the cfg file .

contents%20of%20the%20samples.txt.cfg

contents of the samples.txt.cfg

Now we are all set to start configuring the fileadapter in DP Agent. To do that, run the DP agent configuration tool as an administrator. Click connect to HANA and provide the HANA credentials to connect the DP Agent to HANA

Continue reading here
Read 70 times

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.