I want to execute an ADF copy task to extract data from my on-premise MS SQL Server DB into a blob object on my Azure storage account. Everything I read suggests that I need to install a self-hosted Integration Runtime (IR) on a host in my on-premise network; but I have done a test where I successfully extracted data from the SQL Server instance doing the following:
1. adding (allow) whitelist for the appropriate ADF IPs for the region where my ADF exists (east-us)
2. creating my copy source using the fully qualified domain information for the on-premise SQL Server and entering appropriate SQL Server authentication credentials
What am I missing? Why does all the documentation suggest that this can only be done using an on-premise, self-hosted IR?
Finally, if I would decide to utilize the on-premise, self-hosted IR how does the IR avoid the need for firewall (allow) whitelist entries? Does the IR initiate the communication with ADF? If so, how do I avoid running up ADF costs if there is this constant (keep alive) communication?
Thanks for any assistance clearing up these mysteries.
