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

Ghalbrooks's avatar
Ghalbrooks
New Contributor II
3 years ago

OneStream - NetSuite

Looking for others experiencing issues getting a YTD dataset out of NetSuite for loading into OS.   Also looking to connect with other users who use NetSuite for the ERP and OneStream for planning.  ...
Data Management
Data Sources
kalanina's avatar
kalanina
New Contributor
3 years ago

Hi there, how did you create your file in NetSuite to hold your UD's? I am assuming you used NetSuite custom segments to represent your UDs, did u use a customized trial balance report, saved search, suite analytics?

 

How did you get your report output to pass through suite analytics into OneStream?

 

Thanks!

Sai_Maganti's avatar
Sai_Maganti
Contributor II
3 years ago

We used SuiteAnalytics Connect for the integration (direct connection to Netsuite using ODBC) with some custom SQL queries to pull in the transactions into OneStream. SuiteAnalytics Connect exposes Netsuite data as views where you can map to OneStream dimensions. For example the Entity, Account and other Custom Segments can be mapped to OneStream dimensions.

Best