How to consume an Odata from On Prem system in SAP ABAP Cloud?

We are trying to consumer an Odata service in our On Prem system in SAP ABAP Cloud in BTP. We tried multiple blogs. Can anyone please help with this? Is there any best practice we can try here.

We are getting an error 403 - Forbidden always. If we try to consumer the service through the destination using

DATA(http_destination) = cl_http_destination_provider=>create_by_cloud_destination( i_name = 'Destnination Name' "i_service_instance_name = 'SAP_COM_0276' i_service_instance_name = 'Instance Name' i_authn_mode = if_a4c_cp_service=>service_specific ).