Hello Aman Gill,
Welcome to the Microsoft Q&A forum.
Synapse/Data Factory connector SAP CDC is using SAP ODP RFC API which is not supported anymore according to SAP note 3255746, ODP ODATA API should be used instead within the connector.
So here you can use SAP CDC via OData when it's ready or use the existing OData connector
A similar question was answered here: https://learn.microsoft.com/en-us/answers/questions/1659375/sap-cdc-and-sap-tables-connectors-regarding-sap-no
I hope this helps.
If this answers your question, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.