@Mark Mann
Thanks for posting your question in the Microsoft Q&A forum.
Azure Data Factory does not support parameterization in the Change Data Capture (CDC) feature directly. However, you might consider a workaround by creating a pipeline that wraps your CDC activity. This pipeline could accept parameters and use them to dynamically modify the linked service or dataset properties before invoking the CDC activity.
Here’s a high-level example of how this could work:
{
"name": "PipelineWrapper",
"properties": {
"parameters": {
"connectionString": {
"type": "string"
}
},
"activities": [
{
"name": "ModifyLinkedService",
"type": "AzureFunctionActivity",
"linkedServiceName": {
"referenceName": "AzureFunctionLinkedService",
"type": "LinkedServiceReference"
},
"typeProperties": {
"functionName": "ModifyLinkedService",
"method": "post",
"body": {
"linkedServiceName": "YourLinkedService",
"connectionString": "@pipeline().parameters.connectionString"
}
}
},
{
"name": "CDCActivity",
"type": "Copy",
"linkedServiceName": {
"referenceName": "YourLinkedService",
"type": "LinkedServiceReference"
},
"typeProperties": {
"source": {
"type": "CosmosDbSqlApiSource"
},
"sink": {
"type": "CosmosDbSqlApiSink"
}
}
}
]
}
}
In this example, an Azure Function is used to modify the linked service with the new connection string before the CDC activity is invoked. Please note that this is a simplified example, and the actual implementation might be more complex depending on your specific requirements and environment. Remember to check the official Azure Data Factory documentation for the most accurate and up-to-date information, https://learn.microsoft.com/en-us/azure/data-factory/concepts-change-data-capture https://learn.microsoft.com/en-us/azure/data-factory/concepts-change-data-capture-resource Hope this helps. Do let us know if you any further queries.