question

MadhavanAlagesan-5764 avatar image
0 Votes"
MadhavanAlagesan-5764 asked AnnuKumari-MSFT commented

How to access Azure SQL database from Azure Data factory to copy table from on-premise SAP ?

I am trying to copy from the on-premises sap table to the Azure SQL database using Azure Data Factory.
Integration runtime is running on VM and added this IP in SQL server client IP.

Error:
Check the linked service configuration is correct, and make sure the SQL database firewall allows the intergration runtime to access.

azure-data-factoryazure-sql-database
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MadhavanAlagesan-5764 ,
Just following up to see if the above answer helped. Please do consider clicking Accept Answer as accepted answer helps community as well. Thanks!

0 Votes 0 ·

1 Answer

NandanHegde-7720 avatar image
1 Vote"
NandanHegde-7720 answered AnnuKumari-MSFT commented

Hey,
can you please test the below scenarios :
1) Test the linked service connections for the source and the sink
2) If the linked service connections are successful and the issue is only during copy activity,
test whether you are able to access the source and sink within the IR because whenever we use copy activity with an IR, both source and sink must be accessible via IR

· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Yes. I am not able to access the Azure SQL Database from IR.
Can you please tell me what should I do?
I am new to ADF.

0 Votes 0 ·
NandanHegde-7720 avatar image NandanHegde-7720 MadhavanAlagesan-5764 ·

Hey,
this is more on networking side rather than adf :)
there are 2 things which we need to do :
1) whitelist the IP of the IR server in Azure DB firewall
2) You need to open ports in the server to access Azure SQL db

Azure SQL Database communicates over port 1433. If you're trying to connect from within a corporate network, outbound traffic over port 1433 might not be allowed by your network's firewall

@AlbertoMorillo : please add any points in case if missed out

0 Votes 0 ·

@NandanHegde-7720 and @MadhavanAlagesan-5764 Nandan the first item you mentioned about configuring Azure SQL database firewall to the intergration runtime to access the database would be my first suggestion also.

Also consider to enabled the "Allow Azure services and resources to access this server" option on Azure SQL firewall, just in case it may be needed.

0 Votes 0 ·
Show more comments