The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

IL's avatar
IL
New Contributor II
10 months ago

Can ERP transactional data be loaded into OS?

Hi, my company's OS data integration with the ERP system has been set-up to load monthly TB's into OS and for transactional tables to sit outside of OS but with the ability for OS to query and drill-...
Data Integration
Data Management
Data Sources
Import
sameburn's avatar
sameburn
Icon for OneStream Employee rankOneStream Employee
10 months ago

I agree with DanielWillis​

There are so many ways you can report on this external data from inside OneStream that there is absolutely no need to duplicate your entire dataset inside OneStream. Just because something is possible doesn't mean it's necessarily a good idea. 

IL​ have you consulted with a Partner (if you are a Customer) or Partner Enablement (if you are a partner) for some design advice here?

Sam

IL's avatar
IL
New Contributor II
10 months ago

Thanks Sam, yes, am currently consulting with a partner. Aim is to try and get as much detailed analysis done within OS as possible, rather than using OS just for high-level reporting (because it's slow and difficult to get to the transactional detail), and then reverting to a datawarehouse table of transactions held outside of OS and producing analysis/reports via Excel instead.

  • TGG_Alex's avatar
    TGG_Alex
    Contributor II
    10 months ago

    IL​ - if it is for informational purposes only (e.g., not used for other derived computations or functions like transaction matching, etc.), it may be better to launch a direct query from within OneStream to the narrowed scope of transactions at source if your source ERP allows for that type of query (aka Option 1.1 from DanielWillis​ )

    Cheers,

    A.