Forum Discussion

Yentyl's avatar
Yentyl
New Contributor II
7 months ago

Data Courses - Onestream navigator

Hi i now have access to Onestream Navigator and would like some recommendations of which courses to complete to get an understanding of how to extract data out of Onestream 

Does anybody have any courses that were done that would be of help

  • I'm not sure if there is anything specific about this either. A good general course is the Designing an Application one though.

    Things to read about / watch that would interest you with extracting data:

    1. Excel spreadsheet addin
    2. Data Management jobs (can use to extract among other things)
    3. Cube Views (prepare data for extraction)
    4. Data Adapters (prepare data for extraction, query remotely via REST)
    5. Thorough understanding of Business Rules will enable some of the options listed here and will also just drive better solutions
    6. FDX methods (fast data extraction BR functions)
    7. REST API (can retrieve data or call a DM job that extracts data)
  • DanielWillis's avatar
    DanielWillis
    Valued Contributor

    I'm not sure if there is anything specific about this either. A good general course is the Designing an Application one though.

    Things to read about / watch that would interest you with extracting data:

    1. Excel spreadsheet addin
    2. Data Management jobs (can use to extract among other things)
    3. Cube Views (prepare data for extraction)
    4. Data Adapters (prepare data for extraction, query remotely via REST)
    5. Thorough understanding of Business Rules will enable some of the options listed here and will also just drive better solutions
    6. FDX methods (fast data extraction BR functions)
    7. REST API (can retrieve data or call a DM job that extracts data)
  • Krishna's avatar
    Krishna
    Valued Contributor

    Yentyl  - The data can be extracted from OS using Data Management and you can upload or read the csv file and load it to the external Data Lake or other data sources. I am not sure about the courses in the navigator. but this method works because I have implemented.