Lesson Learned #63: It is possible to create Linked Server in Azure SQL Managed Instance?
First published on MSDN on Jan 19, 2019 The answer is Yes!!! and to create it you only need to follow up the instructions provided in this URL Unfortunately, nowadays, you only are able to use the SQL provider to connect to Azure SQL Database, SQL Server or Azure SQL Managed Instance.
Azure Data Factory pipeline - copy data from on-prem SQL Server and Dynamics CRM
Hello, I need to transfer data from an on-premises SQL Server into CDS (Dynamics 365). This can be achieved by using a CopyData activity, if all data to be transferred is already stored in SQL Server Unfortunately, this is not my case. Steps for my requirement are: - create a CRM record (parent record); - the GUID of this record must be then included into the source data for CopyData activity. In fact, all the data transferred into CRM (by CopyData activity) need to be child records of the previous parent record. How can I accomplish this data flow, please? Best regards, Radu Antonache
