MicrosoftHi, Bartosz! I watched a podcast episode with Manish Shah and Holger Bruchelt from about 8 months ago, #137 "The one with Using SAP CDC via SLT", where they featured your post about using SAP SLT with Azure Data Factory. I'm hoping you can help me out. I currently have a data flow set up and working with hardcoded tables and keys and the default run mode (first full load, incremental after). I can pass parameters for the table name and key columns just fine. The issue I'm having is setting up an expression for the run mode. If a parameter I'm passing in is 1, then I need a full load. If it's 0, I need it to resume its incremental load. My team runs full loads on tables during weekend hours, then incremental loads every 2 hours during the week. Do you have any tips for achieving this?
My current expression:
iif( in(['1'],toString($FullSyncStatus)),'fullLoad','incrementalLoad')
I'm currently receiving an error, however:
Job failed due to reason: com.microsoft.dataflow.broker.MissingRequiredPropertyException: enableCdc is a required property for [Data Flow].
com.microsoft.dataflow.broker.InvalidOperationException: Read mode: (iif(in(['1'],toString($FullSyncStatus)),'fullLoad','incrementalLoad')) is invalid. Please check your parameterized read mode.
The "enableCdc" error is confusing--I can't find any evidence of this property needing to be specified, or of it even existing, in the Microsoft documentation I've looked at. It seems like a simple thing, pretty straightforward, but I'm struggling with this. Any help is much appreciated! Thank you!