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
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.