We have an on-premises MS-SQL Server where all the data is stored, which is also a backend for an application. From this on-premises server, we would like to copy data to Azure Data Lake using Data Factory service. This would require installation of Azure self-hosted integration runtime on application backend server.
Is there any other way, like, to create a standalone server for IR installation and use this IR for data copy activity from application backend to Data Lake?
I dont see a problem with that, you dont have to install it on the same server. Point number 3 talks about this:
The self-hosted integration runtime doesn't need to be on the same machine as the data source. However, having the self-hosted integration runtime close to the data source reduces the time for the self-hosted integration runtime to connect to the data source. We recommend that you install the self-hosted integration runtime on a machine that differs from the one that hosts the on-premises data source. When the self-hosted integration runtime and data source are on different machines, the self-hosted integration runtime doesn't compete with the data source for resources.
Install IR on the on-premise machine and then configure it using Launch Configuration Manager. Doesn't need to be on the same machine as the data source. Details can be found here.
