Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,023 questions
Copy CSV files to citrix sharefile path (doman.sharefile.com) folder using ADF
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 1%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Sree
0
Reputation points
Hello,
I am trying to do a POC, which is to build a small pipeline and I am trying to export a SQL table (AZ SQL DB) to a CSV file and need to upload it on citrix sharefile path, site url looks like "https://domain.sharefile.com/home/shared". there is a shared folder created on this path.
I have credentials which has read/write access to that sharefile site. I tried to create a FileSystem linked service and used basic authentication, which didn't work. I tried using web activity, in 2 ways; Initially used only 1 web activity with Post method (nothing in body), which ran successfully but the file wasn't uploaded, then I tried using 2 web activities one to get the file from ADLS(copied from AZ SQL table) and another web activity to post the output of previous web activity. pipeline ran successfully, but file wasn't uploaded. Then I tried creating FTP linked service with details provided on my sharefile account: FTP Server Information
Security:Implicit SSL/TLS (Port 990) - RequiredSecurity:Implicit SSL/TLS (Port 990) - Required__Security:__Implicit SSL/TLS (Port 990) - Required__FTP Server:__domain.sharefileftp.com__User name:domain/xxxxxxx@XXXXXXXX.com or uxxxxxxxx__Password:_(your ShareFile password)_Then I am getting error in establish connection: Failed to connect to FTP server. ADF doesn't support SSL/TLS implicit encryption mode. Please make sure you are connecting by explicit encryption mode.The underlying connection was closed: The server committed a protocol violation.
Do we have any solution for this, kindly suggest!
Thanks & regards,
Sree
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu 12,105 Reputation points Microsoft Vendor2024-07-04T09:32:58.9933333+00:00 Hi @Sree
Thanks for the question and using MS Q&A platform.
It seems that you are trying to upload a CSV file to a Citrix ShareFile path using Azure Data Factory (ADF). As you mentioned, ADF does not support SSL/TLS implicit encryption mode, which is required by your Citrix ShareFile account. However, you can use the FTPS protocol, which is supported by ADF, to upload files to your Citrix ShareFile account.
To use FTPS, you need to create an FTPS linked service in ADF. Here are the steps to create an FTPS linked service:- In the ADF portal, go to the Author & Monitor tab and click on New linked service.
- Select FTP as the type of the linked service.
- Enter a name for the linked service and select the integration runtime that you want to use.
- Enter the FTP server information as follows:
- Host: domain.sharefileftp.com
- Port: 990
- Protocol: FTPS
- Encryption mode: Explicit
- Enter the credentials for your Citrix ShareFile account.
- Test the connection to make sure that the linked service is working.
Once you have created the FTPS linked service, you can use the Copy Data activity in ADF to copy the CSV file from your source (Azure SQL Database) to your destination (Citrix ShareFile).
I hope this helps. Let me know if you have any further questions.
-
Sree 0 Reputation points
2024-07-04T10:05:55.7266667+00:00 Hello @Smaran Thoomu
I am not finding the option to set Protocol value as FTPS and also encryption mode.this is my screenshot:
can you provide your suggestions along with the screenshots pls?
-
Sree 0 Reputation points
2024-07-04T10:09:21.9566667+00:00 Hello @Smaran Thoomu I am not finding the option Protocol and Encryption mode to set those values from your suggestion, can you pls share a screenshot where to find them?
this is my screenshot:
-
Smaran Thoomu 12,105 Reputation points Microsoft Vendor
2024-07-05T11:38:15.7433333+00:00 Hi @Sree
I apologize for the confusion. Here are the updated steps to create an FTPS linked service in ADF:
Enter the FTP server information as follows:- Host: domain.sharefileftp.com
- Port: 990
- Username: your Citrix ShareFile account username
- Password: your Citrix ShareFile account password
Click on Test connection to make sure that the linked service is working.
I hope this helps. Let me know if you have any further questions. -
Sree 0 Reputation points
2024-07-05T12:09:37.7533333+00:00 Hello @Smaran Thoomu
I have already tried the same steps and it's not working. I tried both options Enable SSL and Disable SSL, but it's not working.
do you have any other suggestion on how I can achieve my requirement?
Sign in to comment