Forum Discussion

daylaking's avatar
daylaking
New Contributor II
2 months ago

Monthly Data from D365 into OneStream

Is there an interface from Dynamics 365 into OneStream?  I have seen some comments mention direct connection with D365 using oData API.  We have several business units across the world that will need...
Data Integration
Data Sources
Import
daylaking's avatar
daylaking
New Contributor II
2 months ago

What would be the method of reaching out to D365?  A business Rule script, or process within?

tschilling's avatar
tschilling
Contributor
2 months ago

Typically, you would use a connector rule BR, but there a few different options depending as well if you're D365 is on prem or in the cloud.  Often times, clients also have a "syncing" mechanism between D365 and Synapse or Fabric so you could hit those endpoints as well.

  • daylaking's avatar
    daylaking
    New Contributor II
    23 days ago

    Would Getting this set up to have data feed into OneStream from D365 through a connector be setup by an OneStream Architect, Technical, or myself (an Admin)?

    • tschilling's avatar
      tschilling
      Contributor
      23 days ago

      It really depends on the level of expertise of the resources.  It will require custom coding, SQL and/or API experience, and working knowledge of D365 and familiarity with Azure App Registrations, Authorizations, etc...