Odata in SSIS from SAP byd is not working

[juandavid_murcia]

Dear Community

I am working with Odata in excel without problem to get the data from SAP byd, but at time to do the same Qry in SSIS (sql server integration services) I dont have any answer. Do your know if SAP Odata is not supported in SSIS or there are restrictions from SAP?.

I will appreciate your help.

[Bernard · Accepted solution]

I am aware that SAP largely publish v2 oData endpoints and SSIS may be attempting to consume a V4 endpoint. All microsoft tech is using V4 and SAP are gradually changing their technologies (E.g SAP Cloud Anlaytics, SAPUI5,...) to consume V4. Is there a way of indicating the odata version to the SSIS job?

[juandavid_murcia]

Thank for your help, finally we used another ETL tool (FME) to get the data because de limitatio of SSIS with sap byd