Azure-Samples / cdm-azure-data-services-integration

Tutorials and sample code for integrating CDM folders with Azure Data Services
MIT License
70 stars 46 forks source link

Reading from Dynamics 365 using ADF using the API #26

Open acrigney opened 3 years ago

acrigney commented 3 years ago

Hi Guys, It looks like my issue before no 272 got deleted, so here it is again. Can we create a linked service to Dynamics like we can for Resources, databases etc? This is how its done to talk to blob store.

Create Azure Data Factory using .NET SDK - Azure Data Factory | Microsoft Docs

Console.WriteLine("Creating linked service " + storageLinkedServiceName + "...");

LinkedServiceResource storageLinkedService = new LinkedServiceResource( new AzureStorageLinkedService { ConnectionString = new SecureString( "DefaultEndpointsProtocol=https;AccountName=" + storageAccount + ";AccountKey=" + storageKey) } ); client.LinkedServices.CreateOrUpdate( resourceGroup, dataFactoryName, storageLinkedServiceName, storageLinkedService); Console.WriteLine(SafeJsonConvert.SerializeObject( storageLinkedService, client.SerializationSettings));

From here https://www.c-sharpcorner.com/article/create-azure-data-factory-and-pipeline-using-net-sdk/

I would like to build a generic solution that would read all the parent child relations in a set of SQL tables and populate them in Dynamics. Also can you do a sample reading from Dynamics 365.

Best Regards, Alistair