BODS Connectivity to Microsoft D365 (Dynamics 365)

[k2020]

I need to connect D365 as the data source in BODS (4.2). I made several attempts with the OData adapter in SAP Data Services Designer but with no success ("Error: Expected status OK, found Unauthorized. Server response:"). Has anyone succeeded? Other standard D365 options also welcome (there is no direct access to database). Could you share details on configuration, please? Thank you.

[former_member410348]

Hi Karel,

Did you manage to get the OData Adapter connect to D365? We've setup a sample job to connect to "https://services.odata.org/V2/Northwind/Northwind.svc" and were successful in query/load data but cloud not get it to work with our Dynamics 365 instance.

Really appreciate if you could share if you had any success and how?

Regards

Vinod