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

[Ivan_Farafonov]

I think you should recheck the authentication and configuration steps carefully, according to your error message, cause it's one of the most common issues. Since you're working with D365 and BODS 4.2, and there's no direct database access, you might use OData APIs. 

Firstly, you’ll need to ensure that your D365 environment is set up to use OAuth authentication via Azure Active Directory or register an application in Azure Active Directory to act as a client that can authenticate with D365. Then check that the application has proper permissions to access the necessary D365 entities And finally endpoint OData URL in D365, ensure that the web API in D365 is enabled and accessible.

As for SAP BODS Ensure that the OData adapter is installed and correctly configured in the BODS designer. This is required to consume OData feeds from D365. In BODS designer, create a new dataflow and add a new OData Data Store. In the data store configuration, select OData as the connection type. For the Service URL, use the OData endpoint you verified in the earlier step. After successful connection setup, define which D365 entities (such as contacts, sales orders, opportunities) you want to work with in BODS. BODS will now be able to access these entities via the OData connection.

Also you might use CSV/Flat Files or Web Service as an alternative. (Discussed in this thread -  https://community.sap.com/t5/technology-q-a/how-to-connect-sap-data-services-to-dataverse/qaq-p/1392...)

You can always ask for help from special teams like Dynamics integration specialists https://www.hiredynamicsdevelopers.com/dynamics-365-integration-services/ or check their site for guides if you will face any issues.