Techiio-author
Started by Tom NelsonSep 8, 2021

Open
Azure Data Factory - Filter Lookup Activity using Dynamics Content

0 VIEWES 0 LIKES 0 DISLIKES SHARE
0 LIKES 0 DISLIKES 0 VIEWES SHARE

I'm working on an integration project from Dynamics 365 CE to SQL Server On-premise database using Azure Data Factory.

Challenge is how to get the label of an optionset and uses it as a column value to pass to SQL?

What I currently have is this:

  1. Lookup - Retrieves String Map
  2. Copy Activity - Retrieve Dynamics Data then copy to SQL

The workaround that I'm thinking is to use Dynamics Content and filter the lookup activity result based on the optionset value of Dynamics Data. But I'm not sure if this is possible since I couldn't see any available Functions in ADF that filters a Lookup Value.

I cannot use Data Flow since Dynamics CE is not supported as source yet unfortunately.

0 Replies

You must be Logged in to reply
Techiio-logo

Techiio is on the journey to build an ocean of technical knowledge, scouring the emerging stars in process and proffering them to the corporate world.

Follow us on:

Subscribe to get latest updates

You can unsubscribe anytime from getting updates from us
Developed and maintained by Wikiance
Developed and maintained by Wikiance