Skip to main content
O
OSAdmin
November 13, 2019

Microsoft D365 with OneStream

  • November 13, 2019
  • 3 replies
  • 0 views
Originally posted by Stan Allan

We have a client that wants to develop and interface from Dynamics 365 F&O to provide the GL transaction data to OneStream. Is there an out of the box solution? Has this been done before?

We have done D365 to ePBCS but it required an export to a data file from D365 that is a manual process. The client wants this process fully automated.

Thanks 

      3 replies

      O
      OSAdminAuthor
      November 13, 2019
      Originally posted by Frank Dossing

      hi Stan,

      I'm currently working on this task. In this case we found that D365 can expose the GL data through a webservice (odata). To connect to this endpoint we'll need to build a custom connector that handles the connection (httpclient) and retrieves data. So it requires a bit of work to get up and running.

       

      Cheers Frank

      O
      OSAdminAuthor
      January 16, 2020
      Originally posted by Francisco Amores

      Hi,

      As Frank mentions, a custom connector BR is needed. You will need to check with the customer if the transactional data they need is exposed through odata. If it's not available as a data entity, you may want to consider using BYOD integration option which let's you extract transactional data from a "replicate" database

      Cheers

      N
      Nil253259
      February 13, 2023

      Hi,

      We are currently working on creating a direct connection with D365 using oData API, but it is failing at the AAD authentication. We are not quite sure if it is to do with missing DLLs at the XF server. Is there any connector code configuration that I can refer to?

      Thanks! 

      A
      anandkrishna
      October 23, 2023

      Hi,

      Did you manage to connect D365 to OneStream?

      Terms & ConditionsAccessibility statement