Copy data from Dynamic 365 to Azure SQL database using ADF

admin

I am moving data from Dynamic 365 to Azure SQL using ADF. While doing so, most of the columns do not get copied to SQL Server.

After doing some research it’s the logical columns that do not get copied.

Is there any way, I can move all the columns to the SQL Server using ADF?

Below is the error I got in the ADF pipeline.

Dynamics operation failed with error code: -2147217149, error message: ‘TableName’ entity doesn’t contain attribute with Name=”ColumnName” and NameMapping = ‘Logical’. MetadataCacheDetails: ProviderType=Dynamic, StandardCache=True, IsLoadedInStagedContext = False, Timestamp=2313762038, MinActiveRowVersion=2313762038, MetadataInstanceId=12335869, LastUpdated=2023-10-05 05:43:24.133, OrgId=ce52ea78-f8d8-4211-ada2-9695342b8504.

Read more here: Source link