Accessing SQL server on-Prem database views from remote server through Azure Data Factory
-1
votes
2
answers
766
views
We need to copy the data from client's remote SQL server (on-prem) database to our Azure SQL server through Azure data factory.
So we can automate the data pull on regular basis.
Client tried to offer us that they can create a domain login for us to access their database views. I would like to know if that works to make a connection via Azure Data Factory pipelines and linked service connections.
Please suggest.
Asked by user237624
(1 rep)
Aug 31, 2021, 10:26 AM
Last activity: Sep 1, 2021, 05:20 AM
Last activity: Sep 1, 2021, 05:20 AM