1

I need to send a file present in azure data lake to IBM cloud server using the REST API of DB2.

I have used the rest API in command prompt in the below format curl -X POST "" -H "accept: application/json" -H "Authorization: Bearer " -k -F fichier=.csv

I have tried to use a Web activity but I was not successful.

I would like to know how this activity can be done in ADF?

Joy Wang
  • 39,905
  • 3
  • 30
  • 54
Bharath R S
  • 258
  • 3
  • 12
  • All I know is that you can get data from a REST API using the http connector however according to the documentation there is no direct way of using HTTP connector as a sink, maybe you can create a custom activity and remotely call powershell/cmd commands (I have not tried this yet) – dim_user Dec 12 '18 at 22:10

1 Answers1

1

Bharath, based on your description, I want to provide two suggestions:

1.As @Saul Cruz said in the command, you could use custom activity to run the command to do the transfer mission.

2.I found Azure Data Factory copy activity has Azure Data Lake connector and DB2 connector,you could configure copy activity to transfer the csv file.

Update Answer:

Per my research, Web activity is not suitable for you. It's unstable for transfer data.

Since you want to avoid custom activity, maybe I suggest you adopt below solution:

1.Use Copy activity to transfer csv file from Azure Data Lake to Azure Blob Storage.

2.Use Azure Function Blob Trigger to monitor any change feed,then send rest request in function.

Jay Gong
  • 23,163
  • 2
  • 27
  • 32
  • Hi Jay, The DB2 is in a different environment all together and hence I am trying to use a REST API. I am trying to avoid the custom activity as much as possible. Let me know if there is no other way of sending the file. Can you let me know if it can be possible via HTTP connector? – Bharath R S Dec 13 '18 at 12:19
  • @BharathRS Hi, my suggestion is mentioned in my update answer. – Jay Gong Dec 18 '18 at 02:08