Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
Showing results for 
Search instead for 
Did you mean: 
In this blog we will create an Azure file share and use it as a destination for SAP SDI FileAdapter.


  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 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 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 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****\myshare\


Create symbolic link using mklink command

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

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 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 csv and cfg file


Here is the content of the cfg file .

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

Connect DP Agent to HANA


Once DP Agent is connected to HANA, scroll down the list of Adapters and find FIleAdapter. click on it and then click Register Adapter.You should see both , Deployed?  and Registered with HANA?  as Yes.

File Adapter deployed and registered with HANA


Click on top left Configure tab and configure the FileAdapter as shown in the below screenshot. Provide an AccessToken which will be used as a password later on.

FileAdapter configuration

Once the FileAdapter is setup, we will login to the WebIDE using a url similar to the following

This will log you into the WebIDE with an interface like below screenshot



Click on Catalog and then expand Provisioning folder. Create a new remote source by right clicking Remote Sources. Choose FIleAdpter as the Adapter for this remote source. You will need to specify the Root Directory and the directory of the file format definitions exactly same as the one where you placed the sampledata.txt and sampledata.txt.cfg.

Note that password to be entered is the Token that you provided while configuring the FileAdapter in the DP Agent Configuration.

Remote source for FileAdapter


Once the remote source is created, you can click on Test Connection to test the connection. Now we will create a flowgraph to output the contents of a HANA table as a csv to the Azure mount.

We have a table in HANA named MATERIAL_CDC with the below structure.
Create table MATERIAL_CDC(

Click on the Editor in WebIDE and right click on the package to create a new flowgraph as shown in the below screenshot

Create a flow graph

Drag a data source from left pane into canvas. A pop up will ask you to choose the source. Navigate to your source table and choose it.

Choose data source of the flow graph


Drag a filter and join the filter to the Data Source.

Add a filter to the flow graph

Use the filter to transform char to nvarchar and nclob to nvarchar. Click back button located on top right once done.

Filter transformation


Finally drag a Template file to the flow graph and join the filter to template file.

Add Template File to flow graph


Then click on the Template file to configure the settings for the template file. Provide the inputs in the General tab as shown in the below screenshot.

General tab configuration

Next click on the Parameters tab and configure it as per the below screenshot. Note that you must provide the Force Directory Pattern to be the same location as the one where the cfg file is located. Also if you include a % in the Force Filename Pattern, it will create the files with a timestamp.

Parameters tab configuration


Save and execute the flow graph. You will see the data from the MATERIAL_CDC table in a csv file on your local Azure file share

csv file is generated at local DP Agent machine

You can login to your Azure portal and check the file there as well. It will be present under the file share as shown in below screenshot.

Generated CSV in Azure file share



SAP HANA SDI FileAdapter can be easily configured to write data to Azure file share. The FileAdapter has the capability to write to a shared directory. In this blog ,I have simply mounted the Azure file share  on the Windows machine running DP Agent as a shared directory. Do note that the file share has to be located in the same directory or a subdirectory of the DP Agent root directory.

Finally do note that these steps are valid for linux environment as well. You can mount the Azure file share on linux under the DP Agent root directory if your DP Agent is running on the linux platform.